Scripts & Codes (17)

Some frequently used queries for oracle apps developers

1. Get the Complete history of concurrent programs
2. Script to find the Concurrent program request details (Program name, user name, responsibility name)
3. Latest cloned date and Version of Oracle application
4. Script to asign Concurrent Program to a Request group
5. How to get Login Passwords for application & Data Base instances
6. Script to find the list users logged into application
7. Delegation or Vacation rule details
8. Script to find the XML template code using RTF name
9. Script to check Responsibilities assigned to a particular user or users assigned for particular responsibility or all users and their responsibilities:
10. Get all the views that refer a particular table
11. Search all packages for a line of code
12. List of all active workflow users and their roles
13. Script to find Oracle API's for any module:
14. Script to Check Current Applied Patch & Patch level status of all modules
15. Script to display status of all the Concurrent Managers
16. Oracle Flashback Query: Recovering at the Row Level (Recover deleted rows)
17. Script to set org context in Oracle apps R12 and 11i