Monday, 30 October 2017

How to find Form Personalization Script or Query in oracle Apps EBS R12

Get Form Personalization Details in oracle apps ( Oracle Applications ) from Database using this Query or Script.

Query to find Form Personalization details by passing form name

SELECT  FFV.FORM_ID,
        FFV.FORM_NAME,
        FFV.USER_FORM_NAME,
        FFV.DESCRIPTION FORM_DESCRIPTION,
        FFCR.SEQUENCE,
        FFCR.DESCRIPTION PERSONALIZATION_NAME
   FROM FND_FORM_VL FFV, FND_FORM_CUSTOM_RULES FFCR
  WHERE FFV.FORM_NAME = FFCR.FORM_NAME
    AND FFV.FORM_NAME = 'POXRQERQ'
ORDER BY FFV.FORM_NAME, FFCR.SEQUENCE;

No comments:

Post a Comment

How to change Employee Number Generation from Manual to Automatic in Oracle HRMS (When attempting to apply for a job in iRecruitment)

When attempting to apply for a job in iRecruitment, the following error occurs: ERROR: You must enter an Application Number. Solution: How t...