My Oracle Support Banner

Journal Import Error and Final Accounted Journals Not Transferred to General Ledger (GL) Together With Other EP01 Records (Doc ID 2249145.1)

Last updated on MARCH 10, 2023

Applies to:

Oracle Cost Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

During the transfer of data from subledger to GL through SLA, some data corruption issues have been reported on the SLA to GL bridge.

Some accounts with event status : "Final Accounted" have not been transferred to GL.
Even if the previous GL period is reopened and Transfer Journal Entries to GL program is run, journals cannot be found in GL, and they are shown as error lines with "Error Code: EP01 - This date is not in any open or future enterable period" in Journal Import .

Error

-Output of Journal Import Execution Report

[recent period record]
                                 Accounting
Error Code                 Source                 Date           Currency       Entered Debit        Entered Credit     Accounting Flexfield/CCID
------------------------- -------------------      -----------    -------- ------------------------ ------------------------ -----------------------------
EP01                         Cost Management DD-MMM-YY XXX                                X                          X      XXXXXXXXXXXXXXXXX

 

[older period record]
                                Accounting
Error Code                Source                  Date             Currency       Entered Debit        Entered Credit     Accounting Flexfield/CCID
------------------------- ------------------      -----------        --------      ------------------------  ------------------------ -----------------------------
EP01                        Cost Management  DD-MMM-YY   XXX                                X                          X          XXXXXXXXXXXXXXXXX

 

Steps to Reproduce

  1. Some accounts were not transferred to GL.
  2. Close period.
  3. Run Transfer Journal Entries to GL program.
NOTE:  Please do not cancel the concurrent requests when "Journal Import" program is launched.
Negative Ledger Batches will be created, if you cancel "Create Accounting" or "Transfer to GL" Concurrent Request when the "Journal import" program is launched.
You have to run "Transfer to GL" program again, which will purge the negative LEDGER_ID batches in the next run.

Changes

Release 12 introduced SLA - an architectural layer between subledger and GL.

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
Changes
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.