Find the SQL behind an OA Framework page in Oracle EBS

Опубликовано: 07 Март 2025
на канале: Enginatics
1,523
26

How to find the SQL query behind and OAF page in Oracle EBS

00:00 Query an AP invoice and open the accounting OAF page
00:55 Retrieve the SQL from the 'About this Page' link
01:44 Run the SQL Performance Summary report to retrieve the SQL and bind values
04:15 Run the FND Responsibility Access report to set the SQL session context