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.
Friday, February 24, 2012
FND_STANDARD.SET_WHO doesn't work / not working
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
Subscribe to:
Posts (Atom)