Use the following queries to check the status of accounting periods. Be sure to substitute the relevant start and end dates as needed.

 SELECT FA.APPLICATION_NAME, SOB.NAME LEDGER, GPS.PERIOD_NAME,

       GPS.PERIOD_NUM, GPS.START_DATE, GPS.END_DATE, GPS.CLOSING_STATUS,

       DECODE(CLOSING_STATUS,’O’,’Open’, ‘C’,’Closed’, ‘F’,’Future’, ‘N’,’Never’, CLOSING_STATUS) GL_STATUS

  FROM GL_PERIOD_STATUSES GPS,

       GL_SETS_OF_BOOKS SOB,

       FND_APPLICATION_VL FA

 WHERE 1=1 

   –AND FA.APPLICATION_NAME = ‘General Ledger’

   AND SOB.NAME LIKE ‘Vision Operations (USA)%’

   AND SOB.SET_OF_BOOKS_ID=GPS.SET_OF_BOOKS_ID

   AND FA.APPLICATION_ID = GPS.APPLICATION_ID

   –AND GPS.ADJUSTMENT_PERIOD_FLAG = ‘N’

   –AND GPS.CLOSING_STATUS = ‘O’

   AND PERIOD_NAME =’Jun-25′