E1: UBE: Data Sequencing, Data Selection and SQL Statement Details Fetched From Work With Submitted Jobs Are Displayed as oracle.sql.NCLOB@<ID> When Viewing From Web Client (Doc ID 2988521.1)

Last updated on NOVEMBER 27, 2023

Applies to:

Symptoms

When attempting to view the data sequencing, data selection or SQL statement from Job Execution Details (P986114A) the details stored in F986114A in Oracle Database are displayed as oracle.sql.NCLOB@<ID>

If user specific debug logging is enabled on JAS server, the same data is also captured into the debug log:

If for the same job number, the execution details are viewed from a Development (FAT) client, the details are displayed as expected, but they are also displayed as oracle.sql.NCLOB@<ID> when connected from local web.

Steps to replicate:

1. Login on JAS server
2. Open Work with Submitted Jobs and select an already submitted UBE
3. Check the Execution Details and select the either Data Sequencing, Data Selection or SQL Statement tab

Cause

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