My Oracle Support Banner

E-Kanban: Update 'Beginning On Hand' Field In Horizontal Plan In Planning Workbench (Doc ID 2871868.1)

Last updated on JUNE 20, 2022

Applies to:

Oracle Flow Manufacturing - Version 12.2.9 and later
Information in this document applies to any platform.


Due to business reasons, it is imperative to maintain item stock in multiple dynamic locators
which are large in numbers and we don't want to define a pull sequence for every locator. We
will perform Kanban Planning at the Item level by defining a single pull sequence for an item. We
want the system to display Item level 'Beginning on-hand' for this planning pull sequence. It is currently
displaying locator level on-hand.

Example: Item 33351 has stock in 100 different locators across
subinventories. We will define single pull sequence for this item and
Horizontal Plan for this pull sequence should display item level "Beginning
Onhand" (total of all 100 locators.). Please see attached screenshot for more

Similarly, in some orgs we may define single pull sequence at subinventory
level, in this case subinventory level beginning on-hand will be displayed for
the item.


We want this solution to be dynamic (could be profile controlled) so that
implementation control can be maintained at inventory organization level, for
example Org A can follow item level on-hand, Org B can follow Subinventory
level on-hand and Org C can follow existing functionality.


The issue can be reproduced at will with the following steps:

1 Resp: Kanban super user.
2 Nav: Home-> Ekanban.
3 Create a pull sequence of any item.
4 Create the plan for the pull sequence.
5 Launch the plan and got Planning Workbench under Planning tab.
6 Select planned pull sequence and check into Horizontal plan section.
7 On-hand quantity should display on the basis preference provided by Customer
in custom hook.




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

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