Reports and Processes

This chapter explains how to submit report and process requests, and briefly describes each Work in Process report.

This chapter covers the following topics:

AutoCreating Final Assembly Orders

The AutoCreate Final Assembly Orders load program creates final assembly orders (discrete jobs) from sales order demand, and links each sales order to the final assembly order supplying it. You can create final assembly orders for ATO configuration items, or standard ATO items.

You can submit the program in specified intervals. For example, to submit the program each day at midnight, specify midnight in the Run Options.

You have the option to create supply for lower level configurations when running the AutoCreate Final Assembly Orders program. This is based on the setting for the Create Lower Level Supply parameter in Oracle Bills of Material. See: Parameters, Oracle Configure to Order Implementation Manual. You have three options:

The Assemble To Order Mass Load Report is automatically printed after submitting the AutoCreate Final Assembly Orders program. This report lists the sales orders where final assembly orders could not be created

Note: When you autocreate a final assembly order, the sales order line delivery quantity becomes the default quantity for the discrete job and the assembly's primary bill and routing are used.

To autocreate final assembly orders

  1. Navigate to the AutoCreate Final Assembly Orders window. The Parameters window appears.

    the picture is described in the document text

  2. Optionally, select the Sales Order number.

    A discrete job is created for each sales order shipment number associated with the sales order number. If you enter an order number, you cannot enter Offset Days, Load Type, or Organization. If you do not enter an order number, you must enter Offset Days and Load Type.

  3. If you have not selected a sales order, enter the number of Offset Days.

    The number of offset days is added to the current date to determine when final assembly orders must be released to the shop floor to be completed by the sales order due date. The final assembly order release date is backwards scheduled using the order from the sales order due date. For example, if the current date is 01-JAN-2007 and you specify 7 offset days, final assembly orders are created that must be released between 01-JAN-2007 and 08-JAN-2007 to meet the due dates of the sales orders they are supplying. Orders that should have been released before the current date are also included.

  4. If you have not selected a sales order, select one of the following Load Type options. The Create Lower Level Supply parameter in Oracle Bills of Material must be set correctly to specify the option selected here. See: Parameters, Oracle Configure to Order Implementation Manual

    Configured Orders only: Final assembly orders created from configured sales orders. A configured order begins with a model and options, and then generates or links a configured item using the AutoCreate Configuration Items program in Oracle Bills of Material.

    Non-configured Orders only: Final assembly orders created from sales orders placed directly for ATO items.

    Both configured and non-configured Orders: Final assembly orders created from both configured and non-configured items.

  5. If you have not selected a sales order, select one of the following job Statuses: Unreleased, Released, or On Hold. See: Discrete Job Statuses.

  6. If you have not selected a sales order, select an Organization.

    If you do not select an Organization, sales order demand across all organizations is examined.

  7. Select an accounting Class. This accounting class is the default for the jobs that are created.

    Default accounting classes may be displayed but can be overwritten. See: WIP Accounting Class Defaults, Discrete Parameters, and Discrete Accounting Classes.

  8. Choose OK to display the request window.

    the picture is described in the document text

  9. Submit the autocreate request.

Related Topics

Overview of Creating Discrete Jobs

Overview to Supplying Unique Configurations, Oracle Configure To Order Implementation Manual.

Closing Discrete Jobs Using Submit Requests

Job close requests can be submitted using concurrent or scheduled processing. See: Overview of Standard Request Submission, Oracle E-Business Suite User's Guide.

The close requirements for the concurrent program are the same as when using the Close Discrete Jobs window. See: Overview of Discrete Job Close. In the concurrent program, you can also use criteria for closing jobs based on a range of accounting classes, job numbers, and dates - including release, scheduled start, and completion dates. You can also close jobs as of a specific date, rather than the date the program is executed.

To close Discrete jobs using Submit Requests

  1. Navigate to the Close Discrete Jobs window using the Close Discrete Jobs (SRS) menu option. The Parameters window appears.

  2. Select an accounting Class Type.

    The options are Standard Discrete, Repetitive Assembly, Asset Non-standard, Expense Non-standard, Standard Lot Based, Maintenance, and Expense Non-standard Lot Based.

    If you do not select a class type, the system closes job for all class types. If you select a class type, you can only select accounting classes of that class type.

  3. To select a range of accounting classes, select values in the From and To Class fields.

    If you do not select a To Class, all jobs from the From Class forward are closed. If you do not select a From Class, all jobs through the To Class are closed.

  4. To select a range of jobs, select values in the From and To Job fields.

    To close a single job, use the same From and To Job value. The From Job value defaults into the To Job field, eliminating accidentally closing all jobs forward from the one selected.

  5. To select a range of job release dates, select values in the From and To Job Release Date fields. Use the same value in the From and To fields if you only want one date.

  6. To select a range of scheduled job start dates, select values in the From and To Job Start Date fields. Use the same value in the From and To fields if you only want one date.

    the picture is described in the document text

  7. To select a range of scheduled job completion dates, select values in the From and To Job Completion Date fields. Use the same value in the From and To fields if you only want one date.

  8. Select a job Status

    You can only close jobs with one with the following statuses: Cancelled, Complete, Complete - No Charges, Failed Bill Load, Failed Close, Failed Routing Load, On Hold, Release, or Unreleased. See: Discrete Job Statuses.

  9. Exclude Reserved Jobs parameter provides the option to exclude or include jobs linked to sales orders from the processing. The default value is Yes.

  10. Exclude Un-Completed Jobs parameter provides the option to exclude or include jobs having a status other than Complete from the processing.

    If the value selected is Yes - jobs in this submission with a status other than Complete are ignored and will not process.

    If the value selected is No - jobs with a status other than Complete are processed, and the job status changes to Failed Close. See: Viewing Pending Job Transactions.

  11. Exclude Jobs with Pending Trans parameter provides the option to exclude or include jobs with pending transactions during the close process.

    If the value selected is Yes - jobs in this submission with pending material, resource, move, or uncosted material transactions are ignored and will not process.

    If the value is set to No - jobs in this submission with pending material, resource, move, or uncosted material transactions are included in the process. The job status changes to Failed Close.

  12. Select a Report Type.

    Reports are printed after the close process computes job close variances. The Discrete Job Value Report is printed when standard discrete jobs and non-standard asset jobs are closed - in summary or detail based on the Report Type option specified. The Expense Job Value Report is printed when expense non-standard jobs are closed and is always printed in detail format regardless of the Report Type option specified. See: Discrete Job Value Report and Expense Job Value Report.

    Report Type options and formats are as follows:

    Summary: Lists each job and includes job header, period-to-date summary, and cumulative-to-date summary information. The system also lists summary elemental account values for each job.

    Detail using planned start quantity: Lists each job using the planned start quantity of the job to calculate the material usage variance. A detail report includes the following: job header, material, resource, resource-based and move-based overhead costs, completion, scrap, and job close variance transactions. It also includes period-to-date and cumulative-to-date summary information.

    Detail using actual completion quantity: Lists each job using the actual completion quantity of the job to calculate the material usage variance. A detail report includes the following: job header, material, resource, resource-based and move-based overhead costs, completion, scrap, and job close variance transactions. It also includes period-to-date and cumulative-to-date summary information

    No Report: Does not print a report.

  13. In the Actual Close Date field, you have the option to enter a date other than today's date. This enables you to close jobs as of a specific date, rather than the date the program is executed.

  14. Choose OK.

  15. Submit the close request. See: Submitting a Request, Oracle E-Business Suite User's Guide.

    Jobs that meet the criteria entered are closed when your request is run.

    You can check the status of close requests using the Concurrent Requests window. See: Concurrent Requests, Oracle E-Business Suite User's Guide.

Related Topics

Overview of Discrete Job Close

Defining Discrete Jobs Manually

Closing Discrete Jobs

Discrete Accounting Classes

Period Close, Cost Management User's Guide

Discrete Job Data Report

The Discrete Job Data Report lists complete information on discrete jobs. You can use this report to review all details about a job, such as quantities, dates, routing operations, material requirements, resources, instructions, sales orders, comments and accounts. You can sort the report by job name or schedule group and build sequence.

Report Submission

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

Report Parameters

Sort By

Choose one of the following options:

Variable Description
Job Sort by job.
Schedule Group, Build Sequence Sort by schedule group, then by build sequence.

Job From/To

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

Assembly From/To

To restrict the report to a range of assemblies, select a beginning and an ending assembly.

Start Dates From/To

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

Class

Select a WIP accounting class. See: WIP Accounting Classes

Status

Choose a status. The available options are Unreleased, Released, Complete, Complete-No Charges, and On Hold. See: Discrete Job Statuses and Reporting by Status.

Schedule Groups From/To

To restrict the report to a range of schedule groups, select a beginning and an ending schedule group.

Related Topics

Overview of Discrete Manufacturing

Dispatch Reports

Discrete Job Dispatch Report

The Discrete Job Dispatch Report lists jobs that must be completed. You can use this report to prioritize the work in each of your manufacturing departments. You can sort this report by operation start date or operation completion date within the department. You can restrict the output by department, date, and schedule group. Information is listed only for jobs with statuses of Released, Complete, and On Hold.

Report Submission

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

Report Parameters

Sort By

Choose one of the following options:

Variable Description
Operation start date Sort by operation start date within the department.
Operation completion date Sort by operation completion date within the department.

Include Unreleased Jobs

Select Yes or No to indicate whether to include jobs with a status of Unreleased on the report.

Departments From/To

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

Dates From/To

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

Schedule Group

Select a schedule group.

Related Topics

Overview of Discrete Manufacturing

Dispatch Reports

Reporting by Status

Discrete Job Listing Report

The Discrete Job Listing Report lists discrete jobs regardless of their status. You can sort the report by assembly, job, scheduled start date, or schedule group and build sequence. You can restrict the output of the report by job, assembly, start date, status, and schedule group. For example, you can use this report to determine which jobs need to be released by restricting it to jobs with a status of Unreleased.

Report Submission

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

Report Parameters

Sort By

Choose one of the following options:

Variable Description
Assembly Sort by assembly.
Job Sort by job. This is the default option.
Scheduled start date Sort by scheduled start date.
Schedule Group, Build Sequence Sort by schedule group, then by build sequence.

Jobs From/To

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

Assemblies From/To

To restrict the report to a range of assemblies, select a beginning and an ending assembly.

Start Dates From/To

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

Status

Choose a status. You can choose any status. See: Discrete Job Statuses.

Schedule Group From/To

To restrict the report to a range of schedule groups, select a beginning and an ending schedule group.

Related Topics

Overview of Discrete Manufacturing

Reporting by Status

Submitting a Request, Oracle E-Business Suite User's Guide

Discrete Job Pick List Report

The Discrete Job Pick List Report lists open component requirements for jobs with statuses of Unreleased, Released, Complete, or On Hold. You can use this report when you pick material from stock to issue to discrete jobs. This report lists component requirements in supply type order; push components first followed by pull, bulk, then vendor components. This report can be sorted by component, date required, item sequence, supply subinventory/locator, or WIP material transaction.

If the report is sorted by component, requirements that are common across jobs are consolidated. This can be particularly useful if you are replenishing backflush subinventories which supply several jobs.

Report Submission

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

Report Parameters

Sort By

Choose one of the following options:

Variable Description
Component Sort by component. Requirements are consolidated across jobs. Use this option to help you replenish backflush subinventories which supply multiple jobs. You can use the Subinventory Transfer form in Oracle Inventory to transfer the consolidated quantity of each requirement from your warehouse to the backflush subinventories that supply your jobs.
Date required Sort by requirement date.
Item Sequence Sort by item sequence. The item sequence is established while defining a component on the bill of material. If a job includes phantom components, the item sequence is derived from the phantom component, not the parent assembly.
Supply sub- inventory, locator Sort by supply subinventory and locator.
Variable Description
WIP material transaction Sort component requirements in WIP Material Transaction order. The system lists components in the order presented in the WIP Material Transactions window. This assists data entry when you use the pick list as hard copy for issuing the components.

Transactable Only

Select Yes or No to indicate whether to exclude discrete jobs with statuses of Unreleased or On Hold.

Jobs From/To

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

Start Dates From/To

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

Schedule Groups From/To

To restrict the report to a range of schedule groups, select a beginning and an ending schedule group.

Supply Type

Choose a Supply Type. The available options are Push, Pull, Bulk, and Vendor. See: Supply Types.

Supply Subinventory

Select the supply subinventory to include as available material in the Discrete Job Pick List. If you do not enter a value, the system lists requirements of any supply subinventory.

Related Topics

Overview of Discrete Manufacturing

Overview of Material Control

Submitting a Request, Oracle E-Business Suite User's Guide

Discrete Job Routing Sheet

The Discrete Job Routing Sheet lists the operations and associated resources and material requirements for jobs with statuses of Unreleased Released, Complete, and On Hold. You can use the report output as a traveler for the discrete job on the shop floor. Jobs can be sorted by job or schedule group and build sequence. Header information is followed by job details including job operations, resources, operation instructions and material requirements.

Report Submission

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

Report Options

Jobs From/To

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

Scheduled Start Dates From/To

To restrict the report to a range of scheduled start dates, select a beginning and an ending date.

Schedule Groups From/To

To restrict the report to a range of schedule groups, enter a beginning and an ending schedule group.

Sort By

Choose one of the following options:

Variable Description
Job Sort by job.
Variable Description
Schedule Group, Build Sequence Sort by schedule group, then by build sequence within the schedule group.

Related Topics

Overview of Discrete Manufacturing

Viewing Discrete Job Information

Viewing Operations

Reporting by Status

Submitting a Request, Oracle E-Business Suite User's Guide

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 format your report to print:

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:

Variable Description
Open requirement Lists open material requirements for all jobs. This is the default option. These values are calculated using only the Include Nettable Only and Requirement End Date parameters, and not any of the other parameters.
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. These values are calculated using only the Include Nettable Only and Requirement End Date parameters, and not any of the other parameters.
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:

Variable Description
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.

Related Topics

Overview of Discrete Manufacturing

Overview of Material Control

Submitting a Request, Oracle E-Business Suite User's Guide

Discrete Job Value Report - Standard Costing

The Discrete Job Value Report - Standard Costing assists you in analyzing your standard discrete jobs and non-standard asset jobs in a standard costing organization. You can submit the WIP Value Report before submitting this report to review total variances and charges for your jobs. Then, you can submit this report to analyze a summary of the transactions behind the charges and variances for each job.

This report includes summarized information on all cost transactions including material, resource, move and resource-based overheads, scraps, completions, and job close variances. The report also lists period-to-date and cumulative-to-date summary information, as well as complete job header information.

You can list information for a group of jobs by specifying a job name range, an accounting class range, an assembly range, and/or a particular job status. Costs are grouped and subtotalled by transaction type.

This report provides you with all the information you need to reconcile your standard and non-standard asset jobs before closing them.

Note: This report does not include expense non-standard jobs. Use the Expense Job Value Report to analyze expense non-standard jobs.

Report Submission

In the Submit Requests window, select Discrete Job Value Report - Standard Costing in the Name field.

You can optionally print this report when you close asset non-standard and standard discrete jobs using the Close Discrete Jobs (Form) or Close Discrete Jobs (SRS) window. This is done by choosing any Report Type option other than No Report. The report is printed after the close process computes job close variances.

See: Closing Discrete Jobs and Closing Discrete Jobs Using Submit Requests.

Report Parameters

Sort By

Choose one of the following options:

Variable Description
Assembly, Job Sort by assembly and then by job within the assembly.
Class, Assembly, Job Sort by WIP accounting class, then by assembly within the WIP accounting class, and then by job within the assembly.
Job Sort by job. This is the default.

Report Type

Choose one of the following options:

Variable Description
Detail using actual completion quantity Lists each job using the actual completion quantity of the job to calculate the material usage variance. A detail report includes the following: job header, material, resource, resource-based and move-based overhead costs, completion, scrap, and job close variance transactions. It also includes period-to-date and cumulative-to-date summary information.
If you push material to a job or backflush material at operation completion and have not completed the assemblies that consumed the material, your material usage variance is overstated. If you backflush material at assembly completion, or you have completed all of the assemblies, any material usage variance is accurate.
Use this option if you backflush your requirements at assembly completion, or if you have already completed most of your assemblies.
Detail using planned start quantity Lists each job using the planned start quantity of the job to calculate the material usage variance. A detail report includes the following: job header, material, resource, resource-based and move-based overhead costs, completion, scrap, and job close variance transactions. It also includes period-to-date and cumulative-to-date summary information.
If you have not transacted each of the items and resources required to produce your assemblies, your variances are understated (you have a favorable variance). You can use this option to analyze the total cost requirements for a job by cost element, based on your planned assembly completions.
Summary Lists each job and includes job header, period-to-date summary, and cumulative-to-date summary information. The system also lists summary elemental account values for each job.

Class Type

Choose one of the following options:

Variable Description
Asset non-standard Report costs for jobs with a WIP accounting class type of asset non-standard.
Standard discrete Report costs for jobs with a WIP accounting class type of standard discrete. This is the default.

Include Bulk

Select Yes to indicate whether to include bulk-supplied material requirements. If you have already issued to a particular bulk requirement, the system lists the requirement, regardless of what you select here. Yes is the default.

Include Supplier

Select Yes to indicate whether to include supplier-provided material requirements. If you have already issued to a particular supplier requirement, the system lists the requirement, regardless of what you select here. Yes is the default.

Classes From/To

To restrict the report to a range of accounting classes, select a beginning and an ending accounting class.

Jobs From/To

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

Status

Select a status. The available options are Unreleased, Released, Complete, Complete-No Charges, On Hold, Cancelled, Closed, Pending Close, and Failed Close jobs. See: Discrete Job Statuses.

Note: If you run the Discrete Job Value Report for closed jobs and have changed your standard costs, the transaction summary information uses the latest standard cost and does not balance to the period or cumulative-to-date summaries.

Assemblies From/To

To restrict the report to a range of assemblies, select a beginning and an ending assembly.

Note: For discrete jobs, any difference between the cumulative single level variances and the material usage or efficiency variance subtotals is from configuration or method variances. The cumulative-to-date summary compares the costs incurred for the job with the standard bill/routing requirements for completions out of the job. Therefore, the difference between the cumulative variances and the usage/efficiency variance is due to the difference between the standard bill/routing requirements and the work in process bill/routing requirements.

To find the configuration variance, you should compare the material usage variance with the single level material variance. To find the methods variance, you should compare the efficiency variance with its corresponding single level variance. For example, you would compare the resource efficiency variance with the single level; resource and outside processing variance added together. You would add the resource-based and move-based overhead efficiency variances and compare it with the single level overhead variance.

Related Topics

Overview of Discrete Manufacturing

Overview of Discrete Job Close

Expense Job Value Report

Submitting a Request, Oracle E-Business Suite User's Guide

Discrete Shop Packet

The discrete shop packet consists of three reports:

Related Topics

Submitting a Request, Oracle E-Business Suite User's Guide

Employee Rates Listing

The Employee Rates Listing lists employees and their hourly labor rates. Employees are listed in alphabetical order with their employee number, current labor rate and effective date.

You can charge an employee labor rate to a job or repetitive schedule by charging a resource that does not charge at standard and by referencing the employee whose rate you want to charge. The system uses the rate effective on the resource transaction date.

Report Submission

In the Submit Requests window, select Employee Rates Listing in the Name field.

Use the Request Cost Setup Reports form and enter Employee Rates Listing in the Name field to submit the Employee Rates Listing.

Report Parameters

Display in Detail

Select Yes or No to indicate whether to print any additional labor rate information. If you select Yes, the system lists any past or future labor rates defined for your employees.

Current Only

Select Yes or No to indicate whether to print current employees only or all employees.

Employees From/To

To restrict the report to a range or employees, select a beginning and an ending employee.

Dates From/To

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

Related Topics

Overview of Shop Floor Control

Overview of Resource Management

Defining Labor Rates

Submitting a Request, Oracle E-Business Suite User's Guide

Expense Job Value Report

The Expense Job Value Report assists you in analyzing your non-standard expense jobs. You can submit the WIP Value Report before submitting this report to review total charges for your jobs. Then, you can submit this report to analyze a summary of the transactions behind the charges for each job.

This report includes summarized information on all cost transactions including, material, resource, move and resource based overheads, scraps, completions, and period close variances. The report also prints period-to-date summary information as well as complete job header information.

You can list a particular group of jobs by specifying a job name range, an accounting class range, an assembly range, and/or a particular job status. The system groups and subtotals your cost transactions by transaction type.

Note: Unlike the Discrete Job Value Report, this report prints no standard or variance information. Expense non-standard jobs typically have no standards and are used only to collect and charge costs. See: Discrete Job Value Report.

Report Submission

In the Submit Requests window, select Expense Job Value Report in the Name field.

You can optionally print this report when you close expense non-standard discrete jobs using the Close Discrete Jobs (Form) or Close Discrete Jobs (SRS) window. This is done by choosing any Report Type option other than No Report. When printed in conjunction with the close process, this report automatically prints in detailed format. The report is printed after the close process computes job close variances.

See: Closing Discrete Jobs and Closing Discrete Jobs Using Submit Requests.

Report Parameters

Sort By

Choose one of the following options:

Variable Description
Assembly, Job Sort by assembly and then by job within the assembly.
Class, Assembly, Job Sort by WIP accounting class, then by assembly within the WIP accounting class, and then by job within the assembly.
Job Sort by job. This is the default.

Report Type

Choose one of the following options:

Variable Description
Detailed In addition to summary information, the system prints detail cost transaction information on material, resource, move and resource based overheads, completions, scrap, and period close variances.
Summary List only summary information, including job header and period-to-date summary information.

Period Start Date

Select a period start date. The system prints non-standard expense jobs with cost transactions against them that are dated on or after this date.

Period Close Date

Select a period close date. The system prints non-standard expense jobs with cost transactions against them that are dated on or before this date.

Classes From/To

To restrict the report to a range of WIP accounting classes, select a beginning and an ending class.

Jobs From/To

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

Status

Choose a status. You can print this report for Unreleased, Released, Complete, Complete-No Charges, On Hold, Cancelled, Closed, Pending Close, and Failed Close jobs. See: Discrete Job Statuses.

Assemblies From/To

To restrict the report to a range of assemblies, select a beginning and ending assembly.

Related Topics

Overview of Non-Standard Discrete Jobs

Submitting a Request, Oracle E-Business Suite User's Guide

Importing Jobs and Schedules

You can use the Import Jobs and Schedules window to submit the WIP Mass Load program.

When the WIP Mass Load program is submitted, the system searches the Open Job and Schedule Interface (WIP_JOB_SCHEDULE_ INTERFACE) table for rows with the specified Group ID. It then creates standard and non-standard discrete jobs, updates existing jobs, and creates pending repetitive schedules for all valid rows. If a row fails validation, an error message is generated. You can view these errors and update failed rows using the Pending Jobs and Schedules window.

Note: When a job is changed to complete, closed, or canceled status – an informational warning message displays if open purchase orders or requisitions exist for any of the operations.

The assembly unit number can be changed through WIP Mass Load for discrete jobs that are unreleased, project related, and use unit effectivity. You can change job status is from Unreleased to Released in the same process.

You can also use Oracle Advanced Planning to submit the WIP Mass Load program and perform the same actions on planned orders, reschedule recommendations, or suggested schedules sourced for Oracle Advanced Planning.

The Job and Schedule Interface Report is automatically printed when the WIP Mass Load program is submitted. This report lists the standard and non-standard jobs that were created, the jobs that were updated, and the repetitive schedules that were created. It also lists the jobs and repetitive schedules rows that failed to process. If you resubmit the Job and Schedule Interface Report after the WIP Mass Load program has cleared the Open Job and Schedule Interface table of successfully processed records, only records for failed rows are listed.

To import jobs and schedules:

  1. Navigate to the Import Jobs and Schedules window. The Parameters window appears.

    the picture is described in the document text

  2. Enter a Group ID number.

    The system polls the WIP_JOB_SCHEDULE_INTERFACE table for rows with this group identification number. When rows with this number are found, the system validates the data and either creates a job or repetitive schedule, reschedules an existing job, or enters an error message. Rows with errors in them remain in the table and can be updated and resubmitted. See: Processing Pending Jobs and Schedules

  3. Choose OK.

  4. Submit the import request. See: Submitting a Request, Oracle E-Business Suite User's Guide.

Related Topics

Open Job and Schedule Interface

Job Lot Composition Report

The Job Lot Composition Report lists assembly and component lot numbers used on discrete jobs of any status. You assign component lot numbers when you issue or backflush lot controlled components to the job. You assign assembly lot numbers when you complete lot controlled assemblies from the job. The system lists all components under lot control consumed by a discrete job as well as lot numbers if you complete assemblies under lot control. You can sort this report by job or lot.

Since the system uses the material transaction history to create compositions, you should not purge any material transactions which contribute to genealogies you need to retain.

Report Submission

In the Submit Requests window, select Job Lot Composition Report in the Name field.

Report Parameters

Sort By

Choose one of the following options:

Variable Description
Job Sort by job. The system lists jobs in alphanumeric order.
Lot Sort by lot. The system lists jobs by lot number and job name.

Assembly

Select an assembly. The system lists the lot composition of all jobs that are building this assembly. If you do not select a value, the system lists the lot composition for all assemblies.

Dates From/To

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

Jobs From/To

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

Lots From/To

To restrict the report to a range of lots, select a beginning and an ending lot.

Related Topics

Overview of Discrete Manufacturing

Overview of Discrete Job Purge

Submitting a Request, Oracle E-Business Suite User's Guide

Job and Schedule Interface Report

The Job and Schedule Interface Report is submitted when the Mass Load program is launched.

This report lists the following information for jobs and schedules that are created and/or updated as well as for those that fail to process.

Variable Description
Created Jobs Job, Job Type, Assembly, Quantity, Start Date, Completion Date, Process Phase, and Process Status
Created Schedules Line, Assembly, Line, Daily Quantity, Days, First Unit Start Date, Last Unit Completion Date. Process Phase, and Process Status
Updated Discrete Jobs Job, Assembly, Status, Quantity, Start Date, Completion Date, Process Phase, and Process Status

The report is sorted by source code and, where applicable, by organization within that source code.

Related Topics

Open Job and Schedule Interface

Processing Pending Jobs and Schedules

Importing Jobs and Schedules

Submitting a Request, Oracle E-Business Suite User's Guide

Move Transaction Report

The Move Transaction Report lists move transaction information for discrete jobs and repetitive schedules. You can choose to display transaction details such as reason codes and references. You can also sort this report by date or assembly.

Report Submission

In the Submit Requests window, select Move Transaction Report in the Name field.

Use the Request Work in Process Reports form and enter Move Transaction Report in the Name field to submit the Move Transaction Report.

Report Parameters

Sort By

Choose one of the following options:

Variable Description
Date Sort by date, then by job or repetitive schedule within the date, and then by operation sequence number within the job or repetitive schedule.
Assembly Sort by assembly, then by date within the assembly, then by job or repetitive schedule within the assembly, and then by operation sequence number within the job or repetitive schedule.

Show Details

Select Yes or No to indicate whether to print the reason and reference for the move transaction. If you select Date in the Sort By field and you choose Yes in this field, the system lists the assembly along with the reason and reference for each move transaction.

Jobs/Schedules From and To

To restrict the report to a range of jobs or repetitive schedules, select a beginning and an ending job/repetitive schedule.

Lines From/To

To restrict the report to a range of lines, select a beginning and an ending line.

Assemblies From/To

To restrict the report to a range of assemblies, select a beginning and an ending assembly

Dates From/To

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

Reasons From/To

To restrict the report to a range of reasons, select a beginning and an ending reason.

Related Topics

Move Transactions

Submitting a Request, Oracle E-Business Suite User's Guide

Production Line Report

The Production Line Report lists production lines in alphabetical order. The system prints the line attributes as well as the assemblies that you can build on each line.

A production line describes a unique set of operations, departments, and/or manufacturing cells that produce one or more of your assemblies. You use production lines to build repetitive assemblies.

You can build different repetitive assemblies on the same production line. This means that you can use production lines to aggregate material requirements for a number of assemblies. You can also use lines to define separate area1s of your shop floor for greater management control.

Report Submission

In the Submit Requests window, select Production Line Report in the Name field.

Report Parameters

Line From/To

To restrict the report to a range of lines, select a beginning and an ending line.

Related Topics

Overview of Repetitive Manufacturing

Defining Production Lines

Associating Lines and Assemblies

Submitting a Request, Oracle E-Business Suite User's Guide

Purging Jobs and Schedules

You can purge old job and schedules records in your database. You can purge:

For quality and customer service tracking purposes, you can choose to retain as-built configuration histories for discrete jobs that build assemble to order items. You can purge all discrete job and repetitive schedule information (details, transactions and headers) by choosing to purge headers.

Note: Once you submit a purge request with a Purge Only or Purge and Report action type, all related information is removed from the database.

Purge requests can be submitted using concurrent or scheduled processing. See: Overview of Standard Request Submission, Oracle E-Business Suite User's Guide.

You can check the status of purge requests using the Concurrent Requests window.

Prerequisites

To purge jobs and schedules

  1. Navigate to the Purge Jobs and Schedules window. The Parameters window appears.

    the picture is described in the document text

  2. Select a Job Type.

    All Jobs/schedules: Purge information for discrete and lot based jobs with statuses of Closed, and repetitive schedules with statuses of Cancelled and Complete-No Charges. All Jobs/schedules is the default.

    Discrete jobs: Purge information for discrete jobs with a status of Closed.

    Lot Based Jobs: Purge information for lot based jobs with a status of Closed.

    Repetitive Schedules: Purge information for repetitive schedules with statuses of Cancelled or Complete-No Charges.

  3. Select an Action Type.

    You can choose from the following:

    Purge and Report: Purge the selected jobs/schedules and print a report. You can print the report in Full, Summary, or Detail format. If you select Purge and Report, you must select a Report Type.

    Report Only: Print a report listing the selected jobs/schedules but do not purge them. You can print the report in Full, Summary, or Detail format. If you select Report Only, you must select a Report Type.

    Purge Only: Purge the selected jobs/schedules but do not print a report. If you choose Purge Only, you must specify that the Report Type is None.

    Note: Printing a report before submitting a purge request allows you to view the exceptions that might arise and determine how many records are to be deleted from related tables as a result of the purge.

  4. Specify which job or schedule records to purge by selecting one or more of the following:

    Jobs From/To: Purge all jobs in this range that have a close date before the purge cutoff date.

    Line: Purge all repetitive schedules produced on this line that have been closed or cancelled before the purge cutoff date.

    Assembly: Purge all jobs and repetitive schedules that produce this assembly. If a job range is also specified, only jobs that produce this assembly that are within that range are purged. Similarly, if a production line is specified, only repetitive schedules that produce this assembly on that line are purged.

    Note: When purging discrete jobs, you can enter a production line, however this information is ignored when the purge is submitted. If you enter a job range, when purging repetitive schedules, this information is also ignored.

  5. Enter a Cutoff Datetime.

    The date and corresponding time component must be less than or equal to the close date of the most recently closed accounting period.

    If you choose to purge details in the Purge Options window, the system purges the details (material requirements, resource requirements, and operations) of Closed jobs and Cancelled and Complete-No Charges repetitive schedules with closed, completed, or cancelled dates less than or equal to this date. If you choose to purge Move, Resource, or Move and Resource Cost Transactions, the system purges transactions with dates less than or equal to this date for Closed jobs and Cancelled and Complete-No Charges schedules.

    Note: If you enter a date that is earlier than the closed, cancelled or completed date of a selected job or repetitive schedule, the system only purges job and repetitive schedule detail and transaction information up to the date you enter.

  6. Select Yes for Include Configurations to include discrete jobs that build either configured items or models in the purge. Select No to exclude configured items.

    If Oracle Bills of Materials purges the configured item that you build in Work in Process, then Oracle Bills of Material replaces the configured item on the job with the model the configuration was based on. You do not want to include configurations if you need this information for customer support. For example, if a customer complains that you did not build the configuration he ordered.

    If you do include configurations, you still have access to lot and serial information using the Lot Genealogy window or the lot and serial transactions in Oracle Inventory.

  7. Select whether to purge Headers.

    If you purge Headers, all information associated with the parent record and all associated details (material requirements, resource requirements, and operations) and transactions (move and resource transactions) are automatically purged. Shop floor statuses associated with jobs and/or repetitive schedules are also purged. Sales order allocations associated with discrete jobs are also purged.

    Note: When you choose to purge headers, the options to include details, move transactions, and resource transactions are automatically selected. You cannot choose to purge header and choose not to purge details are purged even if you choose not to purge details, move transactions, and resource transactions.

  8. Select whether to purge Details

    You can selectively purge Details - material requirements, resource requirements, and operations - without purging headers. Selective purging allows you to retain pertinent historical information. For example, you can retain operation information but purge move transactions associated with these operations.

  9. Select whether to purge Move Transactions

    You can selectively purge Move Transactions associated with the selected discrete jobs, repetitive schedules, or both. If the move transaction date is less than or equal to the cutoff date you entered, move transactions for repetitive schedules with Cancelled and Complete-No Charges statuses or discrete jobs with Closed statuses are purged.

  10. Select whether to purge Resource Transactions associated with jobs and/or repetitive schedules.

    You can selectively purge Resource Transactions associated with the selected discrete jobs, repetitive schedules, or both. Only resource transactions for repetitive schedules with Cancelled and Complete-No Charges statuses are purged, regardless of whether the transaction date is less than or equal to the cutoff date you entered.

  11. Select one of the following Report Types:

    Full: The report lists all job and/or schedule records selected for the purge, the table and number of rows affected as well as those records that cannot be purged because of purge rule violations. Full is the default option.

    Summary: The report lists all job and/or schedule records selected for the purge but in a tabular form. The table and row detail is omitted although exception information is included.

    Exception: The report lists only those job and/or schedule records that cannot be purged because of purge violation rules. Exception information is included.

    None: The report lists only the purge options selected (e.g. Headers, Schedule Details, Move Transactions, Resource Transactions), but does not list tables affected and records purged.

  12. In the Days Before Cutoff Date field, you have the option to select another cutoff value for purge calculations. This value, entered in days, is prior to the date and time entered in the Cutoff Datetime field.

    If there is a value entered in this field, the system purges jobs and schedules where the Close Date is between Cutoff Datetime and Days before Cutoff. If this field is null, all eligible jobs are considered in the purge where Close Date is less than or equal to Cutoff Date.

  13. Choose OK.

  14. Submit your purge request. See: Submitting a Request, Oracle E-Business Suite User's Guide.

Related Topics

Overview of Discrete Job Purge

Overview of Repetitive Schedule Purge

Transaction Control by Status

Purge Report

The Purge Report can be printed as you purge discrete and lot based jobs, repetitive schedules, or all jobs and repetitive schedules using the following windows:

When you choose to print a report as part of the purge process, the report option selected in the Purge Options window is defaulted and determines the format of the report.

Report Options

Variable Description
Full Lists all job and/or schedule records, the table and number of rows affected as well as those records that cannot be purged because of purge rule violations. Full is the default option.
Summary Lists all job and/or schedule records but in a tabular form. The table and row detail is omitted although exception information is included.
Exception Lists only those job and/or schedule records that cannot be purged because of purge violation rules. Exception information is included.
None Lists only the purge options selected (such as Headers, Schedule Details, Move Transactions, Resource Transactions), but does not list which tables are affected and which records purged.
You can only select the None option when submitting a purge request from the Purge Jobs and Schedules window. It is available only if you select the Purge Only action type in the Purge Options window. Furthermore, you must select this report option if the Purge Only option is selected as no other report option selections are allowed.

Related Topics

Purging Discrete Jobs

Purging Repetitive Schedules

Specifying Purge Options

Submitting a Request, Oracle E-Business Suite User's Guide

Repetitive Line Report

The Repetitive Line Report lists repetitive schedules defined for a production line. The system lists effective and pending repetitive schedules separately so you can easily identify which ones to cancel or implement. You can use this report to help you see the overall load on the line.

The system lists the production line header followed by all schedules defined on that line. Schedules are listed by assembly and first unit start date.

Report Submission

In the Submit Requests window, select Repetitive Line Report in the Name field.

Report Parameters

Lines From/To

To restrict the report to a range of lines, select a beginning and an ending line.

Assemblies From/To

To restrict the report to a range of lines, select a beginning and an ending assembly.

Dates From/To

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

Related Topics

Overview of Repetitive Manufacturing

Dispatch Reports

Repetitive Pick List Report

The Repetitive Pick List Report lists component requirements for a range of repetitive schedules in your organization with statuses of Unreleased, Released, Complete, or On Hold. You can use this report to pick material from stock to issue to work in process for a schedule. The report lists production lines in alphanumeric order with all their requirements ordered by supply type, including push, pull, bulk and vendor items. This report can be sorted by component, date required, supply subinventory/locator, or WIP material transaction.

Report Submission

In the Submit Requests window, select Repetitive Pick List Report in the Name field.

Report Parameters

Sort By

Choose one of the following options:

Variable Description
Component Sort by component.
Supply sub- inventory, locator Sort by supply subinventory and locator.
Variable Description
WIP material transaction Sort component requirements in WIP Material Transaction order. The system lists components in the order presented in the WIP Material Transaction window. This assists data entry when you use the pick list as hard copy for issuing the components.

Transactable Only

Select Yes or No to indicate whether to exclude repetitive schedules with statuses of Unreleased or On Hold.

Start Date

Select the start date. The system calculates requirements for your repetitive schedules from this date for the number of days you specified in the Days of Supply report option.

Days of Supply

Select the number of days of supply that you want to calculate requirements for.

Lines From/To

To restrict the report to a range of lines, select a beginning and an ending line.

Assemblies From/To

To restrict the report to a range of assemblies, select a beginning and an ending assembly.

Supply Type

Choose a Supply Type. The available options are Push, Pull, Bulk, and Vendor. See: Supply Types.

Supply Subinventory

Select the supply subinventory to include as available material in the pick list. If you do not select a value, the system lists requirements of any supply subinventory.

Related Topics

Overview of Repetitive Manufacturing

Submitting a Request, Oracle E-Business Suite User's Guide

Repetitive Routing Sheet

The Repetitive Routing Sheet lists operations and associated resources and material requirements for schedules with a status of Unreleased, Released, On Hold, or, Complete. You can use the report as a traveler to report production against repetitive schedules on the shop floor. The system displays repetitive assemblies and production lines in alphanumeric order. For each repetitive assembly/line, the system prints schedules ordered by first unit start date and followed by their operations, resources, instructions and requirements.

Report Submission

In the Submit Requests window, select Repetitive Routing Sheet in the Name field.

Report Parameters

Assembly

Select a repetitive assembly. If you do not select an assembly, the system lists routing information for all schedules defined for the line selected.

Line

Select a production line. If you do not select a line, the system displays routing information for all schedules defined for the assembly selected.

First Unit Start Dates From/To

To restrict the report to a range of first unit start dates, select a beginning and an ending date.

Related Topics

Overview of Repetitive Manufacturing

Repetitive Schedule Data Report

The Repetitive Schedule Data Report lists repetitive assemblies and production lines in alphanumeric order, and their schedules ordered by first unit start date. You can use this report to review all details about a repetitive schedule, such as quantities, dates, routing operations, material requirements, resources, instructions, comments and accounts.

Report Submission

In the Submit Requests window, select Repetitive Schedule Data Report in the Name field.

Report Parameters

Effective Only

Select Yes or No. No means list all schedules in the report. Yes means list only the schedules with the following statuses: Unreleased, Released, On Hold, Complete and Pending - Mass Loaded. See: Reporting by Status.

Assemblies From/To

To restrict the report to a range of assemblies, select a beginning and an ending assembly.

Lines From/To

To restrict the report to a range of lines, select a beginning and an ending line.

Start Dates From/To

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

Related Topics

Overview of Repetitive Manufacturing

Dispatch Reports

Submitting a Request, Oracle E-Business Suite User's Guide

Repetitive Schedule Shortage Report

The Repetitive Schedule Shortage Report lists either open requirements or requirements with inventory shortages for repetitive schedules. You can list requirement shortages based on the quantities available in all subinventories or based on the quantities available in the supply subinventories only. You can also determine shortages using all subinventories or only nettable subinventories. The system lists repetitive schedules with statuses of Unreleased, Released, On Hold, or Complete.

You can print a repetitive schedule'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.

Report Submission

In the Submit Requests window, select Repetitive Schedule Shortage Report in the Name field.

Report Parameters

Report Type

Choose one of the following options:

Variable Description
Open requirement List open material requirements for all repetitive schedules. 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.

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 Qty Ahead/Behind

Select Yes or No to indicate whether to include requirements fulfilled in the past when calculating open requirements and shortages. If you select Yes, the system includes requirements already issued or to be issued in its calculation of open requirements and shortages. If you select No, the system only takes into account today's quantities in its calculation of open requirements and shortages.

Include Bulk

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

Include Supplier

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

Supply Days

Select the number of supply days ahead of today that the system uses to calculate open requirements and shortages for your repetitive schedules.

Lines From/To

To restrict the report to a range of lines, select a beginning and an ending line.

Assemblies From/To

To restrict the report to a range of assemblies, select a beginning and an ending assembly.

Components From/To

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

Related Topics

Overview of Material Control

Repetitive Shop Packet

The repetitive shop packet consists of four reports:

Related Topics

Submitting a Request, Oracle E-Business Suite User's Guide

Repetitive Value Report

The Repetitive Value Report can be used to analyze your repetitive schedules. You can submit the WIP Value Report before submitting this report to review total variances and charges for your repetitive schedules. Then, you can submit this report to analyze a summary of the transactions behind the charges and variances for each repetitive schedule.

This report includes information on all cost transactions including material, resource, outside processing, move and resource-based overhead charges and variances. Relief charges, such as completion, assembly scrap, and period close transactions, are summarized across all schedules building an assembly on a line. The report also lists account summary information as well as repetitive schedule header information. The system groups and subtotals cost transactions by transaction type.

Report Submission

In the Submit Requests window, select Repetitive Value Report in the Name field.

Use the Request Work in Process Reports form and enter Repetitive Value Report in the Name field to submit the Repetitive Value Report.

Report Parameters

Report Type

Choose one of the following options:

Variable Description
Detail with requirements based on actual quantity completion Lists each assembly and line using the actual completion quantity of the assembly and line in to calculate all the variances. A detail report includes the following: header, material, resource, resource-based and move-based overhead costs, completion, scrap, and close variance transactions. It also includes account period-to-date and cumulative-to-date summary information.
Use this option if you backflush your material requirements at assembly completion or if you have already completed most of your assemblies.
Detail with requirements based on planned start quantity Lists each assembly and line using the planned start quantity of the assembly and line to calculate all the variances. A detail report includes the following: header, material, resource, resource-based and move-based overhead costs, completion, scrap, and close variance transactions. It also includes account summary information.
Use this option to compare your total requirements against your existing transactions for all cost elements using your planned completion quantity.
Lists Summary each assembly and line and includes repetitive schedule header and account information. The system also lists summary elemental account values for each repetitive schedule.

Include Bulk

Select Yes to indicate whether to include bulk-supplied material requirements. If you have already issued to a particular bulk requirement, the system lists the requirement, regardless of what you select here.

Include Supplier

Select Yes to indicate whether to include supplier-provided material requirements. If you have already issued to a particular supplier requirement, the system lists the requirement, regardless of what you select here.

Period Start Date

Select a period start date. The system lists the value of repetitive schedules that are dated on or after this date, or that were transacted between the period start date and the period close date.

Period Close Date

Select a period close date. The system lists the value of repetitive schedules that are dated on or before this date, or that were transacted between the period start date and the period close date.

Assemblies From/To

To restrict the report to a range of assemblies, select a beginning and an ending assembly.

Lines From/To

To restrict the report to a range of production lines, select a beginning and an ending line.

Classes From/To

To restrict the report to a range of WIP accounting classes, select a beginning and an ending class.

For repetitive schedules, any difference between the cumulative single level variances and the material usage or efficiency variance subtotals is from configuration or methods variances. The cumulative-to-date summary compares the costs incurred for the schedule with the standard bill/routing requirements for completions out of the schedule. Therefore, the difference between the cumulative variances and the usage/efficiency variance is due to the difference between the standard bill/routing requirements and the work in process bill/routing requirements. To find the configuration variance, you should compare the material usage variance with the single level material variance. To find the methods variance, you should compare the efficiency variance with its corresponding single level variance. For example, you would compare the resource efficiency variance with the single level; resource and outside processing variance added together. You would add the resource-based and move-based overhead efficiency variances and compare it with the single level overhead variance.

Since repetitive schedules are not revalued by the cost update, these variances also include any standard cost adjustments. The Standard Requirements columns use the latest standards. The Applied Cost columns use the transaction cost without cost update adjustments.

Related Topics

Overview of Work in Process Costing

Submitting a Request, Oracle E-Business Suite User's Guide

Resource Performance Report

The Resource Performance Report details resource efficiency by department. The system lists all resources within a department with the jobs/schedules charging these resources in alphanumeric order. The system lists the efficiency percentage of each resource as applied to a specific job or schedule and the departmental efficiency of each resource.

Report Submission

In the Submit Requests window, select Resource Performance Report in the Name field.

Use the Request Work in Process Reports form and enter Resource Performance Report in the Name field to submit the Resource Performance Report.

Report Parameters

Resources From/To

To restrict the report to a range of resources, select a beginning and an ending resource.

Departments From/To

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

Job/Schedule Active Dates From

Select a beginning date.

To

Select an ending date.

Minimum Efficiency

Select a minimum efficiency percentage. The system lists the resources for which the departmental efficiency is equal to or greater than this value. If you also select a maximum efficiency percentage, displays resources for which the departmental efficiency is equal to or greater than the minimum efficiency percentage and less than or equal to the maximum efficiency percentage.

Maximum Efficiency

Select a maximum efficiency percentage. The system lists the resources for which the departmental efficiency is less than or equal to this value. If you also select a minimum efficiency percentage, the system lists resources for which the departmental efficiency is equal to or greater than the minimum efficiency percentage and less than or equal to the maximum efficiency percentage.

Related Topics

Overview of Resource Management

Resource Transaction Report

The Resource Transaction Report lists resource transaction information for discrete jobs and repetitive schedules. You can list transaction details such as reason codes and references. You can sort this report by assembly, date, or employee.

Report Submission

In the Submit Requests window, select Resource Transaction Report in the Name field.

Use the Request Work in Process Reports form and enter Resource Transaction Report in the Name field to submit the Resource Transaction Report.

Report Parameters

Sort By

Choose one of the following options:

Variable Description
Assembly Sort by assembly, then by date within assembly, then by job or repetitive schedule within the assembly, and then by operation sequence number within the job or repetitive schedule.
Date Sort by date, then by job or repetitive schedule within the date, and then by operation sequence number within the job or repetitive schedule.
Employee Sort by employee, then by date within the employee, then by job or repetitive schedule within the date, and then by operation sequence number within the job or repetitive schedule.

Show Details

Select Yes or No to indicate whether to list reason and reference for the resource transaction. If you select Date or Employee in the Sort By field, and you choose Yes in this field, the system also lists the assembly along with the reason and reference for each resource transaction.

Jobs/Schedules From and To

To restrict the report to a range of jobs/schedules, select a beginning and an ending job or repetitive schedule.

Resources From/To

To restrict the report to a range of resources, select a beginning and an ending resource.

Lines From/To

To restrict the report to a range of production lines, select a beginning and an ending line.

Assemblies From/To

To restrict the report to a range of assemblies, select a beginning and an ending assembly.

Dates From/To

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

Employees From/To

To restrict the report to a range of employees, select a beginning and an ending employee.

Reasons From/To

To restrict the report to a range of employees, select a beginning and an ending reason.

Activities From/To

To restrict the report to a range of Activities, select a beginning and an ending activity.

Related Topics

Overview of Resource Transactions

Submitting a Request, Oracle E-Business Suite User's Guide

Schedule Group Listing

The Schedule Group Listing lists all information about schedule groups.

Report Submission

In the Submit Requests window, select Schedule Group Listing in the Name field.

Report Parameters

Schedule Group From/To

To restrict the report to a range of schedule groups, select a beginning and an ending schedule group.

Related Topics

Defining Schedule Groups

Shop Floor Statuses Report

The Shop Floor Statuses Report lists shop floor statuses in alphabetical order. The system also lists status descriptions and disable dates and identifies which statuses prevents you from moving assemblies.

Shop floor statuses give you control of your shop floor movement by limiting when you can make moves. Once you have released a job or repetitive schedule, you can assign and modify these statuses at the operations on the work in process routing using the Shop Floor Statuses window. You can view these statuses during shop floor moves and report them using job or repetitive schedule data reports.

Report Submission

In the Submit Requests window, select Shop Floor Statuses Report in the Name field.

Related Topics

Overview of Shop Floor Control

Assigning and Viewing Shop Floor Statuses

Defining Shop Floor Statuses

WIP Account Distribution Report

The WIP Account Distribution Report details account information for work in process cost transactions, including resource, overhead and outside processing charges, cost updates, and period close and job close variances. The system groups your transactions by job or schedule, by transaction type, and orders your transactions by earliest transaction date. You can list detailed account information for specific accounts, general ledger batches, or both to help you reconcile your general ledger.

This report does not list material cost transactions such as issues, completions, and scrap. You can list this information using the Material Account Distribution reports in Oracle Inventory.

Report Submission

In the Submit Requests window, select WIP Account Distribution Report in the Name field.

Use the Request Work in Process Reports form and enter WIP Account Distribution Report in the Name field to submit the WIP Account Distribution Report.

Report Parameters

Dates From/To

To restrict the report to a range of transaction dates, enter a beginning and ending date.

Account

Select a specific general ledger accounting flexfield.

GL Batch

Select a general ledger batch number. The system lists information by account for each account in the selected batch.

Job/Schedule

Select a specific job or repetitive assembly.

Line

Select a production line.

Assembly

Select an assembly.

Transaction Type

Choose one of the following options to print work in process cost transaction details for a specific transaction type:

Variable Description
Resource transaction Lists resource transaction details.
Variable Description
Overhead transaction Lists overhead transaction details.
Variable Description
Outside processing Lists outside processing transaction details.
Cost update Lists cost update transaction details.
Period close variance Lists transaction details for period close variance transactions for expense jobs and certain instances of repetitive schedules.
Job close variance Lists job close variance transaction details.

Department

Select a department name.

Activity

Select an activity.

Class

Select a WIP accounting class name.

Currency

Select a currency. You can run this report for any defined currency. When you select a currency other than the functional currency, item costs are converted to the selected currency. Your functional currency is the default.

Exchange Rate

The system displays the most recent End of period rate but you can choose another period. The rate type used, either period average or the period end, is determine by how the CST:Exchange Rate Type profile option is set. See: Cost Management Profile Options, Oracle Cost Management.

Related Topics

Overview of Period Close, Oracle Cost Management User's Guide

WIP Account Summary Report

The WIP Account Summary Report summarizes account information for work in process cost transactions, including resource, overhead and outside processing charges, cost updates, and period close and job close variances. The system lists debit, credit and net activity by account for each type of cost transaction. You can list information by date. You can also list information for specific accounts, general ledger batches, or both to help you reconcile your general ledger. You can use this report during your pre-close monthly review process.

The system does not list material cost transactions, such as issues, completions, and scraps, in this report. You can report this information using the Inventory Account Distribution report in Oracle Inventory.

Report Submission

In the Submit Requests window, select WIP Account Summary Report in the Name field.

Use the Request Work in Process Reports form and enter WIP Account Summary Report in the Name field to submit the WIP Account Summary Report.

Report Parameters

Dates From/To

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

Account

Select a general ledger accounting flexfield.

GL Batch

Select a general ledger batch. The system lists information by account for each account in the selected batch.

Related Topics

Period Close, Oracle Cost Management User's Guide

WIP Accounting Classes Report

The WIP Accounting Classes Report lists the WIP accounting classes you have defined. The class type, disable date and description for each accounting class, as well as the elemental valuation and variance accounts, are listed.

You must define separate accounting classes for standard discrete jobs, non-standard expense jobs, non-standard asset jobs, repetitive assemblies, maintenance jobs, and lot based jobs. Each accounting class includes the elemental valuation and variance accounts you use to cost discrete and repetitive production. You must enter an accounting class when you define a discrete job and when you associate production lines with repetitive assemblies.

Report Submission

In the Submit Requests window, select WIP Accounting Classes Report in the Name field.

Related Topics

WIP Accounting Classes

WIP Location Report

The WIP Location Report details the locations of the assemblies within the routings of the jobs and repetitive schedules. This includes job and repetitive schedules with statuses of Released, Complete, and On Hold. The system lists only operations that contain assemblies.

Report Submission

In the Submit Requests window, select WIP Location Report in the Name field.

Report Parameters

Sort By

Choose one of the following options:

Variable Description
Assembly, Job/Schedule, Line, Op seq Sort by assembly, then by job or repetitive schedule within the assembly, then by line within the job or repetitive schedule, and then by operation sequence number within the line.
Department, Assembly, Job/Schedule, Op seq Sort by department number, then by assembly within the department, then by job or repetitive schedule within the assembly, and then by operation sequence number within the job or repetitive schedule.
Job/Schedule, Assembly, Line, Op seq Sort by job or repetitive schedule, then by assembly within the job or repetitive schedule, then by line within the assembly, and then by operation sequence number within the line.
Line, Assembly, Job/Schedule, Op seq Sort the report by line, then by assembly within the line, then by job or repetitive schedule within the assembly, and then by operation sequence number within the job or repetitive schedule.

Jobs/Schedules From and To

To restrict the report to a range of jobs or repetitive schedules, select a beginning and ending job/schedule.

Lines From/To

To restrict the report to a range of production lines, select a beginning and an ending line.

Assemblies From/To

To restrict the report to a range of assemblies, select a beginning and an ending assembly.

Departments From/To

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

Related Topics

Dispatch Reports

Viewing Operations

Submitting a Request, Oracle E-Business Suite User's Guide

WIP Offsetting Account Report

The WIP Offsetting Account Report lists detailed account information for work in process cost transactions, including resource, overhead and outside processing charges; cost updates; and period close and job close variances. Transaction information is grouped by offsetting account, by transaction type, from the earliest transaction date.

The system does not list material cost transactions - issues, completions, and scrap transactions - on this report. You can report this information using the Inventory Account Distribution report in Oracle Inventory.

Report Submission

In the Submit Requests window, select WIP Offsetting Account Report in the Name field.

Use the Request Work in Process Reports form and enter WIP Offsetting Account Report in the Name field to submit the WIP Offsetting Account Report.

Report Parameters

Accounts From/To

To restrict the report to a range of accounts, select a beginning and an ending accounting flexfield.

Dates From/To

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

Related Topics

Submitting a Request, Oracle E-Business Suite User's Guide

WIP Outside Processing Report

The WIP Outside Processing Report lists outside processing information for jobs or repetitive schedules. The system lists all purchase orders associated outside processing resources.

Report Submission

In the Submit Requests window, select WIP Outside Processing Report in the Name field.

Report Parameters

Jobs/Schedules From and To

To restrict the report to a range of jobs or repetitive schedules, select a beginning and ending job/schedule.

Assemblies From/To

To restrict the report to a range of assemblies, select a beginning and an ending assembly.

Lines From/To

To restrict the report to a range of production lines, select a beginning and an ending line.

Status

Choose a status. See: Discrete Job Statuses or Repetitive Schedule Statuses.

Open POs Only

Select Yes or No to indicate whether to print all purchase orders except ones that are closed and cancelled.

Related Topics

Submitting a Request, Oracle E-Business Suite User's Guide

WIP Parameters Report

The WIP Parameters Report lists the Work in Process parameters you have defined.

WIP parameters define modes of operation and assign default values that affect other functions in Work in Process, such as backflushing and lot number entry.

Report Submission

In the Submit Requests window, select WIP Parameters Report in the Name field.

Related Topics

WIP Parameters

WIP Value Report

The WIP Value Report details work in process inventory as of a particular accounting period. The system lists the value of discrete jobs and repetitive schedules for the period specified, lists the ending balance for each discrete job and repetitive schedule in a particular accounting class, and subtotals by the accounting class. In addition, the system summarizes each accounting class by cost element and lists a subtotal for each type of accounting class. For example, your can view your WIP inventory value for all standard discrete jobs.

For Oracle Shop Floor Management lot based jobs, if Estimated Scrap Accounting is enabled, you can view estimated scrap calculations. This includes estimated scrap incurred, relieved, and variances.

You can submit the report using several options to determine your output. You can list the output in a foreign currency using a particular exchange rate.

To ensure accurate ending inventory values for discrete jobs, you must close any open periods before the one you are using for this report.

Note: The system overstates WIP value by the value in your expense non-standard jobs and repetitive schedules. If you have not closed the period you are reporting, you have not yet written off the balances in your expense non-standard jobs and repetitive schedules. The system automatically writes these values off to the variance accounts at period close.

You can optionally set the WIP Recognize Period Variances Parameter so that only variances for repetitive schedules with statuses of Cancelled or Complete-No Charges are posted at period close. See: Repetitive Parameters.

Report Submission

In the Submit Requests window, select WIP Value Report in the Name field.

Use the Request Work in Process Reports form and enter WIP Value Report in the Name field to submit the WIP Value Report.

Report Parameters

Report Type

Choose one of the following options:

Variable Description
Cumulative to Date List WIP inventory values based on transactions entered for all periods, including those Selected before the current period.
For standard discrete jobs and non-standard asset jobs, the system accumulates job costs over the life of the job, which may cover more than one period. This option may be appropriate for these types of jobs
Period to Date Lists WIP inventory values based only on transactions entered for a particular period.
Optionally for repetitive schedules and always for non-standard expense jobs, the system automatically creates journal entries for valuation costs when you close your accounting period each month. This option may be appropriate for this type of job and repetitive schedules.

Period

Select an accounting period. Depending on the report type selected, the WIP values may be cumulative or may include only values transacted during this period.

Closed Jobs

Select Yes to include discrete jobs that were closed during the accounting period you specify. If you select No, the system includes only those jobs that were open at the end of the specified period.

Class Type

Choose one of the following accounting class options:

Variable Description
Asset non-standard List costs for asset non-standard jobs.
Expense non-standard List costs for expense non-standard jobs.
Repetitive assembly List costs for repetitive assemblies.
Standard discrete List costs for standard discrete jobs.

Classes From/To

To restrict the report to a range of WIP accounting classes, select a beginning and ending class. You cannot specify a class range unless you first select a value in the Class Type field.

Jobs/Schedules From and To

To restrict the report to a range of jobs or repetitive schedules, select a beginning and ending job/repetitive schedule. You cannot specify a job/schedule range unless you first select a value in the Class Type field.

For repetitive schedules, you are actually selecting a repetitive assembly value, such as an item number. For discrete jobs, you are selecting a job name.

Assemblies From/To

To restrict the report to a range of assemblies, select a beginning and an ending assembly. You cannot specify an assembly range unless you first select a value in the Class Type field.

If you are reporting values for repetitive schedules, you do not need to select both a job/schedule and assembly range unless you changed a repetitive assembly item number since you defined your repetitive assembly.

Currency Code

Select a currency code in which you want to report your WIP inventory values. The system defaults the functional currency from the set of books associated with your organization.

Exchange Rate

Select an exchange rate when you report your WIP inventory values in a foreign currency. You can choose from any valid exchange rates defined for the currency you selected in the previous field.

Related Topics

WIP Accounting Classes

Submitting a Request, Oracle E-Business Suite User's Guide