Getting error message "gme_gmf_wip_acct_issue" when cancelling batch

When attempting to cancel a batch the following error occurs.

GME_GMF_WIP_ACCT_ISSUE_CONT


STEPS:
1. Production Supervisor > Batches >Cancel batch

CAUSE

Batches having no transaction should not give any warning / error when canceling such batch.

In GMF_BATCH_VALIDATIONS.check_cancel_batch cursor Min_max_trans_date would always get a row due to use of min and max function even when transactions do not exist. Thus cursor not found check needs to be replaced by if min and max dates are null. This would be the case when there are no transactions.

Solution :

Apply Patch

To implement the solution, please execute the following steps:

1. Download and review the read me and pre-requisites for R12.0.x Patch 14627037

                                                                            R12.1.x Patch 16777853
2. Ensure that you have taken a backup of your system before applying the recommended patch.
3. Apply the patch in a test environment.
4. Confirm the following file versions:
     R12.0.x      GMFBCHVB.pls 120.0.12000000.5

     R12.1.x      GMFBCHVB.pls 120.2.12010000.4
You can use the commands like the following:

strings -a $GMF_TOP/patch/115/sql/GMFBCHVB.pls |grep '$Header'
5. Retest the issue.
6. Migrate the solution as appropriate to other environments.