Last updated on MARCH 09, 2017
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
The issue has the following business impact:
We are running the month-end billing processes, and have exceeded the 1 million row mark, which causes BIPRELD to fail. If that process cannot complete, then we are unable to process any additional invoices, delaying close, and impacting the timeliness of our processing as well as providing invoices to our customers.
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