Running DataMover Import Script UPD23482009_IMP_DMS Failing When Applying Image 24 (PI 24) ORA-00904: "FS_MAP_SAMPLEFILE": invalid identifier (Doc ID 2302733.1)

Last updated on SEPTEMBER 17, 2017

Applies to:

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

Symptoms

While applying FSCM 9.2 PI 24 step Running DataMover Import Script UPD23482009_IMP_DMS failing with below message because the Record PS_FS_MAP_SRC_HDR does not have the field 'FS_MAP_SAMPLEFILE'.

Error:
-----------------------------
Importing FS_MAP_SRC_HDR
SQL Error. Error Position: 209 Return: 904 - ORA-00904: "FS_MAP_SAMPLEFILE": invalid identifier
INSERT INTO PS_FS_MAP_SRC_HDR (FS_MAP_ID, FS_MAP_NODE_TYP, FS_FF_LAYOUT_ID, FS_MAP_UPLD_PB, FS_MAP_LAYOUT_PB, FS_MAP_RELT_TYPE, FS_MAP_CHAR_SET, FS_MAP_REFRESH_PB, IB_PACKAGEID, IB_SCHEMANAME, IB_VARIANTNAME, FS_MAP_SAMPLEFILE) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12)
Error: Unable to insert row 1
Error: SQL execute error for FS_MAP_SRC_HDR

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