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 laterInformation 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 |