Distribute and Freeze Date is not Considered in APAYRA Batch Process (Doc ID 2128839.1)

Last updated on APRIL 26, 2016

Applies to:

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

Symptoms

On : 2.4.0.1.0 version, DB - Database


The Distribute and Freeze Date is not being considered in the APAYRA batch process.

Auto Pay Clearing Staging table contains a column called, "APAY_DIST_FRZ_DT", which is mapped to the "Payment Freeze Date" field on the Auto Pay Clearing Staging record.
As the name suggests, this field indicates the Freeze / Distribution date for the payment after the bank response file is received.

Observe that after the bank response file is uploaded, the "Freeze or Cancel Automatic Payments" (APAYRA) Batch Process is immediately freezing the payments even if the APAY_DIST_FRZ_DT is a future date (i.e., that is even if the Payment is supposed to be frozen at a future date).

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