DMS UPD18245696_01_IMP Failed to Import Rows into Table "PS_FIN_MBL_TYPE" (Doc ID 2000976.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


DMS UPD18245696_01_IMP failed to import rows into table "PS_FIN_MBL_TYPE"

When applying a Change Package for Bug 18011111 from HRMS 9.2 Image #11, DMS UPD18245696_01_IMP failed to import rows into table "PS_FIN_MBL_TYPE"


ERROR

Importing FIN_MBL_TYPE
SQL Error. Error Position: 310 Return: 904 - ORA-00904: "EOAW_REQUESTINFO": invalid identifier
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) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18)
Error: Unable to insert row 1
Error: SQL execute error for FIN_MBL_TYPE


STEPS

The issue can be reproduced at will with the following steps:
1. Create a Change Package for Bug 18011111 from HRMS 9.2 Image #11
2. Apply the Change Package to DEMO Environment


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