Skip to main content

Issue/ Error : 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



Queries To determine the Status of the periods  (substitute the pertinent start and end dates in the queries 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
Inventory 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 = 401
order by application_id,start_date desc


Referecen Metalink ID: ID 552244.1

Comments

Popular posts from this blog

SQL Query to extract Oracle Purchase Order Information

SELECT   poh.po_header_id,    poh.type_lookup_code PO_TYPE,   poh.authorization_status PO_STATUS,   poh.segment1 PO_NUMBER,   pov.vendor_name SUPPLIER_NAME,   povs.vendor_site_code Location,   hrls.location_code Ship_To,   hrlb.location_code Bill_to,   pol.line_num ,   msib.segment1 Item,   pol.unit_price,   pol.quantity,   pod.amount_billed Amount,   pod.destination_subinventory,   ppf.full_name Buyer_Name,   poh.closed_Code  FROM   PO_HEADERS_ALL poh,   PO_LINES_ALL pol,   mtl_system_items_b msib,   PO_LINE_LOCATIONS_ALL poll,   PO_DISTRIBUTIONS_ALL pod,   po_vendors pov,   po_vendor_sites_All povs,   hr_locations_all hrls,   hr_locations_all hrlb,   per_all_people_f ppf,   po_line_types polt WHERE   1                         =1 AND polt.line...

Query to find Operating Unit, Business Group and Legal Entity Information

SELECT   DISTINCT   hrl . country ,                  hroutl_bg . name              bg ,                  hroutl_bg . organization_id ,                  lep . legal_entity_id ,                  lep . name                    legal_entity ,                  hroutl_ou . name              ou_name ,               ...

How To Enable / Disable Forms Personalization Option

Forms Personalization gives great flexibility to execute custom business logic without performing so much of technical work. To start forms personalization navigate to Help -> Diagnostics -> Custom Code -> Personalize But many time when we click on personalize it give below error  " Function is not available for this respnosibility. Change responsibilities or contact your System Administrator " To Enable access to forms personalization function we need to set below profile option.  -  Utilities:Diagnostics -> Yes / No It determines the diagnostics option is enabled for a user / responsibility or site, depending on the level profile option is set. Navigate to System Administrator -> Profile -> System Query for your user / responsibility for which you want to provide access. Set the value to 'Yes' , If you want allow access to forms personalization Since we change the profile option please change the respons...