My Oracle Support Banner

APAYCRET Error for Invoice with More Than 9 Records in CI_BILL_ACH (Doc ID 2659776.1)

Last updated on APRIL 17, 2020

Applies to:

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

Symptoms

On RMB v2.6.0.1.0, APAYCRET error for invoice with more than 9 records in CI_BILL_ACH.

ACTUAL BEHAVIOR
-------------------------------
Auto payment is not creating if an invoice has more than 9 entries (Bill Auto pay Id) in the CI_BILL_ACH.
It seems current process is supporting with maximum precision value 1 and throwing an exception if the record count exceeds 9.

Also Batch run tree shows job run status remained in In-progress status even though Batch error out.

EXPECTED BEHAVIOR
------------------------------------
Batch should get executed successfully instead of the overflow exception.

STEPS
---------------
1. Create a person account set up with more than 9 billable charges
2. Create the Autopay set up with rule based autopay for each billable charge separately
3. Complete the bill
4. On Bill completion verify the Bill ACH Entries (it should have more than 9 rows for one bill)
5. Run APAYCRET

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


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