My Oracle Support Banner

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:

Procedure call_tae_api error: ORA-01086: savepoint 'GET_ASSIGNMENTS' never established
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:

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

Find the message_text contains the following error:

API jty_tae_index_creation_pvt.dea_selectivity has failed


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

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