The Adjustment Item Is Not Getting Picked In The Invoice Every Time (Doc ID 2261369.1)

Last updated on MAY 30, 2017

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.5.0.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 7.5.0.15.0 version, Invoicing

Scenario :

1. Account created with a cycle forward product on 13th Feb 2017.
2. Bill Now done on 22nd Feb 2017.
3. Adjustment passed after this on the above billed event.
4. Billing done on 1st May, i.e. on the next billing date.
5. The adjustment event is not seen in the invoice.

Expected Result:

The adjustment event should reflect in the regular invoice at step 5.


Notes :

*  This issue is intermittent in nature
*  This is the case wherein, the bill start_date is same for last two bills (here for bill now and regular bill). So during invoicing ( PCM_OP_INV_MAKE_INVOICE ), the search  query for “Input flist of item_search” can return the output in any order
*  If the order of the returned result (list of items) is in ascending order for PIN_FLD_END_T, then there is no issue, and if the order of the returned result is in descending order for PIN_FLD_END_T, then both PIN_FLD_END_T and PIN_FLD_START_T takes the same value i.e. greater value. 
*  Below is snippet of the cm pinlog for example, showing the search query mentioned above :

Changes

 

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