Invoicing Search Does Not Return All Events Assigned To Bill (Doc ID 1426327.1)

Last updated on SEPTEMBER 24, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.2.1.0.0 to 7.2.1.0.0 [Release 7.2.1]
Oracle Solaris on SPARC (32-bit)

Symptoms


The out of the box invoicing search uses timestamp based conditions when selecting
events. Condition is based on /event.CREATED_T and limits selection.

Limitations for /event.CREATED_T are as follows:
1. /event.CREATED_T >= /bill.START
2. /event.CREATED_T <= (/bill.END_T + (/bill.END_T - /bill.START_T))

Limitations as presented above would cause that invoicing will not get all
events linked to the bill when billing and invoicing was executed after time
calculated by formula: (/bill.END_T + (/bill.END_T - /bill.START_T))


---------------------------------------
Steps To Reproduce The Issue
---------------------------------------
1) 1.01 - create account with BDOM = 2 and some cycle forward fee.
2) 5.01 - run billing and invoicing.

Invoicing search will not select events created during billing in point 2 as
resulted in creating incorrect invoice.

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