Home » Applications » Oracle Fusion Apps & E-Business Suite » abt customer interface problem
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
Previous Topic: Convert Sale Order to Internal Requisition / Purchase Order
Next Topic: Invoice type got blank..very rare issue plz help
Goto Forum:
  


Current Time: Thu Dec 08 08:31:25 CST 2016

Total time taken to generate the page: 0.19398 seconds