AutoInvoice Ends With Error AFDICT_APP_PREFIX-AR-855636: ORA-01405: Fetched Column Value Is NULL (Doc ID 2267350.1)

Last updated on MAY 17, 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, Running autoinvoice is getting error:

ERROR:
----------------
UTIL-CURRENT TIME (DATE=09-MAY-2017) (TIME=16:06:04)
AFDICT_APP_PREFIX-AR-855636: ORA-01405: fetched column value is NULL
  
select ROWID ,ORIG_SYSTEM_BILL_CUSTOMER_ID from RA_INTERFACE_LINES_GTC
AFDICT_APP_PREFIX-AR-855636: /ade/apfwkr_210570585548/fusionapps/fin/ar/c/src/autoinv/raavpm.lpc 201
Error calling raavpm().
Error calling raapic().
Commit after cleanup - UTIL-CURRENT TIME (DATE=09-MAY-2017) (TIME=16:06:04)
Pre processing for partners invoked
Error calling raapic().


EXPECTED BEHAVIOR
-----------------------
Expecting to be able to create transactions


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. On Navigator
2. Go to Tools > Scheduling Processes
3. Run Autoinvoice program
4. Reviewed the report and observed the 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