R12: Autoinvoice (RAXTRX) Errors When Using Revenue Contingencies - ORA-01722: Invalid Number (Doc ID 1586230.1)

Last updated on OCTOBER 18, 2018

Applies to:

Symptoms

Attempting to import Invoices using Autoinvoice and receive the following error:

arcdaa()
ORA-01722: invalid number
Error calling arcdaa_do_autoaccounting()
Error calling raaddl()
Error calling raapic()
raarrt2()

The debug log shows the following: 

arp_auto_accounting.constructor()- 17-SEP-13 03:13:35
 testing collectibility...
ar_revenue_management_pvt.line_collectibility()+
p_request_id :
p_source :
p_customer_trx_line_id : 4488923
default_contingencies()+
 p_request_id :
 p_customer_trx_line_id : 4488923
rows inserted in rule gt: 1
ARCUSPARBAR_CUSTOM_PARAMS_HOOK_PKG.populateContingencyAttributes()+ : 17/09/13 03:13:35
ARCUSPARBAR_CUSTOM_PARAMS_HOOK_PKG.populateContingencyAttributes()- : 17/09/13 03:13:35
OTHERS: default_contingencies
ORA-01722: invalid number
(2) OTHERS: line_collectibility
ORA-01722: invalid number
EXCEPTION: arp_auto_accounting.do_autoaccounting_internal()
ORA-01722: invalid number
Error processing ALL account class
EXCEPTION: arp_auto_accounting.do_autoaccounting()
ORA-01722: invalid number
EXCEPTION:  arp_process_line.insert_line()

Cause

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