Last updated on SEPTEMBER 24, 2015
Applies to:
PeopleSoft Enterprise SCM Purchasing - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
Symptoms
Scenario 1
1)- Navigate to Main Menu > Purchasing > Receipts > Review Receipt Information > Document Status
2)-Search for the Receipt Number.
3)-Click on the Receipt Number Link.
Fatal PeopleCode SQL Error Occurs.
4)-Click OK.
SQL error in DescribeCol. (2,279) SRM_DOCSTATUS.DocumentStatus.OnExecute
Name:getSqlCount PCPC:24663 Statement:346
Called from:SRM_DOCSTATUS.DocStatusRcv.OnExecute Name:initCounts
Statement:41
Called from:SRM_DOCSTATUS.DocStatusRcv.OnExecute Name:DocStatusRcv
Statement:3
Called from:SRM_DOCSTATUS.DocStatusViewController.OnExecute
Name:getDocInquiry Statement:26
Called from:SRM_DOCSTATUS.DocStatusViewController.OnExecute
Name:initDocStatus Statement:57
Called from:PRCR_DS_INQ_WRK.FUNCLIB.FieldFormula Name:InitDocStatus Stat
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.
Scenario 2
1)-Navigate to Main Menu > Purchasing > Return To Vendor / Supplier > Document Status.
2)-Search for the RTV Document.
3)-Click on RTV Link.
System throws a --A fatal PeopleCode SQL error occurred. Please consult your system log for details.
4)-Click OK.
SQL error in DescribeCol. (2,279) SRM_DOCSTATUS.DocumentStatus.OnExecute
Name:getSqlCount PCPC:24663 Statement:346
Called from:SRM_DOCSTATUS.DocStatusRtv.OnExecute Name:initCounts
Statement:35
Called from:SRM_DOCSTATUS.DocStatusRtv.OnExecute Name:DocStatusRtv
Statement:3
Called from:SRM_DOCSTATUS.DocStatusViewController.OnExecute
Name:getDocInquiry Statement:29
Called from:SRM_DOCSTATUS.DocStatusViewController.OnExecute
Name:initDocStatus Statement:57
Called from:PRCR_DS_INQ_WRK.FUNCLIB.FieldFormula Name:InitDocStatus Stat
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.
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