0 Replies Latest reply on Mar 31, 2017 9:13 AM by Angela0086-Oracle

    How to Update Table Type Value Set Using API

    Angela0086-Oracle

      Dear all,

       

      We are trying to update an existing table type value set using the api fnd_flex_loader_apis.up_vset_table. The api is supposed to update fnd_flex_validation_tables table, but we can not see the expected update in the table.

      We need a guidance on this. We are using the below code to update the where clause of the a table type valueset.

       

      BEGIN

      fnd_flex_loader_apis.up_vset_table

                (p_upload_phase  =>  NULL,

                 p_upload_mode  =>   NULL,

                 p_custom_mode  =>  'FORCE',

                 p_flex_value_set_name  =>  'TEST_VALUE_SET',

                 p_owner  =>  NULL,

                 p_last_update_date  =>  SYSDATE,

                 p_table_application_short_name  =>  'XXX',

                 p_application_table_name  =>  NULL,

                 p_summary_allowed_flag  => NULL,

                 p_value_column_name  =>  NULL,

                 p_value_column_type  =>  NULL,

                 p_value_column_size  =>  NULL,

                 p_id_column_name  =>  NULL,

                 p_id_column_type  =>  NULL,

                 p_id_column_size  =>  NULL,

                 p_meaning_column_name  =>  NULL,

                 p_meaning_column_type  =>  NULL,

                 p_meaning_column_size  =>  NULL,

                 p_enabled_column_name  =>  NULL,

                 p_compiled_attribute_column_na  =>  NULL,

                 p_hierarchy_level_column_name  =>  NULL,

                 p_start_date_column_name  =>  NULL,

                 p_end_date_column_name  =>  NULL,

                 p_summary_column_name  =>  NULL,

                 p_additional_where_clause  =>  'trunc(SYSDATE) BETWEEN a.effective_start_date AND a.effective_end_date AND a.person_type_id=b.person_type_id AND b.system_person_type IN (''EMP'',''EX_EMP'') AND a.person_id=c.employee_id(+) AND upper(a.last_name) LIKE ''%BROWN%''',

                 p_additional_quickpick_columns => NULL);

      EXCEPTION

      WHEN OTHERS THEN

        dbms_output.put_line('Error');

      END;

       

      Thanks &Best regards,