What is - fnd_standard.set_who
This is API provide by Oracle to return you the values of WHO columns .WHO columns are columns that tell you who has
1.Created/Update the value in a tables.
For all the standard table provide by in Oracle Applications , oracle has following WHO columns
I am using Apps version 12.0.0 and database version 10.2.0.4.0 .
I am not getting this API .
Am I missing something .??
this API is part of application from days of 11.0.3.
It is not part of database package,It is part of FDRCSID.pll.
Hope that helps.
We are on 184.108.40.206 and Apps 12.1.3
I do not find this FDRCSID.pll under AU_TOP/resource
why you want to look at this pll, you can use the package fnd_standard.set_who in your forms.
If this would have missing then
would have not populated properly.
You need to look closely.Open any of the Oracle Standard Form and navigate to any of the the above 5 filed and you can see fnd_standard.set_who
Hope that hels.
I am developing a new custom form based on a custom table which has the WHO columns.ReplyDelete
I have the following in the PRE-INSERT and PRE-UPDATE triggers at the block level
But I do not see the who columns populated.
Please let me know if I am missing something.
Since system is not raising error when you call fnd_standard.set_who from forms trigger , so my take is everything is good from this API point of view (trust me).ReplyDelete
Only reason that it is not working for you is - you are missing to put this API fnd_standard.set_who in few more places.Google it and I am sure you will get some hits
you need to have the who columns in your data block also to have everything working probably..ReplyDelete