Oracle Cloud offers a broad portfolio of software as a service applications, platform as a service, and social capabilities, all on a subscription basis. Oracle Cloud delivers instant value and productivity for end users, administrators, and developers alike through functionally rich, integrated, secure, enterprise cloud services.
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Subscribe to the OracleAppsHub to receive notifications when there are new posts:

 get RSS feed
 Oracle Fusion Applications (OFA) is a portfolio of next generation suite of software applications from Oracle Corporation. It is distributed across various product families; including financial management, human capital management, customer relationship management, supply chain management, procurement, governance, and project portfolio management
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

“Record History” Utility in 11i

Posted on June 7th, 2008 by Sanjit Anand ||Email This Post Email This Post

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today

Do you know “Record History” utility in the Oracle EBS forms interface where every form block have, where a user simply has to have their cursor in the target data, and then from the command menu, select “Help, Record History” .

This is very old offering in application Release 9, and have evolved to a useful utility in the Release 11i version of the e-Business Suite. From many of the Professional forms that display a data record (not find windows, for example), a user can click on “Help” in the command menu bar, and then select “Record History”.

When you click, the resulting pop-up window will provide two general areas of information. The user audit information from the database table is presented, including the

  • CREATION_DATE Date and Time row was created
  • CREATED_BY Oracle Applications user ID from FND_USER
  • LAST_UPDATE_LOGIN Login ID from FND_LOGINS
  • LAST_UPDATE_DATE Date and Time row as last updated
  • LAST_UPDATED_BY Oracle Applications user ID from FND_USERS

This information can be easily accessed through the application or SQL. Within the applications, select Help > Record History from the main menu to view the information for the current record.

These fields are typically called as “WHO” columns , they are a standard on nearly every Oracle application database table.

The second piece of useful information is the “Table Name” value for the primary table that stores the data on this form. This is sometimes a Database Table, and can also be a View.

This utility did not function on certain very complex forms, where multiple blocks displayed data from a variety of tables. In this case, a user might be presented with a message the “Record History is not available”.

Related Posts

Posted in AOL | No Comments »Email This Post Email This Post |

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today
Leave a Comment

Please note: Comment moderation is enabled and may delay your comment. There is no need to resubmit your comment.