Import AutoInvoice Ends With Error: AFDICT_APP_PREFIX-AR-855636 (Doc ID 2329899.1)

Last updated on NOVEMBER 27, 2023

Applies to:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.