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
-
Report to show 2 sets of data based on dates selected by the userSummary Report needs to show several fields for different dates(not necessarily the current and previous values)Content Hi All, I have built a query that returns data ba… -
OTBI: How do I use a non fact column in the Column Filter.Summary OTBI: How do I use a non fact column in the Column Filter.Content Hi, I have a requirement where i need to use a non-fact column which is Standard Working Hours … -
Function for getting leave balance prior to execution of monthly leave accrualSummary Function for getting leave balance prior to execution of monthly leave accrualContent Hi, Please share function name or logic in order to get the leave balance o… -
Reg BI RolesContent Hi We are in 19C , and employee does not have BI Consumer, BI Administrator and BI Author roles , but still able to see the folders in BI delivered folders , why… -
OTBI Based Dashboard OutputSummary Multiple Employees in different Pages in Dashboard OutputContent Hi All I created a Dashboard for Talent Profile using 10 analysis (Each analysis will bring its … -
Need to be able to identify all BIP Reports and Analyses that use particular field as filterSummary Need to be able to identify all BIP Reports and Analyses that use particular field as filterContent Does anyone know if there is an Oracle program that will iden… -
How to hide data model and edit access for BI ReportsContent Hi Export, We have a requirement to give only view access for BI Report and nothing other than. So we are planning to hide the data model so that a user can not … -
OTBI: how to achieve UNION ALL operation in OTBISummary OTBI: how to achieve UNION ALL operation in OTBIContent Hi, We need to replicate BIP's UNION ALL operation in OTBI Is it possible? Regards Rashmi
-
Workforce Trend Headcount by Assignment StatusSummary We require a report that displays headcount for each month for the last year, but it should only count those employees with a specific assignment status.Content …
-
R13 20A - How to extract BPM approval Configurations task details via SQLSummary Need to extract BPM approval configurationsContent We have a need to extract all the BPM approval configuration task details via SQL. All things BPM related (the…
-
New Role only seeing their information on any report ran in Reports & AnalyticsSummary PAYADMIN_READONLY_DATA_DATAContent Created a new role in HCM and it only when reports are ran it only shows their information, unless it is a line manager, then …
-
OTBI Environment variablesSummary Display current user details in environmentContent Hi, Has anyone come across any OTBI environment variables. Or is there a subject area that displays the curren…User_2025-02-05-23-02-10-916 97 views 4 comments 1 point Most recent by Raghavendra Raghunath-Oracle
-
ESS Access to Custom BI Publisher ReportSummary Access to a Custom BI Publisher Report as Employee Self ServiceContent Hi Friends We have a custom BI Report and one of the parameters is the name. Right now thi… -
Benefits Rates and Coverages - Report for Newly added and Dropped Coverages during a pay periodSummary Benefits Rates and Coverages - Report for Newly added and Dropped Coverages during a pay periodContent Hi Experts Please let me know if there is a report for all…
-
The report cannot be rendered because of an errorSummary The report cannot be rendered because of an error BI ReportContent Hi All, I have a BI Report with custom RTF template. Report runs fine for few users and for fe…
-
Time entry hours by various time codes otbi/reportSummary Time entry hours by various time codesContent Hi, We have some time codes which are not payroll time types specifically. Either they are part of 'Regular Hours' … -
Check-In Performance Template BIP table Joins.Summary Can anyone please explain how goals and its feedback are tied/joined to check-in peformance template for reporting purpose using BI Publisher.Content We have a B…
-
Create dashboard prompt using column with custom formulaSummary Analysis has calculated column with bins. How can I create a dashboard prompt using this column?Content I created a column that bins seniority years (seniority u…
-
Requisition approval notificationSummary Can we use seeded BIP Requisition approval notification as a FYI notification for submitter?Content Hello, We have a requirement to send a FYI notification for t…
-
OTBI Custom Dashboard PromptSummary Looking for ideas on Custom Dashboard PromptContent Hello, We want to create a custom dashboard prompt to add to the other list of prompts. We need a prompt for …
-
Usage TrackingSummary OTBI Usage TrackingContent Is Usage Tracking available for OTBI Reports? Something like in 20A for BI Publisher reports? Or even that which is available for OBIE…
-
Is it possible to fetch Hire Date changes of employees through HCM Extract or OTBI?Summary Is it possible to fetch Hire Date changes of employees through HCM Extract or OTBI?Content Hi Experts, We are looking for a requirement to fetch Hire date change…
-
Multiple attachments through BIP BurstingContent Hi All, Can we send multiple attachments (PDF, Excel) for an employee through BIP bursting in a single mail? Thanks, Visu
-
Using Subject ID in Transaction AdministrationSummary How do I use Subject ID to join to other Subject Areas to identify employee impacted by transaction by nameContent I would like to create an OTBI report on faile…
-
Approved GoalsSummary Need to find dates when Goals were approvedContent Hi, I need to find all Goals that were approved between the 20th - 23rd July but when I look I see there are m…User_2025-02-05-22-44-35-842 25 views 4 comments 0 points Most recent by User_2025-02-05-22-44-35-842
-
Busting OTBI Myths - Trend reportsContent Myth: You can't report trends in OTBI Trend reports can be produced in any subject area which has a "Time" dimension folder (as of 19B 63 out of 78 subject areas… -
OTBI Anchoring date variationSummary Try to change Anchoring date in Performance Subject AreaContent Hi all we try to change in our OTBI reports the Anchoring Date of Performance Subject area: 1) Wo…
-
PER_JOBS_F.APPROVAL_AUTHORITY Translate ValuesSummary Trying to pull in the Name (translate value) for the Approval Authority code on JobVersion 20B -
Adding Action Occurrence Created By column in OTBI ReportSummary Adding Action Occurrence Created By column in OTBI ReportContent Hi Experts, We have an OTBI report. In that report our business requested to add 'Action Occurre…
-
Report to Find When a Payroll Relationship was updatedSummary Report to Find When a Payroll Relationship was updated and it includes the old and new payroll relationshipContent Hi, Wondering if anyone has a report that show…