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

Last updated on MARCH 08, 2017

Applies to:

Oracle Fusion Transportation Intelligence - Version 6.0 and later
Information in this document applies to any platform.
***Checked for relevance on 04-Dec-2012***

Symptoms


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
Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P:OI2DL65P
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

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms