Removing OA Framework Substitutions

Query to find All VO Substitutions

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 ( jdr_mds_internal.Getdocumentname(PATH.path_docid) ) LIKE '%VO%' 
ORDER  BY perz_doc_path; 


In order to delete the customization definition, use the below call -

BEGIN 
jdr_utils.Deletedocument('/oracle/apps/icx/por/reqmgmt/server/customizations/site/0/AllReqsVO');
END; 


BEGIN 
jdr_utils.Deletedocument('/oracle/apps/fnd/server/customizations/site/0/FndAttachedDocumentsDomExtensionVO');
END;