EBS Customizations (MOSC)

MOSC Banner

Query to get OAF Personalization details in EBS R12

edited Jan 19, 2021 8:12AM in EBS Customizations (MOSC) 5 commentsAnswered

Hi,

I am looking for a query which can give me below details about all OAF Personalization done in an instance:

OAF Page, document path, extensions(CO,VO etc), Responsibility and function/form/menu entry to which the personalization is done.

I am able to get the first two i.e OAF page and its document path from the below query:

SELECT JP.path_docid DOC_ID

, JP.path_name NAME

, jdr_mds_internal.getdocumentname(JP.path_docid) DOC_PATH

     FROM jdr_paths JP

WHERE JP.path_docid IN ( SELECT DISTINCT comp_docid

FROM jdr_components

WHERE comp_seq = 0

 AND comp_element = 'customization'

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center