|
Incorrect Costs For Wip Assembly Return To Discrete Job Using Average Costing (文档 ID 788680.1)
|
In this Document
Applies to:
Oracle Cost Management - Version 11.5.10.2 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.
Symptoms
Find using the average cost method and our orgs are Project
Manufacturing enabled. WIP Assembly returns to a job are supposed to be
costs at the average unit value for completions from that job.
Material
was issued to the job in the AUG-08 period at $2,774.81 and the job was
fully completed (8 ea) at the same total cost in the same period.
In
the following period (SEP-08), OSP resource costs of $1800 were
received to the job. In an attempt to absorb this additional cost, all 8
were returned using the WIP Assembly return
transaction then all 8
were completed again using WIP Assy Completion transaction. Oracle
costed the WIP assembly return at $0 cost.
This is incorrect. It
should have returned 8 at $2,774.81 for a unit cost of $346.85. Then,
the 2nd WIP assembly completion was costed at $4,574.81 ($2,774.81 +
$1800) Essentially, the $2,774.81 material cost on the job was absorbed
to inventory twice
EXPECTED BEHAVIOR
Expect ...8 returned at $2,774.81 for a unit cost of $346.85
-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. Open a standard discrete job in a manufacturing org using average cost method.
The routing should have an OSP resource requirement. the BOM should have one costed material component.
2. Issue material to the job and fully complete the job in one accounting period.
3. Close the accounting period
4. Receive OSP resource costs in the next period.
5. Do a WIP assembly return of all quantity completed. Then, do another final WIP assy completion
Changes
Cause
Code Issue
The material costs incurred against some operations (new operations) were not being relieved through the completion transactions
Solution
EBS 11.5.10.X
-- To implement the solution, please execute the following steps:
1. Download and review the readme and pre-requisites for Patch 7520866
bom
|
patch/115/sql
|
CSTLCACB.pls
|
115.6.115100.6
|
bom
|
patch/115/sql
|
CSTLCASB.pls
|
115.3.115100.4
|
bom
|
patch/115/sql
|
CSTPACCB.pls
|
115.17.115100.12
|
bom
|
patch/115/sql
|
CSTPACSB.pls
|
115.8.115100.8
|
|
You can use the commands like the following:
strings -a $BOM_TOP/filename |grep '$Header'
5. Retest the issue.
6. Migrate the solution as appropriate to other environments.
---------------------------------------------------------------------
EBS 12.1.X
To implement the solution, please execute the following steps:
1) Please download and review the readme for Patch 11805897:R12.BOM.C
2) Please apply Patch 11805897:R12.BOM.C in a test environment.
3) Please confirm the following file versions:
CSTPACCB.pls 120.8.12010000.8
CSTPACSB.pls 120.2.12010000.4
CSTLCACB.pls 120.2.12010000.4
CSTLCASB.pls 120.1.12010000.3
4) Please retest the issue.
5) If the issue is resolved, please migrate the solution as appropriate to other environments.