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
-
OTBI Logical SQL complex query assembler - NOW 10 subject AreasSummary Now updated - Combine analyses from up to 10 different subject areas (V4) Content It was already posted on OBIEE forum, but I figured HCM would be a demanding th… -
Common Question: In what particular subject area can I find these columns?Typical Symptoms: you see columns on an application page and you want to know where they are in OTBI. Content: navigate to and download the latest database lineage mappi… -
OTBI Workforce Trend: For better performance, use equi-filter on Calendar Month End Date columnSummary: This is an announcement to provide guidance to improve response time of Workforce Trend reports and dashboards. Content (required): 1- Response time of reports … -
Common Question: I didn't get any rows in the subject area, what's wrong?Typical Symptoms: you selected columns and didn't see any results, or once you added certain column/s, then you didn't see any results. Content: Q: "I didn't get any row…
-
HCM OTBI subject areas to database lineage mapping spreadsheetThis spreadsheet documents HCM OTBI subject areas to database lineage mapping and subject area security. Content This spreadsheet is published by Oracle OTBI Development… -
OTBI ResourcesContent Resources to help you get the most from OTBI. Training Oracle Applications Analytics Cloud Service Videos (Oracle Learning Library) - many are no longer availabl… -
Element HDL Template Generator ReportSummary OTBI report to generate sample files to create Payroll Elements using HDL Content Introduction: This report provides sample files to create Payroll Elements usin… -
R12 HCM OTBI subject area database table mapping spreadsheetSummary R12 HCM OTBI subject areas to database tables mapping spreadsheetContent These spreadsheets are published by Oracle OTBI Development. The spreadsheets document F… -
HCM OTBI Workshop Session 1Summary: This following link allows you to download the recording of session 1 of HCM OTBI Workshop for beginners organized by JAPAC CS Org along with DEV and COE. Conte…
-
R13 HCM OTBI subject area description documentationSummary This spreadsheet provides R13 HCM OTBI subject area description documentationContent This documentation is published by Oracle OTBI development. This document pr…Raghavendra Raghunath-Oracle 1.5K views 19 comments 22 points Most recent by VijayaBaskar Ranganathan
-
OTBI vs BIPContent All - on Julian's OTBI call today, I asked about the benefits of using OTBI vs using BIP. I am aware of when we use BIP instead of OTBI (data not available in OT… -
OTBI Webinar - Introducing Logical SQLSummary This is the monthly OTBI best practice training webinar delivered by Oracle Development. Jan.27 training topic: how to use Logical SQL to control data join with …
-
Release 13 Version 20B: Steps to enable and create an infoletSummary Release 13 Version 20B: Steps to enable and create an infoletContent Hi All, Please find attached herewith, a step by step documentation with screenshots on how … -
BI Publisher Query - Send Bursted Email (HTML) with separate PDF AttachmentSummary Is it possible to have two outputs in a BI Publisher Report?Content Hello, We have a BI Publisher report which sends an email (HTML) output, split and delivered … -
Not a Question: Dynamic Date Parameters in BI ReportContent This is not a question and I have shared the info, For most of the BI Reports we have the input parameter as "AsOfDate" alias Sysdate or current date. Sometimes … -
HCM OTBI Workshop Session 2Summary: This following link allows you to download the recording of session 2 of HCM OTBI Workshop for beginners organized by JAPAC CS Org along with DEV and COE. Conte…Raghavendra Raghunath-Oracle 951 views 6 comments 14 points Most recent by Raghavendra Raghunath-Oracle
-
OTBI Performance GuidelinesContent The attached document pulls together our experience helping customers to improve the performance of OTBI reports into one succinct document. If you are looking t…
-
HOW TO... Report using more than one OTBI subject areaContent Part of a series of short 'how to' videos to help with a variety of topics. This one explains how to report across more than one OTBI subject area using the "dim…
-
Absence Calendar Details Real Time - Reporting on employee absences by daySummary This is a white paper to enable the customers to generate and render worker absences breakdown by day using the absence calendar details real time subject area.C…
-
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…
-
BIP report leveraging the OTBI dashboard promptSummary This post contains a brief synopsis describing the technique to leverage the OTBI dashboard prompt in the BIP reportRaghavendra Raghunath-Oracle 255 views 12 comments 12 points Most recent by Sujay Bandyopadhyay-Oracle
-
Line Managers reporting on terminated workersSummary This post provides customers a work around in OTBI to report on the terminated workers when logged in as a line manager.Content The attached document provides a …
-
R13.x HCM BI Cloud Adapter BI View Object to Database Lineage Mapping SpreadsheetSummary This posting includes R13 HCM BI Cloud Adapter BI view object to database lineage mapping. Content This spreadsheet is published by Oracle BI Cloud Adapter Devel…
-
Legacy Learning Detail Report (OLC) - BI Publisher ReportSummary Legacy Learning Detail Report (Oracle Learning Cloud)Content "Employee Legacy Learning Detail Report" is a report for Learning administrators to view all the Lea… -
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 …
-
Information: Query to get last P2T/T2T Refresh DateSummary: In order to get last refresh date from backend, below SQL can be used: select * from ask_deployed_provision_configs last_update_date column in this table gives … -
Revoking User Access to the Shipped OTBI Content in Fusion HCM 19CSummary This white paper documents the steps to revoke access to the seeded OTBI content for all users in 19C.Content In 19C, OTBI introduced a new set of BI reporting r…
-
Populating the manager hierarchies for OTBI reportingSummary Provides the steps the populate the various manager hierarchies available in HCM OTBI Content This document provides details on the process that allows the custo…
-
Security Matrix - Custom AnalyticsSummary Sharing the Security Matrix Analytics which reports the mappings between rolesContent Hello All, I have seen lot of posts asking for a solution to generate the S… -
Fusion BI Catalog Folder Management Best PracticesSummary A white paper on Fusion BI Catalog Folder Management Best PracticesContent This white paper provides the best practices for working with BI catalog folders, and …
-
Understanding Fusion HCM OTBI SecuritySummary This white paper clarifies how HCM security configuration affects reporting in OTBI and addresses common HCM security questions encountered during an OTBI implem…
-
OTBI performance recommendations paper (2679006.1) is available on MOS PortalSummary OTBI performance recommendations V2 doc is intended for OTBI system integrators, BI report developers and admins. It covers advanced performance tuning technique…
-
Busting OTBI Myths - Using Agents to BurstContent Myth: OTBI doesn't support bursting, this is only possible in BI Publisher OTBI provides bursting via agents. Create an analysis that includes the lowercase comp…Julian Challenger-Oracle 394 views 18 comments 10 points Most recent by Raghavendra Raghunath-Oracle
-
Reporting on Accrual BalanceSummary This document provides a brief overview of the employee accrual balance metric and the corresponding analyses.Content Customers often ask if the projected accrua…