How to check form personalization in oracle apps from backend

Hi friends, we are going to discuss about How to check form personalization in oracle apps from backend. We will share the steps to check form personalization in oracle apps from backend. To check form personalization from back end , we need to develop the sql query which will help to extract the form personalization details in oracle apps. Using this sql query , we can able to check which are the form personalization working against which oracle forms in oracle apps. 

How to check form personalization in oracle apps from backend

6 Important Tables Uses in the Query to check form personalization in oracle apps from backend

1.FND_FORM_CUSTOM_RULES

2.FND_FORM_CUSTOM_PARAMS

3.FND_FORM_CUSTOM_PROP_VALUES

4.FND_FORM_CUSTOM_PROP_LIST

5.FND_FORM_CUSTOM_SCOPES

6.FND_FORM_CUSTOM_ACTIONS

Detail SQL Query to check form personalization in oracle apps from backend

Here below is the detail sql query which will help to check from personalization in oracle apps.

SELECT DISTINCT A.FORM_NAME,

A.FUNCTION_NAME,

A.ENABLED,

C.USER_FORM_NAME,

D.APPLICATION_NAME,

A.SEQUENCE,

A.TRIGGER_EVENT,

A.DESCRIPTION personalization_rule_name,

A.CONDITION

FROM FND_FORM_CUSTOM_RULES A,

FND_FORM B,

FND_FORM_TL C,

FND_APPLICATION_TL D 

WHERE ENABLED = 'Y' 

AND A.FORM_NAME = B.FORM_NAME 

AND B.FORM_ID = C.FORM_ID 

AND B.APPLICATION_ID = D.APPLICATION_ID 

ORDER BY APPLICATION_NAME;

How to check form personalization in oracle apps from backend