E1: 32: Order Processing - R31410 Divides Standard Amount (F3102.OPAT) for Transaction Type 4 Configured Purchased Items by 100 for Currency Codes Having Zero Decimal Places (Doc ID 2872149.1)

Last updated on MAY 26, 2022

Applies to:

Symptoms

When using either a Company, Supplier Number and / or Customer Number defined with default Currency Code using zero decimals (e.g. JPY or HUF), the Standard Amount (Alias: OPAT) calculated in Production Cost Inquiry - P31022 / F3102 by the Order Processing - R31410 UBE for a Transaction Type 4 configured purchased item is always divided by 100.
All related purchase orders, sales order detail lines and other related details (e.g. Cardex - P4111) are updated correctly with the Unit Cost / Extended Cost determined during the sales order creation.

The issue can be reproduced at will with the following steps:

1. P0010 - Choose a company using a default Currency Code having zero decimal places (e.g. Japanese Yen)
2. P01012 - Define Customer Number and Supplier Number to use JPY as Default Currency Code
3. P4101 / P41026 - Define one configured top parent item and one configured child (Stk Ty = C, Ln Ty = W), one purchased configured item (Stk Ty = C, Ln Ty = S) and a simple purchased component (Stk Ty = P, Ln Ty = S)
4. P4105  - Add blank Unit Cost for Sales / Inventory Cost Method for all configured items and a non-blank Unit Cost for Sales / Inventory Cost Method for the purchased component - 07 Unit Cost of the purchased component is 4.3700
5. R30812 & R30835 - Simulate and freeze the 07 - standard cost for the purchased component
6. P3291 - Define segments for each configured item
7. P3293 - Define P AIR rules for all configured items
   - unconditional P AIR for cfg top parent item to call the configured child
   - unconditional P AIR for configured child to call the purchased configured item; set Trans Type = 4 and above Supplier Number, in order to generate a purchase order for the purchased configured item
   - unconditional P AIR for the purchased configured item to call purchased component, with a Required Quantity = 100 units
8. P4210 ZJDE0008 - Create a sales order for the configured top parent item for a Requested Quantity of 1 unit
9. P4210 - Unit Cost of the configured top parent item sales order detail line is calculated correctly as 4.3700 x 100 = 437.0000 and Extended Cost = 437
10. P48013 - Review the works orders related to the above configures sales order
11. R31410 - Process the related work orders, by using a descending data sequencing; make sure the processing option for Standard Cost Calculation is set to either 1 or 2 in the 6-Sales/Config tab
12. P31022 - Check the low-level work order created for the configured child. The Standard Amount bucket for A1 - Material Cost Type is calculated incorrectly to 4.37 instead of 437
13. P4310 - Check the related OP order and see the correct Unit Cost = 437.0000 and Extended Cost = 437 JPY
14. P4312 - Receive the related OP order (and do Material Issues in the same time)
15. Databrowser: F3111 - Unaccounted Direct Labor Amount (F3111.CTS4) field is updated correctly with 437.00. This creates incorrect variances during accounting process.

Changes

Cause

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