Autoinvoice Gets Error: AFDICT_APP_PREFIX-AR-855636: ORA-01405: fetched column value is NULL

(Doc ID 2310246.1)

Last updated on SEPTEMBER 22, 2017

Applies to:

Oracle Fusion Receivables Cloud Service - Version 11.12.1.0.0 and later
Information in this document applies to any platform.

Symptoms

On Oracle Fusion, 11.12.1.0.0 version, Using autoinvoice. Transferring transactions from contract process ends with error


ERROR:
----------------
AFDICT_APP_PREFIX-AR-855636: ORA-01405: fetched column value is NULL
  
arcerr()- UTIL-CURRENT TIME (DATE=14-AUG-2017) (TIME=18:54:28)
arcdsu() Use Invoice Accounting For Credit Memo:
arcerr()+ UTIL-CURRENT TIME (DATE=14-AUG-2017) (TIME=18:54:28)
AG (STATUS=arcsai() )
UTIL-CURRENT TIME (DATE=14-AUG-2017) (TIME=18:54:28)
AFDICT_APP_PREFIX-AR-855636: ORA-01405: fetched column value is NULL
  
select TO_CHAR(FND_DATE.CANONICAL_TO_DATE(:b0),:b1) into :b2 from DUA
AFDICT_APP_PREFIX-AR-855636: c/src/util/arudat.lpc 133
arcerr()- UTIL-CURRENT TIME (DATE=14-AUG-2017) (TIME=18:54:28)
Error: Not all AutoAccounting types are defined.
AG (STATUS=arcsai() )
Error calling arcdsu_do_setup().
Error calling raaini().
CONC-REQ RETURNED NO MESG


EXPECTED BEHAVIOR
-----------------------
Expecting to be able to move contract data into receivables


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. On Navigator
2. Go to Tools > Scheduling Processes
3. Run Import Autoinvoice
4. Reviewed the report and observed error described appears


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