Search 800 + Posts

Oct 22, 2009

How to get complete Techniacal details of a Applications(Module)

Oracle Application has shipped a standard concurrent Program "Diagnostic Apps check" concurrent Program.
This Concurrent program take application name like (Order Management, Bill of Material, Account Receivable etc) as parameter and PRINTS the complete details about that Application (Module) like

1.All tables included custom if created in that instance
2.All triggers/Indexex
3.All Packages including custom also print the standard package file name along with the version.
4.All Profile options.

This is very interested and useful package if you want to see what all objects are associated with a particular Module.

No comments:

Post a Comment