0 Replies Latest reply on Jan 7, 2016 11:48 AM by LnTInfotech

    Insert value issue in fnd_flex_values_pkg

    LnTInfotech

      Hi All,

       

      I have created the DFF in table FND_FLEX_VALUES_VL with attribute1,attribute2,attribute3,attribute4 but I am facing one issue is the B.COLUMN_NAME which is having two column for same index so want to know how to inset the value in x_attribute1 & x_attribute2 as it is only one column here so I have assigned x_attribute1                   => i_index_info.COLUMN_NAME but for the same index we have two value the for x_attribute2 => i_index_info.COLUMN_NAME also I have to assign same or I need to change the cursor query.

       

      x_attribute1 -> VENDOR_ID

      x_attribute2 --> VENDOR_SITE_ID

       

      SELECT A.INDEX_NAME

      ,A.TABLE_NAME

      ,B.COLUMN_NAME

      ,(CASE WHEN UNIQUENESS='UNIQUE' AND INDEX_TYPE='NORMAL'

        THEN 'UNIQUE'

        WHEN UNIQUENESS='NONUNIQUE' AND INDEX_TYPE='NORMAL'

        THEN ''

        WHEN INDEX_TYPE='BITMAP'

        THEN 'BITMAP'

        END) INDEX_TYPE

      FROM DBA_INDEXES A

      ,ALL_IND_COLUMNS B

      WHERE A.TABLE_NAME=B.TABLE_NAME

      AND A.INDEX_NAME=B.INDEX_NAME

      AND A.TABLE_NAME IN ('XXQBD_VENDOR_SITES_D')

      ORDER BY 1;

       

      Index_name.jpg

       

       

      apps.fnd_flex_values_pkg.

                insert_row (

                  x_rowid                        => l_row_id,

                  x_flex_value_id                => l_flex_value_id,

                  x_attribute_sort_order         => NULL,

                  x_flex_value_set_id            => l_flex_value_set_id,

                  x_flex_value                   => i_index_info.INDEX_NAME,

                  x_enabled_flag                 => 'Y',

                  x_summary_flag                 => 'N',

                  x_start_date_active            => TO_DATE ('01-JAN-1950', 'DD-MON-YYYY'),

                  x_end_date_active              => NULL,

                  x_parent_flex_value_low        => NULL,

                  x_parent_flex_value_high       => NULL,

                  x_structured_hierarchy_level   => NULL,

                  x_hierarchy_level              => NULL,

                  x_compiled_value_attributes    =>  'Y'||CHR(10)||'Y',

                  x_value_category               => 'XXFLS_QBIX_INDEXES',

                  x_attribute1                   => i_index_info.COLUMN_NAME,

                  x_attribute2                   => NULL,

                  x_attribute3                   => NULL,

                  x_attribute4                   => NULL

                );