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-
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
Verify closing status.
Closing Status are-
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