My Oracle Support Banner

E1: 49: Partial Ship Confirm (P4205) Performs an Invalid and Unnecessary Validation on Extended Amount Calculation (Doc ID 2930985.1)

Last updated on JULY 12, 2023

Applies to:

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

Symptoms

When Shipment Confirmation (P4205) is done for partial quantity of the order line, with Interop activated in the processing options ShipConfirmEndDoc (N4200790) performs an incorrect and unnecessary validation.

The UpdateOrderTotalInF4201 (B4200250) business function called by ShipConfirmEndDoc (N4200790) makes an incorrect validation because it compares an amount with a 4 decimal number to an amount with a 2 decimal amount. These amounts can never match exactly because of the decimal difference. This makes this an incorrect and unnecessary validation.

STEPS TO REPRODUCE:

These steps are using demo data from an Oracle Test Environment. No actual personal data is revealed. 
  1. Set Exchange Rate (P0015A) to 1.234568 USD per EUR.
  2. Item is in Italian Branch 7403. Pricing UOM is EA. UOM Conversion is 1 CA = 12 EA.
  3. Enter a sales order as follows:
    1. USD Currency Customer (595244)
    2. EUR Currency Branch Plant (74)
    3. Exchange Rate = 1.234568 USD per EUR
    4. Quantity Ordered = 10 CA
    5. Foreign Unit Price = 115.2000 USD per EA
    6. Foreign Extended Price = 13,824.00 USD
  4. Run Pick Slip Print (R42520). Price in EUR is 142.2222 (115.2 USD x 1.234568)
  5. Ship Confirm (P4205) 9 of 10 CA with Debug Logs activated.
    1. There is no Error on the Ship Confirm (P4205) screen
    2. One Sales Order Line with Quantity 9 at status 580 Shipped
    3. One at Status 560 awaiting shipment
  6. Review Debug Log
    1. The business function UpdateOrderTotalInF4201 (B4200250) shows a small rounding difference while comparing a 4 decimal value to a 2 decimal value.
      • mnDomesticCrntDomesticExtndedAmnt [17066.6664
      • mnDomesticPrevExtndedAmnt [17066.66] 
    2. The Business Function XPILoadUnloadCache (B4003000) returns the error Add to Cache Failed Error (078O).
  7. When the process is done by BSSV or services that calls the ShipConfirmEndDoc (N4200790) the transaction fails.

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.