My Oracle Support Banner

AP: PEOPLE CODE SQL ERROR IN VOUCHER INFORMATION PAGE (Doc ID 2137966.1)

Last updated on MAY 13, 2016

Applies to:

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

Symptoms


ISSUE:
----------
During Upgrade 9.2 testing, our users noticed when navigated to Accounts Payable > Review Accounts Payable Infor > Vouchers > Document Status receive fatal PeopleCode error.

ERROR:
-----------
SQL error in DescribeCol. (2,279) SRM_DOCSTATUS.DocumentStatus.OnExecute Name:getSqlCount PCPC:24359 Statement:344
Called from:SRM_DOCSTATUS.DocStatusVou.OnExecute Name:initCounts Statement:36
Called from:SRM_DOCSTATUS.DocStatusVou.OnExecute Name:DocStatusVou Statement:3
Called from:SRM_DOCSTATUS.DocStatusViewController.OnExecute Name:getDocInquiry Statement:38
Called from:SRM_DOCSTATUS.DocStatusViewController.OnExecute Name:initDocStatus Statement:57
Called from:PRCR_DS_INQ_WRK.FUNCLIB.FieldFormula Name:InitDocStatus Stat

 


STEPS:
----------
1.Navigate to Main Menu > Accounts Payable > Review Accounts Payable Info > Vouchers > Document Status
Default business unit is 'US001' and click search you will receive fatal Peoplecode error.

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!


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