In Oracle, some of the Receivables objects have been modified, and a new schema, HZ, has been added. Customer data is now stored in the HZ tables. Views such as RA_CUSTOMERS and RA_ADDRESSES are built on these HZ tables.
Customer and related business objects such as Address, Contacts, Sites, and Site_Usage can be maintained by using either the HZ tables or the Customer Interface. The sample business object BO_ORACLEAPPS_CUSTINTERFACE for Oracle uses the Customer Interface to maintain data in the application.
The Customer Interface includes the following five tables:
RA_CUSTOMER-INTERFACE |
RA_CUSTOMER_PROFILES_INTERFACE |
RA_CONTACT_PHONES_INTERFACE |
RA_CUSTOMER_BANKS_INTERFACE |
RA_CUST_PAY_METHOD_INTERFACE |
The Customer business object is hierarchical. Customer details, addresses, and sites details are inserted into the RA_CUSTOMER_INTERFACE table. The details of profile, contact details, bank details, and payment methods are inserted into the RA_CUSTOMER_PROFILES_INTERFACE, RA_CONTACT_PHONES_INTERFACE, RA_CUSTOMER_BANKS_INTERFACE, and RA_CUST_PAY_METHOD_INTERFACE tables.
Once data has been inserted into the Customer Interface tables, the Customer Interface concurrent program must be run to import the customer data into the HZ tables. Three options are available for running the Customer Interface concurrent program:
The Customer Interface concurrent program generates log and out files that detail the customers imported into the Oracle application. The log and out files also contain error messages generated in the event that the interface table data conflicts with the Receivables setup. Check your specific Oracle installation to determine the directory where the log and out files are written.
The Customer Interface allows only Create and Update operations. Create and Update operations are both performed using the Create verb. Delete is not supported through the Customer Interface. However, a logical delete can be performed by updating the customer status to "Inactive". Retrieve operations must use either the base tables or a view defined on the base tables. The sample business object BO_ORACLEAPPS_CUSTRETRIEVE supports Retrieve operations based on the interface tables.