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

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

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