My Oracle Support Banner

Copy Routing Copies Resources And Alternate Resources To Tables (BOM_OPERATION_RESOURCES, BOM_SUB_OPERATION_RESOURCES) Even When Alternate Resource Not Assigned To Department In Destination Organization (Doc ID 2929059.1)

Last updated on FEBRUARY 21, 2023

Applies to:

Oracle Bills of Material - Version 12.2.8 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
---------------
Routing copy process copies a resource that is actually not existing OR assigned to the right department in the destination organization. This is not visible from Routings form. 
However, you see that resource in the table. Only after you add the resource to the department, you will  see the resource in the routings form  in application.

Expect only resources assigned to a department will be copied. Both front-end and back-end table should show the same resources and alternate resources for the routing.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Bills of material > Routings > Routings
2. Enter the assembly item
3. Navigate to Tools -> Copy Routing From
4. Select the Inventory Organization > Click ‘COPY’ > Save the changes.
5. Change Org (Destination) > Bills of material > Routings > Routings > Operations > Resources > Alternates - See only few resources

-- However, check back-end table bom_sub_operation_resources, see few additional records copied in the database. This is inconsistent.

Changes

 

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
Changes
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.