EBI9.2: BIPRELD Error On Step IU_PROCESSOR.A007.A007-010
(Doc ID 2078509.1)
Last updated on SEPTEMBER 08, 2020
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, Billing Finalization/Proforma PRD
BIPRELD Error on Step IU_PROCESSOR.A007.A007-010
BIPRELD is getting a "Numeric value out of range" error on step IU_PROCESSOR.A007.A007-010, which selects a count(*) from PS_BI_IIP2_TAO. It looks like this TAO table is defined as a SQL table in App Designer, so it is accumulating data, and now has over 1 million rows in our PRD environment.
Stmt #: 1625 Error Position: 0 Return: 8601 - [Microsoft][SQL Server Native Client 10.0]Numeric value out of range (SQLSTATE 22003) 0
Failed SQL stmt: SELECT COUNT(*) FROM PS_BI_IIP2_TAO
Process 8207307 ABENDED at Step IU_PROCESSOR.A007.A007-010 (SQL) -- RC = 8601 (108,524)
Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s
PSAESRV completed service request at 16.01.01 2015-07-02
The issue can be reproduced at will with the following steps:
1. Setup Interunit billing
2. Create a bill and generate running finalization
3. Run Billing Preload to create accounting entries
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document