ERP Associates, Inc. - How to quickly find what tables a batch process uses

How to quickly find what tables a batch process uses

Monday, 20 March 2006

I just ran across a utility available in PeopleSoft called the "Tables Accessed and Updated Utility". It shows what tables an Application Engine, COBOL, SQR, Query or SQR Report uses.

It's an SQR program, and actually steps through the code to get the table list. It then bounces the tables in the list off the valid tables defined in PeopleSoft to generate the report.

Although you don't need something like this very often, it would be a quick way to tell if a process could have been responsible for a suspicious result, or if you need to know what processes access a particular table.

In Financials, the navigation is Setup Financials/Supply Chain > Utilities > Tables Accessed and Updated.

Here's how it looks in Financials 8.8:
Tables Accessed Run Control

Comments (5)

Comment from Suzie : Suzie

That's awesome! Thanks for the tip. I did not know about that utility.

April 20, 2006

... : Deviprasad

I am unable to find this utility either in 8.45 or 8.9. can you please tell me where can i find thie in these versions.

July 10, 2007

... : Brent Martin

I found it in Financials 8.9 under Set Up Financials/Supply Chain - Common Definitions - Tables Accessed and Updated.

July 11, 2007

... : Vivek

If you are Using HRMS 8.43 and higher grade versions .. Please use this link for finding the same ::

System Administration--> Utilities --> Tables Accessed and Updated

April 13, 2008

... : TH

Thanks, I was not knowing this.

May 15, 2008

Write comment

Last Updated ( Monday, 20 March 2006 )

< Prev		Next >

[ Back ]

Main Menu

Syndicate

CB Login

Recommended Products