ARCustomers

ARCustomers

Use this transaction to create and import customers, customer profiles, addresses, contacts, and phone numbers from other systems.

For more information about this transaction, see your Oracle Applications documentation.

Oracle Applications Module

Receivables

Open Interface

Customer Transaction

Open Interface Tables

Open interface table(s) exposed by the transaction are as follows:

RA_CUSTOMERS_INTERFACE_ALL

RA_CUSTOMERS_BANKS_INT_ALL

RA_CUST_PAY_METHOD_INT_ALL

RA_CONTACT_PHONES_INT_ALL

RA_CUSTOMER_PROFILES_INT_ALL

Error SQL

Open interface table(s) queried by the error SQL are as follows:

RA_CUSTOMERS_INTERFACE_ALL

FND_USER

Inputs

Field	Description
WM_USER	User ID of the person who initiated the transaction; that is, the user ID in the CREATED_BY field in the transaction.
CUSTOMER_NAME	Customer name to be imported.

Outputs

Field	Description
ORIG_SYSTEM_CUSTOMER_REF	Original system customer reference (that is, primary key for customer in other application).
CUSTOMER_NAME	Name of the customer to be imported.
INTERFACE_STATUS	Error codes. For error code definitions, see http://www.oracle.com/.
PROCESS_MODE	Process flag to indicate whether processing of row succeeded or failed.
CUSTOMER_NAME	Customer name.
ERROR_EXPLANATION	Detailed error message.

Usage Comments

If Customer Interface fails because of the error SQL‐02112 Too Many Rows, you must install Oracle Applications Patch 822300 (for Windows NT).

To import invoice information, run the Customer Interface request, which is under the AR module.

You can run Customer Interface Transfer report to see exact errors.

INACTIVE_FLAG is a required field. Set it to 1 for Yes and 2 for No.