ARCustomers

ARCustomers

Use this transaction to create, import, and validate 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

The open interface tables exposed by this transaction are:

RA_CUSTOMERS_INTERFACE_ALL

RA_CUSTOMER_BANKS_INT_ALL

RA_CUST_PAY_METHOD_INT_ALL

RA_CONTACT_PHONES_INT_ALL

RA_CUSTOMER_PROFILES_INT_ALL

Error SQL

Inputs

Field	Description
WM_USER	Name of the user for the corresponding user ID in the CREATED_BY column of the interface table. This parameter will accept wild cards. % returns all errors.
ORIG_SYSTEM_CUSTOMER_REF	Original system identifier loaded in the ORIG_SYSTEM_CUSTOMER_REF column of the interface table. This parameter will accept wild cards. % returns all errors.

Outputs

Field	Description
ERROR_EXISTS	Returns a 1 if an error is found in any of the corresponding interface tables; otherwise, it returns 0.