OAF Oracle Docs

How To Define DFF On PPR OAF page (Doc ID 1666725.1)

R12 OAF - How to Format Mask a Number Column? (Doc ID 1500731.1)

Generating the log and trace for self service/OAF issues (Doc ID 1564962.1)

How To Enable DFF On Payment Process Request OAF Page (Doc ID 1368958.1)

How To Launch EBS Forms From A Self Service OAF/Framework Page? (Doc ID 1618970.1)

How To Implement Shuttle Region Combo to Pick Up email addresses In OAF Using Personalization (Doc ID 1561029.1)

How to Setup EBS 12.1.3 / 12.2.x OAF with Webcenter Content AXF Managed Attachments (Doc ID 1927793.1)

View SQL Statement from OAF Page

Below are the detailed steps:

1) Update the following Profile Option Values to Yes at User level.
• FND: Diagnostics
• Personalize Self-Service Defn

2) Go to the Java OAF Page where the SQL Query executes

3) Click on the link About this Page in the bottom Left Hand Side of the page

4) Navigate to the Page Tab on the Top Left Hand Side of the page

5) In the Business Component References Details Section (You may need to expand this
section), Go to the View Objects Sub Section.

6) Find the Object that describes the piece of information that you want to find the query for

7) Click on the Link

8) The full Query used can be cut and pasted into a SQL Editor and the query run.
Note: You will have to find the Bind Variables passed to the query in order to do this!!

SQL Query to get all the personalization on the OAF pages in the application

SELECT   PATH.path_docid perz_doc_id,
         jdr_mds_internal.getdocumentname (PATH.path_docid) perz_doc_path
    FROM jdr_paths PATH
   WHERE PATH.path_docid IN (
            SELECT DISTINCT comp_docid
                       FROM jdr_components
                      WHERE comp_seq = 0
                        AND comp_element = 'customization'
                        AND comp_id IS NULL)
     AND UPPER (jdr_mds_internal.getdocumentname (PATH.path_docid)) LIKE
                                                 UPPER ('%AbsenceHomePagePG%')
ORDER BY perz_doc_path;