MFA Icon

MFA for Oracle Community

Starting September 2025, Oracle Community will require Multi-Factor Authentication (MFA) for all member logins. This simple extra step helps protect your account—and the community data—by adding an additional layer of security during sign-in.

Read more about MFA
Dashboard prompts using sql query — Cloud Customer Connect
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
    • Reporting and Analytics for HCM
    Get Started with Redwood: Oracle Cloud SCM and Purchasing

    Dashboard prompts using sql query

    edited Aug 24, 2021 3:25PM in Reporting and Analytics for HCM 3 comments

    Summary

    Need to create dashboard prompts using sql query as the relevant subject areas for prompt data is not available

    Content

    Hi Experts,

    I have a requirement to have payroll period as a prompt in my dashboard based on which I need to display some non-payroll data.

    The payroll period fields are present in subject areas like Payroll Run Results Real Time and Payroll Balances Real Time. But the period data is present only if the payroll is run for the period. The periods details are not present in these subject areas for the periods where the payroll is not run for any employees but are present in period details section in payroll definition setup.

    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

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