Needs To Determine Which Bill An Adjustment Belongs To (Doc ID 1357064.1)

Last updated on JUNE 13, 2017

Applies to:

Oracle Communications Billing and Revenue Management - Version: 7.4.0.0.0 and later   [Release: 7.4.0 and later ]
Information in this document applies to any platform.

Goal

We need to produce data file containing adjustment and adjustment done to 
previous and current bill cycle on a daily basis, we need to be able to identify which bill does the adjustment or settlement belong to. 

What logic shall we use in the program to determine which bill object does the adjustment?
We are thinking of using the following logic:
  
 Use the PIN_FLD_EFFECTIVE_T of /item/adjustment (or /item/settlement) to 
 check against PIN_FLD_START_T  and PIN_FLD_END_T  of the 3 object (current, 
 last and next) in /billinfo 
  
 If item_t PIN_FLD_EFFECTIVE_T > current bill object PIN_FLD_START_T and   
 item_t PIN_FLD_EFFECTIVE_T <= current bill object PIN_FLD_END_T, then this 
 adjustment/settlement belongs to current bill object 
  
 If item_tPIN_FLD_EFFECTIVE_T > last bill object PIN_FLD_START_T and   
 item_t PIN_FLD_EFFECTIVE_T <= last bill object PIN_FLD_END_T, then this 
 adjustment/settlement belongs to last bill object 
  
 If item_t PIN_FLD_EFFECTIVE_T > next bill object PIN_FLD_START_T and   
 item_t PIN_FLD_EFFECTIVE_T <= next bill object PIN_FLD_END_T, then this 
 adjustment/settlement belongs to next bill object 

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