This discussion is archived
3 Replies Latest reply: Nov 21, 2010 9:40 PM by 817239 RSS

Customer Coversion Using Interface Table - Error during update

757366 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points