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
Accounts Receivable
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 (i.e. primary key for customer in other application). |
CUSTOMER_NAME | Name of the customer to be imported. |
INTERFACE_STATUS | |
PROCESS_MODE | Process flag to indicate whether processing of row succeeded or failed. |
CUSTOMER_NAME | Customer name. |
ERROR_EXPLANATION | Detailed error message. |
Usage Comments
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.