Friday, September 5, 2014

How to fix error EP01:This date is not in any open or future enterable period in Oracle GL

EP01:This date is not in any open or future enterable period.


Whenver you get an error while importing journals through gl_interface table.

Please perform below steps to find cause and fix-

First Check date in accounting_date column of gl_interface table for errored records
Use to_char( accounting_date,'dd-mon-yyyy hh24:mi:ss') to that column so that you can see complete format.

select to_char( accounting_date,'dd-mon-yyyy hh24:mi:ss') from gl.gl_interface where status='EP01';

Then find out period name to which this accounting date belongs.
You can find period name by veryfying in gl_periods table and by checking start_date and end_date columns.

Select * From Gl.Gl_Periods;

Pass period name nad set of books id to below query and run in database

Select closing_status
From Gl.Gl_Period_Statuses
Where  Set_Of_Books_Id=1  --enter your set of books id
And Application_Id In
(Select Application_Id
   From Apps.Fnd_Application_Tl
   Where Application_Name In ('General Ledger','Payables'))
and period_name='AUG-14'   --enter the period name to which accounting date of errored records belong;

Verify closing status.

Closing Status are-
C           Closed
F            Future – Entry
N           Never Opened
O           Open
P            Permanently Closed

It should be either O or F to import journal into Oracle GL.
If its C, then you have to open that period in Oracle GL and AP and import journal.

Please visit my below posts to know how to open period in Oracle GL and AP-
  • Open AP Periods in Oracle account payables to fix invalid period issue
  • Open GL Periods in Oracle general ledger to fix invalid period issue

4 comments:

  1. Tks very much for your post.

    Avoid surprises — interviews need preparation. Some questions come up time and time again — usually about you, your experience and the job itself. We've gathered together the most common questions so you can get your preparation off to a flying start.

    You also find all interview questions at link at the end of this post.

    Source: Download Ebook: Investment Club Accounting has never been easier. Discover a step-by-step process to running the accounts for your investment club:

    Source: Download Ebook: Ultimate Guide To Job Interview Questions Answers:

    Best rgs

    ReplyDelete
  2. Regards
    Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
    LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
    Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at training@oracleappstechnical.com | +91 - 9581017828.

    ReplyDelete

  3. Thanks for the given information you are providing content very usefull to users.
    Learn Complete GL Interface Program in Oracle Apps R12 Actual cost of this course is 3,200/- But now Kuncham Software Solutions Pvt ltd is giving you Free access. Limited period offer Hurry-up Enroll Now at Udemy.


    Hurry-Up Enroll Now and get Free Access to the Entire Course

    ReplyDelete