My Oracle Support Banner

Unable to check the UCM File Upload Status (Doc ID 2946817.1)

Last updated on MAY 10, 2023

Applies to:

Oracle Financial Services Data Integration Hub - Version 8.1.1.1 and later
Information in this document applies to any platform.

Symptoms

On : DIH 8.1.2 and above versions,


When attempting to view the status of the document upload to UCM, Unable to get status of UCM document upload, the status is shown as Error.

ERROR
-----------
in DIH.log

[INFO ] [DBConnect][getConnection]Connection: weblogic.jdbc.wrapper.PoolConnection_oracle_jdbc_driver_T4CConnection@b0c56
[ERROR] [QueryRunnerUtils][getQueryClobResults]ORA-01795: maximum number of expressions in a list is 1000
 
java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in a list is 1000

STEPS
-----------
The issue can be reproduced at will with the following steps:
1. Try to execute the batch that generates the ZIP file and uploads to UCM
2. Once the batch is executed, navigate to Subledger screen , select the SLA and check for the document upload status


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot verify the UCM upload file status.

Changes

 N/A

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution


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