Hrglobal Errors with ORA-20001 on File Pyusroutes.ldt (Doc ID 2035321.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms



When attempting to execute the hrglobal driver after applying <patch 20395533> (R12.AD.B.DELTA.6), <patch 20000288> (12.1 HRMS Release Update Pack (RUP) 8) and <patch 21142484> (Q2 2015 Statutory and JIT Update), the following error occurs on file pyusroutes.ldt:

ERROR
-----------------------
Uploading from staging tables
Error loading seed data for ROUTE_CONTEXT_USAGES: ROUTE_NAME = US ELEMENT ENTRY INCEPTION TO DATE, SEQUENCE_NUMBER = 2, CONTEXT_NAME = ORIGINAL_ENTRY_ID, ORA-20001: Action will invalidate one or more compiled formula.

Cause: An action has been requested which will invalidate one or more compiled formula.

Action: Remove compiled formulae and retry. Then reverify all formulae.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Apply <patch 20395533> (R12.AD.B.DELTA.6), <patch 20000288> (12.1 HRMS Release Update Pack (RUP) 8)
and <patch 21142484> (Q2 2015 Statutory and JIT Update)
2. Execute data install
3. Execute hrglobal


Changes

 Applied <patch 20395533> (R12.AD.B.DELTA.6), <patch 20000288> (12.1 HRMS Release Update Pack (RUP) 8)
and <patch 21142484> (Q2 2015 Statutory and JIT Update)

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