Even Though APAYRA Batch Got Successful Payment Upload Acknowledgement with Completed Status, Payment Event Exception Logged for Unfrozen Payment

(Doc ID 2074141.1)

Last updated on NOVEMBER 16, 2015

Applies to:

Oracle Financial Services Revenue Management and Billing - Version 2.4.0.0.0 and later
Information in this document applies to any platform.

Symptoms

On :  RMB 2.4.0.1.0 version, PY - Payment

ACTUAL BEHAVIOR  
-------------------------
After running the APAYRA Batch, while processing a Payment with Successful ACK, the Payment Event was created, however due to some reason the Payment was unfrozen. But the APAY Upload Status was updated to COMPLETE.

There was an exception logged in the Payment Event Exception table. However, no exception is logged in the Payment Exception table (CI_PAY_EXCP).

EXPECTED BEHAVIOR
---------------------------
The payment should remain frozen when the status is updated as Complete.
If there is any error/issue, exception should be logged in the Payment Exception table (CI_PAY_EXCP).

STEPS
-----------------------
The issue occurred with the following steps:

1. Run APAYRA Batch, processing a Payment with Successful Acknowledgement and the Payment Event created
2. Auto Payment Clearing Staging screen shows 'Uploaded Clearing Staging Record' with 'Complete' status
3. But in Payment Event screen it shows "Unfrozen Payments" for corresponding Payment Event Id
4. In Database, Payment Event Exception is logged (in ci_pay_evt_excp table), but nothing is found in Payment Exception (in ci_pay_excp) table

BUSINESS IMPACT
-----------------------
The concern is Payment Upload was marked as Complete even though the Payment was not successfully frozen and not all corresponding tables were updated accordingly for this failure.

Changes

 Deployed ORMB 2.4.0.1.0.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms