Direct Load option
Date: Tue, 29 Jun 1999 14:34:26 +1200
From: Mark Healey MHealey@swichtec.co.nz
Subject: MRP: Direct Load Option
Could anyone please shed some light on the impact of setting this option to
yes. I have been unable to find any decent documentation.
TIA
Mark Healey
Change Buy to Make
Date: Tue, 29 Jun 1999 10:45:24 -0500
From: "Bearden, Bill" Bill.Bearden@glenayre.com
Subject: MRP: Changing Buy to Make
We are working on a transfer of product responsibility between one plant and
another. In the past, plant A bought major subassemblies for a product from
plant B. Plant A would perform some final assembly and ship the product to
the customer. Now plant A is going to make the product from scratch. The
issue has to do with changing those major subassembly items from Buy to
Make. The Planning Make/Buy attribute is changed from Buy to Make but the
MRP in plant A still doesn't blow through to the components of some of these
items (it works on some, we don't yet know why).
Has anyone run into MRP issues when changing items from Buy to Make?
Thanks for your help.
Bill
p.s. Setup is 10.7SC Prod 16.1, multi-org, HP-UX 10.2
Date: Tue, 29 Jun 1999 10:32:55 PDT
From: Shrikant Purker shrikantpurker@hotmail.com
Subject: Re: MRP: Changing Buy to Make
For the MRP to blow thru you need to set up more attributes than just buy
to make.
Have youdefined the bom for the item? What about the attribute forecast
control. ?It should be set up to consume and derive.What about the routing?
Call me if you need more help.
Shrikant Purker
Date: Tue, 29 Jun 1999 10:43:19 -0700 (PDT)
From: Ravi Krishnamurthy ravi_krishna@rocketmail.com
Subject: Re: MRP: Changing Buy to Make
Bill,
For the MRP to blow through, you should have the items and their
components as MRP or MPS planned. Check whether these are so in the
planning attributes.
Ofcourse, this is in addition to the fact that you should have BOMs
present which can blow down till the raw material.
Hope this helps.
Ravi K.
Date: Mon, 5 Jul 1999 05:59:34 -0700
From: "Miller, Ann" Ann.Miller@glenayre.com
Subject: RE: MRP: Changing Buy to Make
The end result of why this wasn't working seemed to be our Enhanced
AutoSource Rules, they were set to buy, once we purged them, all was well.
Ann Miller
Business Systems Analyst
MDS Relief Problem
Date: Thu, 1 Jul 1999 11:26:59 -0400
From: Yerraguntla Ravindra -G1447C G1447C@ga25epd.mot.com
Subject: MDS Relief Problem
Hi ALL,
We 've got a production problem in relieving the Sales Order,
though the sale order has been closed. The scenario is like this, user
has closed the Sales order and the planning manager still grabs the closed
order as the demand wehen we go to the screen "View Item Planning
Information" in the zone Bucketless Material Plan still showing the gross
requirements for the item for the sales order that has been previously
closed.
The View order screen shows that order has been closed and one
thing for that line the inventory interface errored out, is it casusing the
problem ? Now my question is, If you want to relive the sales order what I
would like to do..?
BTW we 're in 10.7 Char.
I would like to know if any of you guys got this problem earlier in
your site. I would appreicate for your great suggestions.
TIA
Ravindra Yerraguntla
Consultant
Motorola ESG
770 338 3659(W)
Date: Thu, 1 Jul 1999 09:21:43 -0700
From: "Krishna, Shashi (shashi)" shashi@sequent.com
Subject: RE: MDS Relief Problem
Ravindra,
Material Interface error could have caused it. It could be demand still
exists for the closed sales order.
When we apply patch or upgrade script clear the outstanding demand for closed
and cancelled lines.
This script can be found in $OE_TOP/admin/sql. You can run the scripts to
close the demand for
the shipped lines. I found a script oe308164.sql which is used to clear the
MTL_DEMAND records.
Thanks
Shashi
Date: Thu, 1 Jul 1999 15:11:42 -0400
From: Yerraguntla Ravindra -G1447C G1447C@ga25epd.mot.com
Subject: RE: MDS Relief Problem
Hi Sashi,
Thanks for your response, what you said is right the records still
exist in MTL_DEMAND table for my closed order items. Unfortunately the
script is not updating my records, it is not satisfying some of the "where
conditions" such as
--
--
AND D1.COMPLETED_QUANTITY != D1.PRIMARY_UOM_QUANTITY
AND D1.PRIMARY_UOM_QUANTITY 0
--
--
since my record has completed_quantity and primary_uom_quantity are both
zero and the column reservation_quantity is only greater than zero, which
is actually giving me the problem.
THe questions are can I update the table manually by removing the above
where conditions..? Is the transaction processor will remove those records
with zero quantities..?
Thanks again..
Ravindra Yerraguntla
Consultant
Motorola ESG
770 338 3659(W)
Date: Thu, 1 Jul 1999 13:08:17 -0700
From: "Krishna, Shashi (shashi)" shashi@sequent.com
Subject: RE: MDS Relief Problem
Ravindra,
We don't use reservation in my client site. I update the completed_quantity =
primary_uom_quantity so it
will not be picked up for MDS. As long as sales order line closed you can
update this MTL_DEMAND record.
Oracle also provides scripts to delete this MTL_DEMAND data when the order is
closed. Also I will suggest
to look for any demand records without corresponding line details and check
whether any open demand exists.
Thanks
Shashi
Date: Thu, 1 Jul 1999 17:48:09 -0400
From: Yerraguntla Ravindra -G1447C G1447C@ga25epd.mot.com
Subject: RE: MDS Relief Problem
HI shashi,
I updated the reservation_quantity to zero in the MTL_DEMAND for the
Closed order and launched the planning manager to clean up, but still
demand appears in the "view item planning information" screen in the zone
bucketless material plan for that closed order.
One more thing the data in the screen is coming from MRP_QUERY
table, I 've tried to update that one but still had'nt success.
Any more thoughts...
Thanks again
Ravindra Yerraguntla
Consultant
Motorola ESG
770 338 3659(W)
Date: Thu, 1 Jul 1999 15:18:18 -0700
From: "Krishna, Shashi (shashi)" shashi@sequent.com
Subject: RE: MDS Relief Problem
Hi Ravindra,
Did you run the consumption and MDS. I think the MDS Clear the close demand
records in
MRP_GROSS_REQUIREMENTS. Sales order demand records will be in this table the
MDS
will refresh the data.
Thanks
Shashi
Date: Thu, 1 Jul 1999 19:02:20 -0400
From: "Annamaneni, Hanumantha" Hanumantha.Annamaneni@alcoa.com
Subject: RE: MDS Relief Problem
If the inventory interface failed that means two things:
1. Your inventory did not get relieved
2. Your demand did not get relieved (inventory interface takes care of
relieving demand )
If your inventory did not get relieved, you will still be able to see
the quantity as onhand. The cleanest way to get rid of your problem is
to make the inventory interface run successfully. You will have to find
out why the inventory interface failed, and fix the problem.
Hanumanth
Repititive planning
Date: Thu, 8 Jul 1999 12:28:02 -0500
From: Larry_Nelson@i-o.com
Subject: Repetitive Planning
I am a new subscriber. We are attempting to start-up repetitive planning
here. I changed a part to repetitive planning, but MRP does not seem to
plan enough parts. In other words, the projected available sometimes shows
to have negative values.
For example: These are the results of my latest MRP run.
Date Gross Req. Rate Projected Available
15-JUL-99 0 160 355
16-JUL-99 0 160 515
19-JUL-99 1750 320 -915
20-JUL-99 0 320 -595
21-JUL-99 0 320 -275
22-JUL-99 0 320 45
23-JUL-99 0 320 365
26-JUL-99 1750 320 -1065
27-JUL-99 0 320 -745
Why did MRP not plan for more parts before 15-JUL and 16-JUL to cover the
demand of 1750 due 19-JUL? Do I have a problem in my set-up, or is this
MRP's way of telling me I do not have enough capacity?
Thanks in advance.
Date: Thu, 8 Jul 1999 14:54:25 -0400
From: "Paul van den Brink" pbrink1@ibm.net
Subject: Re: Repetitive Planning
Larry,
Repetitive Manufacturing and MRP may react strange on Due Dates, since it is
taking the average demand of the periods as they are defined in the MRP
Parameters. What are your Repetitive Planning buckets ?
Paul van den Brink
Sales Order Consumption
From: oraapps-l@cpa.qc.ca [mailto:oraapps-l@cpa.qc.ca]On Behalf Of Bain
Beth-FMPA11
Sent: Tuesday, July 27, 1999 12:29 PM
Subject: MRP: Sales Order Consumption
Hello,
Two years ago an Oracle instance of 10.7 character was installed that
included OE, PO, INV, MRP, BOM, ENG, WIP. At the time, the design for
planning/forecasting was to use a forecast only loaded into an MDS and NOT
to include any sales orders. In short, the planning group did not want to
consume forecast with sales orders.
Now they have changed their minds. So a new process was designed and tested
and appears to be working fine except for one thing. The planning manager
kicks off 6 sales order consumption workers that never complete. In fact I
have had to terminate these after many hours, start them again and then
terminate them again. I tried letting them run all weekend and they ran for
65 hours before I finally terminated them again.
Is there anyone out there with experience with this that can help me out?
Beth
Beth Bain
Motorola CGISS-IT
Supply Chain Operations Group
5201 Tollview Road
Rolling Meadows, IL 60008
847-538-3651
Pager 1-800-759-8888, #1262221
Date: Tue, 27 Jul 1999 14:50:05 -0400
From: "Mark R Erzen" merzen@darc.com
Subject: RE: Sales Order Consumption
Beth,
It is possible that 6 Planner workers exceeds the maximum allowed on the
concurrent manager, which might cause the problem you're having. There is a
profile option called "MRP:Planning Manager Workers" In which you can limit
the number of workers.
Also, there are probably a large number of sales orders to consume if you're
waiting two years to use this feature. So you may need to Reactivate the
MRP Manager, Check that MRP:Comsumer Sales Order Changes is set to "Yes",
and Consume Forecast is "Yes", and you'll probably want to limit backward
consumption days on the forecast set.
You can also run forecast consumption as an idividual process from the
Forecast Set form, which I believe marks the sales order records in the same
manner as the Planning Manager.
-Mark Erzen
DARC Corp.
Date: Tue, 27 Jul 1999 14:25:22 -0500
From: Bain Beth-FMPA11 Beth.Bain@motorola.com
Subject: RE: Sales Order Consumption
Mark,
I checked the things you suggested.
MRP: Planning Manager Workers was already set at 2
Even though this is a test instance, there are a large number of sales
orders to consume so I did reactivate the planning manager (and terminated
it when things ran too long and reactivated it again and terminated it again
. . )
Compute Sales Order changes was already set to Yes
Consume Forecast was already set to Yes
Backward Consumption was limited to 0.
It appears that I had everything set to what you have suggested. Any other
ideas?
Beth
Date: Tue, 27 Jul 1999 17:26:15 -0400
From: "Mark R Erzen" merzen@darc.com
Subject: RE: Sales Order Consumption
Beth,
See if you can consume an individual forecast set by hitting the Consume set
button in the forecast window. This submits a sales order consumption
process to the concurrent manager that is not the planning manager. If this
process errors out, then there may be a problem in OE or the MTL_DEMAND
table.
For the planning manager, have the system administrator check the number of
processes that can run simultaneously on the MRP Manager concurrent manager
(all Planning Manager processes get submitted to this concurrent manager by
default.) The number of processes allowed should be more than what's set
under MRP: Planning Manager Max Workers.
Also, check the planning manager logs for any errors or messages, etc. that
might warrant a call to Oracle Support (if that call hasn't been placed
already).
I'll try to think of a few more, but I thought I'd try the obvious stuff.
Sometimes it's difficult to get a solution without actually getting my hands
dirty.
Good luck,
Mark Erzen
DARC Corp.