PCM_OP_PYMT_COLLECT Returns Error "Service Unavailable" But BRM Creates Payment in Database (Doc ID 1303193.1)

Last updated on SEPTEMBER 20, 2024

Applies to:

Goal

In a setup with Siebel and Billing and Revenue Management (BRM) integration using Oracle Application Integration Architecture (AIA), when a payment is created, sometimes, the following BRM behavior was detected:

1. AIA called PCM_OP_PYMT_COLLECT opcode to create a payment.
2. BRM returned error: "Service Unavailable".
3. But BRM created the payment, i.e. /item/payment object was created and related event objects: XXX/cash. The transfer event object is not created and, of course, the payment allocation is not performed.

Business impact:

After the Siebel users get this error, they are retrying to create the payment again and again and the result is that, multiple payments (items and events) are created when the expected result (for end user perspective) should be just once. So the expectation in this situation is that, when such an error is raised, no payment information should get stored in database.

It looks like BRM does not rollback entire transaction and the payment stays created on BRM database, even though there is an error.

Note: Here the payment batch contains only single payment.

Solution

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