Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting and Analytics for HCM
Discussion List
-
BIP Query to pull unapproved/pending absences from last 10 daysHi Team, Could you please help me with the BIP Query to pull unapproved/pending absences from the last 10 days? It would be great if you can share DM or query for the sa… -
Getting the Period Start Active Headcount to equal the previous months Period End Active HeadcountSummary: Getting the Period Start Active Headcount to equal the previous months Period End Active Headcount Content (required): We need to get the Period Start Active He… -
Seeded HR Reports not returning any resultsSummary: Hi , We actually have to run all the seeded HR reports and present the output to the client . Now I got the list of the seeded reports but when I am trying to r… -
Subject area for user defined columns under worksheet display (Compensation)Summary: Hi everyone - We have some criteria defined under one of our compensation plans in a user-defined column for the worksheet. The user defined column contains the…
-
Is it possible to report on HCM Recruitment transaction team system activity?Summary: We want to report on activities undertaken in Oracle Fusion by People (HR/HCM) transaction administration colleagues. This specifically relates to job offer rec…
-
"Benefits - Enrollment Real Time" Subject Area Not Populating Plan Name without Payroll Element NameHello all, I have a requirement in which I need to display benefits plan and corresponding payroll element name in OTBI Report. I am using "Benefits - Enrollment Real Ti…
-
OTBI Report Usage - Count of Dashboards run (not executions)Summary: I've found the Usage and Performance Dashboard Sample (catalog files attached) and it looks pretty great but we're struggling to make it work for us. We want to… -
Recruiting Dashboard PDF downloadSummary: Content (required): Hello, The functionality used to download a Recruiting Dashboard page doesn't work anymore. We usually used this html code: -
How to display indirect terminations for a specific manager?Summary: We have a requirement to build OTBI (Graphs) to display number of terminations under a specific manager. There are 2 OTBI analysis I use in the dashboard - 1 wh…
-
Dashboard / reports on Anytime Doc, Check In...etc.Content Hello! I am reaching you because I am preparing a demo for a client and I would need a dashboard about all the "continuous" performance functionalities (feedback… -
OTBI Dashboard Embedded not workingHello, OTBI Dashboard embedded using Page Composer is not working, where as when I'm running Dashboard in analytics its working fine. I've attached the screenshots and c…
-
Performance Issue in OTL BI reportSummary: Performance Issue in OTL report Content (required): We have existing report on OTL which is taking 3-4 minutes for generating data. Is there anyway that we can …
-
Sample Dashboards or Reports - Skills and QualificationsJust checking if there are sample dashboards or reports available on Customer Connect for Talent Profiles -
Is there a way to have an OTBI analysis house legacy data and act as a reference table?Summary: Is there a way to enter in data into an OTBI analysis and have it act as a reference table? Content (required): We have a data export of historical data from a …
-
Create a message before running a BIP ReportSummary: Hi, Is there any way we can create a message to show before running a BIP report with prompts in OTBI Content (required): Version (include the version you are u…
-
Is there a provision to hide the formatted or Data option in OTBI?Summary: Feature to hide or unhide the formatted or Data option in OTBI Content (required):We have developed a report with the Pivot option. While exporting the data if …
-
Subject Area Contents/GlossarySummary: Is there such a document or Resource as a Glossary of what measures, attributes etc are available in each subject area. Content (required): I am constantly stru…
-
Sql query for employment term numberSummary Does someone have a query for the employment term number?Content Hi, I'm really need an sql query for that shows the person number, person f.name, person l.name,…
-
Candidate Success of Hire ReportThis analysis displays candidate information such as past employers, education, certifications, and termination data like last position held and length of service. To ad…
-
OTBI Publisher Report Job Skips even if there is data in the trigger and modelSummary: Oracle BI Publisher Report Job which is scheduled every 30 minutes gets skipped even if data is returned by the trigger Content (required): I have a scheduled r…
-
The specified criteria didn't result in any data.Good afternoon experts, could you help me with the following: An employee analysis is being created, when I consult some employee data, such as name, employee number it …
-
Changing Font color dynamically in rtf template is not workingSummary: Changing Font color dynamically in rtf template is not working Content (required): I am trying to change text font color dynamically. but it is not working. For…
-
Where Close date is stored in tables?Summary: Hello, do you know where Close date is stored in tables? See image Content (required): Payroll Version (include the version you are using, if applicable): N/A C…
-
How to get Department of Level1 , level2 and level 3 position in position HierarchySummary: We have a requirement to fetch following fields in OTBI, Person Number Assignment Number Position Name Level1 Org: Populate department of the position One level… -
How to CAST Char to DateSummary CAST Presentation Variable of Text to Date Prompt in FormulaContent Age Band on Line Manager Dashboard is based on CURRENT_DATE rather it should based on Dashboa…
-
State: HY000. Code: 27047. [nQSError: 27047] Nonexistent table: "SET". (HY000)Summary: I am trying to create 2 reports: 1) Workforce Management - Worker Assignment Event Real Time:- Picking all person numbers with action names and effective date b…
-
BI Publisher Solution ? - Start Excel Preview only open: falseSummary: Hello R&A forum: Start Excel Preview only open: false mTemplate: C:\Users\john.white\AppData\Local\Oracle\BIPublisher\TemplateBuilderforExcel\tmp\tmp\tmp.xls mT…
-
BI Publisher Excel Template preview failsSummary BI Publisher Excel Template preview failsContent I am new to the use of BI Publisher Desktop in Word and Excel to create templates for BI reporting. I have a rep… -
Defined Flex Field (DFF) & Person Count and Head CountContent We have created a defined flex field (DFF) for gender as we use different values from the default HCM gender field. The DFF has been placed into Workforce Manage…
-
Query to fetch existing and proposed information of pending transaction in oracle hcmSummary: We have a requirement to develop a BIP report to display the existing and proposed information of pending transaction like Promotion. Content (required): Need t…