Form personalization tables in oracle apps

Hi friends, we are going to discuss about the Form personalization tables in oracle apps. We will share the detail information's about Form personalization tables which helps to store the oracle apps forms personalization informations. Using these from personalization tables we can able to extract Form Personalizations created in oracle application and for against which oracle form these professionalization working. Using these form personalization table we can able to write the sql query which helps to extract form personalization created against which oracle forms. These Form personalization tables helps to keep track of how many personalization currently working against which oracle forms. In oracle apps application, if we are using form personalization then we should have the track of which personalization working in which oracle forms so that we should have the idea of the oracle form working. Please find below the complete detail about Form personalization tables in oracle apps.

Form personalization tables in oracle apps

6 Important Form personalization tables in oracle apps

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 Extract Form Personalization Detail in Oracle Apps

Here below is the detail sql query to extract the  form personalization details 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,

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;

Form personalization tables in oracle apps