Tuesday, October 24, 2017

JDR_UTILS.LISTDOCUMENTS API to list all OAF Page Extensions/Personalizations in Oracle APPS

JDR_UTILS.LISTDOCUMENTS API to list all OAF Page Extensions/Personalizations in Oracle APPS

JDR_UTILS.LISTDOCUMENTS:-
----------------------------------------------------------------------------------------------
This API list all OA Framework documents in the given path/module. 
It provides list of all the pages/extensions/personalizations.
Parameters:
  •   1st Parameter is Full or Partial path of MDS Repository
  •   2nd Parameter TRUE will direct the API to list all Child Documents underneath that tree path

Partial Path:-
BEGIN
dbms_output.put_line('*******START*******');
jdr_utils.listdocuments('/oracle/apps/ar', TRUE);
dbms_output.put_line('*******STOP*******');
END;
/

Full Path:-
BEGIN
dbms_output.put_line('*******START*******');
jdr_utils.listdocuments('/oracle/apps/ar/cusstd/createcus/webui/ArCreCusPG', TRUE);
dbms_output.put_line('*******STOP*******');
END;
/

No comments:

Post a Comment

Query To Fetch AP Invoice Details From SO Number(Doc ID 2949013.1)

SELECT dh.source_order_number       ,df.source_line_number as so_line_number   ,df.fulfill_line_number    ,ddr.doc_user_key as po_number...