Running Collection Ends with ORA-01086: Savepoint GET_ASSIGNMENTS Never Established
(Doc ID 744346.1)
Last updated on DECEMBER 03, 2019
Applies to:Oracle Incentive Compensation - Version 12.0.1 and later
Information in this document applies to any platform.
When attempting to run Collection with integration to Territory Managment the following error is encountered:
ORA-06510: PL/SQL: unhandled user-defined exception
Enable FND debug log by setting the following profile options :
FND: Debug Log Enabled = Yes
FND: Debug Log Module = jtf%
FND: Debug Log Level = Statement
FND: Debug Log Filename = <path>/jtf.log
Reproduce the problem again and look into the log by running:
where module like 'jtf.plsql.%'
and timestamp >= to_date('&date ', 'DD-MON-YYYY');
Find the message_text contains the following error:
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