Oracle Applications: AR Customer Interface R12

The Customer Interface Data flows to Receivables as shown in the above figure.

To import the Customer information, following Interface Tables have to be populated with mentioned Mandatory columns.

RA_CUSTOMERS_INTERFACE

To import a customer, address, or business purpose, populate the following mandatory columns of RA_CUSTOMERS_INTERFACE:

ORIG_SYSTEM_CUSTOMER_REF

INSERT_UPDATE_FLAG

CUSTOMER_NAME

CUSTOMER_NUMBER (if you are not using Automatic Customer Numbering)

CUSTOMER_STATUS

LAST_UPDATED_BY

LAST_UPDATE_DATE

CREATED_BY

CREATION_DATE

If you are importing an address and a business purpose, you must also populate the following tables:

PRIMARY_SITE_USE_FLAG (if you are inserting an address)

LOCATION (if you are not using Automatic Site Numbering)

SITE_USE_CODE (if you are inserting an address)

ADDRESS1

Receivable requires that you separate your city, state, and postal codes, whereas your current system may not. To save time, separate these components in your current system before importing customers into Receivables.

ORIG_SYSTEM_ADDRESS_REF

You must enter values for the columns you reference in your Tax Location Flexfield if you are calculating sales tax and your Address Validation option is set to 'Error.' (You define this option in the System Options window, Tax alternative region.)

COUNTRY

RA_CUSTOMER_PROFILES_INTERFACE

A customer level profile must exist in RA_CUSTOMER_PROFILES_INTERFACE for new customers and each Bill-To Business Purpose.

ORIG_SYSTEM_CUSTOMER_REF

INSERT_UPDATE_FLAG

CUSTOMER_PROFILE_CLASS_NAME

If you did not pass a value in this column, you must enter values in the following columns:

COLLECTOR_NAME

CREDIT_BALANCE_STATEMENTS

CREDIT_CHECKING

AUTO_REC_INCL_DISPUTED_FLAG

DISCOUNT_TERMS

DUNNING_LETTERS (if 'Y,' you must also enter a value in DUNNING_LETTER_SET_NAME)

INTEREST_CHARGES (if 'Y,' you must also enter values in INTEREST_PERIOD_DAYS and CHARGE_ON_FINANCE_CHARGE_FLAG

STATEMENTS (if 'Y,' you must also enter a value in STATEMENT_CYCLE_NAME)

TOLERANCE

TAX_PRINTING_OPTION

OVERRIDE_TERMS

GROUPING_RULE_NAME

CREDIT_HOLD

LAST_UPDATED_BY

LAST_UPDATE_DATE

CREATED_BY

CREATION_DATE

If you are entering a profile for a customer address, you must also enter a Bill-To site in ORIG_SYSTEM_ADDRESS_REF.

RA_CONTACT_PHONES_INTERFACE

To import telephone numbers for customers, addresses, and contacts, populate the following mandatory columns of RA_CONTACT_PHONES_INTERFACE:

ORIG_SYSTEM_CUSTOMER_REF

ORIG_SYSTEM_TELEPHONE_REF

INSERT_UPDATE_FLAG

TELEPHONE

TELEPHONE_TYPE

LAST_UPDATED_BY

LAST_UPDATE_DATE

CREATED_BY

CREATION_DATE

If you are entering a telephone number for an address, you must also enter a value in ORIG_SYSTEM_ADDRESS_REF.

If you are entering a telephone number for a contact, you must also enter a value in ORIG_SYSTEM_CONTACT_REF and CONTACT_LAST_NAME.
RA_CUSTOMER_BANKS_INTERFACE
To import banks for customers and Bill-To business purposes, use the above table.
RA_CUST_PAY_METHOD_INTERFACE
To import payment methods for customers and Bill-To business purposes, use the above table.

--->:====================================================================

--->: SAMPLE TECHNICAL INPUTS TO RUN THE CUSTOMER INTERFACE.

--->:====================================================================

TRUNCATE TABLE ar.ra_customers_interface_all;

INSERT INTO ar.ra_customers_interface_all

(

orig_system_customer_ref,

customer_name,

orig_system_address_ref,

address1,

address2,

address3,

address4,

city,

county,

state,

province,

country,

postal_code,

site_use_code,

primary_site_use_flag,

customer_status,

insert_update_flag,

last_updated_by,

last_update_date,

created_by,

creation_date,

customer_number,

customer_name_phonetic,

customer_category_code,

location,

org_id

)

VALUES

(

'01-00-01', --->: orig_system_reference

'CUSTOMERNAME0', --->: customer_name

'01-00-01', --->: orig_system_address_ref, change it if you put another address

'ADDRESS0', --->: address1

NULL, --->: address2

NULL, --->: address3

NULL, --->: address4

'San Mateo', --->: city

'San Mateo', --->: county

'CA', --->: state

NULL, --->: provice

'US', --->: country

'94401', --->: postal_code

'BILL_TO', --->: SITE USE

'Y', --->: primary_site_use_flag

'A', --->: customer_staus

'I', --->: insert_update_flag

-1, --->: last_updated_by

sysdate, --->: last_update_date

-1, --->: created_by

sysdate, --->: creation_date

NULL, --->: customer_number if automatic customer number is no

'CUSTOMERNAME0', --->: customer_name_phonetic

'CUSTOMER', --->: customer_category_code

NULL, --->: location if autositenumber is no

204 --->: org_id

);

--->:====================================================================

--->: INSERT THE CUSTOMER PROFILE INFORMATION

--->:====================================================================

TRUNCATE TABLE ar.ra_customer_profiles_int_all;

INSERT INTO ar.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

(

'01-00-01', --->: orig_system_customer_ref

'I', --->: insert_update_flag

'DEFAULT', --->: Should be valid profile class

'N', --->: This can be 'Y','N' not null.

-1, --->: last_updated_by

sysdate, --->: last_update_date

-1, --->: created_by

sysdate, --->: created_by

204 --->: org_id

);

--->:====================================================================

--->: INSERT THE CUSTOMER PHONES & CONTACT INFORMATION

--->:====================================================================

INSERT

INTO

ra_contact_phones_int_all

(

orig_system_contact_ref,

orig_system_telephone_ref,

orig_system_customer_ref,

orig_system_address_ref,

insert_update_flag,

contact_first_name,

contact_last_name,

contact_title,

contact_job_title,

telephone,

telephone_extension,

telephone_type,

telephone_area_code,

last_updated_by,

last_update_date,

created_by,

creation_date,

last_update_login,

sex_code,

salutation,

email_address,

mail_stop,

contact_key,

org_id,

contact_job_title_code,

contact_point_type

)

VALUES

(

'01-00-01',--->:orig_system_contact_ref,

'01-00-01',--->:orig_system_telephone_ref,

'01-00-01',--->:orig_system_customer_ref,

'01-00-01',--->:orig_system_address_ref,

'I',

'CUSTOMERFirstNAME0', --->:contact_first_name,

'CUSTOMERlastNAME0', --->:contact_last_name,

NULL, --->:contact_title,

NULL, --->:contact_job_title,

40986341, --->:telephone,

6341, --->:telephone_extension,

Land line, --->:telephone_type,

91-80, --->:telephone_area_code,

fnd_global.user_id,

SYSDATE,

fnd_global.user_id,

SYSDATE,

fnd_global.login_id,

Male, --->:sex_code,

NULL, --->:salutation,

Customername@company.com,--->:email_address,

NULL, --->:mail_stop,

NULL, --->:contact_key,

v_org_id,

Customer, --->:contact_job_title_code,

Email/Phone ,--->:contact_point_type

);

commit;

--->:====================================================================

--->: RUN CUSTOMER INTERFACE PROGRAM FROM THE APPLICATION.

--->:====================================================================

V_REQUEST_ID := APPS.FND_REQUEST.SUBMIT_REQUEST

( 'AR'

, 'RACUST'

, ''

, FALSE

, P_CREATE_RECIPROCAL_FLAG

, P_ORG_ID

, CHR(0)--->: End of parameters

);

--->:====================================================================

Customer Interface transfers customer data from the interface tables into the following tables:

AR_CUSTOMER_PROFILES

AR_CUSTOMER_PROFILE_AMOUNTS

RA_ADDRESSES

RA_CONTACTS

RA_CUSTOMERS

RA_CUSTOMER_RELATIONSHIPS

RA_CUST_RECEIPT_METHODS

RA_PHONES

RA_SITE_USES

AP_BANK_ACCOUNT_USES

AP_BANK_ACCOUNTS

AP_BANK_BRANCHES

The Customer Interface program will not allow updates to the following tables:

RA_SITE_USES

RA_CUSTOMER_RELATIONSHIPS

RA_CUST_RECEIPT_METHODS

AP_BANK_BRANCHES

AP_BANK_ACCOUNTS

AP_BANK_ACCOUNT_USES

Caution: The Customer Interface Transfer Report will not display errors for records attempting to update these tables; the records will simply not be processed.