SQL Query to fetch the Unposted GL Journal Batches in Oracle fusion.

 Here is the SQL query to fetch the Unposted GL Journal batches in the Oracle fusion.This query might be helpful in case if you want to find how many Unposted GL Batches exists.

SELECT

 GL.NAME "Ledger Name",

 GLJB.NAME "Batch name" , 

 GLJH.PERIOD_NAME,

 GLJH.STATUS, 

 GLJH.JE_CATEGORY CATEGORY ,

 GLJH.JE_SOURCE SOURCE , 

 GLJH.CURRENCY_CODE CURRENCY 

 FROM 

 GL_JE_HEADERS GLJH,

 GL_JE_BATCHES GLJB, 

 GL_LEDGERS GL

 WHERE 

 GLJB.JE_BATCH_ID = GLJH.JE_BATCH_ID AND

 GLJH.LEDGER_ID = GL.LEDGER_ID AND

 GLJH.STATUS <> 'P'

ORDER BY GL.NAME,GLJB.NAME,GLJH.PERIOD_NAME