FCT_billingrecord Is Populating Rounded_quantity Instead of Chargeable Qty in Bal Pkt (Doc ID 1308471.1)

Last updated on MARCH 14, 2019

Applies to:

Symptoms

In 7.0, FCT_ApplyBalance did populate CHARGEABLE_QUANTITY_VALUE of charge packet and discount packets in BALANCE_PACKETS.

In 7.4, FCT_ApplyBalance is populating ROUNDED_QUANTITY_VALUE of charge packet and discount packets. This will effect in invoicing. All the durations and quantities in invoice would show rounded value instead of actual used quantities.

Here the supporting data:

In 7.0 CHARGE_PACKET
=================
CHARGEABLE_QUANTITY_VALUE: <137> :SET
ROUNDED_QUANTITY_VALUE: <150> :SET

and in 7.0 BALANCE_PACKET
===================
PIN_RESOURCE_ID: <36> :SET
..
PIN_QUANTITY: <137> :SET



In 7.4 CHARGE_PACKET
===============
CHARGEABLE_QUANTITY_VALUE: <137> :SET
ROUNDED_QUANTITY_VALUE: <150> :SET

but in 7.4 BALANCE_PACKET
==================
PIN_RESOURCE_ID: <36> :SET
..
PIN_QUANTITY: <150> :SET


So, as one can see that in 7.4, PIN_QUANTITY field ( for resource 36) in BALANCE_PACKET got populated with ROUNDED_QUANTITY_VALUE=150 instead of CHARGEABLE_QUANTITY_VALUE=137.

Changes

Cause

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