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';

ora-00980 synonym translation is no longer valid

synonym translation is no longer valid

Cause: The synonym used is based on a table, view, or synonym that no longer exists.
Action: Replace the synonym with the name of the object it references or re-create the synonym so that it refers to a valid table, view, or synonym.
Oracle docs also has more information on ORA-00980 regarding invalid synonyms.  Here, they reveal that the “ORA-00980: synonym translation is no longer valid” is a common error encountered in a development environment. This ORA-00980 error can happen for many reasons. Some of them are:

1. You created a synonym on non-existing object by mistake. For example, you created a synonym on SCOTT.DEPT where either the SCOTT schema in not present or the DEPT table is missing.
2. You dropped an object but you did not drop the synonyms referencing the object.
3. You dropped a user, but you did not drop synonyms referencing the objects owned by that user.

Keep in mind when reviewing your ORA-00980 situation that as objects become dropped the synonyms are not dropped and they remain until explicitly dropped.