My Oracle Support Banner

Receipts Workbench: Apply a Receipt to a Transaction with Contigencies Error - APP-AR-11526 ORA-01476 (Doc ID 1599684.1)

Last updated on MARCH 14, 2022

Applies to:

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

Symptoms

On : 12.1.3 version, Receipts Related

Attempting to apply a Receipt to a specific Invoice and receive the following error:

APP-AR-11526: Discount: Earned=0.00, Total=0.00

Debug log shows:

AR_RAAPI_UTIL.revenue_amount_total()+
p_customer_trx_id = 1170838
p_customer_trx_line_id = 13278622
p_adjustment_type = EA
p_revenue_adjustment_id=
l_inv_amt = 5
l_cm_amt = 0
l_total_amt = 5
AR_RAAPI_UTIL.revenue_amount_total()-
l_adjustable_revenue = 5
AR_RAAPI_UTIL.Adjustable_Revenue()-
AR_Revenue_Adjustment_PVT.dists_by_model()+
p_adjustment_id = 1086474
earn_or_unearn: Unexpected error ORA-01476: divisor is equal to zero at AR_Revenue_Adjustment_PVT.earn_or_unearn()+
Earn_Revenue: Unexpected error User-Defined Exception at AR_Revenue_Adjustment_PVT.Earn_Revenue()+
RME encountered an ERROR with RAM!
p_customer_trx_id : 1170838
p_customer_trx_line_id : 13278622
Error Reported By RAM API:
APP-AR-11526: &GENERIC_TEXT (GENERIC_TEXT=)
OTHERS: adjust_revenue
ORA-20001: APP-AR-11526: &GENERIC_TEXT (GENERIC_TEXT=)
(1) OTHERS: receipt_analyzer
ORA-20001: APP-AR-11526: &GENERIC_TEXT (GENERIC_TEXT=)
EXCEPTION: arp_process_application.receipt_application

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.