How to Force-Logout Idle or Stuck Oracle EBS Users With One PL/SQL Package (Free Script Inside)

  How to Force-Logout Idle or Stuck Oracle EBS Users With One PL/SQL Package (Free Script Inside) If you've ever administered Oracle E-...

Showing posts with label How to find Form Personalization Script or Query in oracle Apps EBS R12. Show all posts
Showing posts with label How to find Form Personalization Script or Query in oracle Apps EBS R12. Show all posts

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;