Data MoverSQL error. Stmt #: 0 Error Position: 191 Return: 904 - ORA-00904: "FSFB_EXCLUDEIN_FLG": Invalid Identifier When Applying Patch 18767538 (Doc ID 1954046.1)

Last updated on SEPTEMBER 15, 2016

Applies to:

PeopleSoft Enterprise FIN Maintenance Management - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

When attempting to copy the Workcenter datamover script delivered with Bug 18767538,
the following error occurs.

ERROR
----------
Importing FSFB_FLTRFLDS
 Message Set Number: 200
 Message Number: 0
 Message Reason: File: Data MoverSQL error. Stmt #: 0 Error Position: 191 Return: 904 - ORA-00904: "FSFB_EXCLUDEIN_FLG": invalid identifier
Failed SQL stmt: INSERT INTO PS_FSFB_FLTRFLDS (FILTER_ID, FIELDNAME, EFF_STATUS, LABEL_ID, REQUIRED_FLG, FSFB_RESTRICT_FLG, PROMPT_TABLE, DISPLAY_ORDER, XLAT_FLDNAME, KEY_FIELD, DESCR_FLD, FSFB_YES, FSFB_NO, FSFB_EXCLUDEIN_FLG) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14) (200,0)

SQL Error. Error Position: 191 Return: 904 - ORA-00904: "FSFB_EXCLUDEIN_FLG": invalid identifier
INSERT INTO PS_FSFB_FLTRFLDS (FILTER_ID, FIELDNAME, EFF_STATUS, LABEL_ID, REQUIRED_FLG, FSFB_RESTRICT_FLG, PROMPT_TABLE, DISPLAY_ORDER, XLAT_FLDNAME, KEY_FIELD, DESCR_FLD, FSFB_YES, FSFB_NO, FSFB_EXCLUDEIN_FLG) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14)
Error: Unable to insert row 1
Error: SQL execute error for FSFB_FLTRFLDS
Ended: Wed Oct 01 08:35:11 2014
Unsuccessful completion

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

  1. Run the upd18015731.dms
  2. Get the Error

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