Monday 30 May 2011

How to find how many and what DFF(Descriptive Flex Field) are enabled in the Oracle APPS R12.1 instance

Execute following script :

SELECT TITLE FROM  FND_DESCRIPTIVE_FLEXS_VL
WHERE FREEZE_FLEX_DEFINITION_FLAG='Y' AND LAST_UPDATED_BY NOT IN (-1,1,2,0,120,121);

No comments:

Post a Comment