Apply HR_PF Delta 5 On Release 12.2.3 Failed to Compile Form "pay forms/US PAYUSCTY.fmx (Doc ID 2180080.1)

Last updated on SEPTEMBER 27, 2016

Applies to:

Oracle HRMS (UK) - Version 12.2.3 and later
Information in this document applies to any platform.

Symptoms

PRODUCTION UPGRADE and while applying HR_PF Delta 5 and Online Help HR_PF Delta 5 on Release 12.2.3 has ABORTED.


The patch was applied using the following command:
adop phase=apply patches=17909898,17912683 patchtop=/fs02/app/LPROD/stageR12_transient/HRMS_STREAM workers=8 apply_mode=downtime options=forceapply

Following are my findings:
(1) failed to compile form "pay forms/US PAYUSCTY.fmx"


(2) Following two PAY package bodies are invalid

APPS PAY_US_TAX_BAL_SUMMARY_PKG PACKAGE BODY
APPS PAY_US_TAX_BALS_ADJ_API PACKAGE BODY


(3) When compiling these packages receive errors


(4) Issue further traced down to table PAY_US_CITY_TAX_INFO_F: two missing columns ER_CITY_TAX and ER_HEAD_TAX


(5) When object (table) viewed under schema HR.PAY_US_CITY_TAX_INFO_F both columns ER_CITY_TAX and ER_HEAD_TAX exist


(6) When object (synonym) viewed under schema APPS.PAY_US_CITY_TAX_INFO_F both columns are missing ER_CITY_TAX and ER_HEAD_TAX exist

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