abt customer interface problem [message #206008] |
Tue, 28 November 2006 06:09 |
seenujanu
Messages: 53 Registered: August 2006 Location: chennai
|
Member |
|
|
Hi Gareth Roberts
i am getting problem when i am running the programme
The problem is
customer information is storing in main tabels but the thing is not properly inserted abt address.
when i query the customer information in AR ->customer->standard forms ,i will get the details of customer name,no
but the problem is it is not populating in the address field...and when i click on the open to get the details also…
i have searched in metalink i got the error but how should i rectify this i am not getting.
now i have loaded with new data but it is not loading
wat should i do for this
still i am getting the problem would u plz resolve this .i am
sending the sample data,the data is not loading into tables
showin the error
Customer Reference Address Reference Site Use Error Message
c100020 A200020 BILL_TO
Customer record for insert must have validated profile record de fined in the RA_CUSTOMER_PROFILES_INTERFACE table
c100020 A200020
A new location was created for a value in an address segment fie ld
c100020 A200020
Customer record for insert must have validated profile record de fined in the RA_CUSTOMER_PROFILES_INTERFACE table.
The customer reference specified does not exist in the HZ_CUST_A CCOUNTS table or the RA_CUSTOMERS_INTERFACE table. The customer reference could also be in error in the RA_CUSTOMERS_INTERFACE table.
The data is
INSERT INTO ra_customers_interface
(
CUSTOMER_NAME ,
orig_system_customer_ref,
CUSTOMER_STATUS ,
SITE_USE_CODE ,
ORIG_SYSTEM_ADDRESS_REF ,
) ORG_ID
values
(
‘Jhon’,’c100020’,’A’,’BILL_TO’,’A200020’,204
)
insert into RA_CUSTOMER_PROFILES_INTERFACE
(
CUSTOMER_PROFILE_CLASS_NAME,
ORIG_SYSTEM_CUSTOMER_REF,
ORIG_SYSTEM_ADDRESS_REF ,
)
Values
(
‘Average’,’c100020’,’A200020’
)
Thanks in advance
seenu
|
|
|