My Oracle Support Banner

Direct Debit Create Automatic Receipt Batch Errors Out Invalid argument RECEIPT_METHOD_ID (Doc ID 2367480.1)

Last updated on MARCH 12, 2021

Applies to:

Oracle Fusion Receivables Cloud Service - Version 11.12.1.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.12.1.0.0 version, Receipts

Actual Behavior
============

Direct Debit -Create Automatic Receipt Batch errors out.
Exception : insert_batch() ORA-20001: Invalid argument RECEIPT_METHOD_ID for the procedure INSERT_AUTO_BATCH.
Batch creation failed : Invalid argument RECEIPT_METHOD_ID for the procedure INSERT_AUTO_BATCH.


Error Log :
=========
baseProgram- initing payment AM
MOAC init
initBatch:start()
before ar_autorec_parallel_api.submit_autorec_parallel
after ar_autorec_parallel_api.submit_autorec_parallel
submit_autorec_parallel failed
P_ERRBUF=Invalid argument RECEIPT_METHOD_ID for the procedure INSERT_AUTO_BATCH.
autorec master: resume state=null
18/01/17 18:47:50 ar_ess_plsql_wrapper_pkg.gather_table_stats(+)
18/01/17 18:47:50 Parameter table_name RA_CUSTOMER_TRX_ALL
18/01/17 18:47:50 Running flush_database_monitoring_info : table RA_CUSTOMER_TRX_ALL
18/01/17 18:47:50Getting stale_count : table RA_CUSTOMER_TRX_ALL
18/01/17 18:47:50 Stale_count = 0 : table RA_CUSTOMER_TRX_ALL
18/01/17 18:47:50 Gathering stats on table RA_CUSTOMER_TRX_ALL
18/01/17 18:47:50 ar_ess_plsql_wrapper_pkg.gather_table_stats(-)
18/01/17 18:47:50 ar_ess_plsql_wrapper_pkg.gather_table_stats(+)
18/01/17 18:47:50 Parameter table_name AR_PAYMENT_SCHEDULES_ALL
18/01/17 18:47:50 Running flush_database_monitoring_info : table AR_PAYMENT_SCHEDULES_ALL
18/01/17 18:47:50Getting stale_count : table AR_PAYMENT_SCHEDULES_ALL
18/01/17 18:47:50 Stale_count = 0 : table AR_PAYMENT_SCHEDULES_ALL
18/01/17 18:47:50 Gathering stats on table AR_PAYMENT_SCHEDULES_ALL
18/01/17 18:47:50 ar_ess_plsql_wrapper_pkg.gather_table_stats(-)
Exception : insert_batch() ORA-20001: Invalid argument RECEIPT_METHOD_ID for the procedure INSERT_AUTO_BATCH.
Batch creation failed : Invalid argument RECEIPT_METHOD_ID for the procedure INSERT_AUTO_BATCH.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Receivables
2. Account receivables
3. Create Automatic Receipt Batch

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot Create Automatic Receipts

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


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