Oracle Incentive Compensation Implementation Guide

SQL INSERT STATEMENT FOR CREDIT ALLOCATION

In normal situations, you do not need to change this insert statement. It is only necessary to change it if you are performing customizations.

Go to section or comment, which says == > " OIC CODE TO INSERT DATA INTO JTF_TAE_1001_SC_TRANS GOES HERE"

Enter the following SQL script.

    Insert into JTF_TAE_1001_SC_TRANS ( 
            source_id, 
            trans_object_type_id, 
            trans_object_id,
            trans_detail_object_id,  --PARTY SITE ID (TCA)
            squal_num02, --ACCOUNT CODE (TCA)
	            squal_num04, --ACCOUNT HIERARCHY (TCA)
	            squal_char08, --AREA CODE
	            squal_char09, --CATEGORY CODE (TCA)
	            squal_char02, --CITY (AR)
	            squal_curc01, --CURRENCY CODE
	            squal_num06, --COMPANY ANNUAL REVENUE
            squal_char07, --COUNTRY (AR)
            squal_char03, --COUNTY (AR)
            squal_num01,  --PARTY_ID (TCA)
	            squal_fc01, --FIRST CHARACTER OF CUSTOMER NAME RANGE
	            squal_char01, --CUSTOMER NAME RANGE
	            squal_num10, --DUNS NUMBER (TCA)
	            squal_num05, --NUMBER OF EMPLOYEES
            squal_char06, --POSTAL CODE
	            squal_char05, --PROVINCE (AR)
	            squal_num01, --REGISTRY ID (TCA)
	            squal_num03, --SALES PARTNER OF (TCA)
	            squal_char10, --SIC CODE (TCA)
            squal_char04, --STATE (AR)
            worker_id
            )
     SELECT   -1001, 
              -1002, 
             comm_lines_api_id,
            ATTRIBUTE1, --PARTY SITE ID (TCA)
            ATTRIBUTE3, --ACCOUNT CODE (TCA)
            ATTRIBUTE4, --ACCOUNT HIERARCHY (TCA)
            ATTRIBUTE5, --AREA CODE
            ATTRIBUTE6, --CATEGORY CODE (TCA)
            ATTRIBUTE7, --CITY (AR)
            ATTRIBUTE8, --CURRENCY CODE
            ATTRIBUTE9, --COMPANY ANNUAL REVENUE
            ATTRIBUTE10, --COUNTRY (AR)
            ATTRIBUTE11, --COUNTY (AR)
            ATTRIBUTE12,  --PARTY_ID (TCA)
            ATTRIBUTE13, --FIRST CHARACTER OF CUSTOMER NAME RANGE
            ATTRIBUTE14, --CUSTOMER NAME RANGE
            ATTRIBUTE15, --DUNS NUMBER (TCA)
            ATTRIBUTE16, --NUMBER OF EMPLOYEES
            ATTRIBUTE17, --POSTAL CODE
            ATTRIBUTE18, --PROVINCE (AR)
            ATTRIBUTE19, --REGISTRY ID (TCA)
            ATTRIBUTE20, --SALES PARTNER OF (TCA)
            ATTRIBUTE21, --SIC CODE (TCA)
            ATTRIBUTE22, --STATE (AR)
            1
     FROM   cn_comm_lines_api
     
     WHERE  process_batch_id in
     (select process_audit_id from cn_process_audits where parent_ 
process_audit_id = x_conc_program_id);.

SQL Insert Statement for Credit Allocation

SQL INSERT STATEMENT FOR CREDIT ALLOCATION