Install, Upgrade, Clone, Patch - EBS (MOSC)

MOSC Banner

6678700 R12 Upgrade pypkrfm.sql failed "ORA-02437: cannot validate (HR.PAY_REPORT_CATEGORY_COMP_PK)

edited Sep 20, 2012 8:29AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 1 commentAnswered ✓
R12 Upgrade Error:pypkrfm.sql failed "ORA-02437: cannot validate (HR.PAY_REPORT_CATEGORY_COMP_PK) -
Problem Description
---------------------------------------------------
We are upgrading Oracle EBS 11.5.10.2 to R12.1.1 and while running upgrade driver (u6678700.drv), we are getting ORA-02437: cannot validate (HR.PAY_REPORT_CATEGORY_COMP_PK) - primary key" for worker file pypkrfm.sql.

Error,
############################################################################################
sqlplus -s APPS/***** @/app/oracle/R12/apps/apps_st/appl/pay/12.0.0/patch/115/sql/pypkrfm.sql &un_pay &pw_pay &index_tspace
declare
*
ERROR at line 1:
ORA-02437: cannot validate (HR.PAY_REPORT_CATEGORY_COMP_PK) - primary key
violated
ORA-06512: at "SYS.DBMS_SQL", line 1199
ORA-06512: at line 106
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center