My Oracle Support Banner

Import Lot Based Jobs Updating/Doubling Required Quantities On BOM Components After Split Transaction (Doc ID 2318640.1)

Last updated on FEBRUARY 10, 2021

Applies to:

Oracle Shop Floor Management - Version 12.2 to 12.2.7 [Release 12.2]
Information in this document applies to any platform.



After updating a child job attribute field using the open interface(wsm_lot_job_interface), WIP_OPERATION_REQUIREMENTS, component requirements are recalculated for operations that are before the job location in the routing. These components were issued on the parent job (before the lot split). So we have duplicate components required.


If a job is past the operation, the requirements should not be recalculated. And, if the components were issued to the parent job before a lot split, the components should not be reissued.


The issue can be reproduced at will with the following steps:
1. Responsibility = Shop Floor Manager
2. Navigation = Lot Based Jobs
3, Org/Job = FG / parent,  push operations button
4. Components to be issued at operations 10 (Push) and 100 (Push), back flushed (operation pull) at 370
5. Back to main form, update job to released
6. Navigation = Lot Transactions-> Move Transactions
7. Navigation = Lot Transactions-> Material Transactions
8. Issues operation 20 material
9. Show material is issued – Open Lot Based Job Form, click components
7. Query Org/Job = FG / Eparent, move to operation 20 Queue
8. Show material is issued – Open Lot Based Job Form, click components
9. Navigation = Lot Transactions-> WIP Lot Transactions
10. Split into Echild and Eparent
11. Navigation = Lot Transactions-> Material Transactions, Query Org/Job = FG /Echild No components required (4511102 and 45016390) on the child show that there is 0 required for each of the components (as they were already issued on the parent), except at operation 370, component
12 Record entered into WSJ_LOT_JOB_INTERFACE and committed

wsm_lot_job_interface (header_id
VALUES (wsm_lot_job_interface_s.NEXTVAL --
,1 -- mode_flag
,2 -- process_phase
,1 -- process_status
,wip_interface_s.NEXTVAL --
,'XX_COLT_WO_IFACE' -- source_code,
used to uniquely identify records for this process in the interface table
,6 -- load_type =Job update
,3 -- status_type
,TO_DATE ('27-SEP-2017 21:30:00'
-- last_unit_completion_date
,'ECHILD' -- job_name
,105 -- organization_id
,12737 -- primary_item_id
,NULL -- routing_reference_id
(inventory_item_id of reference field on WDJ routing tab
,'FG STD LOT' -- class_code
,NULL --
,NULL -- completion_subinventory
,NULL -- completion_locator_id
,'FG STD LOT' -- attribute_category
,NULL -- attribute1,
,'REP' -- attribute2,
,'16+ DAY' -- attribute4,
,NULL -- attribute10,
,'FLT' -- attribute12,
,2 -- firm_planned_flag
,1 -- scheduling_method
,'Y' -- allow_explosion
,0 -- num_of_children
,SYSDATE -- creation_date
,1394 -- created_by
,SYSDATE -- last_update_date
,1394 -- last_updated_by
,1 -- job_type

13. Navigation = Lot Transactions-> Material Transactions, Query Org/Job = FG /Echild Components issued, 4511102 (132) and 45016390 (66) on the child.  This is double the original quantity




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.