Pin_monitor_balance Throws Error for Writeoff Reversal Events (Doc ID 2936383.1)

Last updated on DECEMBER 26, 2024

Applies to:

Symptoms

While running pin_monitor_balance, some of the events /event/billing/writeoff/tax_billinfo and /event/billing/writeoff_reversal are failing. One observes that the input for write fields is not constructed fully. PIN_FLD_SUB_BALANCES array is truncated in the input for write fields.
When performs a read object for the events which are failing, it also shows that the PIN_FLD_SUB_BAL_IMPACTS arrays are truncated in the robj output

For example, the event /event/billing/writeoff_reversal 336732048759853761 has 404 PIN_FLD_MONITOR_IMPACTS arrays and only 97 PIN_FLD_MONITOR_SUB_BAL_IMPACTS arrays, but the last array is truncated and it does not have PIN_FLD_SUB_BALANCES array in it.
While checking the BALANCES_LARGE CLOB in event_essentials_t table, the data is intact. However, while trying to read the object, the data is getting truncated.
 
See below error in connection manager (CM) pinlog and dm_oracle.pinlog:

Cause

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