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

    Unable to add SQL based Dashboard prompt

    in Reporting and Analytics for HCM 6 comments

    Summary:

    Hi All,

    I am trying to add an SQL based Dashboard Prompt and facing the Error:

    Failed to load(Error during query processing (SQLExecDirectW).

    The SQL I tried to add was a simple SELECT PERSON_NUMBER FROM PER_ALL_PEOPLE_F.

    Btw I am trying to add a BI report in Dashboard and since the BI report Parameters were not visible directly on Dashboard, I was adding Prompt.

    Is this expected? We cannot used SQL statements like this in prompt? We need to use the Subject area related queries only?

    Appreciate your help. PFA screens.

    Thanks,

    Abhishek

    Version (include the version you are using, if applicable):

    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

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