EGL: EE_SEQ_NUM Field Not Found in PS_PO_HDR table, Impacting View PS_PO_HDR_FS (Doc ID 1431807.1)

Last updated on MAY 24, 2016

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.
***Checked for relevance on 23-May-2016***

Goal

On FSCM 9.1 Bundle 16:
When script is run which is trying to build PS_PO_HDR_FS view, it is failing because EE_SEQ_NUM field does not exist.
How to resolve?
Error:
Message Reason: File: Data MoverSQL error. Stmt #: 0  Error Position: 0  Return: 8010 - [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid column name 'EE_SEQ_NUM'.
Failed SQL stmt:CREATE VIEW PS_PO_HDR_FS (BUSINESS_UNIT, PO_ID, CHNG_ORD_BATCH, PO_TYPE, PO_STATUS, HOLD_STATUS, RECV_STATUS, DISP_ACTION, DISP_METHOD, CHANGE_STATUS, PO_DT, PO_REF, VENDOR_SETID, VENDOR_ID, VNDR_LOC, PRICE_SETID, PRICE_VENDOR, PRICE_LOC, PYMNT_TERMS_CD, BUYER_ID, ORIGIN, CHNG_ORD_SEQ, ADDRESS_SEQ_NUM, CNTCT_SEQ_NUM, SALE (200,0)
SQL Error. Error Position: 0  Return: 8010 - [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid column name 'EE_SEQ_NUM'.

Solution

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