My Oracle Support Banner

Querying Tables from OTM/GTM Archive Schema Through SQL Servlet Throwing Error - 'Undefined' OR 'table or view does not exist' (Doc ID 3029610.1)

Last updated on JUNE 21, 2024

Applies to:

Oracle Transportation Management Cloud Service - Version 19.3 and later
Oracle Global Trade Management Cloud Service - Version 19.3 and later
Information in this document applies to any platform.

Symptoms

When OTM / GTM customer is querying for tables in Archive schema through SQL Servlet, it is throwing error of "An Undefined Error Has Occurred. Please Try Again Later." in OTM UI.


User/Exception log shows the error of "java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist".


Sample Error would be similar to below when user executes the SQL SELECT * FROM ARCHIVE_C.INVOICE in SQL Servlet

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.