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 |
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.
Note: For more information on running the Concurrent Manager, see the Oracle Applications User's Guide.
Previous | Next | Contents | Index | Navigation | Library |