4 Replies Latest reply on Oct 10, 2018 5:36 PM by Lalitha Subramanian

    R12.2.7 EBS Segment Values

    Lalitha Subramanian

      Hello All,

      We are in a process of upgrading from R12.1.3 to R12.2.7 and we got our first R12.2.7 instance and search Flexfield Values returns no records.. When i check the system Query

      SELECT PARENT_VALUE_SET_NAME,

             PARENT_VALUE_SET_DESCRIPTION,

             DEP_VALUE_SET_NAME,

             DEP_VALUE_SET_DESCRIPTION,

             FLEX_VALUE,

             VALUE_DESCRIPTION,

             DEP_VALUE_SET_ID,

             PARENT_FLEX_VALUE_SET_ID,

             FLEX_VALUE_SET_ID,

             SECURITY_ENABLED_FLAG,

             VALIDATION_TYPE,

             SUMMARY_ALLOWED_FLAG

        FROM appS.FND_FLEX_VSET_V

      WHERE     (1 = 2)

             AND (   validation_type IN ('I',

                                         'D',

                                         'X',

                                         'Y')

                  OR (validation_type = 'F' AND summary_allowed_flag = 'Y'))

             AND (PARENT_VALUE_SET_NAME LIKE '%')

       

      which will never be true..  What should we do to get it fixed.

      Thanks

      Lalitha