EBI 9.2:SQL Error On LOC Summary Page On Microsoft SQL Server (Doc ID 2134419.1)

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.

Symptoms

On  9.2 version, when an Letter of Credit (LOC) returns more than 9999 rows, the LOC Summary page will error.

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.


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

  1. Access transaction Billing > Manage > Billing Worksheet > letter of Credit Summary
  2. Use Find an existing value search by letter of credit enter number begin by AAA
  3. Click Search and the error occurs.

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