My Oracle Support Banner

Error running Sales Credit Allocation (SCA) - CN_SCATM_TAE_PUB.get_credited_txns for INSERT has failed (Doc ID 1299426.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle Incentive Compensation - Version 12.1.1 and later
Information in this document applies to any platform.

Symptoms

Try to run the SCA program but getting below errors in CN_SCATM_COLLECT_TRANS_BATCH process log

SCA : End of get_where_clause
SCA : CN_SCATM_TAE_PUB.get_where_clause completed successfully
SCA : CN_SCATM_TAE_PUB.get_credited_txns for INSERT has failed
SCA : CN_SCATM_TAE_PUB.get_assignments.g_exc_error
SCA : SQLCODE : 1
SCA : SQLERRM : User-Defined Exception
SCA : End of SCATM


With enable debug profile options are on, run query

SQL>
select timestamp, module, message_text, log_sequence
from fnd_log_messages
where module like ''jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_trans_data%'
and timestamp >= to_date('&date', 'DD-MON-YYYY');


Get debug message as below

jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_trans_data.final_sql "Insert satement : INSERT INTO JTF_TAE_1001_SC_DEA_TRANS(
...
...
FROM (
SELECT /*+ index(cn_comm_lines_api_all CN_COMM_LINES_API_N15) */
org_id,
-1001 source_id,
-1002 trans_object_type_id,
comm_lines_api_id trans_object_id,
comm_lines_api_id trans_detail_object_id,
'ORGANIZATION' party_type,
attribute2 squal_num02,
to_number(attribute3) squal_num04,
attribute4 squal_char08,
attribute5 squal_char09,
attribute7 squal_char02,
attribute8 squal_curc01,
to_number(attribute9) squal_num06,
attribute10 squal_char07,
attribute11 squal_char03,
substr(attribute14,1,1) squal_fc01,
attribute14 squal_char01,
attribute15 squal_char11,
to_number(attribute16) squal_num05,
attribute17 squal_char06,
attribute18 squal_char05,
to_number(NVL(attribute12,attribute19)) squal_num01,
to_number(attribute20) squal_num03,
...
...
jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_trans_data.begin Start of the procedure JTY_ASSIGN_BULK_PUB.insert_trans_data
jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_trans_data.trans_table_name TRANS table name : JTF_TAE_1001_SC_DEA_TRANS
jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_trans_data.other -1722 : ORA-01722: invalid number

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.