My Oracle Support Banner

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

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
Symptoms
Changes
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.