ITEM_T.DUE And ITEM_T.EVENT_POID_LIST Are Not Updated Properly (Doc ID 3038688.1)

Last updated on AUGUST 29, 2024

Applies to:

Symptoms

Scenario:

• During an item level credit adjustment, upon item transfer event, user configured to notify a custom opcode [custom EVENT_NOTIFY opcode] which internally calls a custom REFUND opcode
• The REFUND opcode checks if there are any available credit & debit charges which can be cross allocated before refunding the extra credit to the customers.
• During this cross allocation, any credit (negative) transfer happens to the item (on item, which we are performing an item level adjustment), the transferred amount in ITEM_T.DUE & the transfer event poid in ITEM_T.EVENT_POID_LIST is not updating properly, whereas transfer amount updated in ITEM_T.RECVD column is proper.
• For sake of testing user tried below method:
  • launch testnap
  • open transaction
  • transfer X amount on item I1 using PCM_OP_BILL_ITEM_TRANSFER
  • transfer Y amount on item I1 using PCM_OP_BILL_ITEM_TRANSFER
  • close Transaction
  • in this test, DUE and ITEM_POID_LIST are populating correctly.
  • this is because here Y amount is transfered after completion of X amount transfer.
  • but the reported issue happens only when X amount transfer started --> (before X amount transfer completes) Y amount transfer happens --> X amount transfer completes.

Cause

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