3 Replies Latest reply: Nov 21, 2010 11:40 PM by 817239 RSS

    Customer Coversion Using Interface Table - Error during update

    757366
      I need to import customers from legacy applicatiion and is planning to use standard customer interface for that. For testing, I am able to create customers with hardcoded values. But while I try to update the same customer record (again using hard coded values), it gives me error and is not generating the error report as well. I am getting the following error during update:

      racudc: ORA-20212: Enter valid Billing Fields.
      ORA-06512: at "APPS.ADVOAR_CUST
      racudc: Error updating customers.

      or

      racudc: updated 1 partiesracudc: Partyrel 1 parties
      racudc: ORA-20210: You have edited one of the following fields, Extended Billi
      racudc: Error updating customers.

      Also it seems we can not update an address, site_use_code, or PRIMARY_SITE_USE_FLAG using customer interface.

      The following is the test record I inserted for updating the customer I created and ran the customer interface:

      insert into ra_customers_interface
      (ORIG_SYSTEM_CUSTOMER_REF
      ,INSERT_UPDATE_FLAG
      ,CUSTOMER_NAME
      ,CUSTOMER_STATUS
      ,LAST_UPDATED_BY
      ,LAST_UPDATE_DATE
      ,CREATED_BY
      ,CREATION_DATE
      ,ORIG_SYSTEM_ADDRESS_REF
      ,ADDRESS1
      ,CITY
      ,COUNTY
      ,STATE
      ,POSTAL_CODE
      ,COUNTRY
      ,customer_attribute13
      )
      values
      ('APP1-492503' --ORIG_SYSTEM_CUSTOMER_REF
      ,'U' --INSERT_UPDATE_FLAG
      ,'Pizza Hut - CDH TEST4' --CUSTOMER_NAME
      ,'A' --CUSTOMER_STATUS
      ,-1 --LAST_UPDATED_BY
      ,sysdate --LAST_UPDATE_DATE
      ,-1 --CREATED_BY
      ,sysdate --CREATION_DATE
      --
      --,'Y' --PRIMARY_SITE_USE_FLAG
      --,'BILL_TO' --SITE_USE_CODE
      ,'APP1-492503-ADDR1' --ORIG_SYSTEM_ADDRESS_REF
      ,'1 River Road, Bldg 1' --ADDRESS1
      ,'SCHENECTADY' --CITY
      ,'SCHENECTADY' --COUNTY
      ,'NY' --STATE
      ,12305 --POSTAL_CODE
      ,'US' --COUNTRY
      ,'55'
      )

      I am testing this in 11.5.10 env. Any help on this is appreciated.

      Thanks,
      MK