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
-
Attrition and Turnover ReportsSummary: Need to develop an analysis for Attrition and Turnover Content (required): We have a below requirement for Attrition and Turnover Reports, can anyone share the … -
OTBI Hospital Custom TableSummary: Dear All, Where can i find this table is maintained in Oracle system? Thank you Izliana Content (required): Version (include the version you are using, if appli… -
Adding a Page / Tab to Front End AnalyticsHello, Apologies if this is the wrong place to ask but I'm building several infolets to be used and was wondering if anyone knew if it was possible at all to add an extr… -
Results to be displayed horizontally instead of vertically in reportsSummary: We have a requirement where the results displayed in reports are vertical but we need to display that column horizontally. Suppose say for example this the resu…
-
Job Profile AuditsHi , I have a requirement to pull the changes made to Job profiles/Job details. Is there any way if it can be retrieved from Audit report, If yes, how can i achieve it. …
-
How can I make sure that when the Dashboard is first opened, no data comes in without selecting a paHi, I designed a dashboard for users. It has a detailed dashboard with assignment information of individuals and multiple parameters. What I want is for the parameter sc…
-
Is it possible to get the list of all the Data Models using a specific keyword in Dataset SQL?Summary: Is it possible to get the list of all the Data Models using a specific keyword in Dataset SQL? Content (required): Looking for a query that can be used to check…
-
Unable to add Salary Basis Column in my existing Compensation detail ReportSummary: I need to add Salary Basis Column which I am unable to do so in the exisiting report. Subject area I have use is Payroll - Element Entries Real Time Content (re…
-
Guys, Do you know the table name that stores the where clause on Manage Value Sets page? Thanks VenSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
Calculated item for Actual Time spent in LearningSummary: Content (required): Hi there, the actual time spent for a learning item is measured in 0.5, 0.75, etc. We want to prepare a calculated item column in OTBI repor… -
Where to find Risk Code Description in DBSummary: Need to find the Risk Code (or Workers Compensation Code) description in the database. Content (required): I am creating a report pulling data out of hcm cloud …
-
Percentage of documents in various tasks.Summary: Hi Experts, The performance process flow we are using is 1) Set Goals 2) Self evaluation (employee) 3) Manager evaluation 4) Employee final comments 5) Manager …
-
How can I edit the pie report I added to the Dashboard screen?The pie report I prepared shows the gender information of the people working in the departments. For example, when I click on the number of women, the page in the screen… -
How can I show the number of rows returned from the report?I created a dashboard from the analysis report and there are parameters for this report. How can I show how many data is returned in the report depending on the paramete… -
Utilizing Assignment Event Details with Workforce Trending SASummary: Would like some advice on how fields from the Workforce Events.Event Details folder can be repeated for each month it is active (during assignment Start/End Dat…
-
How can I make the report not open without selecting Parameters on the Dashboard screen?I have a few reports that I have prepared from analysis and I have created a dashboard from them. And reports work with parameters. When I click Open to Dashboard, repor…
-
Display Assignment Data as of hire effective dateI have created an analysis that gives me all hires between two dates. However, I noticed the assignment data that is displayed shows current information. How can it be m…
-
Delivered Report for State TaxSummary: Checking for delivered Report which provides State Tax Withholding details for all states. Content (required): We have built a custom report for State Tax Withh…
-
BIP - Non-catalog item reportSummary: Hello, Have anyone tried creating a Non-catalog item report in Learning? Do you know where I can get these details below? (Column name, tables in BIP) Your help…
-
Is it possible to open a detailed report for a tile or graph besides it?Summary: Is it possible to open a detailed report for a tile or graph besides it? When I am using action links in Interaction tab detailed report is getting opened in th…
-
Create a Report for Candidate Job Application with the Prompts as Prescreening QuestionsSummary: Hello Experts, We have a requirement where we need to build a report with the Filters as the Prescreening Questions. There are 15 Prescreenshing questions but w… -
Report in OTBI to show data as of end of previous monthSummary: Need to show number of openings (from recruiting requisitions) from a specific date (6/1/22) through the last day of the previous month. I created a filter to s…
-
What if i cannot find the Subject Area in the dashboard prompt. Does that mean i cannot create?Summary: Trying to create LSQL coming from Workforce Profile - Person Profile Real Time and Workforce Profile - Model Profile Real Time and will add it to a Dashboard wi…
-
Email Body not bursting correctly (22C)Summary: Content (required): Hi Since we went live with the 22C patch, notifications burst from OTBI are not including anything in the body of the email sent to recipien… -
Scheduling the report(Email Notification) if the data is present in itSummary Scheduling the report(Email Notification) if the data is present in itContent Hi All, Greetings !! Our customer's requirement is to receive the report/Email noti… -
How to embed Analytics, as an icon, in My Team page in UISummary: Our client wants to embed Analytics, as an icon, in My Team page in UI, which will redirect to a custom Analysis, as similar to the attached screenshot. The ico…
-
OTBI Analysis report for auditing changesSummary: Hello - we are looking for a report/audit tool that will help us monitor when changes have been made to OTBI analysis based reports. We are utilizing the functi… -
How to read primary national identifier?Summary: How to read primary national identifier? Content (required): How to read primary national identifier? I use per_national_identifiers table but no reference to t…
-
Do Business Unit names in BI report criteria gets changed to BU ID value during archive/ unarchive?Summary: Hi All BI/ reporting experts - The question is regarding migrating BI reports from one pod to the other. Oracle recommends using archive/ unarchive feature. We … -
Terms (Leavers) with Most Recent Performance Score and Box AssignmentSummary: We need a report and bar chart that shows terms (resignation and term-invol), NO legal employer changes, with their most recent performance score- the Calculate…