Billing and Revenue Management (MOSC)

MOSC Banner

item missing on item_t after exclude from bal_impacts entries with 0 amount

Good Morning,

I would like to understand how can i deal with the following scenario:

In order to reduce the amount of transactions on event_bal_impacts_t and increase the performance of searching on table we are excluding all entries with amount 0 from event_bal_impacts_t table, with following configuration:

if ( ( trxAmountbp == 0.000000 ) and ( edrLong(DETAIL.ASS_PIN.BP.PIN_IMPACT_TYPE, i, j ) != 4) )

        {

            logPipeline("OutGrammar : amount zero postponed! "+decimalToStr(trxAmountbp) ,0);

        }

        else

        {

            edrOutputMap( "V670_EVENT_LOADER.BALANCE_PACKET.STD_MAPPING", i, j );

        }

But with that configuration we realize that event_t for certain (usage)transactions use the item_poid excluded from bal_impacts and item_t does not have the entry that was excluded as well.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center