My Oracle Support Banner

E1: 31A: R31802A Doubles F3102 Completed Amount (CPAT) (Doc ID 2105409.1)

Last updated on FEBRUARY 24, 2020

Applies to:

JD Edwards EnterpriseOne Shop Floor Control - Version 9.0 to 9.2 [Release 9.0 to 9.2]
Information in this document applies to any platform.

Symptoms

E1 9.1 / R31802A Manufacturing Accounting

CPAT is doubled every time R31802A is run across the same work order.
Because CPAT is doubling, with the next completion (same work order), the F4105 (cost method 02, Actual/Average Cost) calculation results with an incorrect value.

This occurs when the work order (parent) Item is setup with cost method 02 (Actual/Average Cost).

Example: Material Issues (P31113) have been transacted, Labor (P311221) has been reported and one (1) unit has been completed (P31114).

F3102 results after each R31802A execution (no additional completions performed):

     CPUN    CPAT     F4105 (02 Cost Method)
1st    1      58.24     58.24  
2nd   1     116.48    58.24  
3rd   1     232.96    58.24
4th   1     465.92    58.24
5th   1     931.84    58.24

Notice that CPAT is doubled every time (after the first) R31802A is run across the order.
Now, complete another one (1) unit on the work order.
The F4105 02 cost method cost value is calculated incorrectly as it is now based on the latest CPAT (931.84):  {(58.24)+(58.24-931.84)}/2 = 407.68.
Had there been no doubling in the F3102, the new unit cost on the completion on the second 1 EA would have been (58.24+0)/2= 29.12

**Following is a list of Bugs that address similar/related issues:
9.1 BUG 16849110 - R31802A Generating Recurring IS Entries (9.0 Bug 16826710)

9.1 BUG 18440874 - Duplicate IS Transactions When Running R31802A (9.0 - Bug 18189077)

9.1 BUG 18440888 - No Journal Entries For Negative Scraps (9.0 Bug 18367513)

9.1 BUG 20755321 - Completed A1 Amount Is Doubling In F3102 Each Time R31802A Is Run (9.0 Bug 20731626)

9.1 BUG 21554838 - R31802A Fails However F3102 Are Still Created For Work Order In Error (9.0 - Bug 21843181)

9.1 BUG 23145375 - 09 Costing With Zero Out Material Cost

9.1 Bug 25999307 - R31802A Errors but Batch is Updated to F4111

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.