Vamsi Oracle Technical Blog

 In this blog, we’ll break down a query that helps you trace a specific Concurrent Program through its Application , Request Group , and associated Responsibilities in Oracle EBS R12 Objective The goal of this query is to find: The User-Friendly Name of a Concurrent Program The Technical Concurrent Program Name The Application to which it belongs The Request Group under which it is registered The Responsibility that grants access to it This is especially useful for ensuring correct program registration or for debugging access issues. SQL Query:      SELECT DISTINCT      fcpl.user_concurrent_program_name,     fcp.concurrent_program_name,     fapp.application_name,     frg.request_group_name,     fnrtl.responsibility_name FROM      apps.fnd_request_groups         frg,     apps.fnd_application_tl         fapp,   ...

Oracle stores passwords in encrypted format, and this SQL script demonstrates how you can decrypt user passwords using standard EBS API functions such as get_pwd.decrypt . Important Note : This script is for educational and internal system diagnostics only. Never use it in production environments without proper security authorization. Use Case This SQL is particularly useful for: Testing internal password decryption functionality Validating password migrations during EBS clone or refresh Technical support or audit trails in development/test environments SQL Query:      SELECT usr.user_name,        get_pwd.decrypt           ((SELECT (SELECT get_pwd.decrypt                               (fnd_web_sec.get_guest_username_pwd,                                usertable.e...