My Oracle Support Banner

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

Last updated on FEBRUARY 18, 2019

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


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