Document Status Page Crashes With A Fatal SQL Error When Trying To Open PO

(Doc ID 2002118.1)

Last updated on DECEMBER 15, 2016

Applies to:

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

Symptoms

Document Status page crashes with a fatal SQL error when trying to open with a PO. Path: Purchasing > Purchase Orders > Review PO Information > Document Status. This is specific on SQLServer so server specific code is being executed in the App Pkg SRM_DOCSTATUS.


ERROR
-----------------------

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

Error getting document count SRM_DOCSTATUS.DocumentStatus.OnExecute Name:getSqlCount PCPC:24663 Statement:346 Called from:SRM_DOCSTATUS.DocStatusPO.OnExecute Name:initCounts Statement:48 Called from:SRM_DOCSTATUS.DocStatusPO.OnExecute Name:DocStatusPO Statement:3 Called from:SRM_DOCSTATUS.DocStatusViewController.OnExecute Name:getDocInquiry Statement:20 Called from:SRM_DOCSTATUS.DocStatusViewController.OnExecute Name:initDocStatus Statement:57 Called from:PRCR_DS_INQ_WRK.FUNCLIB.F. (7990,73)


SQL error in DescribeCol. (2,279) SRM_DOCSTATUS.DocumentStatus.OnExecute Name:getSqlCount PCPC:24663 Statement:346
Called from:SRM_DOCSTATUS.DocStatusPO.OnExecute Name:initCounts Statement:48
Called from:SRM_DOCSTATUS.DocStatusPO.OnExecute Name:DocStatusPO Statement:3
Called from:SRM_DOCSTATUS.DocStatusViewController.OnExecute Name:getDocInquiry Statement:20
Called from:SRM_DOCSTATUS.DocStatusViewController.OnExecute Name:initDocStatus Statement:57
Called from:PRCR_DS_INQ_WRK.FUNCLIB.FieldFormula Name:InitDocStatus Stateme

During the execution of SQL, an error occurred in the DescribeCol subroutine. The preceding message should have described the details of the SQL being executed.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Navigate to Purchasing > Purchase order > Review PO Information > Document Status
 
2. -Search for the PO
 
3. Click on any of the PO Number Link
 
4. It says,” A fatal PeopleCode SQL error occurred. Please consult your system log for details.”

5. Click OK
 
It gives an Error Message

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