Transactions / Receipts Workbench Issue: Cannot Complete A Credit Memo or Apply Cash to a Transaction - No Error Message (Doc ID 1285275.1)

Last updated on JULY 24, 2017

Applies to:

Oracle Receivables - Version 12.0.1 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.
ARPDDB.pls
Form:ARXTWMAI.FMB - Transactions


Symptoms

When creating a credit memo via the Transactions form, upon clicking on the Complete button, no errors are raised, but the credit memo is not saved.
This also occurs when attempting to apply a Receipt to a Transaction with no error.

Steps to Reproduce:
Responsibility
: Receivables Manager
Navigation
: Transactions > Transactions
Create a credit memo, enter all necessary details
Click on Complete Button. The form does not respond, and no error message is raised.

The FND debug log for the Transaction shows:

Reconciliation gross amount
rom the detail gt the amount l_sum :

application record the amount_applied :114

application record the amount_earned :

application record the amount_unearned:

Gross transaction amount do not reconcile

OTHERS IN Trx_level_direct_cash_apply :User-Defined Exception

EXCEPTION: ARP_ALLOCATION_PKG.Allocate_Tax:User-Defined Exception

EXCEPTION: ARP_RECEIPTS_MAIN.Create_Ae_Lines_RA

EXCEPTION: ARP_RECEIPTS_MAIN.Create_Ae_Lines_Common

EXCEPTION: ARP_RECEIPTS_MAIN.Derive_Accounting_Entry

EXCEPTION: ARP_RECEIPTS_MAIN.Execute

EXCEPTION: ARP_ACCT_MAIN.Create_Acct_Entry

EXCEPTION: Overloaded ARP_ACCT_MAIN.Create_Acct_Entry

EXCEPTION: arp_maintain_ps2.process_ira_data()

EXCEPTION: Error fetching select cursor

EXCEPTION: arp_maintain_ps2.insert_cm_ps_private()

EXCEPTION: arp_maintain_ps.maintain_payment_schedules()

EXCEPTION: arp_process_header.post_commit()

The FND debug log for the Receipt shows:

Reconciliation gross amount
From the detail gt the acctd_amount l_acctd_sum  :-.18
application record the acctd_amount_applied:.25
application record the acctd_amount_earned :0
application record the acctd_amount_unearned:0
Gross transaction acctd amount do not reconcile
Checking for currency precision error
ARP_BALANCE_CHK.Check_Precision (+)
p_amount .25
p_actual_amount .25
p_FunctionalCurrency .25
Application amount precision matches with FND currency precision
ARP_BALANCE_CHK.Check_Precision (-)
OTHERS IN Trx_level_direct_cash_apply :User-Defined Exception
EXCEPTION: ARP_ALLOCATION_PKG.Allocate_Tax:User-Defined Exception
EXCEPTION: ARP_RECEIPTS_MAIN.Create_Ae_Lines_RA
EXCEPTION: ARP_RECEIPTS_MAIN.Create_Ae_Lines_Common
EXCEPTION: ARP_RECEIPTS_MAIN.Derive_Accounting_Entry
EXCEPTION: ARP_RECEIPTS_MAIN.Execute
EXCEPTION: ARP_ACCT_MAIN.Create_Acct_Entry
EXCEPTION: Overloaded ARP_ACCT_MAIN.Create_Acct_Entry
EXCEPTION: arp_process_application.receipt_application
arp_app_folder2.event(ON-ERROR)+

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