You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

issue query filter BICC

edited Apr 18, 2025 10:54AM in Reporting and Analytics for SCM 1 comment

Summary:

We're trying to filter specifc data from VO at BICC , but log returns query error at where clause.

Content (please ensure you mask any confidential information):

ORADocs guidance: "All column references should follow the format underscore ( _ )underscore ( _ ) DATASTORE underscore ( _ ) underscore ( _ )dot(.)>BI VO Column Name>, for example select DATASTORE.ViewApplicationId=0"

My filter criteria of DataStore is :

__HcmTopModelAnalyticsGlobalAM.CommonAM.FndFlexValuesPVO__.ValueCategory LIKE '%ESTR'

My job execution returns:

Caused by: java.sql.SQLException: java.io.IOException: prepare query failed[nQSError: 43113] Message returned from OBIS.
[nQSError: 27045] Nonexistent column: "HcmTopModelAnalyticsGlobalAM"."CommonAM"."FndFlexValuesPVO"."ValueCategory"

Column exists at VO and set to use in VO.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!