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);.