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');
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');
No comments:
Post a Comment