How to Delete Pending Bills where no Bill Segments Exist

(Doc ID 2409202.1)

Last updated on JUNE 14, 2018

Applies to:

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

Goal

In RMB v2.6.0.1 against FW v4.3.0.4, if we generate bills with no bill segments (by mistake) and need an way to delete them,
we experience below behavior:

Scenario 1:
Run C1-PNDBL (for any account) -> it generates pending bill
Run C1-BLGEN -> it generates bill segment

Scenario 2:
Run C1-PNDBL (for any account) -> it generates pending bill
Run C1-BLGEN -> let's assume there are no charges, hence no bill segment generated.

Now to clean up these pending bills:
1) Run - C1-BSEGD -> it deletes all bsegments (and create entry in CI_DELETE_BILL_DETAIL table with status P). But for pending bills having no bill segments, no entry is created in this table.
2) Run C1-PNBD -> it takes data from CI_DELETE_BILL_DETAIL table and delete pending bills and change status to C.

Here pending bill which has no bill segments (in real life, such can occur by user mistake) never get deleted and there is no option seen to delete these bills.

Now if we do not want to complete the bills from Scenario 2 and continue with other successful bills from scenario 1 (where bill segment exists), there is no option to delete with base batch. It works only if there are bill segments for all bills in process.

Note that there is no auditing enabled on the CI_BILL table.
With this issue entire process is stuck as base batch can neither delete those bills nor complete others and becomes bottleneck.

This article informs the workaround to avoid this deadlock.

Solution

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