My Oracle Support Banner

When running plan, the components are not exploded (Doc ID 2478609.1)

Last updated on FEBRUARY 26, 2019

Applies to:

Oracle Materials Requirement Planning - Version 12.0 and later
Information in this document applies to any platform.

Symptoms

When running plan, the components are not exploded.
BOM:
Assembly(make item)
|-Component1
|-Component2

SQL>SELECT * FROM MRP_GROSS_REQUIREMENTS
WHERE COMPILE_DESIGNATOR='&Plan_name'
AND ORGANIZATION_ID=(SELECT ORGANIZATION_ID FROM MTL_PARAMETERS WHERE ORGANIZATION_CODE = '&Org_code')
AND INVENTORY_ITEM_ID IN (&item_id1,&item_id2);

No records for USING_ASSEMBLY_ITEM_ID = item_id of the Assembly.

Performed below steps to confirm if the buy sourcing rules are assigned.

1. Check the value of profile option MRP: Default Sourcing Assignment Set.
2. Get assignment_set_id from assignment set name confirmed on step1.
SQL>select assignment_set_id from mrp_assignment_sets where ASSIGNMENT_SET_NAME='&Assignment_set_name';

3. List the source rule assignment in the assignment set for the item.
SQL>select * from mrp_item_sourcing_levels_v
where inventory_item_id=&item_id_of_assembly
and assignment_set_id=&assignment_set_id;

But no buy source rule assignment exist for the item in the assignment set.

Steps to Reproduce

  1. Run plan

 

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.