Post Upgrade To 12.2.7. PER_POSITIONS_V Invalid With ORA-01445
(Doc ID 2507773.1)
Last updated on AUGUST 05, 2022
Applies to:
Oracle Human Resources - Version 12.2.7 and laterInformation in this document applies to any platform.
Symptoms
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:
ERROR
ORA-01445: cannot select ROWID from, or sample, a join view without a key-preserved table
ORA-01445: cannot select ROWID from, or sample, a join view without a key-preserved table
STEPS
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.
Changes
upgrade EBS from 12.1.3 to 12.2.7
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 |