Job Can't Close With Return Status of wip_picking_pvt.cancel_allocations (Doc ID 2335089.1)

Last updated on AUGUST 09, 2019

Applies to:

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

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.