Import customers using interface tables in Oracle Apps R12

To Import Customers using interface tables

Step 01. 

Insert the data in ra_customers_interface_all and ra_customer_profiles_int_all

insert into ra_customers_interface_all
(orig_system_customer_ref, -- SHOULD BE UNIQUE
insert_update_flag,
customer_name, -- SHOULD BE UNIQUE
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, -- SHOULD BE UNIQUE
last_updated_by,
created_by,
creation_date,
org_id,
customer_type)
values( 2007, -- will be incremented
'I',
'Muhammad Ahmed',
4,
'ABM',
'MRO',
F10/1,
F10/2,
F10/3,
F10/4,
44000,
ISLAMABAD,
'PK',
'A',
'BILL TO',
'N',
'7002,
1327,
SYSDATE,
1327,
SYSDATE,
204, 
'R');

INSERT INTO RA_CUSTOMER_PROFILES_INT_ALL
(orig_system_customer_ref, -- SHOULD BE REFER THE ABOVE
-- ar_customers_interface_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
(2007,
'I',
'DEFAULT', 
'N',
1327,
SYSDATE,
1327,
SYSDATE,
204);

Step 02. 

Logon to receivables responsibility >> Receivables >> Request Customer interface
or logon to receivables responsibility >> Receivables >> Interfaces >> Customer

Step 03. 

Verify the customer in Apps:
>> Customers >> Customers
enter the customer name and click go:

select * from ar_customers
where customer_name like 'Muhammad Ahmed';