BOM import
Date: Fri, 11 Jun 1999 18:17:03 -0700
From: deepa sood dsood@us.oracle.com
Subject: Re:BOM Import....URGENT
Hi All,
I am running the BOM import to create Bill of material and
components.
When I run the import process everything in the
BOM_BILL_OF_MTLS_INTERFACE table gets processed but
in the BOM _INVENTORY_COMPS_INTERFACE table ,the process_falg is getting
set to 2 for all rows.
I really need help on this one.
If anyone has any idea about this please let me know.
Thanks,Deepa
x-------------x
From: deepa sood dsood@us.oracle.com
Date: Thu, 17 Jun 1999 11:54:23 -0500
From: "Louise Kewish" kewishls@mindspring.com
Subject: Re: re:BOM IMPORT
Are you populating the supply type and the supply subinventory when you do
this? It may be validating to ensure that the supply type is 'inventory'
before it will populate this other field. Also make sure that you either
put in the supply_subinventory code or name and it is exactly as it is in
the application.
Louise Kewish
Senior Principal - Manufacturing/Distribution Apps
TSC
Dallas, TX
Date: Fri, 25 Jun 1999 10:06:46 -0400
From: "Dave MacQueen" dmacqueen@msn.com
Subject: RE: BOM Import
Deepa, are you specifying when you import that you only bring in information
for the Org that you are working in? Subinventories and Locators are Org
specific and may need to be brought in Org by Org. I had a similar problem
and this solution worked.
Dave
617-988-5882
How to place orders without BOM module">
Date: Wed, 16 Jun 1999 17:55:22 -0400
From: Pravin_Kumar@FirstEnergyCorp.com
Subject: PUR How to without BOM module
All,
We have a requirement as follows:
When Item-A (ex: Oil) is requisitioned, also requisition Item-B (ex:
Drums).
Unfortunately we have not implemented BOM module.
Can this be automated such that when Item-A is procured, Item-B is also
procured, without any customization ?
I vaguely remember a similar situation addressed in this forum months ago.
Thanks.
Pravin Kumar
Date: Thu, 17 Jun 1999 07:38:14 -0700 (PDT)
From: Ravi Krishnamurthy ravi_krishna@rocketmail.com
Subject: Re: PUR How to without BOM module
Pravin,
You may use an Oracle Alert, which can notify you by email if item B
is not procured at the same time as item A.
HTH.
Ravi K.
BOM integer quantity
Date: Wed, 16 Jun 1999 10:05:51 +300500
From: Hirak_kayal@india.notes.pwa.co.in
Subject: Re: BOM integer quantity
Hi mfg gurus,
While creating a BOM for a particular type of cable, there is a
requirement that for every kilometer of cable one wooden spool is required.
But in case of short length production, the number of spool cannot be
decimal rather it should be rounded off to the next integer. How to ensure
that the spool requirement figure is an integer value? Sometime back I
could remember someone had the same problem with number of labels and all I
could gather is that we need to apply database trigger. In that case does
anybody has written that code?
Can I specify a tolerance such that from 700meter to 1200 meter number
wooden spool required will be one?
Thanks for your help in advance.
Hirak Kayal
Routing - machine setup time and operation time
Date: Sat, 26 Jun 1999 21:55:17 -0700 (PDT)
From: Krishnakumar Narasihman chnkrishna@yahoo.com
Subject: Re: Routing / BOM Manufacturing Application
Hi!
How is the machine setup time and the operation time in the routing
/ resources set and used?
Thanks,
Kartik
kartikiyer@hotmail.com
Krishnakumar
Gokulam
35/12 East Park Road
Shenoy Nagar, Chennai 600 030
INDIA
Ph: (91)(44)6446131
http://members.tripod.com/~sramji/kk
Indented Bill of material cost Report
Date: Tue, 29 Jun 1999 17:19:35 -0400
From: Yerraguntla Ravindra -G1447C G1447C@ga25epd.mot.com
Subject: Indented Bill of material cost Report
Hi ALL,
We 've got a problem while running the report Indented Bill of
material cost report, when we try to run this report it 's giving message
'No data found ' for certain items. We also checked the items attributes
and the items are "Make" and rollup is "yes". But other make items with
roll up is "yes" are not giving any problem. Any of you had similar problmes
in your sites..? Any info. related to this is greatly appreciated.
BTW we 're on 10.7 Char.
TIA
Ravindra Yerraguntla
Consultant
Motorola ESG
770 338 3659(W)
From: "Lavy, Shay" Shay_lavy@icomverse.com
Subject: RE: Indented Bill of material cost Report
Date: Tue, 29 Jun 1999 23:12:47 -0400 (EDT)
Hi Ravindra,
If anyone has an answer to your problem, I would also like to know,
since I have the same exact problem, only I'm working on Release 11.01.
We are now in the process of testing Release 11.03. It isn't a steady
environment yet, but this report doesn't seems to be working there as well.
Regards,
Shay Lavy
ITA Department
Comverse Network Systems
Phone no. : 972-(0)3-765-5794
Cell Phone: 972-(0)51-325794
E-mail : shay_lavy@icomverse.com
Date: Wed, 30 Jun 1999 23:11:11 PDT
From: shawish sababa shawish_sababa@hotmail.com
Subject: RE: Indented Bill of material cost Report
Hi Shay
Are you working in standart cost? if so, does all your item's have costs
"Frozen" cost type?
Shawish
Date: Thu, 1 Jul 1999 13:51:34 +0300
From: "Lavy, Shay" Shay_lavy@icomverse.com
Subject: RE: Indented Bill of material cost Report
Hi Shawish,
This is my set-up exactly :
Standard Costing, each item has a Frozen Cost.
Date: Thu, 1 Jul 1999 11:45:54 -0700 (PDT)
From: Ravi Krishnamurthy ravi_krishna@rocketmail.com
Subject: RE: Indented Bill of material cost Report
Shay,
Have you run the pre-coded alert for zero cost items? Do these throw
up any items which do not have a cost defined against them? Also, is
the cost rollup complete for all the items?
Ravi K.
Loading attatchments
Date: Wed, 30 Jun 1999 12:34:01 -0700
From: Steve Silveri ssilver@dpc.com
Subject: Loading attachments
Does anyone have some sample code for loading attachments to items
or BOM. We need to load some at conversion time for R11.
Thanks
Auto create process and item supply/demand
Date: Tue, 6 Jul 1999 14:13:11 +0200
From: Andrew Robertson AndrewR@langeberg.co.za
Subject: Urgent - Auto create process and item supply/demand
Hi All
We are running Oracle 10.7 NCA with INV, WIP OE amongst other modules.
Our problem is as follows:
A sales order is placed against export items and a requisition is created
to get the stock from the manufacturing organisation into the shipping
organisation. From the original sales order/internal requisition discrete
jobs are autocreated in the manufacturing organisation. This autocreated
job is meant to look at the current items supply and demand (ie: stock on
hand that is not reserved against any other sales orders) and then only
autocreate a job for the balance of stock required. However this is not
taking place.
At the moment the autocreate process is ignoring stock availability and
creating jobs for the entire quantity ordered on the sales
order/requisition.The entire quantity on the job is reserved against that
particular sales order and cannot be used against other shipments
When there is enough demand to fulfill the sales order then the autocreate
process does not create a discrete job.
Has anyone come across this problem before of partially fulfilled demand
against a sales order? If so how did you go about fixing it. As I
understand it this should be Oracle functionality - possibly we have
missed out a profile option or something. Any help would be appreciated!
Thanks
Andrew
andrewr@langeberg.co.za
Configuring BOM with 2 components
Date: Thu, 8 Jul 1999 11:33:26 -0400
From: "Lowe, Matthew" Matthew_Lowe@compuware.com
Subject: Configurable BOM
Question for BOM gurus:
Is possible to create a configurable BOM with 2 components, Component 1 must
be a constant quantity (say qty. of 1), and Component 2 must changing to
reflect the quantity selected at the previous BOM level? The end result
would be that component 1 would always be 1 and component 2 may have a
quantity of 5, 10, 15, etc. depending on the line quantity chosen.
Thanks,
Matt Lowe
Common BOMs & ECOs
Date: Sat, 10 Jul 1999 07:47:15 -0400
From: Paul Mallon pmallon@oasys-grp.com
Subject: Common BOMs & ECOs
Is anyone using Common BOMs across orgs? Are you able to see ECO
information from the referencing org?
Can you copy ECO's between orgs for non-common bills?
Paul M.
Part change - globally
Date: Fri, 16 Jul 1999 15:08:27 -0400
From: "Schmidt, Bob" bschmidt@AAFINTL.com
Subject: BOM: Mass part change question
We have the need to replace all occurrences of part number A in all
bills with part number. The UOM and QTY remain unchanged. There
appears no way to do this without entering this change transaction for
each quantity involved. This seems like a simple change that Oracle
ought to handle. Have I missed something in the documentation?
Thanks
Bob Schmidt
bschmidt@aafintl.com
EDS
502.637.0446
502.637.0520 (F)
Date: Sun, 18 Jul 1999 15:36:55 -0400
From: "Mark R Erzen" merzen@darc.com
Subject: RE: Mass part change question
Bob,
I was under the impression that if you selected Update in the changes area
of the screen, and left the UOM and QTY blank, that you could replace one
component with another on all bills regardless of the quantity. Are you
receiving an error of some sort in the process submission that says you
can't?
-Mark Erzen
DARC Corporation
ATP against BOM
Date: Thu, 22 Jul 1999 13:33:34 -0400
From: "Teresa K. Purdy" TPurdy@datavision.com
Subject: ATP against a BOM
We are on 11.0.2 NT and are unable to run ATP against a bill of material.
The components show in stock but the ATP will not show an in stock quantity
for the parent.
At this point, Support has dialed into our system and has duplicated the
problem on their own system when they tried to process an order for a BOM.
We are nervous that we are the beta site.
Has anyone else successfully run ATP against a BOM?
Thank you!!
Date: Thu, 22 Jul 1999 15:07:37 -0400
From: "Mark R Erzen" merzen@darc.com
Subject: RE: ATP against a BOM
Teresa,
Obvious things to check for in ATP is that an ATP rule is assigned to the
parent item(at shipping organization level) or it's organization as a
default. Check ATP should be checked for each component that you want to
see the on hand quantity, and ATP components should be checked for the
parent item.
In looking at the documentation, however, I'm not quite sure that what you
are trying is within Oracle's functionality. They really designed the ATP
components feature for Assemble to Order and Pick to Order models and option
classes, and the availability of the individual options, not necessarily to
check ATP on a standard component (MRP helps you find those shortages).
I have been successful in running ATP against a BOM, but those have either
been PTO or ATO bills, which it doesn't sound like you're doing here.
You may just need to adjust the bill or set it up differently to get the
results you need, depending on how you use the bills in the system.
-Mark Erzen
DARC Corporation
Date: Thu, 22 Jul 1999 12:04:53 -0700 (PDT)
From: Ravi Krishnamurthy ravi_krishna@rocketmail.com
Subject: Re: ATP against a BOM
Teresa,
Try these -
1. In the Order Entry region in Item definition, see if ATP components
is checked.
2. If you sre using MPS planning, in the General Planning region, see
if Calculate ATP is checked.
3. See if Check ATO is enabled for the components in the parent item BOM
4. See if the subinventory is nettable
5. Check the ATP rule - whether Accumulate Available is checked
HTH.
Ravi Krishnamurthy
Senior Consultant Oracle Solutions
AnswerThink Consulting Group
Rounding error
Date: Fri, 23 Jul 1999 10:35:38 +0300
From: "Arvind" oraarv@yahoo.com
Subject: Rounding error
Hi Folks
We are working on oracle R11. I am having problems with the rounding
errors in BOM. I have a decimal place of 5.20
eg one of the components have .000002 Kgs that go into the bill, when i
see it in the materials requirements in the WIP. It says 0 quantity. Is
there any method of escaping this .
I cannot increase the decimal places as i am already having a problem
with the reports as the maximum digits in the reports = 99999.99999.
Can i increase this to any number of digits to be displayed in the
reports.
Can anybody give me a solution to solve both the problems
Thanks in advance
Arvind Chinya
Satyam Enterprise Solutions
Date: Fri, 23 Jul 1999 10:39:47 -0700
From: Satish Reddy SReddy@zilog.com
Subject: RE: Rounding error
I guess there is no limit in display format.But in the calculations if you
are using decimals you need
to round to the decimals u want to display.I faced a Pl/sql bug on
rounding.Use round() to the decimals
intended.
Thanks
Routing - setup
Date: Sat, 24 Jul 1999 00:47:42 -0400 (EDT)
From: kartik iyer mukul061292@yahoo.com
Subject: Manufacturing BOM ,Routing
Hi!
Friends!
Can anybody tell how to enter the details of the machine set up time
, run time and tear down time and where?
Thanks
regards
Kartik
Date: Mon, 26 Jul 1999 09:57:38 +300500
From: Hirak_kayal@india.notes.pwa.co.in
Subject: Re: Manufacturing BOM ,Routing
Hi Kartik,
You will have to tell, whether the setup time is related to each job or for
a series of jobs of same assembly. Is it a discrete manufacturing
environment first of all? If so -
You can define setup and tear down as operations in routings making the
count point and autocharge off. This operations will not get defaulted
during move transactions and when you are actually using up the setup and
tear down resources you can go through this operations for necessary
charging. If you make it Schedule yes it will be calculated during capacity
scheduling for all jobs of the same routing. You can set this to No and
enable manual resource charging where you can book the time.
Run time will be obtained from resource usage rate defined in the routing.
There may be other solutions, but I hope this one may help.
Hirak
Match and Reserve
Date: Tue, 10 Aug 1999 11:48:03 -07:0
From: "Craig Christensen" craig-c@campbellsci.com
Subject: BOM; MATCH AND RESERVE FOR 11
Hello,
We would like to implement the "match and reserve" feature so we
can re-use part numbers for configured items. Does anyone have
the SQL code for Apps 11 that they would be willing to share with
us? It would be appreciated.
Thanks,
Craig Christensen
Campbell Scientific Inc.
craig-c@campbellsci.com
Date: Tue, 10 Aug 1999 14:05:17 -0700
From: "Mark Erzen" merzen@darc.com
Subject: RE: BOM; MATCH AND RESERVE FOR 11
Craig,
are you using a version earlier than release 11? If so, Oracle Support
provided a "Match & Reserve" Patch for release 10.7 for one of my previous
clients that was trying the same thing.
-Mark Erzen
DARC Corporation