PROFILE OPTIONS IN ORACLE APPS R12 - OVERVIEW (FND PROFILE)

Definition:

Profiles are the changeable options which affect the way Oracle Application runs. Moreover, Moreover, The profile option acts like a Global Variable in Oracle. It is needed to provide the flexibility to Oracle Applications.

Types:

The profiles are of two types those are given below.

1. System Profile and

2. User Profile.

About DIFFERENT LEVELS a Profile value can be set:

The Profile values will be set in different levels those are given below.

1. Site

2. Application

3. Responsibility

4. User

5. Server

6. Organization

Site: This field displays the current value, if set, for all users at the installation site.

Application: This field displays the current value, if set, for all users working under responsibilities owned by the application identified in the Find Profile Values block.

Responsibility: This field displays the current value, if set, for all users working under the responsibility identified in the Find Profile Values block.

User: This field displays the current value, if set, for the application user identified in the Find Profile Values block.

Profile: Enter the name of the profile option whose values you wish to display.

Navigation to set Profile Values

 SYSTEM PROFILE: 

Responsibility SYSTEM ADMINISTRATOR -->

You may search for profile options using character strings and the wildcard symbol (%). For example, to find all the profile options prefixed by "Concurrent:” you could enter "Conc%" and press the Find button.

  

PERSONAL PROFILE:

Responsibility SYSTEM ADMINISTRATOR -->

To view personal profiles enter into the query mode and enter the profile name which we have already then we get profile value details.

To check the validation done against the Profile value while setting:

Responsibility APPLICATION DEVELOPER -->

Use of the API FND_PROFILE

It is used to perform various actions related to profile values through PL/SQL. Some of the important ones are listed below

1. FND_PROFILE.GET(‘Name of the Profile’, variable name);

Example

SELECT fnd_profile.value('PROFILEOPTION')

      ,fnd_profile.value('MFG_ORGANIZATION_ID')

      ,fnd_profile.value('ORG_ID')

      ,fnd_profile.value('LOGIN_ID')

      ,fnd_profile.value('USER_ID')

      ,fnd_profile.value('USERNAME')

      ,fnd_profile.value('CONCURRENT_REQUEST_ID')

      ,fnd_profile.value('GL_SET_OF_BKS_ID')

      ,fnd_profile.value('SO_ORGANIZATION_ID')

      ,fnd_profile.value('APPL_SHRT_NAME')

      ,fnd_profile.value('RESP_NAME')

      ,fnd_profile.value('RESP_ID')

  FROM DUAL;

2. variable name := FND_PROFILE.VALUE(‘Name of the profile’);

3. FND_PROFILE.PUT(‘Name of the profile’, value of the profile);

Example

SET SERVEROUTPUT ON;

DECLARE

   v_conc_login_id      NUMBER;

BEGIN

   FND_PROFILE.put ('CONC_LOGIN_ID',1425);

   fnd_profile.get ('CONC_LOGIN_ID', v_conc_login_id);

   DBMS_OUTPUT.put_line (v_conc_login_id);

END;

Output:

1425

PL/SQL procedure successfully completed

The 1st and 2nd are same but, the only difference is FND_PROFILE.GET is the procedure and FND_PROFILE.VALUE is the function so, it return a value.  

Apart from the above procedures we have another important one named FND_PROFILE.SAVE used to set the profile values from backend. A detail regarding this API is available in another article. 

The table fnd_profile_options_tl, profile options names are kept.  Now find the corresponding the Profile option name for which you need to update from backend. For this example I took my favorite “ORG_ID”

SELECT profile_option_name
  FROM fnd_profile_options_tl
 WHERE user_profile_option_name LIKE 'MO%'

It returns more than one row but i can make out that "ORG_ID" is the PROFILE_OPTION_NAME for MO: Operating Unit. Now I need to know the Org_ID of the Org whose value is to be set in MO: Operating Unit. SO I use the simple select as below

SELECT organization_id, NAME
  FROM hr_all_organization_units;

From the organization name I find the one which will be the default Operating Unit, and I note the ID. In my case the ID for my default Operating Unit is 286. Now with the code below I set the profile option value using fnd_profile.save.

DECLARE
   stat   BOOLEAN;
BEGIN
   DBMS_OUTPUT.DISABLE;
   DBMS_OUTPUT.ENABLE (100000);
   stat := fnd_profile.SAVE ('ORG_ID', 286, 'SITE');
   IF stat
   THEN
      DBMS_OUTPUT.put_line ('Stat = TRUE - profile updated');
   ELSE
      DBMS_OUTPUT.put_line ('Stat = FALSE - profile NOT updated');
   END IF;
   COMMIT;
END;

TRADING COMMUNITY ARCHITECTURE (TCA) API’S IN R12 ORACLE APPS

Below give you the list of Trading Community Architecture API’s with the links to their test script. All the test scripts are tested in R12.1.1 Version.

SI NO	Tested API's List
1	HZ_CUST_ACCOUNT_V2PUB.CREATE_CUST_ACCOUNT
2	HZ_CUSTOMER_PROFILE_V2PUB.CREATE_CUSTOMER_PROFILE
3	HZ_CUST_ACCOUNT_SITE_V2PUB.CREATE_CUST_ACCT_SITE
4	HZ_CUST_ACCOUNT_SITE_V2PUB.CREATE_CUST_SITE_USE
5	HZ_PARTY_SITE_V2PUB.CREATE_PARTY_SITE
6	HZ_PARTY_SITE_V2PUB.CREATE_PARTY_SITE_USE)
7	HZ_CONTACT_POINT_V2PUB.CREATE_CONTACT_POINT
8	HZ_LOCATION_V2PUB.UPDATE_LOCATION
9	HZ_CUST_ACCOUNT_V2PUB.UPDATE_CUST_ACCOUNT
10	HZ_PARTY_V2PUB.CREATE_GROUP
11	HZ_CUST_ACCOUNT_V2PUB.CREATE_CUST_ACCOUNT
12	HZ_CUST_ACCOUNT_V2PUB.CREATE_CUST_ACCOUNT
13	HZ_LOCATION_V2PUB.CREATE_LOCATION
14	HZ_TAX_ASSIGNMENT_V2PUB. CREATE_LOC_ASSIGNMENT
15	HZ_CUST_ACCOUNT_V2PUB.UPDATE_CUST_ACCT_RELATE
16	HZ_CUSTOMER_PROFILE_V2PUB.UPDATE_CUSTOMER_PROFILE
17	HZ_PARTY_V2PUB.CREATE_ORGANIZATION
18	HZ_CUST_ACCOUNT_V2PUB.CREATE_CUST_ACCT_RELATE
19	HZ_PARTY_CONTACT_V2PUB.CREATE_ORG_CONTACT

Reports and Listings in account payables

Reports and Listings

Submitting Standard Reports, Programs, and Listings

Supplier Reports

New Supplier/New Supplier Site ListingPurchase Order Header Updates Report
Supplier Balance Revaluation Report+
Supplier Audit Report
Supplier Mailing Labels
Supplier Merge Report
Supplier Paid Invoice History Report
Supplier Payment History Report
Suppliers Report

Income Tax Forms and Reports

1096 Form1099 Forms
1099 Invoice Exceptions Report
1099 Payments Report
1099 Supplier Exceptions Report
1099 Tape
Tax Information Verification Letter
Withholding Tax By Invoice Report
Withholding Tax By Payment Report
Withholding Tax By Tax Authority Report
Withholding Tax By Supplier Report
Withholding Tax Certificate Listing

Invoice Reports

Accrual Reconciliation ReportAccrual Write-Off Report
Actual Invoice Sweep Report See: Unposted Invoice Sweep Program
Batch Control Report by Batch Name See: Batch Control Reports
Batch Control Report by Entered By See: Batch Control Reports
Credit Memo Matching Report
Expense Distribution Detail Report
Invoice Aging Report
Invoice Audit Listing by Voucher Number
Invoice Audit Listing
Invoice Audit Report
Invoice History Report
Invoice Import Exceptions Report
Invoice Import Prepayments Applied Report
Invoice Import Report
Invoice on Hold Report
Invoice Register
Matching Hold Detail Report
Open Items Revaluation Report
Payables Approval Report
Payables Open Interface Report
Preliminary Invoice Sweep Report See: Unposted Invoice Sweep Program
Prepayments Status Report
Recurring Invoices Report
Unrealized Gain/Loss Report

Invoice Tax Reports

Intra-EU VAT Audit Trail ReportTax Audit Trail Report
Tax Declaration Report
Use Tax Liability Report

Payment Reports

Automatic Clearing of Future Dated Payments Utility and ReportCash Requirement Report
Discounts Available Report
Discounts Taken and Lost Report
Final Payment Register
Missing Document Numbers Report
Payment Audit by Voucher Number
Payment Batch Control Report
Payment Gain/Loss Report
Payment Distribution Report
Payment Exceptions Report
Payment Register
Positive Pay Report
Preliminary Payment Register
Separate Remittance Advice
Stopped Payments Report
Undistributed Payments Report
Void Payment Register

Posting Reports

Accounts Payable Journal Entry Audit ReportAccounts Payable Journal Entry Exception Report
Accounts Payable Trial Balance Report
Journal With GL Details Report
Posted Invoice Register
Posted Payment Register
Posting Hold Report
Transaction Reconciliation Report

Purge Reports

Final Purge Statistics ReportFinal Purged Listings
Preliminary Purged Listings
Rejected Purged Listings

Analysis Reports

Key Indicators ReportKey Indicators Current Activity Report
Key Indicators State-of-the-System Report

Notices

Invalid PO Supplier NoticeMatching Hold Agent Notice
Prepayment Remittance Report
Print Invoice Report
Receiving Hold Requestor Notice

Listings

Bank Account ListingDistribution Set Listing
Employee Listing
Expense Report Template Listing
Payment Terms Listing
QuickCode Listing
Tax Names Listing

Oracle Inventory Reports and Processes

Oracle Inventory Reports and Processes

ABC Assignments ReportABC Descending Value Report
Account Alias Listing
All Inventories Value Report
Cost Type Comparison Report
Customer Item Commodity Codes Listing
Customer Item Cross References Report
Customer Items Report
Cycle Count Entries and Adjustments Report
Cycle Count Hit/Miss Analysis
Cycle Count Listing
Cycle Count Open Requests Listing
Cycle Count Schedule Requests Report
Cycle Count Unscheduled Items Report
Cycle Counts Pending Approval Report
Delete Items Report
Detailed Item Cost Report
Elemental Cost Report
Elemental Inventory Value Report
Expected Receipts Report
Expired Lots Report
Forecast Comparison Report
Forecast Detail Report
Forecast Rule Listing
Freight Carrier Listing
Import Items
Inactive Items Report
Inter-organization Shipping Information Listing
Intransit Value Report
Inventory Value Report
Invoice Price Variance Report
Item Categories Report
Item Cost Reports
Item Cross-References Listing
Item Definition Detail
Item Definition Summary
Item Demand History Report
Item Quantities Summary
Item Relationships Listing
Item Replenishment Count Report
Item Reservations Report
Item Statuses Report
Item Template Listing
Item-Subinventory Report
Locator Listing
Locator Quantities Report
Lot Transaction Register
Margin Analysis Report
Material Account Distribution Detail
Material Account Distribution Summary
Min-Max Planning Report
Movement Statistics Report
Multi-Organization Quantity Report
Organization Parameters Listing
Overdue Supplier Shipments Report
Overhead Report
Period Close Value Summary
Physical Inventory Tags
Physical Inventory Accuracy Analysis
Physical Inventory Adjustments Report
Physical Inventory Counts Report
Physical Inventory Missing Tag Listing
Physical Inventory Tag Listing
Physical Inventory Tags
Physical Inventory Trend Analysis
Physical Inventory Summary Analysis
Planner Listing
Purchase Price Variance Report
Purge Replenishment Counts
Receipt Adjustments Report
Receipt Traveler
Receiving Account Distribution Report
Receiving Exceptions Report
Receiving Transactions Register
Receiving Value Report
Receiving Value Report By Destination Account
Reload Safety Stocks
Reorder Point Planning Report
Serial Generation
Serial Number Detail
Serial Number Transaction Register
Status Attributes Listing
Subinventory Account Value Report
Subinventory Listing
Subinventory Quantities Report
Transaction Historical Summary
Transaction Purge
Transaction Register
Transaction Source Type Summary
Transfer Transactions to GL
Unit of Measure Listing
Supplier Lot Trace Report
Update item statuses with pending statuses

Oracle Inventory Profile Options

Oracle Inventory Profile Options

During implementation, you set a value for each profile option to specify how Oracle Inventory controls access to and processes data.The system administrator sets and updates profile values. The Oracle Applications System Administration Reference Manual contains a list of all profile options that are available to every Oracle Application.

INV:Accounting Category Set

Indicates the default category set for defining category accounts.This profile is updatable only at the Site level.

INV:Allow Expense to Asset Transaction

Indicates whether you can transfer an item from an expensed subinventory to an asset location.This profile is updatable at all levels.

INV:Capable to Promise

Indicates whether to enable the CTP calculation.This profile has a predefined value of NULL (no predefined value) upon installation.
This profile is updatable only at the site level.

INV:Default Item Status

Indicates the default item status for new items you define.This profile is updatable at all levels.

INV:Default Primary Unit of Measure

Indicates the default primary unit of measure for new items you define.This profile is updatable at all levels.

INV:Dynamic Precision Option for Quantity on Reports

Indicates the decimal precision for your unit costs. This controls how cost information is displayed on all cost reports. All reports display fourteen digits for unit costs, and display at least 16 digits for extended values.Inventory predefines a value of -9,999,990.00 for this profile for all levels upon installation.
This profile is updatable at all levels.

INV:External ATP

Indicates whether non-Oracle ATP products can be integrated with Oracle.This profile is updatable only at the site level.

INV:Inter-Organization Currency Conversion

Indicates the currency conversion for inter-organization transfers between organizations using different currencies. Available values are:

Corporate	An exchange rate you define to standardize rates for your company. The corporate exchange rate is generally a standard market rate determined by senior financial management for use throughout the organization.
Spot	An exchange rate you enter to perform conversion based on the rate on a specific date. It applies to the immediate delivery of a currency.
User	An exchange rate you specify when you enter a foreign currency journal entry that does not have a daily exchange rate.

Inventory predefines a value of Corporate for this profile for all levels upon installation.
This profile is updatable at all levels.

INV:Intercompany Currency Conversion

Indicates the currency conversion for intercompany invoices using different currencies. Available values are:

Corporate	An exchange rate you define to standardize rates for your company. The corporate exchange rate is generally a standard market rate determined by senior financial management for use throughout the organization.
Spot	An exchange rate you enter to perform conversion based on the rate on a specific date. It applies to the immediate delivery of a currency.
User	An exchange rate you specify when you enter a foreign currency journal entry that does not have a daily exchange rate.

Inventory predefines a value of Corporate for this profile upon installation.
The profile is updatable at the Site, Application, and Responsibility levels.

INV:Item Master Flexfield

Indicates which flexfield is used to define items in MTL_SYSTEM_ITEMS.Inventory predefines a value of System Items for this profile for all levels upon installation.
This profile is updatable at all levels.

INV:Minmax Reorder Approval

Approved or Unapproved indicates the status of requisitions created by the Minmax Planning Report.Inventory predefines a value of Approved for this profile for all levels upon installation. If you choose Unapproved, you can optionally load requisitions as unapproved and use the document approval functionality in Oracle Purchasing.
This profile is updatable at all levels.

INV:Project Miscellaneous Transaction Expenditure Type

Governs the entry of expenditure types for project miscellaneous transactions. Available values are:

System Derived from Cost Elements	You cannot enter expenditure types for project miscellaneous transactions. The Cost Collector uses the expenditure types linked to the cost elements of the current weighted average unit cost of the item to post to Projects.
User Entered	You must enter expenditure types for project miscellaneous transactions.

This profile is updatable at all levels.

INV:RC Line Failure

Indicates the action taken when a failure is detected while processing a replenishment count line. Available values are:

Continue processing	Other (successful) lines for the replenishment header are processed to requisition lines.
Halt processing	Do not process other (successful) lines for the replenishment header.

Inventory predefines a value of Continue processing for this profile for all levels upon installation.
This profile is updatable at all levels.

INV: RC Requisition Approval

Indicates the status of Subinventory Replenishment requisitions created by the replenishment processor. Available values are:

Approved	Requisitions created by the replenishment processor are approved.
Unapproved	Requisitions created by the replenishment processor are not approved.

Inventory predefines a value of Approved for this profile for all levels upon installation. If you choose Unapproved, you can optionally load Subinventory Replenishment requisitions as unapproved and use the document approval functionality in Oracle Purchasing.
This profile is updatable at all levels.

INV:Save Search Items

Indicates whether items returned by the Search Items window are saved on exit.Inventory predefines a value of N for this profile for all levels upon installation.
This profile is updatable at all levels.

INV:Transaction Date Validation

Controls the date you can enter for transactions. Available values are:

Allow date in any open period	Allows entry of a past date if it is in an open period.
Do not allow past date	Does not allow entry of a date before the current date.
Do not allow date in past period	Allows entry of dates in the current period only.
Provide warning when date in past period	Allows entry of dates in prior periods after a warning.

Inventory predefines a value of Allow date in any open period for all levels upon installation.
The profile is updatable at the Site, Application, and Responsibility levels.

INV:Updatable Customer Item

Indicates whether you can change the customer item number.The default is No.
This profile is updatable at all levels.

INV:Updatable Item Name

Indicates whether you can update the item flexfield.Inventory predefines a value of No for this profile for all levels upon installation.
This profile is updatable at all levels.

INV:Use catalog name in the item description

Indicates whether to use the catalog name or the catalog description as the first element of a concatenated item catalog description. Available values are:

No	Catalog description
Yes	Catalog name

Inventory predefines a value of No for this profile for all levels upon installation.
This profile is updatable only at the Site level.

TP:INV Cycle Count Approvals form

Indicates processing control of cycle count approvals in the Cycle Count Approvals window. Available values are:

Background processing	Upon commit, control returns immediately to you, allowing you to continue working. The cycle count transactions are executed on a periodic basis.
	Displays the concurrent request number representing the concurrent process executing the cycle count transactions.
On-line processing	Processes your cycle count transactions while you wait, and control is returned once transaction processing is completed.

Inventory predefines a value of On-line processing for this profile for all levels upon installation.
This profile is updatable at all levels.

TP:INV Cycle Count Entries form

Indicates the processing control of cycle count entries in the Cycle Count Entries window. Available values are:

Background processing	Upon commit, control returns immediately to you, allowing you to continue working. The cycle count transactions are executed on a periodic basis.
	Displays the concurrent request number representing the concurrent process executing the cycle count transactions.
On-line processing	Processes your cycle count transactions while you wait, and control is returned once transaction processing is completed.

Inventory predefines a value of On-line processing for this profile for all levels upon installation.
This profile is updatable at all levels.

TP:INV Enter Replenishment Count form

Indicates processing control in the Enter Replenishment Count window. Available values are:

Background processing	Upon commit, control returns immediately to you, allowing you to continue working. The replenishment count transactions are executed on a periodic basis.
Concurrent processing	Upon commit, Inventory spawns the concurrent process and returns control immediately to you, allowing you to continue working.
	Displays the concurrent request number representing the concurrent process executing the replenishment count transactions.

Inventory predefines a value of Concurrent processing for this profile for all levels upon installation.
This profile is updatable at all levels.

TP:INV Inter-Organization Transfer form

Indicates the processing control of inter-organization transfers in the Inter-Organization Transfer window. Available values are:

Background processing	Upon commit, control returns immediately to you, allowing you to continue working. The inter-organization transfer transactions are executed on a periodic basis.
Concurrent processing	Upon commit, Inventory spawns the concurrent process and returns control immediately to you, allowing you to continue working.
	Displays the concurrent request number representing the concurrent process executing the inter-organization transfer transactions.
On-line processing	Processes your inter-organization transfer transactions while you wait, and control is returned once transaction processing is completed.

Inventory predefines a value of On-line processing for this profile for all levels upon installation.
This profile is updatable at all levels.

TP:INV Miscellaneous Issue and Receipt form

Indicates the processing control of miscellaneous issues and returns in the Miscellaneous Issue window. Available values are:

Background processing	Upon commit, control returns immediately to you, allowing you to continue working. The miscellaneous issue and receipt transactions are executed on a periodic basis.
Concurrent processing	Upon commit, Inventory spawns the concurrent process and returns control immediately to you, allowing you to continue working.
	Displays the concurrent request number representing the concurrent process executing the miscellaneous issue and receipt transactions.
On-line processing	Processes your miscellaneous issue and receipt transactions while you wait, and control is returned once transaction processing is completed.

Inventory predefines a value of On-line processing for this profile for all levels upon installation.
This profile is updatable at all levels.

TP:INV Receive Customer Returns form

Indicates the processing control of receiving customer returns on the Receipt of Customer Return window. Available values are:

Background processing	Upon commit, control returns immediately to you, allowing you to continue working. The customer return transactions are executed on a periodic basis.
Concurrent processing	Upon commit, Inventory spawns the concurrent process and returns control immediately to you, allowing you to continue working.
	Displays the concurrent request number representing the concurrent process executing the customer return transactions.
On-line processing	Processes your customer return transactions while you wait, and control is returned once transaction processing is completed.

Inventory predefines a value of On-line processing for this profile for all levels upon installation.
This profile is updatable at all levels.

TP:INV Return to Customer form

Indicates the processing control of returning items to customers on the Return to Customer window. Available values are:

Background processing	Upon commit, control returns immediately to you, allowing you to continue working. The return to customer transactions are executed on a periodic basis.
Concurrent processing	Upon commit, Inventory spawns the concurrent process and returns control immediately to you, allowing you to continue working.
	Displays the concurrent request number representing the concurrent process executing the return to customer transactions.
On-line processing	Processes your return to customer transactions while you wait, and control is returned once transaction processing is completed.

Inventory predefines a value of On-line processing for this profile for all levels upon installation.
This profile is updatable at all levels.

TP:INV Transaction Processing Mode

Indicates the processing control for transacting items. Available values are:

On-line processing	Processes transactions while you wait, and control is returned once transaction processing is completed.
Background processing	Upon commit, control returns immediately to you, allowing you to continue working. The transactions are executed on a periodic basis.
Immediate concurrent processing	Upon commit, Inventory spawns the concurrent process and returns control immediately to you, allowing you to continue working.
	Displays the concurrent request number of the concurrent process executing the transaction.
Form level processing	Processes transactions using the processing control option you choose for that particular type of transaction. You must also set the Inventory profile options for Inter-Organization Transfer, Miscellaneous Issue and Receipt, Receive Customer Return, Return to Customer, and Transfer Between Subinventories. If you are using Oracle Work-in-Process, you must set the WIP profile options Completion Material Processing, Completion Transaction Form, Material Transaction Form, Move Transaction, Operation Backflush Setup, and Shop Floor Processing.

The value you choose for this profile overrides values you set for individual transaction profiles unless you choose Form level processing.
Inventory predefines a value of Immediate concurrent processing for this profile for all levels upon installation.
This profile is updatable at all levels.

TP:INV Transfer Between Subinventories form

Indicates the processing control of transferring items between subinventories in the Subinventory Transfer window. Available values are:

Background processing	Upon commit, control returns immediately to you, allowing you to continue working. The transfer between subinventories transactions are executed on a periodic basis.
Concurrent processing	Upon commit, Inventory spawns the concurrent process and returns control immediately to you, allowing you to continue working.
	Displays the concurrent request number representing the concurrent process executing the transfer between subinventories transactions.
On-line processing	Processes your transfer between subinventories transactions while you wait, and control is returned once transaction processing is completed.

Inventory predefines a value of On-line processing for this profile for all levels upon installation.
This profile is updatable at all levels.

TP:INV Update Average Cost form

Indicates the processing control for updating average costs. Available values are:

Background processing	Upon commit, control returns immediately to you, allowing you to continue working. The update average costs transactions are executed on a periodic basis.
Concurrent processing	Upon commit, Inventory spawns the concurrent process and returns control immediately to you, allowing you to continue working.
	Displays the concurrent request number representing the concurrent process executing the update average costs transactions.
On-line processing	Processes your update average costs transactions while you wait, and control is returned once transaction processing is completed.

Inventory predefines a value of On-line processing for this profile for all levels upon installation.
This profile is updatable at all levels.

TP:Server Side Online Processing

Indicates whether Inventory and Work-in-Process transactions using on-line processing are processed on the server or client side.Inventory predefines a value of Yes for this profile for all levels upon installation.
This profile is updatable at all levels.