E1: UBE: UBE Ignores Runtime Data Selection Changes and Executes with Previously Saved Data Selection (Doc ID 2767649.1)

Last updated on AUGUST 08, 2024

Applies to:

Symptoms

Reports /UBEs, which are submitted from "Work with Batch Versions" application with modified runtime data selection, are ignoring the data selection changes that are made during submission. It is observed that instead of using the modified runtime data selection, the UBE executes with data selection that was already saved in the version specification and was stored on server during first execution of the version.

This issue may be replicated using the steps below:

1. Login to web client.
2. Type 'BV' in fast path to open "Work With Batch Versions" Application (P98305W).
3. Find the versions of report R0006P and select the Version XJDE0002.(Checkmark)
4. Take row exit for data selection to verify below data selection is saved. (Where Company = 00020, 00900 and 00999)
   
5. Submit the version on server. (This step ensures Server specs installed if not installed already)
6. Select the version again for submission and select prompt for data selection.
   
7. Click Submit.
8. On the next prompt, change the data selection to “Where Company=00030”.
   
9. Proceed to submit the job on server.
10. Type WSJ in fast path, to open "Work with Submitted Jobs" and find the Job submitted. Alternatively Click on the report job in recent reports section of carousel to directly open the job in WSJ.
11. Select the job record for R0006P-XJDE0002 and take row exit for Execution Detail.
12. Go to Data selection tab and notice the job was submitted with pre-saved data selection instead of modified data selection given at runtime. i.e ”Company=00020,00900,00999” instead of “Company=00030”
    

Changes

 Tools release upgrade to 9.2.5.2

Cause

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