Data Selection of Sales Order Batch Price/Cost Update (R42950) in Running Calling UBE in Local Environment

Purpose of Document

Issue

The data selection of Sales Order Batch Price/Cost Update R42950) when called by Print Invoice (R42565) and Sales Update (R42800) does not match. For testing purpose, we have run R42565/R42800 on local machine. It takes long time to run with huge data selection for R42950. What wentr wrong?

Solution

This is working as designed, working per the current design.

This functionality will be working fine only when:

Calling UBE (R42565/R42800) are running in server

Called Version of R42950 does not contain any Data Selection in it

See 656362.1 to understand RuntimeCache and UBEOverride in Spec directory of your Logic/Batch Server

The different results seen when running on the server versus running on the full client are caused by BSFN B0000196 - UseReportDataSelection (Use Report Data Selection)

When submitting Print Invoice to the server, it gets data selection (RDASPEC) of R42565 (for example) Z:\JDEdwards\E900\DDP\6016\PD900\spec\UBEOverride\ where runtime Data Selection is stored in clicking Submit Button

When submitting Print Invoice locally, data selection is retrieved on the Local machine(by override location) from localspec (DS Local - PD900 Specs)

SELECT * FROM SPEC_ESU900A.F98761ESU900A WHERE ( RSOBNM = 'R42565' AND RSVERS = 'XJDE0019' AND RSRCRDTP = 7.000000 AND RSGNCID1 = 1 )
SELECT * FROM SPEC_ESU900A.F98761ESU900A WHERE ( RSOBNM = 'R42565' AND RSVERS = '+' AND RSRCRDTP = 7.000000 AND RSGNCID1 = 1 )

The functionality of B0000196 - UseReportDataSelection is working only when R42565/R42800 are submitted to the server. The local RDASPEC does not store runtime data selection information. The RDASPEC difference between the server and client is in constructing runtime data selection. For this example, R42565, R42800 and R42950 are making use of same table (F4211 - Sales Order Detail). The data selection can be inherited from calling UBE to called UBE.

Note

Runtime Data Selection refers to the data selection defined when the data selection is reviewed/revised during UBE submission:

1. Go to Batch Versions and inquire on R42565 - Print Invoice
2. Select a Version. In the version prompt, note there are two user override options, Data Selection and Data Sequence.
3. Select the option for Data Selection then populate the Data Selection window.

Runtime Data Selection refers to the runtime cache which is constructed based on the Data Selection window. If there is any Appended Data Selection in 'Initialize Section' event, it will not take effect on the data selection of R42950.

Currently R42950 can be called from the following options:

Standalone

Called by Print Invoice (R42565)

Called by Sales Update (R42800)

Called by Orders Affected by Price Chg (R40821)

cf., For subsystem version only RI values will affect the result

a. Mode 1

B0000196 - UseReportDataSelection (Use Report Data Selection)
R42565 -> szReportName
RI szVersion -> szVersion
1 -> idSectionID

b. Mode 2

B0000196 - UseReportDataSelection (Use Report Data Selection)
R42800 -> szReportName
RI szVersion -> szVersion
6 -> idSectionID

c. Mode 3

this does not specify any information other than mode as R42950 is to be called at the end of transaction (written at 'End Section' event)

Meanwhile, to call R42950 before/after calling UBEs:

A. Print Invoice (R42565)

Tab: Cost/Price Update
Parameters

Item #1. Update Cost: 1 (= Update Item Costs)
Item #2. Sales Price/Cost Update Versions (R42950): Specific Version - if you do not specify this parameter the default version ZJDE0001 is used

B. Sales Update (R42800)

Tab: Cost Update
Parameters

Item #1. Update Cost: 1 (= Update Item Costs)
Item #2. Sales Price/Cost Update Versions (R42950): Specific Version - if you do not specify this parameter the default version ZJDE0001 is used

C. Orders Affected by Price Chg (R40821)

Tab: Process
Parameters

Item #3. Enter a value of '1' to update price: 1 (= Update Cost before you run R40821)
Item #4. If you have entered a '1' for previous selection. Set Version

NOTE: In case the customer's case Daily Business Logic requires it (e.g., R42565) to be run in Local (check PDF result and print) make it sure that the data selection of R42950 is to be same data selection which is waiting for Print Invoice (For instance, ShipDate = 'SL Date Today' and Next Status = 'Waiting for Invoice').