Query to find Responsibility and Request Group from Concurrent Program
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, ...