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… -
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… -
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…
-
Is it possible to add a field to an OTBI analysis that uses sql to query the underlying oracle tableSummary: We have an existing OBTI Analysis that reports on candidate from ORC. We need to add that a field from the Extra Info section of the candidates profile, the Des… -
How to report Job Details > Action reason in OTBISummary: We use the 'Action Reason' field in Workforce Structures - Job Details to record why we created or updated a job. We would like to be able to report on this fie… -
Could not find the lookup HRC_TRANSACTION_STATUSSummary Could not find the lookup HRC_TRANSACTION_STATUSContent Hi Experts, As a part of pulling the Approval Transaction Details, I have used the table HRC_TXN_DATA. Th… -
User unable to run OTBI report but could in the pastSummary: All of a sudden this user is not able to run reports specific to ORC. I cleared the server cache but it's still not working. Any ideas prior to logging an SR? C… -
Base table - Email Notifications Workflow approvalsContent Hi, I am looking for a table that holds emails sent out of the workflow mailer. I am specifically looking for details such as Transaction/Task id along with an e… -
OTBI Subject area for Candidate Extra Internal InfoSummary OTBI Subject area for Candidate Extra Internal InfoContent Hello team, I'm looking for OTBI subject area for Candidate job application extra internal info. Thank… -
Week Number calculation for OTL Overtime report if week starts from saturday and end on fridaySummary: Hi Team, We need to calculate the weeknumber for a overtime card report. Week will start from saturday and end on friday We need to pass "from week" and "to wee…
-
How to retrieve timestamp when candidate submits RMI applicationSummary: Content (please ensure you mask any confidential information): Working to troubleshoot CSP automation and I am looking for a timestamp for when candidates submi… -
Mass Download of Document Records errorsSummary: Can you get details on the skipped downloads or those with errors? Content (please ensure you mask any confidential information): This is in the log file: Total…
-
Can I speed up the search for people who successfully completed a course?Summary: I need to generate a list of who's completed a specific course. I don't care how often they've completed it - I just need to know if they've got at least one su…
-
Job Requisition Audit report neededHi Team, We have a requirement to create a report to bring Requisition Audit report, The client is trying to fetch each transaction that occurs with a requisition , any …
-
📄 OTBI Report to Generate HDL File for Deleting Feedback RequestsSummary: This provides a custom OTBI report built on the Workforce Performance – Requested Feedback subject area. It helps companies generate HDL-formatted data to delet… -
Does exist an official/unofficial presentation for OTBI reporting training?Summary: Looking for OTBI reporting training presentations. Content (please ensure you mask any confidential information): I need to teach the customer how to use OTBI r… -
Looking for the Checklist Task Sequence in the Workforce management Checklist Real TimeSummary: Looking for the Checklist Task Sequence field in the Subject Area Workforce Management - Checklist Real Time Content (required): We are looking to add the Check…
-
BIP HCM Payroll - Is there any alternative to pull the Payroll process statusBIP HCM Payroll - Is there any alternative to pull the Payroll process status apart from below Query /* ( SELECT meaning FROM hcm_lookups WHERE lookup_type = 'ORA_HWM_PA…
-
Table for Payroll Transfer Status and Payroll Processing StatusWe need to get Payroll Transfer Status and Payroll Processing Status. Where are these information gets stored? Please share if you have any inputs. We have tried using p…
-
Help Desk Data only role for access to reporting for HR Service Requests and Knowledge ManagementSummary: I am trying to provide access to a Help Desk and Knowledge dashboard for users that cannot access the Help Desk and Knowledge modules. The subject areas that th…
-
Processing Bar Not Visible During Report Generation – Needs Left Alignment or Fixed PositionSummary: When running a wide report, the Processing bar appears centered on the report, making it not visible unless the user scrolls horizontally. This causes confusion…
-
Oracle Fusion BI Publisher - Excel Template - Generate Multisheet Report Excel OutputSummary: Hi Team, We have a requirement where we need to generate an excel output with 3 tabs in the output file. Sheet1 name: Static value as "Parameter" and it has to …
-
Getting error after scheduling BI Report with Bursting definitionSummary: I have resignation report based on transaction console. I'm scheduling the report with Bursting definition and i'm getting below error. Job processor caused exc…
-
Capability to add CSP Progression Comments in OTBI analysisHi All, Currently, it is possible for a recruiter to add the comments while moving a candidate to different phase / state. The comments are visible in Progress tab under… -
Public Key for sharing with ADP Global View - same key across all environments?Summary: Can we generate the SAME set of public encryption keys across ALL our non-PROD environments? Content (please ensure you mask any confidential information): In t… -
SQL query to fetch the Candidate university name from Academic qualification section in ORCHi Team, Need assistance, we are trying to fetch the university name from the candidate education qualification section. But not getting the data from this table IRC_PRO…
-
Career Site Metrics ReportSummary: Does anyone have Career Site metrics report based on Candidate Tracking subject area in OTBI? Content (please ensure you mask any confidential information): Doe…
-
Start Date change on ORC side - Need to know table where Old start date value is storedSummary: When a candidate is in Post Offer stage and the Start date is changed to a new value, in which table does the old value reside? Context - We are trying to build…
-
Payroll OTBI with Balance Definitions, Names, Feeds and Element names with Input Value NamesSummary We have a Balance Name called Net Pay with a Balance feed of multiple combinations of Elements and Input Value Names but I cannot find this relationship in the m…
-
How to join Transaction ID with Assignment IdentifierSummary: We are trying to join "Compensation - Individual Compensation Real Time" with "Human Capital Management - Approval Notification Archive Real Time". This is so t…
-
HCM Alert Employment DFFHi Gurus, We have a termination Alert Configured using HCM Alerts where we send notification to all HRBPs for employee who got terminated one day prior. The alert is wor…
-
OTBI Report isn't showing all employees' dataSummary: OTBI Report isn't showing all employees' data. shows only Person number and name. Content (please ensure you mask any confidential information): When creating O…
-
Is it possible to embed OTBI report and BIP report in one dashboard?Summary: Hello, I would like to confirm if it is possible to embed OTBI report and BIP report in one dashboard wherein both reports share with the same dashboard prompt?…