My Oracle Support Banner

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

Last updated on DECEMBER 03, 2019

Applies to:

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

Goal

A business requirement is to produce data file containing adjustment and adjustment done to previous and current bill cycle on a daily basis.
How to identify which bill does the adjustment or settlement belong to?
Would the following logic be working?
1. 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 these 3 objects (current, last and next) in /billinfo.
2. 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.
3. 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.
4. 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

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.