Direct Debit Create Automatic Receipt Batch Errors Out Invalid argument RECEIPT_METHOD_ID
(Doc ID 2367480.1)
Last updated on JULY 29, 2024
Applies to:
Oracle Fusion Receivables Cloud Service - Version 11.12.1.0.0 and laterInformation 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 |