# Oracle EBS WIP Discrete Job Close Variance Worksheet

> Source: https://netray.co/tools/oracle-ebs-wip-job-close-variance-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Editable worksheet to review material and resource variances per discrete job before running the close, with variance percent and totals.

## Category

oracle

## Erp

Oracle E-Business Suite

## Industry

Discrete Manufacturing

## Audience

- Cost accountant
- EBS consultant
- Plant controller

## Tool

**Kind:** worksheet

**Mode:** editable

**Currency:** $

**Columns:**

#### Job

**Key:** job

**Type:** text

#### Assembly

**Key:** assembly

**Type:** text

#### Qty completed

**Key:** qty_done

**Type:** number

**Unit:** units

#### Std material

**Key:** std_mat

**Type:** number

**Format:** currency

#### Actual material

**Key:** act_mat

**Type:** number

**Format:** currency

#### Std resource and overhead

**Key:** std_res

**Type:** number

**Format:** currency

#### Actual resource and overhead

**Key:** act_res

**Type:** number

**Format:** currency

#### Material variance

**Key:** mat_var

**Type:** number

**Expr:** act_mat - std_mat

**Format:** currency

#### Resource variance

**Key:** res_var

**Type:** number

**Expr:** act_res - std_res

**Format:** currency

#### Total variance

**Key:** tot_var

**Type:** number

**Expr:** (act_mat - std_mat) + (act_res - std_res)

**Format:** currency

#### Variance % of standard

**Key:** tot_pct

**Type:** number

**Expr:** if(gt(std_mat + std_res,0),((act_mat - std_mat) + (act_res - std_res)) / (std_mat + std_res) * 100,0)

**Format:** percent

#### Reviewed

**Key:** reviewed

**Type:** select

**Options:**

- No
- Yes
- Hold

**Rows:**

**Job:** J-104211

**Assembly:** AS-10045

**Qty done:** 100

**Std mat:** 8200

**Act mat:** 8460

**Std res:** 3100

**Act res:** 3340

**Reviewed:** Yes

**Job:** J-104238

**Assembly:** AS-20310

**Qty done:** 40

**Std mat:** 12400

**Act mat:** 12150

**Std res:** 2200

**Act res:** 2260

**Reviewed:** No

**Job:** J-104302

**Assembly:** FG-77120

**Qty done:** 25

**Std mat:** 6800

**Act mat:** 7310

**Std res:** 1900

**Act res:** 2480

**Reviewed:** Hold

**Job:** J-104355

**Assembly:** AS-10045

**Qty done:** 150

**Std mat:** 12300

**Act mat:** 12290

**Std res:** 4650

**Act res:** 4600

**Reviewed:** No

**Totals:**

#### Total material variance

**Key:** mat_var

**Agg:** sum

**Format:** currency

#### Total resource variance

**Key:** res_var

**Agg:** sum

**Format:** currency

#### Total job variance

**Key:** tot_var

**Agg:** sum

**Format:** currency

**Summary:**

#### Average variance per job

**Key:** avg_var

**Expr:** sum_tot_var / count

**Format:** currency

**Primary:** true

**Notes:** Positive variance here means actual exceeded standard (unfavourable). Check the sign convention of your own variance accounts in the WIP accounting classes before posting anything.

## Content

**Intro:** Before closing discrete jobs, controllers want to see which jobs carry the largest variances and why. This worksheet lets you lay out standard and actual cost per job, compute material and resource variance, and mark jobs reviewed.

**Sections:**

#### How to use it

**Body:** Pull the job list that is complete and ready to close, along with standard and actual cost by element from your WIP value or job cost reports. Enter each job on a row. The sheet computes material variance, resource and overhead variance, total variance and the percentage of standard. Use the Reviewed column to track which jobs have been explained or are on hold, then export for your month-end close file.

**Bullets:**

- Include only completed jobs with no open transactions
- Keep material and resource separate to find the cause faster
- Mark Hold for jobs with missing charges or pending returns

#### Where variances come from in Oracle WIP

**Body:** In standard costing, completing a job relieves the standard cost of the assembly. The difference between what was charged to the job and what was relieved at completion is held in the job, then written to variance accounts when the job is closed. Material usage variance, resource efficiency, resource rate and overhead variances are tracked separately, and the accounts come from the WIP accounting class. Reviewing before close avoids surprises in the period results.

#### Reading the results

**Body:** A job with a large percentage but small value is often a short-run issue. A job with a modest percentage on a large value deserves more attention. Persistent material overruns across many jobs of the same assembly suggest the bill of material yield or scrap factors are wrong. Persistent resource variances suggest routing times or rates are out of date. Fix the source data, not just the jobs, or the same variance returns each month.

#### Common mistakes

**Body:** Do not close a job while material is still issued but not returned, or while resource transactions are pending. Check that over-completions and scrap transactions are posted. Remember that closing is period-driven: the variance posts in the period you choose, so align with your calendar. Always document why large variances were accepted, because auditors look for that note.

**Cta:** If you would like these variances pulled automatically from WIP tables with an explanation per job, Netray can discuss a read-only reporting layer over your EBS data.

**Faq:**

#### Does this post anything to Oracle?

**Answer:** No. It is an offline working sheet in your browser. Closing jobs and posting variances is done in Oracle WIP by an authorised user. This tool only helps you review and document first.

#### Does it work for average costing?

**Answer:** The arithmetic works, but average costing handles variances differently, with fewer variance accounts in WIP. Use the columns as a comparison of planned versus actual cost and adapt the labels.

#### What is a good variance threshold?

**Answer:** Many plants investigate anything above a few percent of standard or above a fixed currency amount. Pick thresholds with your controller and keep them consistent between periods.

#### Can I paste rows from Excel?

**Answer:** Use the add row control and type or paste cell values where the interface allows. You can also export, edit in Excel and keep your own copy of the results.

## Search terms

oracle ebs wip job close variance, discrete job close variance worksheet, oracle wip variance analysis excel, ebs job close checklist, wip variance review template, oracle wip close discrete jobs

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json