Default Status for discrete jobs
Date: Mon, 15 Jun 1998 10:20:34 -0400
From: "Dave MacQueen" dmacqueen@msn.com
Subject: default Status for discrete jobs in wip
Hi all, is there a way to have the status of Discrete Jobs be "Released".
Version is 10.7
Thanks
Dave MacQueen
Date: Tue, 15 Jun 1999 09:42:22 -0500
From: "David Keeney" keeneyd@wilsonart.com
Subject: Re: default Status for discrete jobs in wip
Hi Dave,
In 10.7 Character, if you build your WIP Jobs in the Planner's Workbench,
you can specify "Released-charges allowed" in the Default Job Status
field.
If you are creating them in the 'Define Discrete Job' form, you can
quickpick "Released-charges allowed" in the Status field when you create
the Job.
If it is your intent to always create WIP Jobs with this Status, you can
also make a copy of the form and modify the field to have "Released-charges
allowed" as the default.
//David Keeney
Inventory Manager
Wilsonart International
Date: Thu, 17 Jun 1999 10:58:07 -0500
From: "Louise Kewish" kewishls@mindspring.com
Subject: Re: default Status for discrete jobs in wip
Yes, under the WIP parameters in the setup, you choose which Status you
want as the default. also if you are realeasing work orders from MRP, it
uses this default or if you want to change it then set something different
in the preferences/Implement As screen
Hope this helps
Louise Kewish
Senior Principal - Manufacturing and Distribution Apps
TSC
Dallas, TX
Date: Thu, 17 Jun 1999 11:42:08 -0500
From: "David Keeney" keeneyd@wilsonart.com
Subject: Re: default Status for discrete jobs in wip
Hi Louise,
I am on 10.7 char and don't see this parameter in the setup. Are you
running GUI?
//David
Creating new items in a Metal processor / distributor industry
Date: Wed, 28 Jul 1999 11:09:28 -0400
From: "McElhinny, Steve A." Steve.McElhinny@alcoa.com
Subject: WIP: Remnants and New Items
All -
Any metal processors/distributors out there?
We'd be very interested in talking to you re: how you are handling remnants
created during a shearing or sawing operation. Are you creating new items
on the fly for each size that you want to save?
Thanks!
Steve McElhinny
Steve.McElhinny@alcoa.com
Date: Fri, 30 Jul 1999 09:53:21 +300500
From: Hirak_kayal@india.notes.pwa.co.in
Subject: Re: WIP: Remnants and New Items
Hi Steve,
I do not know about the product type you are talking of nor i am a
distributor / processor. I can suggest that you create a subinventory for
such remnants and after move transaction, perform Material transaction as
WIP component return to those subinventories. Will this help?
Hirak Kayal
Date: Sat, 31 Jul 1999 11:49:01 -0700 (PDT)
From: Ravi Krishnamurthy ravi_krishna@rocketmail.com
Subject: Re: WIP: Remnants and New Items
Steve,
Unless tracking each size of remnant is necessary, you create one or
more (but a mangeable number) of items to deal with remnants. Allow
description update for these items. You may record the item size in
the description.
HTH.
Ravi K.
Convert job requirements
Date: Mon, 2 Aug 1999 13:20:20 -0700 (PDT)
From: Ramesh Gupta ramgup@yahoo.com
Subject: WIP question....
Hey Folks,
I am trying to convert legacy work orders into Oracle
Apps(10.7SC). We are converting them as Std. Discrete
planned Orders.
v
My question is,
To convert job info, that is to create std. discrete jobs we have
wip_job_schedule_interface but
what abt material requirements...it seems there is no
wip interface table to convert job requirements info.
Do we need to do direct table load or any other interface programs and
how they affect inv and gl in onhand qts. and accounting info.
I greatly appreciate for sharing the knowledge.
Thanks in advance
Ramesh Gupta
Date: Mon, 2 Aug 1999 22:38:03 -0400
From: "Paul van den Brink" pbrink1@ibm.net
Subject: Re: WIP question....
How about the Open Transaction Interface ? You may also look into Move
Transactions Interface.
Date: Tue, 3 Aug 1999 10:34:42 +300500
From: Hirak_kayal@india.notes.pwa.co.in
Subject: Re: WIP question....
Hi Ramesh,
I think material requirements for a job is taken from the BOM of the
assembly being mfgd. Does the BOM exist?
Move_transaction interface etc will be required to upload the completion or
production status of the job.
Have I understood your question?
Hirak
Date: Tue, 03 Aug 1999 06:57:58 -0500
From: JFlemmin@micro.honeywell.com (Flemming, Joel)
Subject: Re: WIP question....
Ramesh
When you load your orders in thru the wip_job_schedule_interface at
conversion time, this process will take a snapshot of your BOM and Routing
for that assembly and place it under the new discrete job number.
This will create your material and resource requirements.
If the jobs have already started and you need to catch them up, Paul is
exactly right.
Either move the jobs manually through the online screens or use the move
transaction interface table to catch them up.
We chose to load the jobs and then have our factories catch the jobs up by
doing the move through the screens. This gave them some added training
before going live that Monday morning.
Don't forget if you have push material, you will need to issue this material
to the job manually or use the mtl interface table.
Hope this helps,
Joel Flemming
Honeywell Sensing and Control
Backflush
Date: Tue, 3 Aug 1999 17:06:00 -0400
From: "Schmidt, Bob" bschmidt@AAFINTL.com
Subject: WIP: Backflush question
Help - we are in the early planning stages of implementing the WIP
module. We do not want to use repetitive schedules or discrete
workorders. We want to report production of units as some yet to be
defined inventory transaction and have the components relieved as a
backflush type operation. Are there setups required that will allow us
to do this? Is anything special about the setup of the parts (assembly
and component level) that is required? Is there special configuration
of the transactions to do this? Any insights would be appreciated even
if to tell me where to look for this stuff.
Thanks
Bob Schmidt
bschmidt@aafintl.com
EDS
502.637.0446
502.637.0520 (F)
Date: Tue, 3 Aug 1999 17:50:01 -0700
From: skirby@bco.com
Subject: RE: Backflush question
It sounds like you want to Work-Orderless completions. You will also need to
implement BOM.
Note: WO-less completions are only available in Rel 11 from what I
understand. If you are in Rel 10.7 you will have to set up a discrete work
order and move the transaction to consume the parts.
Steve Kirby
skirby@bco.com
Date: Tue, 3 Aug 1999 21:26:04 -0700
From: "Mark Erzen" merzen@darc.com
Subject: RE: Backflush question
Bob,
The WIP completion transaction allows you to relieve component inventory and
increase assembly inventory at the same time. Unfortunately this requires
that you complete against an existing job or schedule. Components on the
bill of material if you want to backflush at completion should have a WIP
supply type of assembly pull. This can be either set on the item, or the
bill of material.
The process in 10.7 goes like this:
1) create the discrete job
2) Perform a WIP move transaction to move the assembly to the run of the
last operation (if there is a routing)
3) Perform a WIP completion transaction to complete the assembly and
backflush the components.
In release 11 it can be a little easier.
1) Perform a Work Order-less completion transaction.
You'll need to set up WIP steps 1&2 to do this.
Otherwise, I'm not sure of any other transactions that will backflush
inventory and increase assembly inventory outside of Work in Process.
Good luck with your project.
Mark Erzen
DARC Corporation
Overhead Cost
Date: Thu, 5 Aug 1999 11:17:13 +300500
From: Hirak_kayal@india.notes.pwa.co.in
Subject: Re:Overhead cost
Hi,
Is there any method to charge actual overhead costs to WIP jobs? While
performing move transactions overhead charges take place at the standard
rate defined in departments that contain the resource. At the end of the
year we come to know about the total actual overhead cost incurred. Can the
difference between actual and standard be divided among jobs which were
executed during that year?
Regards.
Hirak
Date: Thu, 05 Aug 1999 00:42:05 PDT
From: "shawish sababa" shawish_sababa@hotmail.com
Subject: Re:Overhead cost
Hi Hirak
The only way I know of is at period end you update the Overhead useing Cost
Mass Edit Mass edit cost information window
Shawish
Date: Thu, 5 Aug 1999 14:07:21 +300500
From: Hirak_kayal@india.notes.pwa.co.in
Subject: Re:Overhead cost
Hi Shawish,
Will that update the costs of jobs already complete?
Thanks and regards.
Hirak
Date: Thu, 05 Aug 1999 05:22:11 PDT
From: "shawish sababa" shawish_sababa@hotmail.com
Subject: Re:Overhead cost
Hi Hirak
No, it well only update the cost of the item. I have faced thesame problem
and had to do with period end update of the items. what you can do is to ask
your client if he is willing to charge this cost as resource, create it as a
charge type "Manual" and for every job enter the amount you want.
If you find any other way, please let me know
Shawish
Date: Fri, 6 Aug 1999 09:53:01 +300500
From: Hirak_kayal@india.notes.pwa.co.in
Subject: Re:Overhead cost
Thanks Shawish. Manual charging is not possible since number of job is
quite high and the process is quite complex. I will let you know if some
work around is found out.
Hirak
How many items can be built
From: "Solomon, Jim" Jim.Solomon@axiohm.com
Subject: WIP question
Date: Mon, 9 Aug 1999 09:50:01 -0400 (EDT)
Is there anything in WIP where you could enter an item (ATO) to see how
many
could be built? Kind of like a "what if".
Any ideas?
Date: Mon, 09 Aug 1999 23:10:15 PDT
From: "shawish sababa" shawish_sababa@hotmail.com
Subject: Re: WIP question
Hi Jim
I haven't tried any thing like that, but you can try the "Simulate Discrete
jobs"? you can not tell how many items could be built, but try it.
Shawish
Date: Tue, 10 Aug 1999 07:10:15 -0500
From: JFlemmin@micro.honeywell.com (Flemming, Joel)
Subject: RE: WIP question
Jim, try the simulate discrete jobs screen in WIP or the ATP functionality
in Inventory.
If you use simulate, enter your information and hit the components button to
see if you have enough components.
Hope this helps,
Joel
Supply Quantity on Discrete Job Shortage report
Date: Tue, 10 Aug 1999 11:27:19 -0700
From: Larry Scheurich larrys@dpapplications.com
Subject: Supply Quantity on the WIP Discrete Job Shortage report
Folks,
I have been looking over the Discrete Job Shortage report in WIP, and am
looking at a column called Supply Quantity. When I look at the report
definition, I can't find out how this is calculated. Does anyone know how
this is done? Thanks! Larry Scheurich
Reopen accidentally closed Discrete jobs
Date: Mon, 24 May 1999 10:36:56 +0800
From: "Gracia Becongco" Gracia.Becongco@tip.toshiba.co.jp
Subject: Closed Discrete Jobs
We have accidentally closed a discrete job. Is there a way we can "unclose"
the said discrete job? The said job has a erroneous transaction date and it
could really mess up our inventory. Any suggestions???
:-) grace
Date: Mon, 24 May 1999 05:32:52 -0700
From: CFowler@littonapd.com
Subject: RE: Closed Discrete Jobs
Hi,
Yes, there is a way to "unclosed" a discrete job. In 10.7 16.1SC the menu
path is:
Work In Process:Discrete:Close Discrete Jobs:Close Discrete Jobs
(Form)
- or -
Cost:Discrete:Close Discrete Jobs:Close Discrete Jobs (Form)
Query up the job in question, click on the Special drop down menu and select
"Unclose 1".
One important note: once a job is closed you cannot collect any more costs
on it even if you re-open it:
i.e. Any transactions done against that job after it has been closed
and re-opened you will not be able to collect those costs for that job.
I hope this helps.
Candace
Date: Mon, 24 May 1999 09:12:20 MDT
From: "Vijay Kumar Ch" horo_horo@hotmail.com
Subject: Re: Closed Discrete Jobs
hi grace,
this was the response i got from Oracle when i had logged a TAR on this 6
monts back. this was for 10.6 :
Unfortunately there is not Oracle built in function to reopen accidentally
closed discrete jobs. However we have some guidelines where we could help
customer to do this via SQL. Here's a method we adopted to reopen all the
accentedly closed orders by date. You may have to modify the script to suit
the requirements. This is not a supported standard functionality by Oracle
WWS. So care should be taken as we will not take any responsibility in the
event something goes wrong.
This is only a guidelines. First test this in the customer's Test System
before applying it in their PRODUCTION environment.
____________________________________________________________
Limitations:
---------
1. Customer should NOT have performed CostUpdate after the job closure.
2. Customer should NOT have closed Inventory Accounting period after this.
____________________________________________________________
Data needed from customer: ACCIDENTAL CLOSE DATE . Ex: '03-SEP-98'
Actions to TAKE:
1. Take Backup of the tables getting affected.
2. Run the pl/sql script 'wip_djuncls_1.sql' First.
3. Run the pl/sql script 'wip_djuncls_2.sql' next.
-------------------------------------------------------------
PL/SQL: wip_djuncls_1.sql
-------- Cut from here for Action2 as above - Start -------------------
set serveroutput on size 1000000;
spool wip_djuncls_1.lis;
DECLARE
close_date date := &accidental_date_closed;
cursor wpb_cls_csr is
select wpb.organization_id, wpb.wip_entity_id,
wpb.acct_period_id, ent.wip_entity_name
from wip_period_balances wpb,
wip_discrete_jobs wdj,
wip_entities ent
where wpb.wip_entity_id = wdj.wip_entity_id
and wpb.organization_id = wdj.organization_id
and wdj.status_type = 12 /** Closed **/
and wdj.date_closed = to_date(close_date)
and ent.wip_entity_id = wdj.wip_entity_id
and ent.organization_id = wdj.organization_id;
wpb_count number;
wpb_rec wpb_cls_csr%ROWTYPE;
BEGIN
/*** LET US NOW FIX THE WIP_PERIOD_BALANCES Table *****/
open wpb_cls_csr;
wpb_count := 0;
Loop
Fetch wpb_cls_csr into wpb_rec;
Exit when wpb_cls_csr%NOTFOUND;
wpb_count := wpb_count + 1;
update wip_period_balances wpb
set
wpb.pl_material_var = 0, wpb.pl_outside_processing_var = 0,
wpb.pl_overhead_var = 0, wpb.pl_resource_var = 0,
wpb.tl_material_var = 0, wpb.tl_outside_processing_var = 0,
wpb.tl_overhead_var = 0, wpb.tl_resource_var = 0,
wpb.tl_material_overhead_out = 0, wpb.tl_material_overhead_var = 0,
wpb.pl_material_overhead_var = 0
where wpb.wip_entity_id = wpb_rec.wip_entity_id
and wpb.acct_period_id = wpb_rec.acct_period_id -- period id in
which job is closed
and wpb.organization_id = wpb_rec.organization_id;
dbms_output.put_line(to_char(wpb_count) ||
') WIP Variances fixed Org/JobName/period -- ' ||
to_char(wpb_rec.organization_id) || '-' ||
substr(wpb_rec.wip_entity_name,1,20) || '-' ||
to_char(wpb_rec.acct_period_id));
End Loop;
close wpb_cls_csr;
END;
/
set serveroutput off;
spool off;
-------- Cut upto here for Action2 as above - End -------------------
PL/SQL: wip_djuncls_2.sql
-------- Cut from here for Action3 as above - Start -------------------
set serveroutput on size 1000000;
spool wip_djuncls_2.lis;
DECLARE
close_date date := &accidental_date_closed;
cursor wdj_cls_csr is
select wdj.organization_id, wdj.wip_entity_id,
wdj.date_released, wdj.date_completed, wdj.date_closed,
wdj.class_code, wdj.status_type,
wdj.start_quantity, wdj.quantity_completed, wdj.quantity_scrapped,
ent.wip_entity_name
from wip_discrete_jobs wdj, wip_entities ent
where wdj.date_closed = to_date(close_date)
and wdj.status_type = 12 /** CLOSE Status ONLY **/
and ent.wip_entity_id = wdj.wip_entity_id
and ent.organization_id = wdj.organization_id;
wdj_count number;
wdj_rec wdj_cls_csr%ROWTYPE;
BEGIN
/*** LET US NOW FIX THE
WIP_DISCRETE_JOBS,
WIP_TRANSACTIONS,
WIP_TRANSACTION_ACCOUNTS Table *****/
open wdj_cls_csr;
wdj_count := 0;
Loop
Fetch wdj_cls_csr into wdj_rec;
Exit when wdj_cls_csr%NOTFOUND;
wdj_count := wdj_count + 1;
IF /** IF date completed is not null and Date_released is not null ***/
(wdj_rec.date_completed is NOT NULL and
wdj_rec.date_released is NOT NULL) Then
update wip_discrete_jobs wdj
set wdj.status_type = 4 , /** completed-charges allowed **/
wdj.date_closed = null
where wdj.organization_id = wdj_rec.organization_id
and wdj.wip_entity_id = wdj_rec.wip_entity_id
and wdj.date_closed = to_date(close_date)
and wdj.status_type = 12/**CLOSED STATUS ONLY **/;
ELSIF /** Date Completed is NULL but Date Released is NOT NULL
***/
(wdj_rec.date_released is NOT NULL and
wdj_rec.date_completed is NULL ) then
update wip_discrete_jobs wdj
set wdj.status_type = 3 ,/** Released **/
wdj.date_closed = null
where wdj.organization_id = wdj_rec.organization_id
and wdj.wip_entity_id = wdj_rec.wip_entity_id
and wdj.date_closed = to_date(close_date)
and wdj.status_type = 12/**CLOSED STATUS ONLY **/;
ELSE
update wip_discrete_jobs wdj
set wdj.status_type = 1, /** UnReleased **/
wdj.date_closed = null
where wdj.organization_id = wdj_rec.organization_id
and wdj.wip_entity_id = wdj_rec.wip_entity_id
and wdj.date_closed = to_date(close_date)
and wdj.status_type = 12 /**CLOSED STATUS ONLY **/;
END IF;
delete from wip_transaction_accounts wta
where wta.transaction_id in
(select distinct wt.transaction_id
from wip_transactions wt
where wt.organization_id = wdj_rec.organization_id
and wt.wip_entity_id = wdj_rec.wip_entity_id
and wt.transaction_type = 6 /** JobCloseVariance **/ );
delete from wip_transactions wt
where wt.organization_id = wdj_rec.organization_id
and wt.wip_entity_id = wdj_rec.wip_entity_id
and wt.transaction_type = 6;
dbms_output.put_line(to_char(wdj_count) ||
' -- WDJ, WTXN, WTA records fixed - Org/JobName/status - ' ||
to_char(wdj_rec.organization_id) || '--' ||
substr(wdj_rec.wip_entity_name,1,20) || '--' ||
to_char(wdj_rec.status_type));
End Loop;
close wdj_cls_csr;
END;
/
set serveroutput off;
spool off;
-------- Cut upto here for Action3 as above - End -------------------
Discrete jobs - start time default
Date: Thu, 2 Sep 1999 15:58:02 -0500
From: "Carver, Elizabeth" ecarver@MarkAndy.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: WIP Discrete Jobs
Hello
I was wondering if this happens to anyone else. Our environment is Character
10.7 RDBMS 7.3.3.5
When we create a WIP Discrete Job the start time defaults to 00:00.
Does anyone else have this condition? and if you do
Does it impact lead times, shop scheduling and/or Dispatch Report?
Thanks
Beth Carver
Date: Fri, 3 Sep 1999 08:01:59 -0500
From: "Carver, Elizabeth" ecarver@MarkAndy.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: WIP Discrete Jobs
Hello Again
I have another WIP Discrete Job question
In 10.7 NCA, the form Define Discrete Jobs, requires that you enter the
start time (hh:mi:ss) for the job. Is there a profile option or setup option
that will default this to the first shift start time, current time or other
value?
Thanks
Beth Carver
Date: Fri, 3 Sep 1999 13:16:04 -0400
From: "McElhinny, Steve A." Steve.McElhinny@alcoa.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: WIP Discrete Jobs
We also searched for a profile option that could turn the times off, both in
OE (Request Date) and WIP.
Steve McElhinny
Steve.McElhinny@alcoa.com
Date: Fri, 03 Sep 1999 14:52:13 EDT
From: "Raj P" raj_orapps@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: RE: WIP Discrete Jobs
hi
WIP:Default Start Date --- set this to 'yes'
once u set this option, system date will default when u define new discrete
job.
Rajagopalan, Panchat
Functional Consultant - Manufacturing
Kay Software Inc.,
Date: Fri, 3 Sep 1999 19:28:44 -0700
From: "TomHery" TomHery@home.com
To: oraapps-l@cpa.qc.ca
Subject: RE: WIP Discrete Jobs
The scheduling program will schedule the first resource for the first
operation to run on the shift assigned. For example, if the first resource
is a kit operation and takes 3 hours per lot, and is in a department with
shifts that begin at 6:30am, the first step will be scheduled to run from
6am to 9am, regardless of whether the WO start time is 00:00.
If the first resource is in a department that is scheduled with 24hr = Y,
then the scheduling program will start the three hours at midnight, and the
following resource (assuming it is shift driven) will begin at 6:30am
Hope this helps.
WIP - Operation Pull Method
Date: Wed, 8 Sep 1999 08:18:42 +0200
From: "Cohen, Dan" Dan_Cohen@icomverse.com
To: "'Oracle Applications Forum'" OraApps-L@cpa.qc.ca
Subject: WIP: Operation Pull Method
Any information about a company that manufactures in an Operation Pull
method, and its impact on discrepancy in stock level (due to the delay in
the flashback) will be very appreciated.
Regards,
Danny Cohen
972-3-6452016
dan_cohen@icomverse.com mailto:dan_cohen@icomverse.com
Quality
Date: Tue, 14 Sep 1999 15:06:55 +0200
From: "Olah, Karoly" Karoly.Olah@alcoa.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: QUALITY
Hi everybody,
I started to test the quality modul functionality for my company.
Unfortunately I can't select any Quality Collection Transaction
for Collection Plans exprect:Move transaction (Oracle Work in Process).
Is it normal?(I dont think so)
How can I select the: WIP completion teansaction or Material
Transaction, etc.?
Please help me !
Thanks,
Karoly Olah
Prod.Sys.&MIS Mgr.
ALCOA-KOFEM
INGOT MU.
HUNGARY