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

Last updated on MARCH 01, 2024

Applies to:

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)

• Object Affected - B3104180

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

• Object Affected - B3104180
• Object Affected - B3101630

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

• Object Affected - B3104180

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

• Object Affected - B3104180

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

• Object Affected - R31802A

9.1 BUG 23145375 - 09 Costing With Zero Out Material Cost

• Object Affected - B3104180

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

• Object Affected - B3104175

Cause

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