When Applying ACA Patches From Image 20 (upd21301815_01_IMP_DMS) is failing with Invalid column name 'EOAW_REQCOMM_FLG' error (Doc ID 2230944.1)

Last updated on FEBRUARY 06, 2017

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

When attempting to apply ACA Patches from Image 20 the following error occurs.

Records remaining: 6
Importing FIN_MBL_TYPE
Message Set Number: 200
Message Number: 0
Message Reason: File: Data MoverSQL error. Stmt #: 0 Error Position: 0 Return: 8010 - [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid column name 'EOAW_REQCOMM_FLG'.
Failed SQL stmt: INSERT INTO PS_FIN_MBL_TYPE (FIN_MBL_ITEM_TYPE, FIN_MBL_ITEM_NAME, FIN_MBL_ITEM_HNDLR, PACKAGEROOT, FIN_MBL_IMG_LARGE, FIN_MBL_IMG_MEDIUM, FIN_MBL_IMG_SMALL, FIN_MBL_SEQNUM, FIN_MBL_SHOW_FLG, EOAWPRCS_ID, HMAP_INCL_APPR, HMAP_MASS_APPR_FLG, HMAP_ITEM_GRP_ID, EOAW_APPROVE, EOAW_DENY, EOAW_PUSHBACK, EOAW_HOLD, EOAW_ (200,0)
SQL Error. Error Position: 0 Return: 8010 - [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid column name 'EOAW_REQCOMM_FLG'.
INSERT INTO PS_FIN_MBL_TYPE (FIN_MBL_ITEM_TYPE, FIN_MBL_ITEM_NAME, FIN_MBL_ITEM_HNDLR, PACKAGEROOT, FIN_MBL_IMG_LARGE, FIN_MBL_IMG_MEDIUM, FIN_MBL_IMG_SMALL, FIN_MBL_SEQNUM, FIN_MBL_SHOW_FLG, EOAWPRCS_ID, HMAP_INCL_APPR, HMAP_MASS_APPR_FLG, HMAP_ITEM_GRP_ID, EOAW_APPROVE, EOAW_DENY, EOAW_PUSHBACK, EOAW_HOLD, EOAW_REQUESTINFO, EOAW_REQCOMM_FLG, EOAW_SHOWTERM_FLG) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20)

Error: Unable to insert row 1
Error: SQL execute error for FIN_MBL_TYPE
Ended: Tue Jan 03 15:32:07 2017



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