HRMS RUP 12 fails with ORA-00942: table or view does not exist for HR.PER_JOBS while executing pay_j
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