C1-BLPPR Goes Into Error when it is Executed for a Single Account (Doc ID 2126819.1)

Last updated on APRIL 19, 2016

Applies to:

Oracle Financial Services Revenue Management and Billing - Version 2.4.0.1.0 and later
Information in this document applies to any platform.

Symptoms

On : 2.4.0.1.0 version, BT - Batch

C1-BLPPR errors when executed for a single account.

Delete the pending bill from the UI or through the C1-PNBD bill batch and then try to run the three Billing Batch for one account . Get the error as” CIPBBPOB - SQL Error code 999999994 occurred in module CIPBBPOB:GA120 SELECT”.


ERROR
-----------------------
SQL Error code 999999994


Steps:
 1- Delete the bill segment by batch C1-BSEGD
 2- Delete the pending bill by batch C1-PNBD
 3- Now run the C1-PNDBL batch with multiple threads for single account
 4- Once the batch is created, check the Bill pending bill on the account “0910866573”. It has created multiple pending bills.
 5- Run The C1-BLGEN batch.
 6- Run The C1-BLPPR batch.

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