[Profile] FND: Message Level Threshold

FND: Message Level Threshold is used for debugging issues.

The internal name of the profile is FND_AS_MSG_LEVEL_THRESHOLD.

In the FND code tree, its value is checked in only one place: FND_MSG_PUB.Check_Msg_Level() function.
This function is used to check if the level of the message, that a developer wants to write to the message table, is higher or equal to the FND: Message Level Threshold value or not. If the function returns TRUE (message level >= FND_AS_MSG_LEVEL_THRESHOLD), then the developer should go ahead and write the message to the message table else the developer should should skip writing this message. The value of FND: Message Level Threshold is determined using the lookup_type Message Level Threshold which has the following lookup_codes or possible values: 

10 = Debug Low 
20 = Debug Medium 
30 = Debug High 
40 = Success 
50 = Error 
60 = Unexpected Error 

So, if FND: Message Level Threshold is set to 10, then it is likely that all messages that a developer wanted to write to the message table will get written. A value of 60 would only write Unexpected Error messages to the message table. The default value in FND_MSG_PUB.Check_Msg_Level() for FND: Message Level Threshold is 40 or Success in the absence of a set profile option value.

How to set Default Marketing Approver role

1.Go to Responsibility, CRM Resource Manager, Vision Enterprises, Maintain Resources -> Resources Forms UI.
2.Find the resource by name. Click on Resource Details.
3.In Roles tab, add a new row by selecting  Role Type -> "Default Marketing Approver", Role -> "Default Marketing Approver Role", start date and end date.

How to find patchset level of a particular product in an instance

1. Open any form for the product(say AR).

2. Go to Tools -> About AR

3. patch set level will be displayed here.

Other way is to execute the below query

SELECT patch_level

FROM fnd_product_installations

WHERE patch_level LIKE '11i.AR%';

Setting up Reporting Currency Ledger and Secondary Ledger in General Ledger.

Setting up Reporting Currency Ledger:

1. Responsibility : General Ledger Vision Operations(USA), Setup -> Financials -> Accounting Setup Manager and Search for Primary Ledger "Vision Operations (USA)" and Click on Update Accounting Options.
2. In Primary Ledger: Vision Operations (USA) section, Click on Update Icon for Reporting Currencies.
3. Add New Reporting Currency with the following info and Apply.
• Reporting Currency Name - Indian Rupee
• Short Name - INR
• Currency Conversion Level -  Journal 
• Default Rate Type   - Corporate
4.  Go to Setup -Open/Close Periods, Query for Ledger : Indian Rupee and Open the Period

  
Setting up Secondary Ledger:

1. Responsibility : General Ledger Vision Operations(USA), Setup -> Financials -> Accounting Setup Manager and Search for Primary Ledger "Vision Operations (USA)" and Click on Update Accounting Options.
2. Go to Secondary ledger and check the Secondary Ledger Name .It may be IAS Reporting Vision Ops. If not available , create new with the same name.
3. Switch to System Administrator Responsibility, Create new Responsibility in the name of IAS Reporting Vision Ops. Set the details as the same as Responsibility: General Ledger Vision Operations (USA) and add this responsibility to the respective User
4.  Switch to Responsibility Oracle Trade Management Administrator, ->Profile ->  Query for the Profile GL: Data Access Set for Responsibility IAS Reporting Vision Ops, and set it as IAS Reporting Vision Ops
5. Switch to Responsibility: IAS Reporting Vision Ops. Open the GL Periods for the Ledger as IAS Reporting Vision Ops.

Testing the setup:

1. Create a new Journal entry in GL,(By creating accruals from Trade Management and Executing CC job " Transfer to General Ledger" from  Responsibility Oracle Trade Management Administrator)
2. Post the details to GL, this will create a new journal entry in Reporting currency with Journal name INR: Fixed Budgets USD . Click on Review Journal to View the details in Reporting Currency.
3. Switch to Responsibility: IAS Reporting Vision Ops and query for the same information by navigating to Journals --> Enter -->Query for the Period, this will retrieve the details for the Secondary Ledger : IAS Reporting Vision Ops.       

How to Open a secondary Ledger

Follow the below steps to open secondary ledger for Vision Ops GL

1.Note the Secondary Leger name for Vision Operations(USA)

•    To verify this navigate to General Ledger Vision Operations(USA) Resp >Setup : Financials : Accounting Setup Manager >Accounting Setups

•     Search for Vision Operations(USA)

•     Click on update

•     Under "Secondary Ledger" section verify the ledger name as "IAS Reporting Vision Ops"

2.  Assign the GL access to Secondary ledger to any responsibility   

•    Add "General Ledger, IFRS Reporting Vision Ops"" resp to your user 

•  Now as sysadmin , Make sure "GL:Access Set" profile is set to "IAS Reporting Vision Ops" at the responsibility level
  (Assign "IAS Reporting Vision Ops" as value to "General Ledger, IFRS Reporting Vision Ops" resp for the the above profile)

3. Open the periods

•     Switch to "General Ledger, IFRS Reporting Vision Ops" resp

•     Open form "Open /Close periods and select the period to be opened

How to get the file versions of any file in oracle applications

-- get the file_id for appropriate file and dir

SELECT * FROM ad_files WHERE filename = '' 

Note : For Java files, instead of .java, use .class

Now , get the file version.

SELECT *
FROM ad_file_versions
WHERE file_id =
ORDER BY file_version_id DESC

How to get the list of parameter of PL/SQL procedure

SELECT position,
  argument_name,
  data_type,
  sequence
FROM all_Arguments
WHERE package_name=
AND object_name   =
ORDER BY position,
  argument_name,
  data_type,
  sequence;