Oracle Apps Inventory / Purchasing / GL Accounting Periods

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-12

    and end_date < '01-JAN-13'

    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-12'

    and end_date < '01-JAN-13'

    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-12'

    and end_date < '01-JAN-13'

    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