My Oracle Support Banner

Import Auto Invoice Ends with Error AFDICT_APP_PREFIX-AR-855636: ORA-12899 (Doc ID 2613717.1)

Last updated on MAY 26, 2020

Applies to:

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

Symptoms

On : 11.13.19.07.0 version, Reports

When try to run Import Auto Invoice, the ess process ends with error and no Autoinvoice Execution Report is created.

ERROR
-----------------------

Transferring : UTIL-CURRENT TIME (DATE=14-NOV-2019) (TIME=12:30:14)
UTIL-CURRENT TIME (DATE=14-NOV-2019) (TIME=12:30:14)
AFDICT_APP_PREFIX-AR-855636: ORA-12899: value too large for column ??? (actual: 31, maximum: 30)
...
INSERT INTO RA_CUSTOMER_TRX_LINES (
customer_trx_line_id,
last_update_^X
AFDICT_APP_PREFIX-AR-855636: c/src/autoinv/raaild.lpc 1190
INSERT INTO RA_CUSTOMER_TRX_LINES (
customer_trx_line_id,

....
Error calling raaild().
Error calling raapic().
Commit after cleanup - UTIL-CURRENT TIME (DATE=14-NOV-2019) (TIME=12:30:15)
 Pre processing for partners invoked
Error calling raapic().

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run import auto invoice
2. The job errors with error and no execution report was created

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot create invoices using autoinvoice


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.