The other day I was asked to find all the supplier sites that are that have the “Transportation Arranged”  option set to “Buying Organization”.  Normally, I would do a query in a form and then use the Examine feature to find the query.  But in R12, the suppliers are now in web pages.  It seemed my old trick would work in Oracle’s new OA framework.  But luckily, Oracle has the same functionality in the “About this Page”  link.  If you want to find the SQL query behind any web page, you need to enable personalization and then use “About this Page” to find the view object.  Below is an example using Supplier sites:

Step 1: Enable the personalization profile

a)      Under the system admin responsibility, open the system profiles form

b)      Change the “Personalize Self-Service Defn” profile to yes for your responsibility

Step 2: Perform the business process as you would normally do.

a)      Using the Payables Manager responsibility, open the Suppliers web page

b)      Find your supplier

c)       Click the Purchasing link

d)      Click the Freight tab

Step 3: Click the About the Page link

Step 4:  Click the Page tab and then click the Expand button on the business components section

Step 5: Find you view object and click the link

Step 6: Select the SQL query and copy it to your favorite SQL tool (TOAD, SQL Developer,..)

Step 7: Replace and variables (anything that has a colon in front of it) with your data and test the query

Step 8: Modify the query to fit your needs.

Comments are closed.

Looking for something?

Use the form below to search the site:

Still not finding what you're looking for? Drop a comment on a post or contact us so we can take care of it!