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
Need Help(In customer open interface) the address is not populating can u plz help [message #281274] Fri, 16 November 2007 05:19 Go to next message
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
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 Go to previous message
prashant_pathak
Messages: 263
Registered: February 2006
Location: California,US
Senior Member
what is that some other address? where is pointing too?
Previous Topic: FND_FLEX
Next Topic: Concurrent Request - How to Create / Update schedules using a plsql program
Goto Forum:
  


Current Time: Mon Dec 05 14:47:53 CST 2016

Total time taken to generate the page: 0.15680 seconds