EVENT Level Adjustment on Usage Event Failed on High Value PIN_FLD_AMOUNT_EXEMPT with "ORA-01426: numeric overflow" (Doc ID 2851352.1)

Last updated on AUGUST 01, 2023

Applies to:

Symptoms

On : 12.0.0.3.0 version, ADJUSTMENTS

EVENT Level Adjustment on Usage event is resulting in junk values on PIN_FLD_AMOUNT_EXEMPT in the PIN_FLD_TAX_JURISDICTIONS of the /event/billing/adjustment/tax_event for accounts where PIN_FLD_AMOUNT_EXEMPT is populated on the original /event/billing/cycle/tax during billing time taxation.

The value that is being set in PIN_FLD_AMOUNT_EXEMPT on each adjustment tax event is doubled the previous value of PIN_FLD_AMOUNT_EXEMPT of previous tax adjustment event.
This is observed after Billing and Revenue Management (BRM) 12 PatchSet (PS) 3 upgrade.

The value is going up to 40 decimal places and dm_oracle.pinlog has the error:

ERROR
=============
E Tue Jan 11 09:10:33 2022 <HOSTNAME> dm:29305 dm_subr.c(178):2903 2:<HOSTNAME>:testnap:21457:-147134720:141:1640967911:1:root.0.0.0.1:::
      ORACLE error: do_sql_insert: PINStmtExecute: code 1426, op 0
      =ORA-01426: numeric overflow
      "insert into event_tax_jurisdictions_t ( element_id, name, percent, type, amount, amount_gross, amount_exempt, amount_taxed, rec_id, obj_id0 ) values ( :element_id, :name, :percent, :type, :amount, :amount_gross, :amount_exempt, :amount_taxed, :rec_id, :obj_id0 )"
E Tue Jan 11 09:10:33 2022 <HOSTNAME> dm:29305 dm_do_ops.c(106):2180 2:<HOSTNAME>:testnap:21457:-147134720:141:1640967911:1:root.0.0.0.1:::
      ERROR do_create_create sql_insert err=43(PIN_ERR_STORAGE)

STEPs
=============
1. Enable Deferred Taxation
2. Create an Account in BRM which is Tax Exempted
3. Process 10-15 different Usage on the account with some Charge
4. Run billing and verify Cycle tax event is generated with some value in PIN_FLD_AMOUNT_EXEMPT
5. Process event level adjustment on the usage events and verify the PIN_FLD_AMOUNT_EXEMPT on Adjustment tax event keeps Doubling the value from Previous value on the Adjustment tax event

Expected value is the PIN_FLD_AMOUNT_EXEMPT on adjustment tax event should be copied from the original Cycle Tax event and this value should be same for all the tax adjustment events.

Cause

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