Job Can't Close With Return Status of wip_picking_pvt.cancel_allocations

(Doc ID 2335089.1)

Last updated on DECEMBER 11, 2017

Applies to:

Oracle Work in Process - Version 12.1.3 and later
Oracle Warehouse Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Problem Statement
A discrete job is not closed by the Close Discrete Jobs program. It is stuck with "Failed Close" Status and below output message:

*****************************
2089164
There are transactions pending against these jobs.
*******************

But there is no pending transactions for the JOB.

Error

According to the Inventory Debug logs while closing the job, following messages are outputted.

Session 5493356: Cancelling Move Orders if any exists
Session 5493356: Invoking wip_picking_pvt.cancel_allocations for Job : 3169774
Session 5493356: In wip_picking_pvt.cancel_comp_allocations - Invoke is_task_loaded for Put Away 6717481 3169774
Session 5493356: In wip_picking_pvt.cancel_comp_allocations - Invoke cancel_MO_line for Put Away 6717481
Session 5493356: Return Status of wip_picking_pvt.cancel_allocations : U

Steps to Reproduce

  1. Run the Close Discrete Jobs program

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms