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
Skip to content
  • Register
    • Get Started: AI Resources for Oracle Cloud HCM – Go Here

    Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

    Having issue with OTBI Analysis report created using logical sql

    edited Mar 29, 2017 3:59PM in Reporting and Analytics for HCM 2 comments

    Content

    Hi,

    We have created an OTBI ANALYSIS REPORT which is based on a logical sql and when we run it we are getting the below strange error msg:

    Result field position: 1, has metadata data type of varchar, but the actual result data type is integer. This can be resolved by having an administrator refresh the server metadata.

    I dont see any issues with the datatype in the script. Wondering if anyone have come across this error?

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

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