Discrete Job Shortage Report (Oracle Work in Process)


	Previous	Next		Contents	Index	Glossary	Library

Discrete Job Shortage Report

The Discrete Job Shortage report lists either jobs with open requirements or jobs with component requirements for which there is a shortage. Shortage component requirements can be listed based on the quantities available in all subinventories or based only on the quantities available in the component's supply subinventory. You can also list shortage components based on all subinventories or only those subinventories that are nettable. Only discrete jobs with statuses of Unreleased, Released, Complete, and On Hold are listed on this report. See: Reporting by Status.

You can print a job's open requirements to identify components you need to issue or have not yet backflushed. You can print the shortage report to highlight components you need to expedite. You can sort either report by component, date required, department, job, or by make/ buy option, buyer, and planner.

Report Submission

In the Submit Requests window, select Discrete Job Shortage Report in the Name field.

Report Parameters

Report Type

Choose one of the following options:

Open requirement Lists open material requirements for all jobs. This is the default option.

Shortage based on QOH Lists requirements with insufficient quantities as based on all subinventories. If you select Yes in the Include Nettable Only option, then you may see more shortages depending on how much quantity you have available for each requirement in your non-nettable subinventories.

Shortage based on supply sub/loc Lists requirements with insufficient quantities as based on each requirement's supply subinventory and locator.

Sort By

Choose one of the following options:

Component Sort the shortages or open requirements by component, and then by job within the component.

Date required Sort the shortages or open requirements by requirement date, and then by job within the requirement date.

Department Sort the shortages or open requirements by department, and then by job within the department.

Job Sort the open requirements by job. This is the default option.

Make or Buy, Buyer, Planner Sort the shortages or open requirements by component, and then by job within the component. Order the components by the make or buy code, and then by the buyer, and then by the planner.

Include Nettable Only

Select Yes to include only nettable subinventories when calculating subinventory quantities and printing shortages. Select No to include nettable and non-nettable subinventories when calculating subinventory quantities and printing shortages. The system determines the quantity onhand for each requirement using this value.

Include Bulk

Select Yes to indicate whether to include bulk-supplied material requirements.

Include Supplier

Select Yes to indicate whether to include supplier-provided material requirements.

Jobs From/To

To restrict the report to range of jobs, select a beginning and an ending job.

Components From/To

To restrict the report to range of components, select a beginning and an ending component.

Dates From/To

To restrict the report to a date range, select a beginning and an ending date.

Departments From/To

To restrict the report to a range of departments, select a beginning and an ending department.

Planners From/To

To restrict the report to a range of planners, select a beginning and an ending planner name.

Buyers From/To

To restrict the report to a range of buyers, select a beginning and an ending buyer name.

Make or Buy

Select Make or Buy to indicate whether to report on shortages for components that are made or purchased.

Requirement End Date

Select a date to limit netting the requirements for open jobs. The system nets the requirements required on or before this date.

Schedule Group

Select a schedule group.

Open requirement	Lists open material requirements for all jobs. This is the default option.
Shortage based on QOH	Lists requirements with insufficient quantities as based on all subinventories. If you select Yes in the Include Nettable Only option, then you may see more shortages depending on how much quantity you have available for each requirement in your non-nettable subinventories.
Shortage based on supply sub/loc	Lists requirements with insufficient quantities as based on each requirement's supply subinventory and locator.

Component	Sort the shortages or open requirements by component, and then by job within the component.
Date required	Sort the shortages or open requirements by requirement date, and then by job within the requirement date.
Department	Sort the shortages or open requirements by department, and then by job within the department.
Job	Sort the open requirements by job. This is the default option.
Make or Buy, Buyer, Planner	Sort the shortages or open requirements by component, and then by job within the component. Order the components by the make or buy code, and then by the buyer, and then by the planner.