My Oracle Support Banner

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

Last updated on NOVEMBER 23, 2019

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.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.