Review Contract Information, Document Status Page: Fatal SQL Error is Received on Microsoft Database
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.
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
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.
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