AR_RECEIPT_API_PUB.Activity_application ends with AR_AMOUNTS_NO_MATCH error (Doc ID 1598650.1)

Last updated on SEPTEMBER 20, 2016

Applies to:

Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

When running AR_RECEIPT_API_PUB.Activity_application with the following data type for parameters AR_AMOUNTS_NO_MATCH error occurs.

Sample Code:


API Log:

SQL> @API_Activity_application.sql

AR AR_AMOUNTS_NO_MATCH                                                          
AR GENERIC_MESSAGE N GENERIC_TEXT ARP_PROCESS_APPLICATION.ACTIVITY_APPLICATION :
ORA-20001: This action has been blocked to avoid inaccurate accounting entries. Please contact Oracle Support Services                                                                  
PL/SQL procedure successfully completed.


FND Debug:

ar.plsql.ARP_ACCT_MAIN.Create_Acct_Entry.end ARP_ACCT_MAIN.Create_Acct_Entry()-
ar.plsql.ARP_ACCT_MAIN.Create_Acct_Entry.end Overloaded ARP_ACCT_MAIN.Create_Acct_Entry()-
ar.plsql.ARP_BALANCE_CHK.CHECK_RECP_BALANCE .begin ARP_BALANCE_CHK.CHECK_RECP_BALANCE (+)
ar.plsql.ARP_BALANCE_CHK.CHECK_RECP_BALANCE GL_DATE : 30-MAY-2013
ar.plsql.ARP_BALANCE_CHK.CHECK_RECP_BALANCE Sum_amount_dr :114200
ar.plsql.ARP_BALANCE_CHK.CHECK_RECP_BALANCE Sum_amount_cr :114200
ar.plsql.ARP_BALANCE_CHK.CHECK_RECP_BALANCE Sum_acctd_amount_dr : 114200
ar.plsql.ARP_BALANCE_CHK.CHECK_RECP_BALANCE Sum_acctd_amount_cr : 114200
ar.plsql.ARP_BALANCE_CHK.CHECK_RECP_BALANCE CC_flag : Y
ar.plsql.ARP_BALANCE_CHK.CHECK_RECP_BALANCE GL_DATE : 31-MAY-2013
ar.plsql.ARP_BALANCE_CHK.CHECK_RECP_BALANCE Sum_amount_dr :8500
ar.plsql.ARP_BALANCE_CHK.CHECK_RECP_BALANCE Sum_amount_cr :8500
ar.plsql.ARP_BALANCE_CHK.CHECK_RECP_BALANCE Sum_acctd_amount_dr : 8500
ar.plsql.ARP_BALANCE_CHK.CHECK_RECP_BALANCE Sum_acctd_amount_cr : 5000
ar.plsql.ARP_BALANCE_CHK.CHECK_RECP_BALANCE CC_flag : Y
ar.plsql.ARP_BALANCE_CHK.CHECK_RECP_BALANCE ARP_BALANCE_CHK.CHECK_RECP_BALANCE - OUT_OF_BALANCE
ar.plsql.ARP_BALANCE_CHK.Check_Precision .begin ARP_BALANCE_CHK.Check_Precision (+)
ar.plsql.ARP_BALANCE_CHK.Check_Precision p_amount 8500
ar.plsql.ARP_BALANCE_CHK.Check_Precision p_actual_amount 8500
ar.plsql.ARP_BALANCE_CHK.Check_Precision p_FunctionalCurrency 8500
ar.plsql.ARP_BALANCE_CHK.Check_Precision Application amount precision matches with FND currency precision
ar.plsql.ARP_BALANCE_CHK.Check_Precision .end ARP_BALANCE_CHK.Check_Precision (-)
ar.plsql.ARP_BALANCE_CHK.Check_Precision .begin ARP_BALANCE_CHK.Check_Precision (+)
ar.plsql.ARP_BALANCE_CHK.Check_Precision p_amount 5000
ar.plsql.ARP_BALANCE_CHK.Check_Precision p_actual_amount 5000
ar.plsql.ARP_BALANCE_CHK.Check_Precision p_FunctionalCurrency 5000
ar.plsql.ARP_BALANCE_CHK.Check_Precision Application amount precision matches with FND currency precision
ar.plsql.ARP_BALANCE_CHK.Check_Precision .end ARP_BALANCE_CHK.Check_Precision (-)
fnd.plsql.APP_EXCEPTION.RAISE_EXCEPTION.dict_auto_log This action has been blocked to avoid inaccurate accounting entries. Please contact Oracle Support Services
ar.plsql.arp_global.init_global EXCEPTION: arp_process_application.activity_application

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