tag:blogger.com,1999:blog-71678649289296775452024-02-07T11:48:54.450-08:00Oracle Bill Of MaterialJust Shared !S.Grace Paul Reganhttp://www.blogger.com/profile/08467360023113459306noreply@blogger.comBlogger8125tag:blogger.com,1999:blog-7167864928929677545.post-30273554227075475272012-07-10T04:34:00.000-07:002012-07-10T04:34:06.777-07:00APP-BOM-28282 - Error<div dir="ltr" style="text-align: left;" trbidi="on">
<strong>APP-BOM-28282: You do not have access to any of the item types. Bills of Material definition form can be accessed only if you have at least one of the Model, Standard, Planing or Option Class item type </strong><br />
<br />
You may get the above error because of the improper values set for related profile options.<br />
<br />
1. Go into the responsibility: System Administrator<br /><br />2. Navigate to Profiles => System.<br /><br />3. Set the following profiles to YES either at site, application or user level<br /><br />BOM: Model Item Access = YES<br />BOM: Planning Item Access = YES<br />BOM: Standard Item Access = YES<br />
<br />
Thanks & Regards,<br />
S.Grace Paul Regan.<br /></div>S.Grace Paul Reganhttp://www.blogger.com/profile/08467360023113459306noreply@blogger.com1tag:blogger.com,1999:blog-7167864928929677545.post-63303309921221705812012-07-09T05:08:00.002-07:002012-07-09T05:08:36.244-07:00Simple Query To Fetch Bill Of Material (BOM) Information<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<div class="Note1">
SELECT<o:p></o:p></div>
<div class="Note1">
<span style="mso-tab-count: 1;"> </span>substr(iasy.segment1,1,20)
"Assembly",<o:p></o:p></div>
<div class="Note1">
<span style="mso-tab-count: 2;"> </span>substr(icmp.segment1,1,20)
"Component",<o:p></o:p></div>
<div class="Note1">
<span style="mso-tab-count: 2;"> </span>substr(comp.component_quantity,1,8)
"Quantity",<o:p></o:p></div>
<div class="Note1">
<span style="mso-tab-count: 2;"> </span>substr(comp.effectivity_date,1,8)
"From",<o:p></o:p></div>
<div class="Note1">
<span style="mso-tab-count: 2;"> </span>substr(comp.disable_date,1,8)
"To Date"<o:p></o:p></div>
<div class="Note1">
FROM<o:p></o:p></div>
<div class="Note1">
<span style="mso-tab-count: 2;"> </span>mtl_system_items_B
iasy,<o:p></o:p></div>
<div class="Note1">
<span style="mso-tab-count: 2;"> </span>bom_bill_of_materials
bom,<o:p></o:p></div>
<div class="Note1">
<span style="mso-tab-count: 2;"> </span>bom_inventory_components
comp,<o:p></o:p></div>
<div class="Note1">
<span style="mso-tab-count: 2;"> </span>mtl_system_items_B
icmp<o:p></o:p></div>
<div class="Note1">
WHERE<o:p></o:p></div>
<div class="Note1">
<span style="mso-tab-count: 2;"> </span>iasy.segment1
LIKE '&Item%' AND<o:p></o:p></div>
<div class="Note1">
<span style="mso-tab-count: 2;"> </span>iasy.organization_id
= 207 AND<o:p></o:p></div>
<div class="Note1">
<span style="mso-tab-count: 2;"> </span>iasy.inventory_item_id
= bom.assembly_item_id AND<o:p></o:p></div>
<div class="Note1">
<span style="mso-tab-count: 2;"> </span>iasy.organization_id
= bom.organization_id AND<o:p></o:p></div>
<div class="Note1">
<span style="mso-tab-count: 2;"> </span>bom.bill_sequence_id
= comp.bill_sequence_id AND<o:p></o:p></div>
<div class="Note1">
<span style="mso-tab-count: 2;"> </span>comp.component_item_id
= icmp.inventory_item_id AND<o:p></o:p></div>
<div class="Note1">
<span style="mso-tab-count: 2;"> </span>icmp.organization_id
= 207<o:p></o:p></div>
<div class="Note1">
<br /></div>
<div class="Note1">
Thanks & Regards,</div>
<div class="Note1">
S.Grace Paul Regan</div>
</div>S.Grace Paul Reganhttp://www.blogger.com/profile/08467360023113459306noreply@blogger.com3tag:blogger.com,1999:blog-7167864928929677545.post-88452224176958834272012-07-09T05:04:00.001-07:002012-07-09T05:05:08.567-07:00Simple Query To Fetch Implemented Engineering Change Order Information<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<div class="Note1">
SELECT<o:p></o:p></div>
<div class="Note1">
substr(iasy.segment1,1,20) "Assembly",<o:p></o:p></div>
<div class="Note1">
substr(icmp.segment1,1,20) "Component",<o:p></o:p></div>
<div class="Note1">
substr(comp.component_quantity,1,8) "Quantity",<o:p></o:p></div>
<div class="Note1">
substr(comp.effectivity_date,1,8) "From",<o:p></o:p></div>
<div class="Note1">
substr(comp.disable_date,1,8) "To Date"<o:p></o:p></div>
<div class="Note1">
FROM<o:p></o:p></div>
<div class="Note1">
mtl_system_items_B iasy,<o:p></o:p></div>
<div class="Note1">
bom_bill_of_materials bom,<o:p></o:p></div>
<div class="Note1">
bom_inventory_components comp,<o:p></o:p></div>
<div class="Note1">
mtl_system_items_B icmp<o:p></o:p></div>
<div class="Note1">
WHERE<o:p></o:p></div>
<div class="Note1">
iasy.segment1 LIKE '&Assembly%' AND<o:p></o:p></div>
<div class="Note1">
iasy.organization_id =
207 AND<o:p></o:p></div>
<div class="Note1">
iasy.inventory_item_id =
bom.assembly_item_id AND<o:p></o:p></div>
<div class="Note1">
iasy.organization_id =
bom.organization_id AND<o:p></o:p></div>
<div class="Note1">
bom.bill_sequence_id =
comp.bill_sequence_id AND<o:p></o:p></div>
<div class="Note1">
comp.component_item_id =
icmp.inventory_item_id AND<o:p></o:p></div>
<div class="Note1">
icmp.organization_id =
207<o:p></o:p></div>
<div class="Note1">
<br /></div>
<div class="Note1">
Thanks & Regards,</div>
<div class="Note1">
S.Grace Paul Regan</div>
</div>S.Grace Paul Reganhttp://www.blogger.com/profile/08467360023113459306noreply@blogger.com0tag:blogger.com,1999:blog-7167864928929677545.post-51358125239739974592012-07-09T05:03:00.001-07:002012-07-09T05:03:51.522-07:00Implementing Engineering Change Order (ECO)<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<div class="Subheading">
<span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;">Responsibility = Manufacturing and Distribution Manager<o:p></o:p></span></div>
<div class="Subheading">
<span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div class="Task1">
<span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;">1.<span style="mso-tab-count: 1;"> </span>Navigate to the
Engineering Change Orders window.<o:p></o:p></span></div>
<div class="Task2" style="margin-left: .55in; mso-list: l0 level1 lfo2; tab-stops: list .55in left .6in; text-indent: -.25in;">
<!--[if !supportLists]--><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><span style="mso-list: Ignore;">·<span style="font: 7.0pt "Times New Roman";">
</span></span><!--[endif]--><span dir="LTR"></span>(N) Engineering > ECOs
> ECOs<o:p></o:p></span></div>
<div class="Task2" style="margin-left: .55in; mso-list: l0 level1 lfo2; tab-stops: list .55in left .6in; text-indent: -.25in;">
<span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div class="Task1">
<span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;">2.<span style="mso-tab-count: 1;"> </span>Use F11 to start a
query.<o:p></o:p></span></div>
<div class="Task1">
<span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div class="Task1">
<span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;">3.<span style="mso-tab-count: 1;"> </span>Enter the following
data:</span></div>
<div class="Notelist1" style="mso-list: l1 level1 lfo1;">
<!--[if !supportLists]--><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><span style="mso-list: Ignore;">-<span style="font: 7.0pt "Times New Roman";">
</span></span><!--[endif]--><span dir="LTR"></span>ECO Number = "enter the ECO number you wish to query"<o:p></o:p></span></div>
<div class="Notelist1" style="mso-list: l1 level1 lfo1;">
<span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div class="Task1">
<span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;">4.<span style="mso-tab-count: 1;"> </span>Use Ctrl F11 to run
the query.<o:p></o:p></span></div>
<div class="Task1">
<span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div class="Task1">
<span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;">5.<span style="mso-tab-count: 1;"> </span>(M) Tools >
Implement (B) Yes<o:p></o:p></span></div>
<div class="Task1">
<span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div class="Task1">
<span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;">6.<span style="mso-tab-count: 1;"> </span>Ensure that the
request is Compeleted.<o:p></o:p></span></div>
<div class="Task2" style="margin-left: .55in; mso-list: l0 level1 lfo2; tab-stops: list .55in left .6in; text-indent: -.25in;">
<!--[if !supportLists]--><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><span style="mso-list: Ignore;">·<span style="font: 7.0pt "Times New Roman";">
</span></span><!--[endif]--><span dir="LTR"></span>(M) View > Requests<o:p></o:p></span></div>
<div class="Task2" style="margin-left: .55in; mso-list: l0 level1 lfo2; tab-stops: list .55in left .6in; text-indent: -.25in;">
<span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div class="Subheading">
<span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;">View the components on the primary Bill of Material<o:p></o:p></span></div>
<div class="Subheading">
<span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div class="Task1">
<span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;">7.<span style="mso-tab-count: 1;"> </span>Navigate to the Bills
of Material window.<o:p></o:p></span></div>
<div class="Task2" style="margin-left: .55in; mso-list: l0 level1 lfo2; tab-stops: list .55in left .6in; text-indent: -.25in;">
<!--[if !supportLists]--><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><span style="mso-list: Ignore;">·<span style="font: 7.0pt "Times New Roman";">
</span></span><!--[endif]--><span dir="LTR"></span>(N) Bills of Materials >
Bills > Bills<o:p></o:p></span></div>
<div class="Task2" style="margin-left: .55in; mso-list: l0 level1 lfo2; tab-stops: list .55in left .6in; text-indent: -.25in;">
<span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div class="Task1">
<span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;">8.<span style="mso-tab-count: 1;"> </span>Use F11 to start a
query<o:p></o:p></span></div>
<div class="Task1">
<span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div class="Task1">
<span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;">9.<span style="mso-tab-count: 1;"> </span>Enter the following
data:<o:p></o:p></span></div>
<div class="Notelist1" style="mso-list: l1 level1 lfo1;">
<!--[if !supportLists]--><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><span style="mso-list: Ignore;">-<span style="font: 7.0pt "Times New Roman";">
</span></span><!--[endif]--><span dir="LTR"></span>Item = "(XX 1000-User Defined Item Number)"<o:p></o:p></span></div>
<div class="Notelist1" style="mso-list: l1 level1 lfo1;">
<span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div class="Task1">
<span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;">10.<span style="mso-tab-count: 1;"> </span>Use Ctrl F11 to run
the query.</span><o:p></o:p></div>
<div class="Task1">
<span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhJCZNT87Ar5I2shqjm31NKooM3l77UhVQlnPSOO6XwFGkYJATQHmWxplhjlPduSZ2F-oWkcKoeKcvPYa-ZTmQ-q86W35hzg07FmFbsLLpAjqYHfIFfgkLsRHmVIFgZvU9sVDdHORhbJGM/s1600/ECO.JPG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhJCZNT87Ar5I2shqjm31NKooM3l77UhVQlnPSOO6XwFGkYJATQHmWxplhjlPduSZ2F-oWkcKoeKcvPYa-ZTmQ-q86W35hzg07FmFbsLLpAjqYHfIFfgkLsRHmVIFgZvU9sVDdHORhbJGM/s1600/ECO.JPG" /></a></div>
<div class="Task1">
<span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><span style="font-family: "Times New Roman","serif"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-language: AR-SA; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: EN-US;"><br /><!--[endif]--></span></span></div>
<div class="Task1">
<span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><span style="font-family: "Times New Roman","serif"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-language: AR-SA; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: EN-US;"><!--[if gte vml 1]><v:shapetype id="_x0000_t75"
coordsize="21600,21600" o:spt="75" o:preferrelative="t" path="m@4@5l@4@11@9@11@9@5xe"
filled="f" stroked="f">
<v:stroke joinstyle="miter"/>
<v:formulas>
<v:f eqn="if lineDrawn pixelLineWidth 0"/>
<v:f eqn="sum @0 1 0"/>
<v:f eqn="sum 0 0 @1"/>
<v:f eqn="prod @2 1 2"/>
<v:f eqn="prod @3 21600 pixelWidth"/>
<v:f eqn="prod @3 21600 pixelHeight"/>
<v:f eqn="sum @0 0 1"/>
<v:f eqn="prod @6 1 2"/>
<v:f eqn="prod @7 21600 pixelWidth"/>
<v:f eqn="sum @8 21600 0"/>
<v:f eqn="prod @7 21600 pixelHeight"/>
<v:f eqn="sum @10 21600 0"/>
</v:formulas>
<v:path o:extrusionok="f" gradientshapeok="t" o:connecttype="rect"/>
<o:lock v:ext="edit" aspectratio="t"/>
</v:shapetype><v:shape id="_x0000_i1025" type="#_x0000_t75" style='width:468pt;
height:313.5pt'>
<v:imagedata src="file:///C:\Users\Regan\AppData\Local\Temp\msohtmlclip1\01\clip_image001.png"
o:title="BillsofMaterial2"/>
</v:shape><![endif]--><!--[if !vml]--><img src="file:///C:/Users/Regan/AppData/Local/Temp/msohtmlclip1/01/clip_image002.jpg" v:shapes="_x0000_i1025" /><!--[endif]--></span></span></div>
<div class="Task1">
<span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div class="Task1">
<span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div class="Task1">
<span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div class="Task1">
<span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div class="Task1">
<span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div class="Task1">
<span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div class="Task1">
<span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div class="Task1">
<span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div class="Task1">
<span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div class="Task1">
<span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div class="Task1">
<span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div class="Task1">
<span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div class="Task1">
<span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div class="Task1">
<span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div class="Task1">
<span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div class="Task1">
<span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div class="Task1">
<span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div class="Task1">
<span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div class="Task1">
<span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div class="Task1">
<span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div class="Task1">
<span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div class="Task1">
<span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div class="Task1">
<span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"></span></div>
<div class="Task1">
<span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;">11. Select the ECO tab to view the change order.<o:p></o:p></span></div>
<span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;">
<div class="Task1">
12.<span style="mso-tab-count: 1;"> </span>Close the window.<o:p></o:p></div>
<div class="Task1">
<br /></div>
<div class="Task1">
Thanks & Regards,</div>
<div class="Task1">
S.Grace Paul Regan</div>
</span><br />
<div class="Task1">
<span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"></span></div>
<div class="Note1">
<!--[if gte vml 1]><v:shapetype id="_x0000_t75" coordsize="21600,21600"
o:spt="75" o:preferrelative="t" path="m@4@5l@4@11@9@11@9@5xe" filled="f"
stroked="f">
<v:stroke joinstyle="miter"/>
<v:formulas>
<v:f eqn="if lineDrawn pixelLineWidth 0"/>
<v:f eqn="sum @0 1 0"/>
<v:f eqn="sum 0 0 @1"/>
<v:f eqn="prod @2 1 2"/>
<v:f eqn="prod @3 21600 pixelWidth"/>
<v:f eqn="prod @3 21600 pixelHeight"/>
<v:f eqn="sum @0 0 1"/>
<v:f eqn="prod @6 1 2"/>
<v:f eqn="prod @7 21600 pixelWidth"/>
<v:f eqn="sum @8 21600 0"/>
<v:f eqn="prod @7 21600 pixelHeight"/>
<v:f eqn="sum @10 21600 0"/>
</v:formulas>
<v:path o:extrusionok="f" gradientshapeok="t" o:connecttype="rect"/>
<o:lock v:ext="edit" aspectratio="t"/>
</v:shapetype><v:shape id="_x0000_i1025" type="#_x0000_t75" style='width:468pt;
height:313.5pt'>
<v:imagedata src="file:///C:\Users\Regan\AppData\Local\Temp\msohtmlclip1\01\clip_image001.png"
o:title="BillsofMaterial2"/>
</v:shape><![endif]--><!--[if !vml]--><!--[endif]--><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><o:p></o:p></span></div>
<br />
</div>S.Grace Paul Reganhttp://www.blogger.com/profile/08467360023113459306noreply@blogger.com0tag:blogger.com,1999:blog-7167864928929677545.post-25126339115678017282008-10-28T04:18:00.000-07:002008-10-28T04:20:32.954-07:00Bill Of Material Creation in Oracle<strong>Creating a Bill of Material</strong><br />-----------------------------------<br /> <br />A bill of material contains information on the parent item, components,<br />attachments, and descriptive elements. Each standard component on a bill<br />can have multiple reference designators and substitute components.<br /> <br />You can create either an engineering or manufacturing bill, copy an<br />existing bill, or reference a common bill. When you create a bill, it<br />exists only in the current organization. To use a bill in another<br />organization, you must either copy it or reference it as a common.<br /><br />The procedure below describes how to create a bill.<br /><br /><strong><br />Prerequisites</strong><br />-------------<br /> Define the parent item and all components as inventory items and set<br /> the BOM Allowed attribute to Yes and BOM Item Type to Model, Option<br /> Class, Planning or Standard.<br /><br /><br /><strong>To create a bill of material</strong><br />------------------------------------<br /><br /> 1. Navigate to the Bills of Material window.<br /><br /> Note: If your current responsibility does not include the<br /> Privilege to Maintain security function, you can only view<br /> bill information. If so, enter selection criteria in the<br /> Find Bills window and choose the Find button. The Bills<br /> Summary folder window appears.<br /><br /> 2. Enter the parent item for which you are creating a bill, and if<br /> you are creating an alternate bill, enter the alternate.<br /><br /> Note: Bills and routings can share alternate labels. If you<br /> create an alternate bill with the same label as an alternate<br /> routing, components are assigned to operations on the<br /> alternate routing. If there is no routing with the same<br /> alternate label, components are assigned to operations on<br /> the primary routing.<br /><br /> 3. Enter or select the revision and the revision date.<br /><br /> 4. If you are updating or viewing a bill, use the Display pop list to<br /> display all, current, or future and current components effective<br /> as of the revision date you specify. Check the Implemented Only<br /> field to further restrict the components to display.<br /><br /> The Bills of Material window contains the following alternative<br /> regions: Main, Effectivity, Component Details, Material Control,<br /> Order Entry, Shipping, and Comments.<br /><br /> 5. Enter the item sequence, operation sequence, and the component<br /> item.<br /><br /> 6. In the Main tabbed region, enter the quantity used to make one<br /> unit of this assembly item at the current operation.<br /><br /> This can include negative or decimal values, subject to the<br /> following rules:<br /><br /> Pick-to-order bills cannot have fractional component<br /> quantities if Oracle Order Management is installed.<br /><br /> Pick-to-order option class components cannot have negative<br /> values.<br /><br /> Components with Check ATP turned on cannot have negative or<br /> zero quantities.<br /><br /> If the component has Quantity Related turned on, then the<br /> component quantity cannot be fractional or negative.<br /><br /> If an implemented component has Quantity Related turned on,<br /> then the component quantity must be equal to the number of<br /> reference designators.<br /><br /> Attention: The planning process in Oracle Master<br /> Scheduling/MRP ignores negative requirements on<br /> standard discrete jobs and components with a<br /> negative usage on a bill of material when netting<br /> supply and demand.<br /><br /> Note: If you enter a negative quantity for a component, you<br /> should enter either Assembly pull or Operation pull for<br /> the supply type to ensure that you transact the material<br /> when you build the bill.<br /><br /> The Revision field displays the current revision of the component<br /> as of the revision date of the parent item.<br /><br /> 7. Open the Effectivity tabbed region and enter the effective date<br /> range for each component. <br /><br /> 8. Open the Unit Effectivity tabbed region and verify the following:<br /><br /> The Implemented check box indicates whether the component is<br /> implemented.<br /><br /> Checked: Component is on a pending Engineering Change Order<br /> (ECO)<br /><br /> Unchecked: Component is on implemented ECO or was added<br /> directly to the bill<br /><br /> 9. Open the Component Details alternative region and enter the<br /> planning percent.<br /><br /> Enter the yield.<br /><br /> Enter the Enforce Integer Requirement, or select a value from the<br /> list of values. Acceptable values are up, down and none.<br /><br /> Indicate whether the component should be included in cost rollups.<br /> If enabled, the material cost of this component, but not the<br /> routing cost, is included in the cost of the parent item.<br /><br /> 10. Optionally, open the Material Control tabbed region and enter the<br /> supply type.<br /><br /> Enter the supply subinventory and the locator.<br /><br /> If you have set the BOM: Default WIP Supply Values for Components<br /> profile option to Yes, these values default from the item master.<br /> If any of these values are left blank, Work in Process will read<br /> the values contained in the item master.<br /><br /> 11. For model, option class, and kit bills, open the Order Entry<br /> alternative region and enter the minimum and maximum sales order<br /> quantities.<br /><br /> Indicate whether to check ATP.<br /><br /> Indicate whether the component is optional and mutually<br /> exclusive.<br /><br /> Enter the basis.<br /><br /> 12. Open the Shipping tabbed region, and choose whether the component<br /> should be listed on shipping documents, required to ship, or<br /> required for revenue.<br /><br /> 13. Choose buttons to perform related tasksS.Grace Paul Reganhttp://www.blogger.com/profile/08467360023113459306noreply@blogger.com1tag:blogger.com,1999:blog-7167864928929677545.post-4570461939382364122008-05-28T07:50:00.001-07:002008-05-28T09:36:35.410-07:00Bill Of MaterialThe statement of components that you need for manufacturing a Product (Finished Good) will be defined in a structured manner with the step wise sequence of operation. What has to be manufactured first and what next, the number of components, Resource (Machine and Technical Labour ) that we require to manufacture a Product will be defined in Oracle Bill Of Material .<br /><strong>For Example:</strong><br />If you want to manufacture a pen the Bill Of Materials for Pen will be...<br />1.Cap - 1 Each<br />2.Top Cover - 1 Each<br />3.Bottom Cover - 1 Each<br />4.Nib - 1 Each<br />5.Ink - 4 Dps<br />6.Refil - 1 Each<br /><strong>Operation Sequence:</strong><br />1 - Assebble Nib<br />2 - Assemble Top & Bottom Cover<br />3 - Fix the Cap - Final Operation to manufacture pen.<br /><strong>Resource Required:</strong><br />1.Nib Fixing Machine - 2-Each<br />2.Technical Labour - 2-Each will work on 8-hours shift one person at a time<br />Oracle Bill Of Material can be used to capture all the above data as per business requirement and still has lot more functionality to help the business.<br /><br />Thanks & Regards,<br />S.Grace Paul Regan.S.Grace Paul Reganhttp://www.blogger.com/profile/08467360023113459306noreply@blogger.com4tag:blogger.com,1999:blog-7167864928929677545.post-53626362098819326252008-05-24T06:21:00.000-07:002008-06-06T06:48:38.715-07:00Creating Resource in Oracle BOMThe first proor step in Oracle BOM will be of creating resource..<br /><strong>I. Resources<br /></strong>Resources are anything—except component material—required to manufacture, cost, and schedule products. Each costed resource can have any number of associated costs, including overhead cost.<br /><strong>Resource Creation<br /></strong>In Oracle Bills of Material: Routings > Resources is the navigation to create or view a resource.<br /><strong>i. Provide the resource name in the resource field<br />ii. Inactive On field to be left null<br />iii. Provide the description about the resource in the description field<br />iv. Type :</strong><br />a. Machine<br />b. Miscellaneous<br />c. Person<br />d. Amount<br />e. Currency<br />Depending upon the type of resource select the type from the list of values.<br /><strong>v. UOM :</strong>Select the unit of measure from the list of values for the resource. If the resource to be included in calculating the lead time for the assembly, the unit of measure should be in time based like hour, min.<br />vi. Charge Type<br />a. WIP Move<br />b. PO Move<br />c. PO Receipt<br />d. Manual<br />The amount of time , resource is used should be applied , this is called applying or charging resource.<br /><strong>There are four methods of charging resource.</strong><br />a. Manual : By manual method, resource used will be entered.<br />b. WIP Move : In WIP, Once the transactions completed, resource will automatically get applied.<br />c. PO Move, PO Receipt : These two charge types are only for Outside Processing Resources.<br />a. For other type of resources, this is not applicable.<br /><strong>vii. Basis<br /></strong>Total Resource Cost will be calculated from the resource rate entered for this resource.<br />If the basis is Item, resource cost will be calculated by multiplying the item qty with resource rate and usage rate.<br />If the basis is lot, resource cost will be calculated by usage rate * resource rate, here item quantity will not be taken into consideration.<br /><strong>viii. Outside Processing</strong><br />If the resource is outside processing resource, enable the check box and the enter the outside processing item otherwise do not enable the check box.<br /><strong>ix. Costed<br /></strong>Check the costed check box.<br />Activity : This is to apply the cost according to the activity. Leave this field as null.<br />Standard Rate : To apply standard rate for the resource. Don’t check this field.<br /><strong>x. Resource Rates:</strong><br />To provide the resource cost per UOM , click Rates button in the resource form.<br />New window will open.<br />Select Cost type as Avg Rates and provide the resource unit cost .<br />save and close the window.<br />xi. Resource Overhead Association<br />To provide the overheads associated with this resource, click overhead button in the resource form. New window will open, select cost type as Avg Rates .<br />In the second block of that screen, Resource Overhead Associations, select the overhead associated with this resource.<br />Example : Admin Cost, Consumable, Ind Depr, M/C Repair, P&M Ins<br />It is not required to fill the data in Employees, Equipment and Setups menu in the resource form.<br />Thanks & Regards,<br />S.Grace Paul Regan.S.Grace Paul Reganhttp://www.blogger.com/profile/08467360023113459306noreply@blogger.com7tag:blogger.com,1999:blog-7167864928929677545.post-65793674976073586272008-05-24T04:11:00.000-07:002008-10-28T04:18:43.448-07:00Substitute ComponentsDear All,<br /><br />A simple explaination to help you understand Assigning Substitute Components to a BOM.<br /><br /><strong>Assigning Substitute Components</strong><br />---------------------------------------<br /> <br />You can assign any number of substitute items to each bill component and<br />you can assign the same substitute item to more than one component. The<br />substitute item quantity is the quantity needed to replace the full<br />component quantity. The quantity can differ from the component usage<br />quantity. Oracle Master Scheduling/MRP reports these substitutes on some<br />planning reports, such as the MRP Detail Report. Oracle Work in Process<br />does not consider substitute items in its pick lists.<br /><br />Planning bills and model, option class, and planning components cannot<br />have substitute components.<br /><br /><br /><strong>To assign substitute components</strong><br />---------------------------------------<br /> 1. Navigate to the Substitute Components window. Do this by choosing<br /> the Substitutes button from the Bills of Material window.<br /><br /> 2. Enter a substitute item for the component. If you are using Bills<br /> of Material, use a manufacturing item; if you are using Oracle<br /> Engineering, use an engineering or a manufacturing item.<br /><br /> 3. Enter the quantity of the substitute item needed to replace the<br /> full component quantity. This quantity can differ from the bill<br /> usage quantity of the component.<br /><br />Thanks & Regards,<br />S.Grace Paul ReganS.Grace Paul Reganhttp://www.blogger.com/profile/08467360023113459306noreply@blogger.com1