Transaction Handling Is Not Proper in PCM_OP_BILL_ITEM_TRANSFER (Doc ID 1963024.1)

Last updated on JANUARY 26, 2024

Applies to:

Goal

When a user made a payment which remained as unallocated, a custom utility will be used to allocate that payment based on the due. But the same payment can be allocated by Customer Center (CC) User Interface (UI) as well. Both testnap utility and CC use the same opcode PCM_OP_BILL_ITEM_TRANSFER.

If the payment allocation happened at the same time from both the utility and CC, same payment is getting allocated twice and causing over allocation issue. This issue is also happening when there is a gap of few seconds. Means, if the payment allocation from CC is not completed, but the utility is triggered in between, it will result in the same issue.

Steps to reproduce
1. Create and account.
2. Move the pin_virtual_time to end of billing cycle and bill the account.
3. Make an under payment such that you could allocate later.
4. Do a manual allocation of the same /item/payment simultaneously from the Customer Center UI and the testnap utility.

Is this a product defect or intended behaviour? If It is not a bug, how to avoid double allocations?
If one has to use the same opcode within customized operations, should there be a lock at account level (as it is via Customer Center)?

 

Solution

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