One of the best features of Oracle applications is the flexibility to add custom applications and extend the functionality of the business suite. Many time developers who are not well versed with the Oracle’s guidelines for custom development for Oracle applications will totally ignore the pre-requisites for fnd_standard.set_who API to work properly by avoiding to include the following mandatory columns while designing tables
- CREATION_DATE DATE
- CREATED_BY NUMBER
- LAST_UPDATE_DATE DATE
- LAST_UPDATED_BY NUMBER
- LAST_UPDATE_LOGIN NUMBER
Which will fail the API call and result in “No record history available here” notification
Another possibility is, developer adds these columns with the custom tables at later stages and manually add the columns to the block, without involving the datablock wizard, thus not properly linking the block with newly created columns.
Manually adding the columns with proper column names and data types may not generate an error while compiling, however the API will not able to see those columns.
The best method to avoid this problem is, by running the data block wizard once after new columns are added to the custom table(s)
Run the data block wizard, refresh the data source and make sure you don’t have any column within the left side pan
Recompile and test the custom application once again. 99% this method should solve the fnd_standard.set_who API not updating information.