Friday, November 27, 2009

Analyze a Process

If you want to know what are all the tables are used in Application Engine, COBOL, SQR, Query or SQR Report.
Its an SQR report which will parse all the lines and produces output with what are all tables accessed and its access mode.

In Financials 8.9, the navigation is Setup Financials/Supply Chain > Common Definitions > Tables Accessed and Updated
In HRMS 8.9,the navigation is Set Up HRMS>System Administration>Utilities>Tables Accessed and Updated

Thursday, November 5, 2009

Exploring Application engine

-Max 200 state records associated with a Application Engine.
-Application Engine erases the contents of derived state records at commit time if Restart is enabled for the current process.
-Unless you have disabled Restart, derived work records have their field values reinitialized after each commit
- The called program inherits the calling program's default state record
- Any changes made by the called program remain when control returns to the calling program.
- Does not commit a step containing a Do Select action with the Select/Fetch option enabled.