Security Deployment Tool Failed Invalid column name FSPC_% 'PACKAGEROOT_FL' and 'NEW_WINDOW' (Doc ID 2173341.1)

Last updated on AUGUST 17, 2016

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

Running HCM version 9.2.00. Created the change package using HCM Image 18 using the <Bug 22731732>. It failed on the data mover steps trying to insert into PS_FSPC% tables. 

Importing FSPC_SYS_MYWORK

SQL Error. Error Position: 0 Return: 8010 - [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid column name 'PACKAGEROOT_FL'.
INSERT INTO PS_FSPC_SYS_MYWORK (FSPC_SYS_LINK_ID, FSPC_DESCR, OBJECTOWNERID, RECNAME, PACKAGEROOT, APPCLASS_PATH, PACKAGEROOT_FL, APPCLASS_PATH_FL, EOWC_CLASSIC_FLUID) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9)
Error: Unable to insert row 1
Error: SQL execute error for FSPC_SYS_MYWORK



Importing FSPC_ADM_RPTLST


SQL Error. Error Position: 0 Return: 8010 - [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid column name 'NEW_WINDOW'.
INSERT INTO PS_FSPC_ADM_RPTLST (PAGELET_CONFIG_ID, FSPC_GROUP_ID, FSPC_LINK_ID, FSPC_LINK_TYPE, PORTAL_NAME, PORTAL_OBJNAME, URL, FSPC_DESCR, FSPC_PUBLIC_FLG, DISPLAY_ORDER, SHOW_LINK, FSPC_DATA_SOURCE, FSPC_OVERRIDE_FLAG, NEW_WINDOW, RUN_CNTL_ID) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15)
Error: Unable to insert row 1
Error: SQL execute error for FSPC_ADM_RPTLST

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