Previous	Next		Contents	Index	Navigation		Library

Suppose that you want to keep track of several pieces of information about a customer. Your customer is identified by a customer number in the Oracle Receivables table RA_CUSTOMERS. You use the indirect mapping method to move the data in CUSTOMER_NUMBER in table RA_CUSTOMERS into the ATTRIBUTE2 column in table CN_TRX. In the table CN_TRX, the column SOLD_TO_CUSTOMER_ID can be used as a foreign key for the table RA_CUSTOMERS to select information about the customer identified by the column SOLD_TO_CUSTOMER_ID. The final destination column for the data is ATTRIBUTE4 in table CN_COMMISSION_LINES. Table 4 shows you the source and destination tables for the transaction data.

Table 4: Source and Destination Tables and Columns for Indirect Mappingfrom Oracle Receivables to Oracle Sales Compensation at the Header Levelusing a Foreign Key

Receivables Source Table	Receivables Source Column Name	Receivables Source Table Primary Key	Receivables Source Table Dimension
RA_CUSTOMERS	CUSTOMER_NUMBER	CUSTOMER_ID	CUSTOMERS
Intermediate Sales Compensation Table	Intermediate Sales Compensation Table Column	Intermediate Sales Compensation Table Foreign Key	Intermediate Sales Compensation Table User Name Column
CN_TRX (Header level)	ATTRIBUTE2	SOLD_TO_CUSTOMER_ID	CUST_NUMBER

Destination Sales Compensation Table	Destination Sales Compensation Table Column Name	Destination Sales Compensation Table User Name Column
CN_COMMISSION_LINES	ATTRIBUTE4	CUST_NUMBER

Defining an indirect mapping using a foreign key consists of two main tasks:

   To define a dimension to link the foreign key:

In the AR Mapping window, select an Oracle Receivables table, and select Foreign Key and Expression from the alternate region to see the list of valid foreign keys for that table. These keys are linked to the primary keys by the Dimension name. By default, Oracle Sales Compensation gives you two dimensions: Salespeople and Revenue Class. If you are not using a predefined dimension, you must define the dimension first before you define the Receivables mapping.

Let us suppose we want to define the dimension called CUSTOMERS for the table RA_CUSTOMERS. This dimension will define the link between SOLD_TO_CUSTOMER_ID brought into the CN_TRX table and the record that it corresponds to in the table RA_CUSTOMERS. Follow the steps in Defining a Dimension to define a dimension. The dimension value is CUSTOMER_NUMBER.

   To define the indirect mapping using the defined foreign key:

   To define indirect mapping at the header level using a foreign key:

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 RA_CUSTOMERS in the Table Name field to execute a query.

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

4. Move to the column CUSTOMER_ID and check for the following:

• the primary key flag is on (selected)

• the dimension has been defined

To do this, select Dimensions from the alternate region. Enter the dimension name CUSTOMERS in the Dimension Name field if one does not appear there.

5. Return to the Tables window in the Tables and Columns form.

6. Select Query->Enter from the menu again, type CN_TRX in the Table Name field, and execute a query.

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

8. Move to the column SOLD_TO_CUSTOMER_ID and:

• make sure that the foreign key flag is on (selected)

• set the dimension name to CUSTOMERS

9. Return to the Tables window in the Tables and Columns form.

10. Select Query->Enter from the menu again, and define the following User Column Names:

• For the CN Destination Table, CN_TRX:

For the column ATTRIBUTE2, define the User Column Name = CUST_NUMBER

• For the CN Table, CN_COMMISSION_LINES:

For the column ATTRIBUTE4, set the User Column Name = CUST_NUMBER

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.

Now, you must set up the foreign key mapping between Oracle Receivables table RA_CUSTOMERS the Oracle Sales Compensation table CN_TRX.

11. Navigate to the Receivables Mapping form.

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

12. 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.

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

14. Enter the following values:

Destination Column: ATTRIBUTE2 AR Source Table: RA_CUSTOMERS AR Source Column: CUSTOMER_NUMBER Foreign key: SOLD_TO_CUSTOMER_ID

15. 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.