Want the Planner to be in charge of Released, Firm Jobs.
Solution ID = KB-73
Goal : Want Infinite Backward Scheduling to now be in charge of Released Jobs.
Version = Syteline7.01
Module : SLMFG
Fact 1 : Recently changed from forward finite scheduling to infinte backward scheduling.
Fact 2 : Someone recently ran the Scheduling activity inadvertently.
Symptom 1 : I want the Planner to be in charge of Firmed and or Released Jobs, but I see that they have been 'scheduled' by looking at the 'scheduled' field on the Job Orders form.
Symptom 2 : Ran Firm jobs in the scheduler and did not mean to
Database : SQL 2000
Cause
Once the Scheduling Activity has been run, the Firmed or Released Jobs that have been run through the Scheduler will have their 'scheduled' field checked on the Job Orders form. SchedOp records will have been created to represent load as an input to the planner. Other scheduling output will have been created. As a result, the planning activity will not be in charge of these previously scheduled and released jobs.
Fix
The following steps can be taken to
give the Planning activity control over released jobs:
- Open SQL Query Analyzer to the appropriate SL 7 App
database
- Truncate the RESSCHD000 table. This has the
effect of making the integration code think that these Jobs were not
scheduled.
- Truncate the SCHEDOP000 table. This will adjust
the load records to reflect only what the planner believes is the load.
- Run the following command: Execute
ApsResyncAllSp. This will fire all of the triggers that are input to
the planning run. (CAUTION: this command should ONLY be run when no
one else in SyteLine.)
Note: This also applies to Firm Jobs if the Schedule Firm Jobs check box has been checked on the Shop Floor Control Parameters form.
