IN PROCESS JOURNAL / Journal Approval showing inprocess / How to change approval status of a journal from inprocess to Approved

1) We need to fine the journal which is showing inprocess
2) We need to find the Journal batches which are containing inprocess journal

you can use the query
SELECT * FROM  GL_JE_BATCHES WHERE APPROVAL_STATUS_CODE='I';

3) We need to update the status code from I to A

UPDATE GL_JE_BATCHES SET APPROVAL_STATUS_CODE='A'
               WHERE JE_BATCH_ID IN
               (SELECT JE_BATCH_ID FROM GL_JE_BATCHES WHERE   APPROVAL_STATUS_CODE='I');