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 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
-
Can we create replica of changes only extract using BIP reportSummary Can we able to create a replica of changes only Extract using BIP Report. If Yes can you please guide me how we can proceed with this kind of requirements.Conten…
-
Query to fetch data model output in hdl formatContent We are trying to automate HDL process using BI publisher report and Extract. Data model query to include output for Worker dat file with two metadata lines (Assi…
-
Compare two fields from two different subject areasSummary I am trying to put a filter where I compare the Requisition country to an Employee's nationality but they are from two different subject areas and the output is …
-
Time card entry report in OTBISummary Time card entries not visible in "Workforce Management - Reported Time Cards Real Time" SAContent Time card entries are not visible in "Workforce Management - Re… -
Filter Logical SQL based on dashboard prompt with multiple valuesContent Hi Thurrock are developing a customised version of the Line Manager Dashboard to suit their needs. An important aspect is having the ability to drill-down throug…
-
Duration in current job or position in oracle fusion HCMSummary Is there a way of knowing the duration of job/position or the start/end date of job/positionContent I need a way to track employee's duration in their current jo…
-
Absence related OTBI analysis returning no resultsContent Hello, I have a couple of absence related analyses which are no longer returning any results. They worked fine last month. We just had our quarterly update this … -
Highlight a change within an AnalysisSummary Highlight a change within an AnalysisContent Hello, I have an bonus change report and I want to be able to highlight when the bonus percentage changes. Anyone ha… -
Which table stores active/inactive user details flag?Summary Which table stores active/inactive user details flag?Content Hello, I developed the below SQL to get all the users details with role details. But this query retu…
-
Goal Plan Status ReportContent Hi, I am looking for a report that will tell me the goal plan status and if anything requires approval. Has anyone created something like this? I tried using the…
-
Joining iby_ext_bank_accounts_ audit table with the person recordSummary Joining iby_ext_bank_accounts_ audit table with the person recordContent Hi All, I am trying to create the audit report for the Bank Account Changes and want to …
-
How to remove Extra blank lines in Excel output from BI Publisher RTF templateSummary How to remove Extra blank lines in Excel output from BI Publisher RTF templateContent Hi Experts, How to remove Extra blank lines in Excel output from BI Publish…
-
Which table/view stores information of Data models / BI Reports / OTBI reports created or updatedSummary I need the table that stores the information of Data models / BI Reports / OTBI reports created or updatedContent I need the table that stores the information of…
-
Talent Review| Succession Plan| Career Development - All in One ReportSummary This report will give employees' Performance, Talent Review, Succession and Career detailsContent If your customer wants a detailed report on Talent management w… -
Round a summed total?Summary Round a summed total?Content I have an OTBI analysis and on a column it does the aggregate sum - so summing each value based on how I have it grouped in the resu… -
Precedence of security roles for custom BIP reportsContent If we have 2 roles attached to the BIP report, one of them should have Read, Traverse access and another one should not have access what would be the precedence …
-
OTBI - Date prompt from and to dateContent Hi Team, I am using a date prompt between from and to date. Issue is that during negative testing - user is trying to check if the system gives error for From da…