My Oracle Support Banner

GENERATING 2 BILLS FOR THE SAME BILL CYCLE & ACCOUNT SHOULD NOT BE ALLOWED (Doc ID 3001696.1)

Last updated on FEBRUARY 05, 2024

Applies to:

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

Goal

In ORMB v4.0.0.0.0, 2 bills were being generated for the same bill cycle for the same account.

We have observed that when a bill is generated manually from the application UI, it does not create an entry in the CI_BILL table for BILL_CYC_CD and WIN_START_DT. However, if we generate a pending bill using the C1-PNDBL (Pending Bill Generation) Batch, these entries are successfully recorded in the CI_BILL table. When we attempt to create another bill for the same bill cycle window, the system (through the batch process) checks for existing entries in CI_BILL based on BILL_CYC_CD and WIN_START_DT.

We find that when the result count >= 1, the system prevents the creation of a new bill via batch. However, the creation of a manual bill is permitted, as the system does not validate against BILL_CYC_CD and WIN_START_DT in this case. We wonder if this should be restricted as well. 

Solution

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
Goal
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.