My Oracle Support Banner

hrglobal errors on hrrunsec.sql: ORA-01445: cannot select ROWID from, or sample, a join view without a key-preserved table (Doc ID 1424534.1)

Last updated on OCTOBER 02, 2023

Applies to:

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

Symptoms


After applying <Patch 13343360> - TYE12 : UK END OF YEAR CHANGES 2011-12, when attempting to run Hrglobal as a post install step, the following error occurs.

ERROR
-----------------------
sqlplus -s APPS/***** @/fs1/HRTE/appl/per/11.5.0/patch/115/sql/hrrunsec.sql &un_apps &pw_apps &un_apps &un_per APPOBJ
Connected.
DECLARE
*
ERROR at line 1:
ORA-01445: cannot select ROWID from, or sample, a join view without a key-preserved table
ORA-06512: at line 537
ORA-06512: at line 554

 

Steps to Reproduce:
The issue can be reproduced at will with the following steps:


1. Apply <Patch 13343360> - TYE12 : UK END OF YEAR CHANGES 2011-12
2. Run Hrglobal

 

Changes

 After UK TYE 2012 Patch 13343360 is applied

 

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.