OTM FTI Display Error When Drilling Down Into Data (Doc ID 871553.1)

Last updated on MARCH 14, 2013

Applies to:

Oracle Fusion Transportation Intelligence - Version 5.5.04 to 6.1
Information in this document applies to any platform.
***Checked for relevance on 14-Mar-2013***


Symptoms

-- Problem Statement:

When clicking on the statistics graph in the performance area of Transportation Intelligence the following error is seen:

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has
occurred. [nQSError: 23013] An error occurred when extracting the metadata definition for the
Attribute '"Fusion Transportation Intelligence"."D_SHIPMENT"."SHIPMENT_GID_LINK"'. [nQSError:
23005] The repository variable, WEB_SERVER, has no value definition. (HY000)
SQL Issued: {call NQSGetQueryColumnInfo('SELECT "- OLTP Shipments".SHIPMENT_GID_LINK, "- Shipment
Details"."Shipment Date", "- Shipment Details"."Total Weight Base", "- Shipment Details"."Total
Weight UOM Code", "- Shipment Details"."Total Weight", "Destination Geography"."Destination
Country", "Destination Geography"."Destination Province", "Destination Geography"."Destination
Region", "Destination Geography"."Destination XID", "Source Geography"."Source Country", "Source
Geography"."Source Province", "Source Geography"."Source Region", "Source Geography"."Source XID",
"Transport Mode"."Mode XID", Carrier."Carrier XID", Period."Day of Week", Period."Month",
Period."Year", Period.Event, Period.Holiday, Period.Quarter, Period.Season, Period.Week,
VALUEOF(NQ_SESSION.WEIGHT), substring("- Shipment Details"."AA Shipment GID",Position(''.'' IN "-
Shipment Details"."AA Shipment GID")+1,length("- Shipment Details"."AA Shipment GID")) FROM
"Fusion Transportation Intelligence"')}
SQL Issued: SELECT "- OLTP Shipments".SHIPMENT_GID_LINK, "- Shipment Details"."Shipment Date", "-
Shipment Details"."Total Weight Base", "- Shipment Details"."Total Weight UOM Code", "- Shipment
Details"."Total Weight", "Destination Geography"."Destination Country", "Destination
Geography"."Destination Province", "Destination Geography"."Destination Region", "Destination
Geography"."Destination XID", "Source Geography"."Source Country", "Source Geography"."Source
Province", "Source Geography"."Source Region", "Source Geography"."Source XID", "Transport
Mode"."Mode XID", Carrier."Carrier XID", Period."Day of Week", Period."Month", Period."Year",
Period.Event, Period.Holiday, Period.Quarter, Period.Season, Period.Week,
VALUEOF(NQ_SESSION.WEIGHT), substring("- Shipment Details"."AA Shipment GID",Position('.' IN "-
Shipment Details"."AA Shipment GID")+1,length("- Shipment Details"."AA Shipment GID")) FROM
"Fusion Transportation Intelligence"

-- Steps To Reproduce:

Navigate to Transportation Intelligence -> Dashboard -> click on graph in the Performance area


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