My Oracle Support Banner

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

Last updated on JANUARY 23, 2018

Applies to:

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


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, the user makes a change to 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. When the user changed quantity at ship confirm, R42950 then updated the data back to what it was before running.

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

If a sales order 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 after cache was created. The fact that the sales order record is reserved for the update will not be beneficial nor effective, 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.




To view full details, 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 a vibrant support community of peers and Oracle experts.