Total Pageviews

Tuesday, December 18, 2012


Oracle Apps Inventory / Purchasing / GL Accounting Periods

Whenever you do Receiving inventory transactions, you often get errors if your Inventory/ purchasing/ GL periods are not open.

Here is the navigation where you can setup the periods for your material receipts:

1.    Ensure that the  GL Period  has Status=Open:
Setup > Financial > Accounting > Open and Close periods
-OR-
Setup > Open and Close periods

2.    Ensure the Purchasing Period is Open:
Setup > Financial > Accounting > Control Purchasing Period

3.    Please note that the Inventory period must also be Open:
Accounting close cycle > Inventory Accounting Periods

Use the following Query to check the status of the same:

select a.period_name,
       a.period_num,
       a.gl_status,
       b.po_status,
       c.ap_status
from
   (select period_name, period_num, 
    decode(closing_status,'O','Open',
                          'C','Closed',
                          'F','Future',
                          'N','Never',
           closing_status) gl_status
    from gl_period_statuses
    where application_id = 101
    and start_date >= '01-JAN-98
    and end_date < '01-JAN-99'
    and set_of_books_id = &&set_of_books_id) a,
   (select period_name, 
    decode(closing_status,'O','Open',
                          'C','Closed',
                          'F','Future',
                          'N','Never',
           closing_status) po_status
    from gl_period_statuses
    where application_id = 201
    and start_date >= '01-JAN-98'
    and end_date < '01-JAN-99'
    and set_of_books_id = &&set_of_books_id) b,
   (select period_name,
    decode(closing_status,'O','Open',
                          'C','Closed',
                          'F','Future',
                          'N','Never',
           closing_status) ap_status
    from gl_period_statuses
    where application_id = 200
    and start_date >= '01-JAN-98'
    and end_date < '01-JAN-99'
    and set_of_books_id = &&set_of_books_id) c
where a.period_name = b.period_name
and   a.period_name = c.period_name
order by a.period_num

No comments:

Post a Comment