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

(Doc ID 1586230.1)

Last updated on AUGUST 28, 2017

Applies to:

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

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

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