This chapter explains how to submit report and process requests, and briefly describes each Work in Process report.
This chapter covers the following topics:
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:
No - Creates supply only to the top level ATO item or configuration
Auto Created Configuration Items only - Creates supply for any lower level configuration generated because of the specific sales order generation.
Auto Created Configuration Items and ATO Items - Creates supply for all lower level ATO, preconfigured, and autocreated configured items.
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
Navigate to the AutoCreate Final Assembly Orders window. The Parameters window appears.
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.
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.
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.
If you have not selected a sales order, select one of the following job Statuses: Unreleased, Released, or On Hold. See: Discrete Job Statuses.
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.
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.
Choose OK to display the request window.
Submit the autocreate request.
Related Topics
Overview of Creating Discrete Jobs
Overview to Supplying Unique Configurations, Oracle Configure To Order Implementation Manual.
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
Navigate to the Close Discrete Jobs window using the Close Discrete Jobs (SRS) menu option. The Parameters window appears.
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.
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.
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.
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.
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.
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.
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.
Exclude Reserved Jobs parameter provides the option to exclude or include jobs linked to sales orders from the processing. The default value is Yes.
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.
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.
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.
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.
Choose OK.
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
Period Close, Cost Management User's Guide
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.
In the Submit Requests window, select Discrete Job Data Report in the Name field.
Choose one of the following options:
Variable | Description |
---|---|
Job | Sort by job. |
Schedule Group, Build Sequence | Sort by schedule group, then by build sequence. |
To restrict the report to a range of jobs, select a beginning and an ending job.
To restrict the report to a range of assemblies, select a beginning and an ending assembly.
To restrict the report to a date range, select a beginning and an ending date.
Select a WIP accounting class. See: WIP Accounting Classes
Choose a status. The available options are Unreleased, Released, Complete, Complete-No Charges, and On Hold. See: Discrete Job Statuses and Reporting by Status.
To restrict the report to a range of schedule groups, select a beginning and an ending schedule group.
Related Topics
Overview of Discrete Manufacturing
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.
In the Submit Requests window, select Discrete Job Dispatch Report in the Name field.
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. |
Select Yes or No to indicate whether to include jobs with a status of Unreleased on the report.
To restrict the report to a range of departments, select a beginning and an ending department.
To restrict the report to a date range, enter a beginning and an ending date.
Select a schedule group.
Related Topics
Overview of Discrete Manufacturing
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.
In the Submit Requests window, select Discrete Job Listing Report in the Name field.
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. |
To restrict the report to a range of jobs, select a beginning and an ending job.
To restrict the report to a range of assemblies, select a beginning and an ending assembly.
To restrict the report to a date range, enter a beginning and an ending date.
Choose a status. You can choose any status. See: Discrete Job Statuses.
To restrict the report to a range of schedule groups, select a beginning and an ending schedule group.
Related Topics
Overview of Discrete Manufacturing
Submitting a Request, Oracle E-Business Suite User's Guide
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.
In the Submit Requests window, select Discrete Job Pick List Report in the Name field.
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. |
Select Yes or No to indicate whether to exclude discrete jobs with statuses of Unreleased or On Hold.
To restrict the report to a range of jobs, select a beginning and an ending job.
To restrict the report to a date range, select a starting and an ending date.
To restrict the report to a range of schedule groups, select a beginning and an ending schedule group.
Choose a Supply Type. The available options are Push, Pull, Bulk, and Vendor. See: Supply Types.
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
Submitting a Request, Oracle E-Business Suite User's Guide
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.
In the Submit Requests window, select Discrete Job Routing Sheet Report in the Name field.
To restrict the report to a range of jobs, select a beginning and an ending job.
To restrict the report to a range of scheduled start dates, select a beginning and an ending date.
To restrict the report to a range of schedule groups, enter a beginning and an ending schedule group.
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
Submitting a Request, Oracle E-Business Suite User's Guide
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:
A job's open requirements to identify components you need to issue or have not yet backflushed
Components you need to highlight for expediting
You can sort either report by component, date required, department, job, or by make/ buy option, buyer, and planner:
When you sort by component, make/ buy option,or planner-the components are listed in order of the corresponding jobs
When you print report type Shortage based on supply sub/loc-the components are not listed by corresponding jobs
In the Submit Requests window, select Discrete Job Shortage Report in the Name field.
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. |
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. |
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.
Select Yes to indicate whether to include bulk-supplied material requirements.
Select Yes to indicate whether to include supplier-provided material requirements.
To restrict the report to range of jobs, select a beginning and an ending job.
To restrict the report to range of components, select a beginning and an ending component.
To restrict the report to a date range, select a beginning and an ending date.
To restrict the report to a range of departments, select a beginning and an ending department.
To restrict the report to a range of planners, select a beginning and an ending planner name.
To restrict the report to a range of buyers, select a beginning and an ending buyer name.
Select Make or Buy to indicate whether to report on shortages for components that are made or purchased.
Select a date to limit netting the requirements for open jobs. The system nets the requirements required on or before this date.
Select a schedule group.
Related Topics
Overview of Discrete Manufacturing
Submitting a Request, Oracle E-Business Suite User's Guide
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.
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.
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. |
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. |
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. |
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.
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.
To restrict the report to a range of accounting classes, select a beginning and an ending accounting class.
To restrict the report to a range of jobs, select a beginning and an ending job.
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.
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
Submitting a Request, Oracle E-Business Suite User's Guide
The discrete shop packet consists of three reports:
Related Topics
Submitting a Request, Oracle E-Business Suite User's Guide
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.
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.
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.
Select Yes or No to indicate whether to print current employees only or all employees.
To restrict the report to a range or employees, select a beginning and an ending employee.
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
Submitting a Request, Oracle E-Business Suite User's Guide
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.
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.
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. |
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. |
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.
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.
To restrict the report to a range of WIP accounting classes, select a beginning and an ending class.
To restrict the report to a range of jobs, select a beginning and an ending job.
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.
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
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:
Navigate to the Import Jobs and Schedules window. The Parameters window appears.
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
Choose OK.
Submit the import request. See: Submitting a Request, Oracle E-Business Suite User's Guide.
Related Topics
Open Job and Schedule Interface
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.
In the Submit Requests window, select Job Lot Composition Report in the Name field.
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. |
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.
To restrict the report to a date range, select a beginning and an ending date.
To restrict the report to a range of jobs, select a beginning and an ending job.
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
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
Submitting a Request, Oracle E-Business Suite User's Guide
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.
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.
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. |
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.
To restrict the report to a range of jobs or repetitive schedules, select a beginning and an ending job/repetitive schedule.
To restrict the report to a range of lines, select a beginning and an ending line.
To restrict the report to a range of assemblies, select a beginning and an ending assembly
To restrict the report to a date range, select a beginning and an ending date.
To restrict the report to a range of reasons, select a beginning and an ending reason.
Related Topics
Submitting a Request, Oracle E-Business Suite User's Guide
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.
In the Submit Requests window, select Production Line Report in the Name field.
To restrict the report to a range of lines, select a beginning and an ending line.
Related Topics
Overview of Repetitive Manufacturing
Associating Lines and Assemblies
Submitting a Request, Oracle E-Business Suite User's Guide
You can purge old job and schedules records in your database. You can purge:
Discrete and lot based jobs closed in accounting periods currently closed
Repetitive schedules cancelled or completed with no charges in a closed accounting period
All detail information including material requirements, resource requirements, and operations associated with jobs and schedules
Move and/or resource transactions associated with jobs and repetitive schedules
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
Navigate to the Purge Jobs and Schedules window. The Parameters window appears.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
Choose OK.
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
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:
Purge Discrete Jobs
Purge Repetitive Schedules
Purge Discrete Jobs/Repetitive Schedules (SRS)
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.
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
Submitting a Request, Oracle E-Business Suite User's Guide
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.
In the Submit Requests window, select Repetitive Line Report in the Name field.
To restrict the report to a range of lines, select a beginning and an ending line.
To restrict the report to a range of lines, select a beginning and an ending assembly.
To restrict the report to a date range, select a beginning and an ending date.
Related Topics
Overview of Repetitive Manufacturing
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.
In the Submit Requests window, select Repetitive Pick List Report in the Name field.
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. |
Select Yes or No to indicate whether to exclude repetitive schedules with statuses of Unreleased or On Hold.
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.
Select the number of days of supply that you want to calculate requirements for.
To restrict the report to a range of lines, select a beginning and an ending line.
To restrict the report to a range of assemblies, select a beginning and an ending assembly.
Choose a Supply Type. The available options are Push, Pull, Bulk, and Vendor. See: Supply Types.
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
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.
In the Submit Requests window, select Repetitive Routing Sheet in the Name field.
Select a repetitive assembly. If you do not select an assembly, the system lists routing information for all schedules defined for the line selected.
Select a production line. If you do not select a line, the system displays routing information for all schedules defined for the assembly selected.
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
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.
In the Submit Requests window, select Repetitive Schedule Data Report in the Name field.
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.
To restrict the report to a range of assemblies, select a beginning and an ending assembly.
To restrict the report to a range of lines, select a beginning and an ending line.
To restrict the report to a date range, select a beginning and an ending date.
Related Topics
Overview of Repetitive Manufacturing
Submitting a Request, Oracle E-Business Suite User's Guide
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.
In the Submit Requests window, select Repetitive Schedule Shortage Report in the Name field.
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. |
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.
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.
Select Yes to indicate whether to include bulk-provided material requirements.
Select Yes to indicate whether to include supplier-supplied material requirements.
Select the number of supply days ahead of today that the system uses to calculate open requirements and shortages for your repetitive schedules.
To restrict the report to a range of lines, select a beginning and an ending line.
To restrict the report to a range of assemblies, select a beginning and an ending assembly.
To restrict the report to a range of component, select a beginning and an ending component.
Related Topics
The repetitive shop packet consists of four reports:
Related Topics
Submitting a Request, Oracle E-Business Suite User's Guide
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.
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.
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. |
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.
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.
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.
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.
To restrict the report to a range of assemblies, select a beginning and an ending assembly.
To restrict the report to a range of production lines, select a beginning and an ending line.
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
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.
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.
To restrict the report to a range of resources, select a beginning and an ending resource.
To restrict the report to a range of departments, select a beginning and an ending department.
Select a beginning date.
Select an ending date.
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.
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
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.
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.
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. |
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.
To restrict the report to a range of jobs/schedules, select a beginning and an ending job or repetitive schedule.
To restrict the report to a range of resources, select a beginning and an ending resource.
To restrict the report to a range of production lines, select a beginning and an ending line.
To restrict the report to a range of assemblies, select a beginning and an ending assembly.
To restrict the report to a date range, select a beginning and an ending date.
To restrict the report to a range of employees, select a beginning and an ending employee.
To restrict the report to a range of employees, select a beginning and an ending reason.
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
The Schedule Group Listing lists all information about schedule groups.
In the Submit Requests window, select Schedule Group Listing in the Name field.
To restrict the report to a range of schedule groups, select a beginning and an ending schedule group.
Related Topics
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.
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
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.
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.
To restrict the report to a range of transaction dates, enter a beginning and ending date.
Select a specific general ledger accounting flexfield.
Select a general ledger batch number. The system lists information by account for each account in the selected batch.
Select a specific job or repetitive assembly.
Select a production line.
Select an assembly.
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. |
Select a department name.
Select an activity.
Select a WIP accounting class name.
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.
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
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.
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.
To restrict the report to a range of transaction dates, select a beginning and an ending date.
Select a general ledger accounting flexfield.
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
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.
In the Submit Requests window, select WIP Accounting Classes Report in the Name field.
Related Topics
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.
In the Submit Requests window, select WIP Location Report in the Name field.
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. |
To restrict the report to a range of jobs or repetitive schedules, select a beginning and ending job/schedule.
To restrict the report to a range of production lines, select a beginning and an ending line.
To restrict the report to a range of assemblies, select a beginning and an ending assembly.
To restrict the report to a range of departments, select a beginning and an ending department.
Related Topics
Submitting a Request, Oracle E-Business Suite User's Guide
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.
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.
To restrict the report to a range of accounts, select a beginning and an ending accounting flexfield.
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
The WIP Outside Processing Report lists outside processing information for jobs or repetitive schedules. The system lists all purchase orders associated outside processing resources.
In the Submit Requests window, select WIP Outside Processing Report in the Name field.
To restrict the report to a range of jobs or repetitive schedules, select a beginning and ending job/schedule.
To restrict the report to a range of assemblies, select a beginning and an ending assembly.
To restrict the report to a range of production lines, select a beginning and an ending line.
Choose a status. See: Discrete Job Statuses or Repetitive Schedule Statuses.
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
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.
In the Submit Requests window, select WIP Parameters Report in the Name field.
Related Topics
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.
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.
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. |
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.
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.
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. |
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.
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.
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.
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.
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
Submitting a Request, Oracle E-Business Suite User's Guide