My Oracle Support Banner

"Sample Sales" Reports Fail with: Unresolved Table (Doc ID 1330343.1)

Last updated on MAY 06, 2022

Applies to:

Oracle Fusion Transportation Intelligence - Version 6.0 and later
Information in this document applies to any platform.


After installing FTI, it is found that there are some pre-installed sample reports when accessing the AdHoc Query, called "Sample Sales". When trying to run these sample reports and it is failing with the following error:

View Display Error
Odbc driver returned an error (SQLExecDirectW).
Error Details
State: HY000. Code: 10058. NQODBC SQL_STATE: HY000 nQSError: 10058 A general error has occurred. nQSError: 27004 Unresolved table: "Sample Sales". (HY000)
SQL Issued: {call NQSGetQueryColumnInfo('SELECT "D0 Time"."T00 Calendar Date", "D0 Time"."T01 Per Name Week", "D0 Time"."T02 Per Name Month", "D0 Time"."T03 Per Name Qtr", "D0 Time"."T04 Per Name Half", "D0 Time"."T05 Per Name Year", "D1 Customer"."C-00 Cust Key (Segmentation)", "D1 Customer"."C0 Cust Key", "D1 Customer"."C1 Cust Name", "D1 Customer"."C2 Cust Status", "D1 .....

Steps to replicate:

1. Install FTI for OTM
2. Navigate to Transportation Intelligence -> Ad Hoc Query
3. Navigate to Shared Folders -> Sample Sales
4. Click on any report


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

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