Processing Pending Jobs and Schedules
You can view, update, delete, and resubmit records (rows) that have failed validation and remain in the Open Job and Schedule Interface (WIP_JOB_ SCHEDULE_INTERFACE) table. You can view the error messages associated with failed records. Error messages assist you in updating failed records before resubmission.
You cannot insert new job and schedule records into your interface table using this window.
Prerequisites
To find job and schedule interface records:
2. Enter your selection criteria.
You can find all records with a specific Group ID. You can also find all records that have a specific Process Phase (Validation, Explosion, Creation, or Complete), Process Status (Pending, Running, Error, or Complete), Source Code, Source Line ID, Load Type (Create Standard job, Create Repetitive Schedule, Update Discrete Job, or Create Non-standard Job), or are for a specific Organization. You can also search for a specific Job, Assembly, or Line and Assembly.
To view job and schedule interface records:
Process: Group ID, Phase, Status, Request ID, Source Code, and Source Line (if applicable)
Header: Load Type, Organization, Job, Line, Assembly
Quantities: Discrete Start and Net Quantities, Repetitive Daily Quantity and processing Days, and Total Quantity (both discrete and repetitive)
Discrete: Class, Lot Number, Schedule Group, Build Seq, Project Number and Task
More: Status, Firm planned option, Demand Class, Scheduling Method
Dates: First Unit Start Date, First Unit Completion Date, Last Unit Start Date, and Last Unit Completion Date
Bill: Reference, Alternate, Revision, Revision Date, Supply Type
Routing: Reference, Alternate, Revision, Revision Date, and Completion Subinventory, and Completion Locator
Description: Description and Created By
1. In the Pending Jobs and Schedules window, select the failed (Status=Error) record.
All errors for the selected record are displayed. The Type indicates whether the failed record produced an Error or a Warning. The Message explains why the transaction failed. Using these messages you can determine what fields need to be updated.
1. Select the record to update.
You can only update records with a processing status of Error. You can update all fields except the Group ID, processing Phase, processing Status, Request ID, and Total Quantity.
The Source Code and Source Line identify the source of the interface record. For example, if you load jobs and schedules from different sources, you can use a difference Source Code to identify each.
3. In the Header alternative region, select the Load Type.
The Load Type indicates whether the current interface record is a planned order, update recommendation, or suggested repetitive schedule.
1: Create Standard Discrete Job
2: Create Pending Repetitive Schedule
3: Update Standard or Non-Standard Discrete Job
4: Non-Standard Discrete Job
The assembly is the item you are building. An assembly is optional for non-standard discrete jobs.
Select the production Line on which to build the repetitive assembly and the repetitive Assembly to be produced on that line.
6. In the Quantities alternative region, enter the Start Quantity and Net Quantity for discrete jobs or the Daily Quantity and number of Days for repetitive schedules.
7. In the Discrete alternative region, select the class.
For records with a Load Type of 4 (Non-Standard Discrete Job), you can select any active Asset Non-standard, Expense Non-standard, or Project accounting class. For records with a Load Type 1 (Create Standard Discrete Job), you can select any active Standard Discrete accounting class.
The combination of schedule group and build sequence must be unique for each job.
You can only select a project if the current organization's Project References Enabled parameter is set in Oracle Inventory. You must select a task if the Project Control Level parameter is set to Task and you have entered a project. See: Organization Parameters Window and Defining Project Information.
13. Select whether the discrete job or repetitive schedule is Firm.
14. Select the Demand Class.
You can choose one of the following:
Routing: You can schedule discrete jobs using routing lead times, if the Load Type is 1 (Create Standard Discrete Job) or 3 (Update Standard or Non-Standard Discrete Job).
Item Lead Time: You can schedule discrete jobs using item lead times, even if the item has a routing, if the Load Type is 1 (Create Standard Discrete Job) or 3 (Update Standard or Non-Standard Discrete Job).
Manual: You can manually schedule your discrete jobs by entering start and/or completion dates.
16. In the Dates alternative region, enter a First Unit Start Date (FUSD), First Unit Completion Date, a Last Unit Start Date, or a Last Unit Completion Date (LUCD).
If you are using Manual scheduling, enter both a FUSD and a LUCD.
You can select bill of material reference if the Load Type is 3 (Update Standard or Non-Standard Discrete Job) or 4 (Non-Standard Discrete Job).
You can select an alternate bill if alternates have been defined for the assembly. For non-standard jobs, you can enter any alternate defined for the bill Reference specified.
You can select any of the following Supply Types: Push, Assembly Pull, Operation Pull, Bulk, or Supplier. See: Supply Types.
Routing references are used to create routings (operations and resource requirements) for non-standard discrete jobs, however, they are not required.
You cannot enter a value here unless you have defined alternate routings for the assembly you are building. For non-standard jobs, you can enter any alternate defined for the routing reference you specify. See: Primary and Alternate Routings.
24. Select the Completion Subinventory, and if required, locator.
You can optionally enter a Description that can be used to identify jobs on standard reports. They can be up to 240 characters of alpha numeric text.
You can update the name of the user that created the transaction is displayed. This field can be updated.
You can only resubmit records with a processing status of Error. If you do not mark a row for resubmission, you can still update it but the WIP Mass Load Program does not process it again when polling the Open Job and Schedule Interface table.
Resubmitting records resets their process status flags to 1 (Pending), and nulls their Group ID. The next time the WIP Mass Load Program polls the Open Job and Schedule Interface table, these records are reevaluated.
You can only delete records with a processing status of Error. When you delete records, their corresponding error messages are deleted from the Errors table (WIP_INTERFACE_ERRORS).
2. Choose Delete from the Edit menu.
See Also
Open Job and Schedule Interface
Open Job and Schedule Interface, Oracle Manufacturing Open Interfaces Manual, Release 11