EGL9.2: FSCM 9.1 To 9.2 Upgrade Task 8-22-1 Returns Fatal SQL Error When Creating Closing Group (Doc ID 2129336.1)

Last updated on MAY 31, 2016

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

FSCM 9.1 to 9.2 Upgrade Task 8-22-1 Returns Fatal SQL Error When Creating Closing Group

When attempting to complete upgrade Task 8-22-1, the following error is generated:

  SQL error in DescribeCol. (2,279) CLOSE_DFLT_TBL.CHARTFIELD_VALUE.SaveEdit PCPC:2415 Statement:29

The offending SQL in the app server log is:

  Return: 8010 - [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid column name 'EFFDT'.
  Statement: SELECT EFF_STATUS FROM PS_KK_TMP_BP_VW A WHERE A.BUDGET_PERIOD = :1 AND A.SETID = :2 AND A.EFFDT= (SELECT MAX(EFFDT) FROM PS_KK_TMP_BP_VW B WHERE B.SETID = A.SETID AND A.BUDGET_PERIOD=B.BUDGET_PERIOD AND B.EFFDT <= :3)
Original Statement: SELECT EFF_STATUS FROM %TABLE(KK_TMP_BP_VW ) A WHERE A.BUDGET_PERIOD = :1 AND A.SETID = :2 AND A.EFFDT= (SELECT MAX(EFFDT) FROM %TABLE(KK_TMP_BP_VW ) B WHERE B.SETID = A.SETID AND A.BUDGET_PERIOD=B.BUDGET_PERIOD AND B.EFFDT <= %DATEIN(:3))

Environment
------------------
FSCM 9.1 to 9.2 Upgrade

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