Oracle Engineering Routers

[ITGUY99]

OK, you all are my last hope in fixing a problem that I am having.

First off, please excuse some of the wording that I may use in this post. Just to let you know, I am not an Oracle admin. I am just a simple minded engineer that is having a problem with Oracle routers. I can tell you that we are running Oracle 11i and should be up to date with all of the patch. If there is a better place to post this please let me know.
My problem is this. I work for a pharmaceutical company that makes over-the-counter products for different companies. Basically we have over about 100 customers 200 products in about 50 different sizes. As of right now we have over 800 active Bill of materials in the system with their corresponding routers. The routers basically list the staff and machinery used with a given rate. Well, we currently had someone go over the rates and they want to change almost all of the routers. Needless to say that if we had to do an eco on each router it would take a huge amount of time. What I came up with is a set of template routers that we could set the customer routers as a “common routing” so that we would only have to change one router per product/size. It really seemed like a good idea except for one problem. I don’t see a way to change a router that is already in the system to a “common routing”. If I can’t do this, every time we get a new piece of equipment that changes the rate, I would have to go change do an eco on each router again. I really need to find a way to get the routers to correspond to a common routing. The MIS guru says there is nothing they can do. I am looking for a miracle. Any ideas?

Thanks in advance.

 

[SantaMufasa]

ITGuy,

You apologised for being "a simple-minded engineer". I must apologise for being "a simple-minded Oracle DBA/software engineer", since I don't understand the frame of reference and terminology you are labouring under. The only "router" with which I am familiar (in computing terms) is the box into which we plug multiple computers to facilitate their network connectivity.

Please pardon my density, but what do routers have to do with Bill of Materials data changes?

As of right now we have over 800 active Bill of materials in the system with their corresponding routers. The routers basically list the staff and machinery used with a given rate. Well, we currently had someone go over the rates and they want to change almost all of the routers.

I cannot even visualise what you are saying here. Could you please give us more of a description of what you mean by "router"?


We are looking forward to helping once we understand your situation/environment better.

Mufasa
(aka Dave of Sandy, Utah, USA)

http://www.dasages.com

@ 17:34 (07Feb05) UTC (aka "GMT" and "Zulu"),
@ 10:34 (07Feb05) Mountain Time

Click here to Donate to Tsunami Relief. 100% of your contributions here go to the victims...0% to administration.
They were "The First-Responder" to the disaster, with relief deliveries arriving before Red Cross and U.S. aid.

 

[ITGUY99]

OK SM, thanks for your quick response, I will try to explain some more. I have recently been but in change of all the Bill of Materials (BOM’s) and routers in the engineering module of our oracle system. The BOM lists what components are needed to do the job while the router list what resources (people, machines, etc) are needed to complete the job. We assign a rate to the router of how long it should take to complete a certain about a finished goods and the router computes a cost in the system to see if we are making money or not. The problem is that it has been a long time since anyone as looked at the rates on the routers and almost all of the numbers are wrong. So, I am looking for the best way to change the routers to what they should be. In the past, people would just go into the router, change the rate and hit save. That caused major problems whenever finance would do a cost rollup the prices would always change with no tracking of who did what. We can do an ECO (Engineering change order) on the router to track what changes we did to a router but this process is very time consuming. So what I did was create some template routers for each one of the products that we do. So whenever a new customer came along that wants that product I would setup the router as a “common routing” to the template router. This way, whenever the rate would change I would just change the template router and all corresponding common routers would change automatically. The problem that I am having is that I cannot change any router that is currently in the system to match a common template router. I can only do an ECO to change the rates. I would like to change all of the routers in the system to link to a template router. That way, I would only have to change about 100 routers and not 800 routers. Any better?

Thanks in advance!