My Oracle Support Banner

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

Last updated on AUGUST 24, 2020

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

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.