Error Collecting Transactions with Territory Post Collection Code - ORA-01086: savepoint GET_ASSIGNMENTS Never Established
(Doc ID 855977.1)
Last updated on SEPTEMBER 01, 2020
Applies to:Oracle Incentive Compensation - Version 12.0.4 and later
Information in this document applies to any platform.
When attempting to collect invoices from AR into OIC and getting error:
ORA-06512: at "APPS.CN_POST_COLLECTION_TAE_PUB", line 313
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "APPS.CN_COLLECT_
The issue can be reproduced at will with the following steps:
Run STAR program
(R) Compensation Manager
Select operating unit
Transaction Source = Receivables Posting
Transaction Type = Collect Invoices
Schedule request = run it now
Error is encountered
Recently defined a new territory and run STAR
Also added a Post Collection Code in Collection Package based on <Note:307329.1> How to Integrate Territories with Incentive Compensation for Use with Sales Credit Allocation
p_api_version => 1.0, -- IN parameter
x_start_period_id => x_start_period_id, -- IN parameter
x_end_period_id => x_end_period_id, -- IN parameter
x_conc_program_id => x_col_audit_id, -- IN parameter
x_return_status => x_return_status, -- OUT parameter
x_msg_count => x_msg_count, -- OUT parameter
x_msg_data => x_msg_data, -- OUT parameter
x_org_id => x_org_id -- OUT parameter
--*** End of User Code, Location: Post-Collection
This is the code which is failing.
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