Group Team

This article help us in assigning a value to the independent value set using FND_FLEX_VALUE_PKG.LOAD_ROW Api.

Independent Value Set ‘TESTVALUESET’ exists in the system. We can query this value set in following Navigation

System Administrator à Application à Validation à Set


Let see if there are any value attached to this independent value set.



As seen in above screen there are no values attached to the value set.

Lets use the below api to attach the value to the independent value set ‘TESTVALUESET’.
API is tested in R12.1.3 instance

DECLARE
   v_enabled_flag           VARCHAR2 (2)              := 'Y';
   v_summary_flag         VARCHAR2 (2)              := 'Y';
   v_start_date_active   DATE                              := SYSDATE;
   v_error_msg                VARCHAR2 (1000)       := NULL;
   v_who_type                 fnd_flex_loader_apis.who_type;
   v_request_id                NUMBER;
   v_rec_success              NUMBER;
   v_rec_error                  NUMBER;
   v_rec_cnt                     NUMBER                        := 0;
   v_user_id                     NUMBER                        := fnd_global.user_id;
   v_login_id                    NUMBER                        := fnd_global.login_id;
   v_req_id                      NUMBER                         := fnd_global.conc_request_id;
   v_value_set_name    VARCHAR2 (50)             := 'TESTVALUESET';
   v_value_set_value    VARCHAR2 (50)              := 'SAMPLEVALUE';
BEGIN
   v_who_type.created_by := v_user_id;
   v_who_type.creation_date := SYSDATE;
   v_who_type.last_updated_by := v_user_id;
   v_who_type.last_update_date := SYSDATE;
   v_who_type.last_update_login := v_login_id;

   BEGIN
      fnd_flex_values_pkg.load_row
               (x_flex_value_set_name        => v_value_set_name,
                x_parent_flex_value_low     => NULL,
                x_flex_value                            => v_value_set_value,
                x_who                                      => v_who_type,
                x_enabled_flag                       => v_enabled_flag,
                x_summary_flag                    => v_summary_flag,
                x_start_date_active              => v_start_date_active,
                x_end_date_active               => NULL,
                x_parent_flex_value_high   => NULL,
                x_structured_hierarchy_level  => NULL,
                x_hierarchy_level                  => NULL,
                x_compiled_value_attributes  => NULL,
                x_value_category                  => NULL,
                x_attribute1                      => NULL,
                x_attribute2                      => NULL,
                x_attribute3                      => NULL,
                x_attribute4                      => NULL,
                x_attribute5                      => NULL,
                x_attribute6                      => NULL,
                x_attribute7                      => NULL,
                x_attribute8                      => NULL,
                x_attribute9                      => NULL,
                x_attribute10                     => NULL,
                x_attribute11                     => NULL,
                x_attribute12                     => NULL,
                x_attribute13                     => NULL,
                x_attribute14                     => NULL,
                x_attribute15                     => NULL,
                x_attribute16                     => NULL,
                x_attribute17                     => NULL,
                x_attribute18                     => NULL,
                x_attribute19                     => NULL,
                x_attribute20                     => NULL,
                x_attribute21                     => NULL,
                x_attribute22                     => NULL,
                x_attribute23                     => NULL,
                x_attribute24                     => NULL,
                x_attribute25                     => NULL,
                x_attribute26                     => NULL,
                x_attribute27                     => NULL,
                x_attribute28                     => NULL,
                x_attribute29                     => NULL,
                x_attribute30                     => NULL,
                x_attribute31                     => NULL,
                x_attribute32                     => NULL,
                x_attribute33                     => NULL,
                x_attribute34                     => NULL,
                x_attribute35                     => NULL,
                x_attribute36                     => NULL,
                x_attribute37                     => NULL,
                x_attribute38                     => NULL,
                x_attribute39                     => NULL,
                x_attribute40                     => NULL,
                x_attribute41                     => NULL,
                x_attribute42                     => NULL,
                x_attribute43                     => NULL,
                x_attribute44                     => NULL,
                x_attribute45                     => NULL,
                x_attribute46                     => NULL,
                x_attribute47                     => NULL,
                x_attribute48                     => NULL,
                x_attribute49                     => NULL,
                x_attribute50                     => NULL,
                x_attribute_sort_order    => NULL,
                x_flex_value_meaning     => v_value_set_value,
                x_description                    => v_value_set_value
               );
      COMMIT;
   EXCEPTION
      WHEN OTHERS
      THEN
         DBMS_OUTPUT.put_line ('Error is ' || SUBSTR (SQLERRM, 1, 1000));
   END;
END;

Once the above api is executed, the value 'SAMPLEVALUE' is attached to the independent value set 'TESTVALUESET' as shown below.




Labels: edit post
3 Responses
  1. Adnan zafar Says:

    Great Man...! it's working fine.

    Adnan zafar Goraya


  2. Sridevi K Says:

    Regards
    Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
    LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
    Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at training@oracleappstechnical.com | +91 - 9581017828.


  3. Spot on script. Copied, pasted, changed Value_set_name and Value_set_value and it worked perfectly. Thank you! You saved me some time!!


Post a Comment