During working on ticket I noticed that some requisition statuses are not saved to the reporting database. These are the following statuses:
REJECTED, RELEASED_WITHOUT_ORDER, IN_APPROVAL, SKIPPED. As a result, some data in the database is out of date because it does not update when the status is changed to REJECTED or RELEASED_WITHOUT_ORDER or IN_APPROVAL or SKIPPED.
JoltTransformJSON processor should be changed to fix this issue.