My Oracle Support Banner

EBI9.2: BIPRELD Error On Step IU_PROCESSOR.A007.A007-010 (Doc ID 2078509.1)

Last updated on APRIL 07, 2019

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

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.