E1: 42: Enhancement Request to Redesign the Report R42950 Update Sales Price/Cost and Record Reservation Method (Doc ID 2245837.1)

Last updated on MARCH 20, 2017

Applies to:

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

Symptoms

 The customer is facing a big problem with R42950 related to the way it processes the data. It is running exchange rate update for the whole company, and it takes around 20 minutes. Due to fact that the customer has operations in North and South America, Europe, and Asia, it is not so easy to find a time slot where no user is working in the system. In those 20 minutes while the report is running, user manages to change an order (e.g. ship confirm it). The way this report works is, that in the beginning of the run, it will create a cache with all the data (orders selected, quantities, unit price, extended price, unit cost, extended cost). When the report comes to this record to actually process it, it does not check if in the meantime the data was not changed. So it has happened, that when the user changed quantity at ship confirm, R42950 then updated the data back to what it was before.

The record reservation method of R42950 is done only when the actual update of the record happens, but the data can already be 15-20 minutes old by this time, the record already released, and the issue happens. The customer has split the processing of R42950 into multiple batches, per branch but he are using extensively the SI-SK/OK process, which means that in each transaction are two sites involved. In many cases these are in different timezone, so there is always a risk using this kind of scheduling for R42950.

If the record is towards the end of the processing (e.g. 20 minutes have already passed since the cache was created), it can be already changed in the meantime, and the fact that it is reserved for the update will not help, as
it will be updated with "old" data.

The customer would require a redesign of the report R42950 and of the record reservation method for this report.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms