Error In FTI When Joining Shipment And Order Tables (Doc ID 1140649.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

The following error is received when attempting to create an ad hoc query by joining the shipment and order tables.

ERROR
-----------------------
Odbc driver returned an error (SQLExecDirectW).
Error Details
Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65PState: HY000. Code: 10058. NQODBC SQL_STATE: HY000 nQSError: 10058 A general error has occurred. nQSError: 14026 Unable to navigate requested expression: Shipment Details.FTI Shipment GID. Please fix the metadata consistency warnings. (HY000)SQL Issued: SELECT "- Shipment Details"."FTI Shipment GID" saw_0, "- Order Details"."Late Delivery Date" saw_1 FROM "Fusion Transportation Intelligence" ORDER BY saw_0, saw_1


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to Transportation Intelligence  --> Ad Hoc Query
2. Click on the "Create a New request" icon
3. Click on Fusion Transportation Intelligence
4. Expand Shipment Analysis
5. Expand Shipment Details
6. Click on "FTI Shipment GID"
7. Scroll down to Order Analysis, and expand it
8. Expand Order Details, then click on "Late Delivery Date"
9. Under the Criteria on the right hand side, click on the display results button
10. Note the error received.

Cause

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