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

MOSC Banner

HRMS RUP 12 fails with ORA-00942: table or view does not exist for HR.PER_JOBS while executing pay_j

edited Dec 10, 2018 4:08AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 1 commentAnswered

We are applying HRMS RUP12 26787667 on 12.2.7. It fails on pay_job_wc_code_usages_tab.xdf with ORA-00942: table or view does not exist as below.

Executing statement

  ALTER TABLE PER.PAY_JOB_WC_CODE_USAGES ADD CONSTRAINT "PAY_JOB_WC_CODE_USAGES_FK2" FOREIGN KEY (JOB_ID ) REFERENCES HR.PER_JOBS (JOB_ID ) ON DELETE CASCADE

Start time for statement above is Tue Nov 20 23:41:38 EST 2018

End time for statement above is Tue Nov 20 23:41:38 EST 2018

Error in executing statement ALTER TABLE PER.PAY_JOB_WC_CODE_USAGES ADD CONSTRAINT "PAY_JOB_WC_CODE_USAGES_FK2" FOREIGN KEY (JOB_ID ) REFERENCES HR.PER_JOBS (JOB_ID ) ON DELETE CASCADE

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