Friday, February 24, 2012

FND_STANDARD.SET_WHO doesn't work / not working

Even though FND_STANDARD.SET_WHO is set in pre-insert and pre-update data block triggers it fails to show record history.

Use app_special.enable('ABOUT', PROPERTY_ON) in WHEN-NEW-BLOCK-INSTACE trigger of corresponding blocks along with set_who.

Display/Set WHO columns for Record History in Oracle Forms

Call FND_STANDARD.SET_WHO procedure in data blocks pre-insert and pre-update triggers where record history is needed.

 It only works on database data blocks.

Set Inventory organization selection for custom form

Call procedure FND_ORG.CHOOSE_ORG in PRE-FORM to ensure the organization parameters are set.

You need to define 3 parameters in your FMB to make procedure work.
ORG_NAME
ORG_CODE
CHART_OF_ACCOUNTS_ID

Other useful FNDSQF Routine API's
http://docs.oracle.com/cd/E18727_01/doc.121/e12897/T302934T462356.htm