How to find all work flow notification details of specific journal batch?
Use below queries to find work flow activity status & notification details of the journal batch select * from wf_notifications where notification_id in (select notification_id from WF_ITEM_ACTIVITY_STATUSES where item_type=’GLBATCH’ and item_key like ‘&je_batch_id%’ ); Select * from WF_ITEM_ACTIVITY_STATUSES where item_type=’GLBATCH’ and item_key like ‘&je_batch_id%’; je_batch_id can be obtained using below query select je_batch_id from gl_je_batches where name=&je_batch_name;
Related Questions
- Certain jobs in a business critical batch flow will run longer on future days. Can I predict if this will impact my service levels and what jobs will actually build the critical path?
- What is the meaning of the notification "Valve cannot deliver flow", with regards to a Flow Control Valve (FCV)?
- How do I translate conventional batch chemistry into micro/macro flow chemistry?
