OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » Need Help(In customer open interface) the address is not populating can u plz help

Home » Applications » Oracle Fusion Apps & E-Business Suite » Need Help(In customer open interface) the address is not populating can u plz help (Oracel EBS 11..5.10) (

) 1 Vote

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Need Help(In customer open interface) the address is not populating can u plz help [message #281274]

Fri, 16 November 2007 05:19

syed_hussain
Messages: 6
Registered: November 2007
Location: India

Junior Member

Hi AppsGurus,

I have inserted the data into ra_customers_interface_all,ra_customer_profiles_int_all tables and i have run the Customer Interface program and for the parameter create_reciprocal_customer as YES and the data is going to base tables, but the problem is address is not populating correctly.It is populating some other address.

Can anybody plz help.

The below is the insert statement.

INSERT INTO ra_customers_interface_all
(orig_system_customer_ref
,insert_update_flag
,customer_name
,cust_tax_reference
,person_flag
,person_first_name
,person_last_name
,address1
,address2
,address3
,address4
,postal_code
,city
,country
,customer_status
,site_use_code
,primary_site_use_flag
,orig_system_address_ref
,last_updated_by
,last_update_date
,created_by
,creation_date
,org_id
,customer_class_code
)
VALUES
(122
,'I'
,'SYED22'
,4
,'N'
,'SYED'
,'HUSSAIN'
,'KISTA'
,'HUSBY2'
,'NIDAROSGATAN'
,'NGATAN'
,11188
,'STOCKHOLM'
,'SE'
,'A' -- Active
,'BILL_TO'
,'N'
,1230
,-1
,sysdate
,-1
,sysdate
,2
,'BUSINESS'
);

INSERT INTO ra_customer_profiles_int_all
(orig_system_customer_ref
,insert_update_flag
,customer_profile_class_name
,credit_hold
,last_updated_by
,last_update_date
,created_by
,creation_date
,org_id)
VALUES
(122
,'I'
,'3 Insurance Customers'
,'N'
,-1
,sysdate
,-1
,sysdate
,2);

Regards
Syed

Report message to a moderator

Re: Need Help(In customer open interface) the address is not populating can u plz help [message #281431 is a reply to message #281274]

Fri, 16 November 2007 18:05

prashant_pathak
Messages: 263
Registered: February 2006
Location: California,US

Senior Member

what is that some other address? where is pointing too?

Report message to a moderator

Previous Topic:	FND_FLEX
Next Topic:	Concurrent Request - How to Create / Update schedules using a plsql program

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jun 29 00:00:46 CDT 2024