Post Upgrade To 12.2.7. PER_POSITIONS_V Invalid With ORA-01445
(Doc ID 2507773.1)
Last updated on MARCH 08, 2021
Applies to:Oracle Human Resources - Version 12.2.7 and later
Information in this document applies to any platform.
After upgrading instance from 12.1.3 to 12.2.7, following view PER_POSITIONS_V becames invalid
and errors out when trying to recompile the same:
ORA-01445: cannot select ROWID from, or sample, a join view without a key-preserved table
The issue can be reproduced at will with the following steps:
1.Upgrade from 12.1.3 to 12.2.7
2. When attempting to compile view PER_POSITIONS_V
3. Error occurs.
upgrade EBS from 12.1.3 to 12.2.7
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