OAF customizations queries

•By admin

OAF customizations queries
Query to list all pages under any top/directory
Query to list all customizations on a OAF page
Query to get xml code of an OAF page/module
Query to delete any OAF customization
Query to find all changes done to OAF Pages in the application

Query to list all pages under any top/directory
SQL Query
sql
1--Query to list all pages under any top/directory
2set serveroutput on;
3DECLARE
4BEGIN
5   jdr_utils.listdocuments ('/oracle/apps/per', TRUE);
6END;
Query to list all customizations on a OAF page
SQL Query
sql
1--Query to list all customizations on a OAF page
2set serveroutput on;
3DECLARE
4BEGIN
5   jdr_utils.listcustomizations (p_document   => '/oracle/apps/per/irc/candidateSelfService/webui/RegCreateAccountPG');
6END;
Query to get xml code of an OAF page/module
SQL Query
sql
1--Query to get xml code of an OAF page/module
2set serveroutput on;
3DECLARE
4BEGIN
5   jdr_utils.printdocument (
6      p_document   => '/oracle/apps/per/irc/candidateSelfService/webui/RegCreateAccountPG');
7END;
Query to delete any OAF customization
SQL Query
sql
1--Query to delete any OAF customization
2set serveroutput on;
3DECLARE
4BEGIN
5   jdr_utils.deletedocument (
6      p_document   => '/oracle/apps/per/irc/candidateSelfService/server/customizations/site/0/VisitorAM');
7END;
Query to find all changes done to OAF Pages in the application
SQL Query
sql
1--The below query helps to find all changes done to OAF Pages in the application.
2  SELECT PATH.path_docid                                  perz_doc_id,
3         jdr_mds_internal.getdocumentname (PATH.path_docid) perz_doc_path
4    FROM jdr_paths PATH
5   WHERE     PATH.path_docid IN
6                (SELECT DISTINCT comp_docid
7                   FROM jdr_components
8                  WHERE     comp_seq = 0
9                        AND comp_element = 'customization'
10                        AND comp_id IS NULL)
11         AND UPPER (jdr_mds_internal.getdocumentname (PATH.path_docid)) LIKE
12                UPPER ('%%')-- document path here
13ORDER BY perz_doc_path;