Migrate NI Categories 2016 Process Errors With ORA-20001: Assignments errored out.Please review the log file. ORA-06512: at "APPS.PAY_GB_NICAT_UPD", line 623 (Doc ID 2132630.1)

Last updated on MAY 27, 2016

Applies to:

Oracle HRMS (UK) - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

After Patch 22669294 TYE16: TAX YEAR END CHANGES : FINAL PATCH application, error in Migrate NI Categories 2016

As per <Note 2072952.1>:
Request the customer to review and run the Concurrent Programs, ‘Migrate NI Categories 2016’ and 'RTI GB Update NI Category' to update the NI Categories appropriately in the below sequence, with the below effective dates.
1. Update NI categories with effective date of 5th April 2016
2. Migrate NI categories 2016
3. Update NI categories with effective date of 6th April 2016)

However, when trying to run the processes, Migrate NI categories 2016 fails with error:

ORACLE error 20001 in FDPSTP
Cause: FDPSTP failed due to ORA-20001: -20001 - ORA-20001: Assignments errored out.Please review the log file.
ORA-06512: at "APPS.PAY_GB_NICAT_UPD", line 623
ORA-06512: at line 1

 

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