Import AutoInvoice Ends With Error: AFDICT_APP_PREFIX-AR-855636

(Doc ID 2329899.1)

Last updated on NOVEMBER 18, 2017

Applies to:

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

Symptoms

When attempting to run Autoinvoice,the following error occurs.

ERROR
-----------------------
........

UTIL-CURRENT TIME (DATE=24-JUL-2017) (TIME=12:51:36)
AFDICT_APP_PREFIX-AR-855636: ORA-01405: fetched column value is NULL

SELECT REPLACE(T.NAME, '''', ''''''), T.CUST_TRX_TYPE_SEQ_ID
FROM RA_C^X
AFDICT_APP_PREFIX-AR-855636: c/src/autoinv/raabdf.lpc 229
SELECT REPLACE(T.NAME, '''', ''''''), T.CUST_TRX_TYPE_SEQ_ID
FROM RA_CUST_TRX_TYPES_ALL T WHERE T.TYPE IN ('INV', 'CM', 'DM') and ( T.set_id =
FND_SETID_UTILITY.GETSETID('AR_TRANSACTION_TYPE','BU', MO_GLOBAL.GET_CURRENT_ORG_ID) OR T.SET_ID = 0)
Error calling raabdf().
Error calling raabsv().
Error calling raapu0().
raarrt2()+ UTIL-CURRENT TIME (DATE=24-JUL-2017) (TIME=12:51:36)
issued rollback in raarrt2 UTIL-CURRENT TIME (DATE=24-JUL-2017) (TIME=12:51:36)
Document Sequencing mode ::: <LEDGER>
Document Sequencing level::: <P>

...........




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run AutoInvoice

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Unable to import invoice because of this issue.

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