Deploy Compensation Plan Error ORA-20969: Request exited with ERROR: : 1 User-Defined Exception on CN_TP_NOTIFY_LOGS_ALL
Last updated on JUNE 13, 2017
Applies to:Oracle Fusion Incentive Compensation Cloud Service - Version 126.96.36.199.0 and later
Oracle Fusion Incentive Compensation - Version 188.8.131.52.0 and later
Information in this document applies to any platform.
Deploy Compensation Plan process is in running status for over 8 hours then completed with error.
ORA-20969: Request 285188 exited with ERROR: : 1 User-Defined Exception
1. Make changes to compensation plan
2. Run Deploy Compensation Plan
Navigator > Participant Assignments > Deploy Compensation Plan
Sample event logs being processed :
select event_log_id, count(1), min(period_id), max(period_id)
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.
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