Sunday, May 6, 2012

The GL date is not in an open period

Normally EBS end users will be getting the below error while receiving in Oracle Inventory:-

==> Error:

APP-PO-14230: The GL date is not in an open period
Or- APP-PO-14376: Please enter a GL date within an open purchasing period
==> Steps to Reproduce:

  1. Navigate to Enter Receipts form:
  2. Save a receipt.


==> Solution:-

1. Ensure the Receipt Date falls into a GL Period that has Status=Open or Future:

Setup / Financials / Accounting / Open and Close periods
-OR- Setup / Open and Close periods

2. Ensure the Purchasing Period is Open:

Setup / Financials / Accounting / Control Purchasing Period

3. Please note that the Inventory period must also be Open:

Accounting close cycle / Inventory Accounting Periods

(Note )To determine the Status of the periods, substitute the pertinent start and end dates in the sql below:

GL Period:

select set_of_books_id, period_name, decode(closing_status,'O','Open', 'C','Closed', 'F','Future', 'N','Never', closing_status) gl_status, start_date, end_date
from gl_period_statuses
where trunc(start_date) > sysdate-40 --adjust date as needed and trunc(start_date) < sysdate+1 and application_id = 101
order by application_id,start_date desc

PO Period:

select set_of_books_id, application_id, period_name, decode(closing_status,'O','Open', 'C','Closed', 'F','Future', 'N','Never', closing_status) po_status, start_date, end_date
from gl_period_statuses
where trunc(start_date) > sysdate-40 --adjust date as needed and trunc(start_date) < sysdate+1 and application_id = 201
order by application_id,start_date desc


==> Referecen Metalink ID [ID 552244.1





2 comments:

  1. I'm a newbie.

    by using the above are steps i found out that the dates upto jan-13(open) and feb-13 is future.
    My question is, how to update the dates till dec-14 and validate them and resolve the issue.

    ReplyDelete
  2. I really appreciate this wonderful post that you have provided for us. I assure this would be beneficial for most of the people. Period Track

    ReplyDelete