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
-
In OTBI - How can we restrict user to create and edit report only in My FolderSummary Need to restrict the users to have the right to create edit update the analysis only in My Folder.Content Need to restrict the users to have the right to create … -
Is there an easy way to pull all the notifications enabled in the systemSummary: Is there an easy way to pull all the notifications enabled in the system. Content (please ensure you mask any confidential information): Is there a way we can p… -
Skip Query in Oracle Fusion HCM BPM workflows is not workingSummary: Hi All, We want to skip the approval step if the approver is the CEO. We tried using the below query; however, it is neither skipping the hardcoded person nor w…
-
BIP Vs OTBI What is the practicality of moving BIP reports to OTBI?Summary: I am recommending that my client investigates the possibility of using OTBI in preference to BIP for their reports (including whether this is just for new repor… -
Is there any query to identify which flow generated the output file that included the given PNHi Team, Is there any query to identify which flow generated the output file that included the given person number. I want to identify which flows picked up the given pe…
-
Front-Loaded Accrual BalanceContent I've been trying to create an Absence Balance OTBI Report that reports both the Incremental and Front-Loaded Balances (for the Incremental Accrual Balance, I use…
-
I'm unable to upload rtf template in report or it is showing uploading since long timeSummary: I'm unable to upload rtf template in report or it is showing uploading since long time. Content (please ensure you mask any confidential information): Version (…
-
Tables with employee cost center, manager, assignment, and job title historySummary: We need to write a query to report on employee cost center, manager, assignment, and job title history. So far we're not finding the data we need in the tables … -
Account Holder field not available in OTBISummary: Account Holder field not available in OTBI Content (please ensure you mask any confidential information): Hi experts, we are creating an OTBI report to retrieve… -
REST APIs or SQL Queries to fetch the Fusion SAAS BI Report's list from "/Custom" FolderSummary: We have a requirement to fetch all Data Models & Report from "/Custom" folder in Fusion SAAS. Content (please ensure you mask any confidential information): Loo… -
Change Text format in dashboard BI publisherHi, is it possible change text format (size, format, color,…) in caption inside "Link or Image" in BI publisher dashboard ? Thanks, Han Xi Zhao
-
BIP Pivot Table Row Label Header PropertySummary: Hello, I'm trying to have a header label for my rows in a pivot table in BI Publisher. I'm using the Row Label Header property but does not show anything. Can y…
-
I need a BIP/OTBI report If the rating in any of the question is 3 & below-BHR intervene & solve.Proposing to integrate three feedback forms into our HRMS, triggered automatically at the 30-, 60-, and 90-day milestones, to capture each new joiner’s onboarding experi…
-
Incorrect values are appearing in OTBI report for leave durationSummary: We have created OTBI report where we are fetching absence details based on year and month (monthly absence report). If employee has taken leave for single month…
-
Retro ReportsSummary Retro ReportsContent EDIT: The newer version, after few bug fixes, can be found here -
Hierarchical Prompt for dep tree with OTBISummary: Hierarchical Prompt for dep tree with OTBI Content (please ensure you mask any confidential information): Hello experts, we have configured in OTBI a report wit…
-
Issue with Month-wise Active Headcount Count in Workforce Real time Trend Subject Area - OTBI ReportHello All, I am working on a report using the Workforce Trend - Real Time subject area in OTBI. The requirement is to show month-wise new joiners, attrition, and total a… -
Read excel file with querySummary: Content (please ensure you mask any confidential information): In a datamodel I have a query dataset linked with an excel dataset: The excel is used to translat… -
How to see ESS log messages/files in a Global Absence Ceiling fast formulaI have configured a few ESS log messages within my Global Absenece Ceiling fast formula, however the formula doesn't get triggered when the Calculate Balances and Accrua…
-
Inputs Needed for BIP Folder Setup.Summary: Inputs Needed for BIP Folder Setup. Content (please ensure you mask any confidential information): By mistake, we removed My Folders in the lower environment. W…
-
Issue in Salary Certificate DORSummary: Issue in Salary Certificate DOR Content (required): Hi All, We are facing the issue in salary certificate DOR. Salary certificate is working fine in draft versi…
-
Has anyone created a costing by job report using the Payroll Run Costing Real TIme subject area?I need a report to show costing by job for last year. I've written one but can only get it to work for one person at a time, it does not produce results when I try to ru…
-
Is there a way to pull out job offer comments in OTBI?Summary: Is there a way to pull out job offer comments in OTBI? Content (please ensure you mask any confidential information): Hello Experts, We are challenged to pull o… -
Can we set the absence accrual repeating period to daily?Summary: Can we set the absence accrual repeating period to daily? I tried searching for the delivered Daily Calculation repeating period in the absence accrual plan, bu…
-
person security profile required to custom query to restrict location and email?Summary: Summary: threre is location page- hr1, hr2 and hr3 are DFF stored employee emails. suppose one of the employee login as HR , all location assoicated to hr emial…
-
How to output a list of all reports and their folders in Production environmentSummary: We are trying to map all reports in our production environment, with their folder locations. Does anyone know of an administrative tool that might be able to ou… -
How to report on Unsubmitted Timecards?Content Has anyone been able to produce a report showing which employees haven't yet submitted a time card in a given period? Any help would be much appreciated -
How to find the difference between two date attributes in eText templateSummary: We need to find out the difference between two dates and add 1 to the result in eText template. Content (required): We need to find out the difference between t…
-
HCM Custom Extract Guide for Payroll ReportsSummary Sample extract with modularized UEs for customized payroll reportsContent Change Notes Date Version Change Reference 16-May-2018 v1 First Version 18-Sep-2018 v1.… -
Position trend real time Subject Area - how to find Position Incumbent?Summary: Hello. I'm trying to build a report of open positions and their previous position incumbents. Is it possible to create this report using a new subject area 'Pos…