Get SQL from an OAF Page
Posted: Mon Jan 25, 2021 10:24 am
1) Set the following profiles
FND: Diagnostics
Personalize Self-Service Defn
2) Open Java OAF Page.
3) Click on About this Page in the bottom left of the page.
4) Expand the Business Component References Details Section and go to the View Objects Sub Section.
5) Click the Object by reading the last few words as might be more than one links
6) Copy the displayed SQL if relevant else click other links.
FND: Diagnostics
Personalize Self-Service Defn
2) Open Java OAF Page.
3) Click on About this Page in the bottom left of the page.
4) Expand the Business Component References Details Section and go to the View Objects Sub Section.
5) Click the Object by reading the last few words as might be more than one links
6) Copy the displayed SQL if relevant else click other links.