Problem With Editioned View/ Apps Synonym For PER_ALL_PEOPLE_F Returns ORA-00932 (new column delivered)

(Doc ID 2322304.1)

Last updated on OCTOBER 27, 2017

Applies to:

Oracle Human Resources - Version 12.2.6 and later
Oracle Database - Version 12.2.0.1 and later
Information in this document applies to any platform.

Symptoms

On : EBS 12.2.6 and Oracle Database 12.1.0.2.0

After applying R12.HR_PF.C.Delta.9 patch 22559919, HR.PER_ALL_PEOPLE_F has a new column REHIRE_AUTHORIZOR#1 VARCHAR2(60)

SQL> desc hr.per_all_people_f

Name Null? Type
----------------------------------------- -------- ----------------------------
REHIRE_AUTHORIZOR#1 VARCHAR2(60)

However, the editioned view per_all_people_f doesn't reflect the newly added column.

CREATE OR REPLACE VIEW per_all_people_f#

persleo.odf 120.18.12020000.10

 

Step to Reproduce:
The issue can be reproduced at will with the following steps:
     Apply the R12.HR_PF.C.Delta.9 <Patch 22559919>

 

 

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