My Oracle Support Banner

FBDI Journal Import Failing When Using Reversal Period (Doc ID 2575315.1)

Last updated on AUGUST 08, 2019

Applies to:

Oracle Fusion General Ledger Cloud Service - Version 11.13.19.04.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to import Journal using FBDI with Reversal period, the following error occurs.

ERROR
-----------------------
Record 1: Rejected - Error on table GL_INTERFACE, column REFERENCE8.
ORA-01841: (full) year must be between -4713 and +9999, and not be 0

Record 2: Rejected - Error on table GL_INTERFACE, column REFERENCE8.
ORA-01841: (full) year must be between -4713 and +9999, and not be 0

STEPS TO REPRODUCE
==================
The issue can be reproduced at will with the following steps:
1. Download new FBDI template from
https://docs.oracle.com/en/cloud/saas/financials/19b/oefbf/general-ledger.html#journalimport-3139
2. Fill the template as needed (Not passing Ledger ID instead passing Ledger Name) and passed the Reversal Period.
3. Generate the csv file.
4. Run the Load Interface file for import using new file for Import Journal.
5. 'Load File to Interface' child job failed with:
Record 1: Rejected - Error on table GL_INTERFACE, column REFERENCE8.
ORA-01841: (full) year must be between -4713 and +9999, and not be 0

Record 2: Rejected - Error on table GL_INTERFACE, column REFERENCE8.
ORA-01841: (full) year must be between -4713 and +9999, and not be 0

Note: Ledger is not ADB ledger.

EXPECTED BEHAVIOR
=================
It should get imported fine.

BUSINESS IMPACT
===============
Due to this issue, users cannot import Journal.

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
References


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