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 JANUARY 10, 2017

Applies to:

Oracle HRMS (UK) - Version 11.5.10.2 and later
Information in this document applies to any platform.
Checked for currency 10-Sep-2014

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

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