EBI9.2: BIPRELD Error On Step IU_PROCESSOR.A007.A007-010

(Doc ID 2078509.1)

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.

Symptoms

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.

ERROR
-----------------------
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

STEPS
-----------------------
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

BUSINESS IMPACT
-----------------------
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.

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