R12 Error EF01 on the Journal Import (Doc ID 859344.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle General Ledger - Version: 12.1 and later   [Release: 12.1 and later ]
Oracle Payables - Version: 12.1.1 and later    [Release: 12.0 and later]
Information in this document applies to any platform.

Symptoms

On 12.1.1 in Production:
When running journal import into GL, the following error occurs:

ERROR
EF01 This Accounting Flexfield is inactive for this accounting date.

-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. AP: Run Payables Transfer Journal Entries to GL program with journal import.
2. Journal Import completes with warning showing the above error.

Changes

In R12.1.1 the profile option 'SLA: Disable Journal Import' is  end dated to discourage usage of this profile, see <> 'SLA:Disable Journal Import Profile Option Behaviour'.

Therefore, on failure of Journal Import, the data will be rolled back to SLA tables and we will not have any data in GL_INTERFACE. That means that you have to correct first the error and after that to re-run the Transfer Journals Entries to General Ledger.

This will also mean that “Journal -> Import -> Run”and “Journal -> Import-> Correct” forms in GL will not be used for the Subledger data as GL_INTERFACE will never have any data for them.

Please review <> 'Release 12 (R12) - Impact of Subledger Accounting (SLA) on General Ledger (Drilldown and Journal Import)' for more information.

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