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
-
HCM Integration Real TimeSummary HCM Integration Real TimeContent Hi Experts, I am trying to build an OTBI report based on "HCM Integration Real Time" subject area to fetch HCM Extract definitio… -
SQL query for balance groups and definitionsContent Hi, I need to write a SQL query to extract balance groups and the balance definitions contained within each group. I can see the balance groups are held in PAY_B…
-
How to read Planned Schedule informationSummary Which tables are involved?Content Hello, which tables do we need to use to read Planned Schedule information? Please see the attached image. Thanks, Nicola
-
Candidate Address and Other - IRC_JobOffer_Accepted_External - Alert/NotificationContent Hi, Using Alert: IRC_JobOffer_Accepted_External, added template. Whereas Procurement Department need to be informed that Candidate accepted offer. Procurement ne…
-
BIP Report Export Issue for Excel FormatSummary BIP Report Export Issue for Excel FormatContent Hi Experts, BI Publisher Report able to generate in PDF, where as if we try to export in to Excel, getting error … -
CR/LF values in rtf template issueSummary CR/LF values in rtf template issueContent Hello All, We developed an interface file and this file will be read by mainframe system. I am seeing a strange issue t…
-
RTF with more than 30MBSummary RTF with more than 30MB Content We have template a RTF template with more than 30MB file which is employee handbook have lots of images. Since its more than 30MB… -
Need Help with E-textSummary Arabic data getting Jumbled in Etext tempalteContent Hi There, We are having a requirement wherein the data in the database is in Arabic. We are preparing the e-…
-
Report needs to show accruals for current and previous time dimensionsSummary Report needs to show accruals for current and previous time dimensionsContent Experts, Need your help!Could you please let me know if you would use an HCM Extrac… -
Is there a way we can track daily performance/task.Summary There is a need to track daily/weekly/monthly deliverables as all the employees working from home.Version 21C
-
Use TIMESTAMPADD in SQL PrefixSummary What is the correct syntax for using TIMESTAMPADD in a SQL prefix without using a presentation variable prompt?Content Hello - I am creating an analysis that wil…User_2025-02-08-04-27-03-855 26 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle -
Calculate Time at grade, location, time in role (not position) using Assignment Event Real Time in HContent Hello, I am trying to use OTBI to look at an employee's assignment history and derive new calculated fields for the following: * Grade Effective Start Date and t…
-
Issue in Turn Over ReportSummary I have built Turn Over Report with 2 subject areas workforce Management-Assignment Event Real Time and Workforce Management- Trend Real Time .Content The Columns…
-
How to get the only Error message from FAULT_PAYLOAD columnSummary How to get the only Error message from FAULT_PAYLOAD columnContent Hi Experts, Good Day!! We are trying to pull the failed transaction details from transaction c…
-
How dependent parameter works in OTBI Report, BI Report and DashboardSummary How dependent parameter works in OTBI Report, BI Report and DashboardContent Hi Experts, Can someone explain how the following thing works in OTBI Report, Dashbo…
-
Sample snapshots of OOTB Reports and AnalyticsContent Hi Everyone, Client need sample snapshots of all OOTB report and analytics, Let me know where can i get all snapshots of OOTB report and analytics. Please let me… -
Multiple Dashboards to oneContent I have created 2 separate dashboards one for Headcount and one for Performance Document. I want to now add the performance dashboard as a separate tab on the hea…
-
Recruitment Subject Area - retrieve Candidate skillsSummary Fusion (21c) Subject Area Recruiting - Recruiting Real TimeContent Our customer requirement is to see Skills from the 'Skill and Qualifications' Candidate sectio… -
SQL - Job Table historySummary We want to pull all rows from the job code table and have the following SQL. The query pulls several rows for the same effective start date. Any suggestions? Tha…
-
HCM Integrations Real Time Subject AreaSummary Extract SubfolderContent 1. Do we have any column which says if that extract is seeded or custom?2. Though I can see the Rule in Extract Definition, but can not …
-
Adding parameters to a deep linkContent Hi, Does anyone have steps or documentation of adding parameters to a deep link to go into a specific person's page/details from an OTBI report? Deep Link - http…
-
Average Time to HireSummary Documentation or Logic of Average Time to HireContent Is there any documentation or means to know how the measure "Average Time to Hire (Days)" is calculated in …
-
Please share SQL to return only employee person type whose termination approvals has been acceptedSummary Please share SQL to return only employee person type whose termination approvals has been acceptedContent Hi All, Please share SQL to return only employee person… -
Absence Management | Hours Worked Year to DateContent Hi all, I have a request to create a report that shows hours worked year to date. Is there a specific subject area that I should be referencing? We do have the A… -
How to bring different type of manager in analysisSummary To display matrix manager and functional manager in analysisContent In fusion system, as per business requirement, there are two types of manager type, one is Li…User_2025-01-29-18-45-19-617 78 views 6 comments 0 points Most recent by Raghavendra Raghunath-Oracle
-
Duplicate lines in OSHA 300 when an employee transfers to a new job/positionSummary Duplicate lines in OSHA 300 when an employee transfers to a new job/positionContent We are working through some issues where an employee has two rows within the … -
Role permissions to BI reportsContent We want to give access to our HR manager to modify BI report or create an adhoc OTBI analysis for the recruitment and onboarding module. What permission can we g…
-
HCM Cloud Delivered Approval RulesContent Does anyone have a list of delivered approval rules and the workflow details on each rule? I am trying to understand what is delivered to help client determine w…
-
commonly used HCM tables in fusionContent Hi, Any body has commonly used HCM tables in fusion, Please let me know. Regards, Reddykrishna
-
Add 45 day to Benefit Program Date in OTBI AnalysisSummary Add 45 days to Benefit Program Date in in OTBI Analysis filterContent Hello, I need to add a filter to the OTBI analysis. The filter should add 45 days to the Be…