Is there any SQR or other program which lists the number of tables and steps referenced in a given App. Engine program?
This SQL will assist you to give the number of steps involved in the App. Engine:
SELECT A.AE_APPLID, COUNT(*)
FROM PSAESTEPDEFN A
WHERE A.EFFDT =
(SELECT MAX(A_ED.EFFDT) FROM PSAESTEPDEFN A_ED
WHERE A.AE_APPLID = A_ED.AE_APPLID
AND A.AE_SECTION = A_ED.AE_SECTION
AND A.MARKET = A_ED.MARKET
AND A.DBTYPE = A_ED.DBTYPE
AND A_ED.EFFDT <= SYSDATE)
AND A.AE_APPLID =
GROUP BY A.AE_APPLID
PeopleSoft delivers an SQR Report called TBLUSAGE.
In the web-client (Financials 8.4 SP1, PeopleTools 8.43.07) you can access the Run Control page for this process at Setup Financials/Supply Chain, Utilities, Tables Accessed and Updated. This process will create a list of tables for an SQR, App. Engine, COBOL or Query.
*Questions excerpted from ITToolBox.com*
Disclaimer: Contents are not reviewed for correctness and are not endorsed or recommended by PeopleSoft-Planet.com.