WIP Mas Load Fails After Kanban Status Change BY API:INV_KANBAN_PUB with Error: "Unable to update the associated kanban card to 'Inprocess' status for this job." (Doc ID 2900315.1)

Last updated on SEPTEMBER 30, 2024

Applies to:

Symptoms

Problem Statement
Through Public API: INV_Kanban_PUB.Update_Card_Supply_Status,  kanban status is changed to Empty for multiple kanban cards. Then some WIP Mass load requests fail with the following message:

Error
Unable to update the associated kanban card to 'Inprocess' status for this job.

Steps to Reproduce

1. Navigate to Inventory > Kanban > Kanban Cards, and prepare multiple Kanban Cards with Status = New (or Full), Source = Production.
2. From a custom program, execute API: INV_Kanban_PUB.Update_Card_Supply_Status with p_Supply_Status = 4 (Empty), p_commit = false for multiple Kanban Cards.  At the end of custom program, execute commit manually after all process completes for all Kanban Cards.
3. Navigate to Menu:View > Requests and click Find button, then WIP Mass Load request launches for every Kanban Card.
4. Some of WIP Mass Load requests fail and the reported error message is shown in WIP_INTERFACE_ERRORS table.
   
   

Cause

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