My Oracle Support Banner

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:

JD Edwards EnterpriseOne Configurator - Version 9.2 and later
Information in this document applies to any platform.


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.




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

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