Applies to:

Item Master - Version: 11.5.10
This problem can occur on any platform.
FORM:OEXOEORD.FMB - Sales Orders

Applies to:

Item Master - Version: 11.5.10
This problem can occur on any platform.
FORM:OEXOEORD.FMB - Sales Orders

Symptoms

On 11.5.10 in Production:
When attempting to enter a Sales Order, using a specific item with same attributes as others, the
following error occurs.

ERROR
"You must specify a valid bill for this bill revision"

STEPS
The issue can be reproduced at will with the following steps:
1. Order Management resonsibility
2. Orders, Returns
3. Enter Sales Order with items

BUSINESS IMPACT
The issue has the following business impact:
Due to this issue, users cannot book orders using this specific item.

Cause

The issue is caused by the following setup: The Bill for this part ahs not been propagated to the
OE Item Validation Organization

Solution

To implement the solution, please execute the following steps:

1. Run the following scripts to confirm which BILLs do not exist for the Master Organization.
a) Navigate to System Administrator / profiles / system and Query OE: Item Validation Organization
b) Determine the organization_id for the Item Validation Organization

select organization_id, organization_code, organization_name
from org_organization_definitions
where organization_name = '&value_from_profile'; --- note. case matters when entering
org name.

c) Run the following script using the organization_id from the previous script to identify the Bills that need to be propagated and their creators.

select s.segment1 , f.user_name
from BOM_BILL_OF_MATERIALS b,
mtl_system_items_b s,
fnd_user f
where b.organization_id <> &orgid --- item validation organization
and b.assembly_item_id NOT IN (select assembly_item_id
from BOM_BILL_OF_MATERIALS
where organization_id = &orgid) --- item validation organization
and b.organization_id = s.organization_id
and b.assembly_item_id = s.inventory_item_id
and b.created_by = f.user_id
order by s.segment1;


1. Go into the responsibility: Bill of Materials

2. For each Assembly Item identified above, create a Common Bill or Copy the Bill to the Item Validation Organization:
To create common bill.

a. Nav: BOM > Bills > Bills (in child organization)
b. Query bill.
c. Choose Tools > Create Common Bill / enter details including master organization code.

-OR-

a. Nav: BOM > Bills > Create Common Bills

To copy bill,

a. Nav: BOM > Bills > Bills (in master organization)
b. Enter new item number for new bill.
c. Choose Tools > Copy bill from.... pull down menu / enter details for the bill you want to copy.
d. Make changes as needed.
e. Save

3. Retest the issue.

4. Migrate the solution as appropriate to other environments.