Last updated on MAY 30, 2016
Applies to:PeopleSoft Enterprise SCM Billing - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
On 9.2 version, when an Letter of Credit (LOC) returns more than 9999 rows, the LOC Summary page will error.
The following is the error in the app server log file:
E:\pt85306c-retail\peopletools\src\psppr\ramget.cppSQL error. Stmt #: 656 Error Position: 0 Return: 8601 - [Microsoft][SQL Server Native
Client 10.0]Numeric value out of range
[Microsoft][SQL Server Native Client 10.0]Numeric value out
of range (SQLSTATE 22003) 0
Failed SQL stmt: SELECT LC_ID, LOC_DOC_ID, COUNT_7, BILL_STATUS, CONTRACT_NUM, INVOICE_AMT_PRETAX, UNBILLED_AMT_TMP, UNBILLED_AMT_REAL, BI_CURRENCY_CD FROM PS_BI_LOC_SUM_VW WHERE (UNBILLED_AMT_REAL <> 0.0 OR UNBILLED_AMT_TMP <> 0.0) and LC_ID= 'AAA' ORDER BY LC_ID, LOC_DOC_ID
PSAPPSRV.3520 (19430) (0) Error in PeopleCode ScrollSelect processing. (2,213) BI_LOC_SUMMARY.Activate PCPC:591 Statement:13
PSAPPSRV.3520 (19430) (0) An error has occurred which prevents this transaction continuing
Where 'AAA' is the letter of credit enter number.
The issue can be reproduced at will with the following steps:
- Access transaction Billing > Manage > Billing Worksheet > letter of Credit Summary
- Use Find an existing value search by letter of credit enter number begin by AAA
- Click Search and the error occurs.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms