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 MAY 01, 2018
Applies to:Oracle HRMS (UK) - Version 188.8.131.52 and later
Information in this document applies to any platform.
Checked for currency 10-Sep-2014
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.
sqlplus -s APPS/***** @/fs1/HRTE/appl/per/11.5.0/patch/115/sql/hrrunsec.sql &un_apps &pw_apps &un_apps &un_per APPOBJ
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
After UK TYE 2012 Patch 13343360 is applied
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!