Previous	Next		Contents	Index	Navigation		Library

For example, suppose that you want to move the information in column CUSTOMER_REFERENCE in the RA_CUSTOMER_TRX table in Oracle Receivables into Oracle Sales Compensation. To accomplish this, the data is first moved into one of the 15 attribute columns in the Oracle Sales Compensation intermediate table CN_TRX; from there it is moved into CN_COMM_LINES_API, and then to the appropriate table, CN_COMMISSION_LINES.

Let's suppose that the transaction information will be moved into column ATTRIBUTE1 in the table CN_TRX, and, from there, it will be moved again into the column ATTRIBUTE1 in CN_COMMISSION_LINES. Oracle Sales Compensation moves information from the CN_TRX attribute columns to the attribute columns in the CN_COMMISSION_LINES table by matching the value in a column called the User Column Name. The first part of the mapping procedure, therefore, consists of defining the User Column Name for the Oracle Sales Compensation tables CN_TRX and CN_COMMISSION_LINES on the Tables and Columns form. Table 1 shows the source, interface, and destination tables and columns for the mapping.

Table 1: Source and Destination Tables and Columns for Direct Mapping from Oracle Receivables to Oracle Sales Compensation at the Header Level.

Receivables Source Table	Receivables Source Column Name	Not Applicable
RA_CUSTOMER_TRX	CUSTOMER_REFERENCE
Intermediate Sales Compensation Table	Intermediate Sales Compensation Table Column Name	Intermediate Sales Compensation Table User Name Column
CN_TRX	ATTRIBUTE1	CUST_REF
Destination Sales Compensation Table	Destination Sales Compensation Table Column Name	Destination Sales Compensation Table User Name Column
CN_COMMISSION_LINES	ATTRIBUTE1	CUST_REF

   To define direct mapping at the header level:

1. Navigate to the Tables and Columns form.

By default, choose Tables and Columns from the Setup menu.

2. Select Query->Enter from the menu and type CN_TRX in the Table Name field to execute a query.

3. Select Columns to see the columns in the CN_TRX table.

4. Decide which attribute field you want to hold the data, and move to the row for that column.

In this example, move to the row named ATTRIBUTE1.

5. In the User Column Name field on that row, type a unique name that will identify the information that the column will hold.

For this example, type CUST_REF in the User Column Name field, which stands for CUSTOMER_REFERENCE.

Attention: The name you type in the User Column Name field is your name for the column, and this name must NOT be the same as the system name for the column. If you are bringing in transaction information into the ATTRIBUTE1 field, then the name in the User Column Name field must NOT be ATTRIBUTE1.

6. Repeat step 5 to create a User Column Name for ATTRIBUTE1 in CN_COMMISSION_LINES called CUST_REF.

Now, you must set up the mapping between the CUSTOMER_REFERENCE column in the Oracle Receivables table RA_CUSTOMER_TRX, and the CUST_REF column in the Oracle Sales Compensation table CN_TRX.

7. Navigate to the Receivables Mapping form.

By default, choose Collections from the Setup menu, and then choose Mapping.

8. Select Header from the alternate region.

You use the Header column mappings because the data is at the header level and it is being moved into destination table CN_TRX in Oracle Sales Compensation.

9. With the Header mappings displayed, select Edit->New Record to enter a new mapping.

10. Enter the following values:

Destination Column: ATTRIBUTE1 AR Source Table: RA_CUSTOMER_TRX AR Source Column: CUSTOMER_REFERENCE

11. Save your work and close the AR Mapping window.

   To collect the transaction data according to the mappings you just defined:

1. In the Collections window, select Synchronize.

2. Follow the steps described in Tasks 2 and 3 of the section Overview of the Oracle Receivables Transaction Data Collection Process for the steps required to complete the data collection.

Note: For more information on running the Concurrent Manager, see the Oracle Applications User's Guide.