E1: UBE: ENV: When Submitting R31410 or Any Custom Ube Which Uses B314101 (GetNumSelectParams) Business Function on Different Batch Servers, the Results of R31410 Are Different Because the Number of Data Selection Paramters Cannot Be Determined (Doc ID 2988074.1)

Last updated on NOVEMBER 24, 2023

Applies to:

Symptoms

When R31410 or any custom UBE which is using B314101 (GetNumSelectParams) to determine the number of the data selection parameters, on different servers (e.g Batch1 and Batch2), the results of UBE processing are different.

For example, when the UBE is submitted on Batch1, the UBE produces the expected results, but if the same UBE is submitted on Batch2, the UBE does not produce the same results. Both batch servers are using the same full package and the UBE is having the same object specifications.

The UBE debug log for the job submitted on Batch2 server shows the following information:

Steps to replicate:

1. Submit one R31410 version to be executed on Batch1.
2. Check the results and notice that they are as expected.
3. Submit the same R31410 version on Batch2, check the results and notice that they are not the expected ones.

Changes

Cause

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