This page gives a few easy DIY (Do It Yourself) steps to resolve Oracle Application Framework (OAF) personalization page
Problem:
- OAF personalization done
- Page gives error and not able to recover
Solution:
1. Identify personalization
SELECT
PATH.PATH_DOCID PERZ_DOC_ID,
jdr_mds_internal.getdocumentname(PATH.PATH_DOCID)
PERZ_DOC_PATH, 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
path.creation_date > sysdate-.04
ORDER
BY PERZ_DOC_PATH;
97016 /oracle/apps/iby/fundcapture/transaction/request/webui/customizations/site/0/AuthorizationsSearchPG AuthorizationsSearchPG
2. Delete customization
begin
jdr_utils.deleteDocument('/oracle/apps/iby/fundcapture/transaction/request/webui/customizations/site/0/AuthorizationsSearchPG');
end;
/
commit;
3. Bounce OA CORE Server
{
echo Password123 ; }| admanagedsrvctl.sh abort oacore_server1 @-nopromptmsg
{
echo Password123; }| admanagedsrvctl.sh start oacore_server1 @-nopromptmsg
The changes normally do not require bouncing or clearing cache. But
if the steps fails to resolve the error, try after bouncing middle tier.
Keywords:
Oracle EBS, R12, R12.2.8, Oracle Applications, OAF, OA Framework,
Personalization, Customization, HTML UI Page, page.xml
