Review Contract Information, Document Status Page: Fatal SQL Error is Received on Microsoft Database (Doc ID 2188154.1)

Last updated on OCTOBER 21, 2016

Applies to:

PeopleSoft Enterprise SCM Purchasing - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

A Fatal SQL error is received when navigating to Procurement Contracts - Review Contract Information - Document Status.

This issue occurs only when using a Microsoft database



ERRORs:

1) A fatal PeopleCode SQL error occurred. Please consult your system log for details.

2) SQL error in Exec. (2,280) PO_SCR_NAV_WRK.FORMULA.FieldFormula Name: GetTotalCount PCPC:10671 Statement:218
Called from PO_SRC_NAV_WRK.FORMULA.FieldFormula Name:FirstGetProcCntrctDocs Statement:234
Called from PRCR_DOCSTAT_CNT.GBL.PostBuild Statement:2



The issue can be reproduced at will with the following steps:
1. Navigate to: Procurement Contracts - Review Contract Information - Document Status
2. Click Search
3. Select a contract from the list.
4. Error is thrown


The issue has the following business impact:
Due to this issue, users cannot review the contract doc status page.

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