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 get the Concurrent Program along with Value Set details

SELECT fcpl1.user_concurrent_program_name       ,fdfcuv.end_user_column_name       ,ffvs.flex_value_set_name value_set_name       ,ffvt.appl...