Deploy Compensation Plan Error ORA-20969: Request exited with ERROR: : 1 User-Defined Exception on CN_TP_NOTIFY_LOGS_ALL (Doc ID 2271872.1)

Last updated on JUNE 13, 2017

Applies to:

Oracle Fusion Incentive Compensation Cloud Service - Version 11.1.11.1.0 and later
Oracle Fusion Incentive Compensation - Version 11.1.11.1.0 and later
Information in this document applies to any platform.

Symptoms

Deploy Compensation Plan process is in running status for over 8 hours then completed with error.


ERROR MESSAGE
ORA-20969: Request 285188 exited with ERROR: : 1 User-Defined Exception

STEPS
1. Make changes to compensation plan
2. Run Deploy Compensation Plan
    Navigator > Participant Assignments > Deploy Compensation Plan


Changes

Sample event logs being processed :

select event_log_id, count(1), min(period_id), max(period_id)
from cn_tp_notify_logs_all
where notify_log_status = 'INCOMPLETE'
and request_id is null
and participant_id = 10200
and org_id = 300000001266005
and revert_state = 'ROLLUP'
group by event_log_id
EVENT_LOG_ID COUNT(1) MIN(PERIOD_ID) MAX(PERIOD_ID)
93148                     729       2016001           2017365

Note: These are daily periods (ie. 365 day periods per year) assignments.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms