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 make responsibilities as read only in oracle apps EBS R12 Using Custom.Pll Or Creating a read only Responsibility in oracle apps EBS R12 Using Custom.Pll

  How to make responsibilities as read only in oracle apps EBS R12 Using Custom.Pll Or Creating a read only Responsibility in oracle apps ...