2 Replies Latest reply: Jan 30, 2013 4:30 AM by Ayan Das RSS

    Error: EGO_USER_ATTRS_DATA_PVT"."Validate_Row_Pvt"

    892257
      Hi All,

      I have a requirement where I have to write a code where the code will fetch values from interface table and based on some validation it will insert the value into User Defined Attribute (table AR.HZ_PER_PROFILES_EXT_B).


      Here is api which will insert the values into AR.HZ_PER_PROFILES_EXT_B table.

      The below code is working fine on one instance and not working on another instance....
      l_ego_row  := ego_user_attr_row_table(ego_user_attr_row_obj(1,
                                                                      l_ego_attr_group_id,
                                                                      NULL, 
                                                                      NULL,
                                                                      NULL,
                                                                      NULL,
                                                                      NULL,
                                                                      NULL,
                                                                      EGO_USER_ATTRS_DATA_PVT.G_SYNC_MODE) );
          l_ego_data := ego_user_attr_data_table( ego_user_attr_data_obj( 1, 
                                                                          'XXAD_DIGIPOST_ADRESSE', 
                                                                          dp_address, 
                                                                          NULL, 
                                                                          NULL, 
                                                                          NULL, NULL, NULL) );
          
          HZ_EXTENSIBILITY_PUB.process_person_record( p_api_version => 1.0, 
                                                      p_person_profile_id =>p_profile_id, 
                                                      p_attributes_row_table => l_ego_row , 
                                                      p_attributes_data_table => l_ego_data , 
                                                      x_failed_row_id_list => l_failed_row_id_list , 
                                                      x_return_status => l_return_status , 
                                                      x_errorcode => l_error_code , 
                                                      x_msg_count => l_msg_count , 
                                                      x_msg_data => l_msg_data );
      Here are the errors which are throwing when I tried this code in another instance can you please let me know the cause of this error....

      Errors:::

      l_return_status: U

      l_error_code:

      l_msg_count: 1

      l_msg_data Executing - "EGO_USER_ATTRS_DATA_PVT"."Validate_Row_Pvt" "ORA-06531: Reference to uninitialized collection

      ORA-06512: at "APPS.EGO_USER_ATTRS_DATA_PVT", line 3087
      ORA-06531: Reference to uninitialized collection
      ORA-01403: no data found"


      Thanks in advance
      889254

      Edited by: 889254 on Apr 3, 2012 10:30 PM