Calrification on Item

Here post Oracle Order Management related topics.
Post Reply
latha_bv
Posts: 15
Joined: Thu Jul 17, 2008 1:18 am
Location: USA

Calrification on Item

Post by latha_bv »

Hi Friends,

When I am booking the sales order, it give me Note that **You must specify a valid Bill for this revision??** in line level.

I have created customer, Master item, price and attach the item with the price. and enable the warehouse for this item. But still I am not understanding why I am getting this error. Can some body help me.

Thank you.
Latha.
ahmadbilal
Posts: 615
Joined: Mon Sep 18, 2006 1:32 am
Location: United Arab Emirates
Contact:

Post by ahmadbilal »

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.

References
Note 357471.1 - OEXOEORD: Receive Error with Items With No BOM: You Must Specify a Valid Bill for This Bill Revision
mpdhas@gmail.com
Posts: 64
Joined: Mon May 14, 2007 9:47 am
Location: India

Post by mpdhas@gmail.com »

Hi Latha,

The issue might have caused by the following setup: The attributes in item master were checked for:

The BOM Allowed was not checked in the Bills tab

But in the OM tab, the attributes in item master were checked for:
Pick components
Ship Model Complete

<b>Solution:</b>

Please execute the following steps:

1. Go into the responsibility: Inventory

2. Navigate to Items > Item Master

3. Query the item > OM tab > uncheck the attributes:
Pick components
Ship Model Complete

Let me know your feedback after implementing the above solution.

Regards,
Dhas
latha_bv
Posts: 15
Joined: Thu Jul 17, 2008 1:18 am
Location: USA

Post by latha_bv »

Hi friends,

Thank you so much for helping me. Yes when I unchecked pick component and ship Model complete, it worked for me. Now I could book the sales order.

Sorry for late reply, server was down since morning.

Regards.
Latha
Post Reply

Who is online

Users browsing this forum: No registered users and 9 guests