Persleo.Odf Errors With ORA-30556 On Table Per_All_People_F
(Doc ID 263266.1)
Last updated on JANUARY 03, 2023
Applies to:Oracle Human Resources - Version 11.5.6 to 22.214.171.124 [Release 11.5 to 11.5.10]
Information in this document applies to any platform.
Instance is being upgraded to 11.5.9, and the following error is being received while running u2669606.drv (the 11.5.9 patch):
persleo.odf errors with:
"ALTER TABLE HR.PER_ALL_PEOPLE_F MODIFY ( LAST_NAME VARCHAR2(150) )
ORA-30556: functional index is defined on the column to be modified"
It was noted that the following functional index was defined on HR.
the index was actually owned by APPS.
CREATE INDEX APPS.PER_ALL_PEOPLE_F_N1 ON
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!