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
-
How to fetch 'Y' for Managers having direct reportee and 'N' for Managers not h'ing direct reportsSummary: Sql to get 'Y' for the Managers having direct reportee and 'N' for the Managers not having direct reportees in oracle fusion hcm. Please suggest. Content (requi… -
OTBI: "Performance Task": How to get 1 value per employee on report?Summary: All Performance Tasks show as "Ready" unless the task has been started, then it gets a second value of "In Progress". I would like my OTBI report to only have o… -
Fiscal calendar in OTBIHas anyone built a fiscal calendar in OTBI? A 5-4-4 fiscal calendar. Our fiscal year starts in November (October 28th for 2020). We have a lot of reports that we end up … -
Pass parameter to embedded report in pageSummary Pass person id as parameter to embedded report.Content We need to display some employee information on the Public Info page for any employee. Since personalizati…
-
Employment History extract is not picking up Salary history records when assignment effective date iContent Employment History extract is not picking up Salary history records when assignment effective date is not between salary start date and salary end date Here are … -
SQL help needed to get the effective start date of employee's assignment status changeSummary SQL help for determining effective start dateContent Hi All, Really hoping someone can help me out. I got really close on my query but I am missing something whe… -
Random Sampling of EmployeesContent I am trying to pull 50% of the employee population at random. Is there a report or formula I can use to pull this information?
-
Work structure reports for Oracle HCMSummary Work structure reports for Oracle HCMContent Do anyone have list of reports which can help pulling the work structure details from the configuration tables - JOB… -
Unable to create new infoletSummary In sandbox mode but can’t see create infoletContent Hi, can anyone please direct me to a document in MOS or something here which explains steps to create infolet… -
Reporting TemplatesContent Hello Everyone, Can anyone please share me sources(video links, documents,samples etc) for learning ETEXT, RTF templates that covers right from the very basics.?…
-
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 21 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 …