Repetitive Value Report (Oracle Work in Process)


	Previous	Next		Contents	Index	Glossary	Library

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.

Report Parameters

Report Type

Choose one of the following options:

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 Summaryeach 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.

Attention: 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.

Attention: 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.

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	Summaryeach assembly and line and includes repetitive schedule header and account information. The system also lists summary elemental account values for each repetitive schedule.