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
-
Need inputs to display data in a single record for each employee if an employee is having multiple aContent Hi All, We have a requirement to display Person, Visa and assignment details through OTBI. As of now we are using below two subject areas to achieve this require… -
Customize OTBI Analysis Header FieldsSummary Need Help with customizing the OTBI analysis header field to a custom nameContent Hello Everyone, I am new to OTBI analysis and I need help with some customizati…
-
Subject Area which includes Maternity Weekly Average EarningsContent Can any one help me to identify subject area which contains below highlighted field in the attachment? Absence Administration (Maternity Leave) -> Override Avera…
-
Session Timezone in BI PublisherSummary BI publisher not using the timezone from the Account screenContent I've found that the CURRENT_DATE in BI Publisher isn't applying the timezone entered on the us… -
While scheduling setup name file based on parameter. Is that possible?Summary While scheduling setup name file based on parameter. Is that possible?Content Hello, is there a chance to have the file name dynamically setup based on parameter…
-
No access to create BI Publisher reportSummary No access to create BI Publisher reportContent Hi all, is it possible to give users access to create/Modify only OTBI reports but only read-only access to BIP re… -
OTBI Agents and BI publisher scheduling us there a Report displaying the active scheduling ?Summary OTBI Agents and BI publisher scheduling us there a Report displaying the active scheduling ?Content Hello , We would like to have a list of the existing active a… -
Export my Favourites analysesContent Hi there, is there an easy way to export the favourite analyses. I do not mean the actual analyses but rather the structure that one has under Favourites. Thank … -
SQL query help needed - Payroll tablesSummary Reporting on those employees who have had a garnishment added in the selected payrollContent Hi All, I hope someone is able to help me out. I am trying to debug …User_2025-02-04-08-51-08-912 20 views 1 comment 0 points Most recent by User_2025-02-04-08-51-08-912 -
Report by Performance Task countSummary Report by Performance Task countContent Currently have a query that reports out current status of performance task: Employee Self Evaluation, Manager Evaluation,…User_2025-01-29-19-46-35-367 78 views 2 comments 0 points Most recent by User_2025-02-06-15-04-02-124
-
BI Report - Need to display Date Time in User TimeZone in excel template - But always displaying UTCSummary Trying to display Report Run Time in User TimeZone, but unable to do itContent The requirement is to display the Date and Time in user Timezone. I came across fe…
-
Override Average weekly earning field in OTBIContent Does anyone know if the Override Average weekly earning field that can be found in Absence Records under legislative information is available in OTBI?
-
OTBI Pivot Table - Value FilterContent Hi, I am looking at how many assignment actions have been processed on the same effective start date per employee. In OTBI I have an assignment history report lo…
-
Deploy OTBI artifactsSummary How to deploy OTBI artifacts (REST or SOAP available?)Content Hi All, I would like to know if there is a way (apart from manual operation) to deploy OTBI artifac…
-
Headcount by Age Band in Workforce Trends Real timeSummary Unable to count headcount by Age Band as compared to other attributesContent Hello Experts! I'm hoping this is an easy one! I'm trying to report Period End Headc…
-
Scheduled Report Returning only 25k rowsSummary Scheduled Report Returning only 25k rowsContent I have an OTBI report that i am running that has output greater than 25k rows but less than 65k rows. I thought i…
-
Seeded Report Location for Worksheet ExportSummary Looking for seeded report location for Worksheet Export under compensation module.Content Hello Everyone, Does anyone know how to find the seeded report location…
-
Report Job History does not display informationSummary OTBI Report Job HistoryContent OTBI Report Job History displays for a few seconds and then screen mostly vanishes in Production.
-
HCM Extract | How to find current difference FTE, Incumbent FTE of position in fusion hcmContent Hi All, I am working on a HCM extract and I need to fetch the position details like difference FTE, current Incumbent FTE of position. I am able to get current p… -
Report | SQL query to get details of the employees belonging to departments below the selected deparContent Requirement: 1) Report should display employees belonging to the departments of the selected organization type. 2) Report should also display employees belonging…
-
How to add drill down feature on Formula ColumnSummary How to add drill down feature on Formula ColumnContent Hi Experts I created an analysis using "Workforce Management - Worker Assignment Real Time" to see the Age… -
HCM OTBI Historical Reporting ExplainedSummary This white paper explains how OTBI supports historical reporting.Content Fusion HCM OTBI supports historical reporting. This white paper explains how HCM OTBI su… -
OTBI Multi-Language SupportSummary This white paper explains how OTBI supports multi-language translation, the current limitation and the planned enhancementContent OTBI supports multi-language tr…
-
Configuration Fusion HCM OTBI SecuritySummary This white paper is a guide in how to configure security for HCM OTBI.Content This white paper addresses how to: * Grant line managers and employees the ability …
-
Restricting BI Answers Access for Fusion Application UsersSummary This paper outlines steps that customers can take to restrict user access to BI catalog.Content This paper is published by Oracle OTBI product development. By de…
-
How to Implement Specialized Reporting Security in OTBI for Fusion HCMSummary Creating Custom Roles for Specialized Reporting Access in Oracle Transactional Business Intelligence (OTBI)Content By default OTBI would always enforce Fusion HC…
-
Busting OTBI Myths - NOT INContent Myth: OTBI can't give me a list of workers without goals (or absences or ...) There are a few ways to perform a "NOT IN" query. The easiest and most performant i… -
Need to know Tables to retrieve time card details like hours entered, time attribute detailsSummary Need to know Tables to retrieve time card details like hours entered, time attribute detailsContent I am trying to report time entries and other details like cor…
-
BIP Report getting timed out and cancelled while extracting the AOR reportSummary Hi, We have an report where we are verifying if there are any multiple assignment of same HRBP's (HR Representatives) to the same department / scope.Content Hi, …
-
Use of Variable prompt in OTBIContent Hi Experts, Greetings of the day!! Can someone please let me know the use of variable prompts in OTBI analysis. Regards, Divya Version 21A