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
-
Invalid Payroll Transactions in the SubledgerContent We have been up for a year on Oracle and have had a very rocky go of it. We have about 50k (yep thats right) invalid transactions for 2020 in the subledger from … -
Field School Empty in Subject Area “Workforce Profiles – Person Profile Real Time”Content Hello All, We have created the following report “Report Degree” which uses the subject area “Workforce Profiles – Person Profile Real Time” and the following col…
-
Point in Time - Home Address for EmployeesSummary Point in Time - Home Address for EmployeesContent Does anyone know if it is possible to create a report that returns employee's home address as of a specific dat…
-
Non Prod Last refresh (P2T) dateSummary Non Prod Last refresh (P2T) dateContent Hello All, Is there any way we can find the Non Prod environment last refresh (P2T) date by using a query/table or profil… -
Misalignment of DatesContent Hi all - I have an issue I've not experienced before. I have an LSQL for a changes report I am working on, and I am pulling in the Last Update Date for the assig… -
Subject Areas in Union analysisSummary Only the primary subject area is visible in a Union analysisContent Hi, We're busy building reports ahead of a not-too-distant implementation of Cloud for HCM & …User_2025-02-08-05-56-00-229 48 views 7 comments 0 points Most recent by User_2025-02-08-05-56-00-229 -
How to Add Worker Details to Job Details in a single report in OTBIContent Hello, I am trying to add the following under Workforce Management-Worker Assignment Real Time subject area: Job-> Job Name, Job Code and Level Worker-> Name Whe…User_2025-02-10-12-13-36-181 21 views 4 comments 0 points Most recent by User_2025-02-10-12-13-36-181
-
Set Column Filter Formula to 'Full Time' - Dashboard TileSummary I've created a headcount dashboard with tiles by employees, contingent worker, Full Time, Part Time, PRN. I've created a column filter formula for all of the til…
-
Action Link LayoutContent Hello experts. I'm trying to use action link. but I'm also unable to edit the layout. I'd like to make it like abutton, not a single stream of text as default. A… -
Question marks in attributes causing filtering troubleContent Hello Experts, We've encountered a situation where a course has been setup in our learning module with a question mark at the end. We've found that when we try t… -
Can we create the output as .txt file in analysisSummary Can we create the output as .txt file in analysisContent i have created a analysis to fetch the assignment number for all the employees.but we need the output as…
-
End Dated Scheduled ProcessesSummary End Dated Scheduled ProcessesContent Hi Team, We have observed some of the scheduled process got stopped in our production environment. this might be due to end …
-
Query/ Table information Required for FYI notification (When manager add new Goal to reportee goal pSummary Query/ Table information Required for FYI notification (When manager add new Goal to reportee goal plan, FYI notification get triggered)Content Hi Expert, Query/…
-
OTBI Report from Person Profile Real Time Subject AreaSummary Person Profile Real TimeContent In reporting out of this subject area I'm encountering multiple rows for a single employee. What I want is one row for one employ…User_2025-01-28-08-47-04-905 113 views 3 comments 1 point Most recent by User_2025-02-08-03-57-26-191
-
QR Code Integration in BI Publisher ReportsContent Hello Experts: Could anyone please confirm if QR Code integration is done earlier for BI Publisher, or any other type of reports. If Yes, what is the process to … -
User behavior and AnalyticsSummary Is there a BI table which captures information on user behaviorsContent Our customer is looking for information on user behavior - which Fusion page is being use…
-
How can I get Job Change Date?Summary Sending data to LMS need to send Date a job changesContent Hello Everyone, I am having a business case where we as a company need to send Job start date and when…
-
Need a SQL Query to fetch previous employment element entry details.Summary Need a SQL Query to fetch previous employment element entry details.Content Hello Team, I have a requirement to fetch Previous employement element entry details …
-
Performance issues while using Period Name and Payroll Name in the Column Prompts LOV of a OTBI repoSummary Performance issues while using Period Name and Payroll Name in the Column Prompts LOV of a OTBI reportContent Hi I have 2 prompts on my OTBI report. Period Name … -
Scheduling ReportContent Hi, The OTBI reports works fine when run manually filtering the conditions but when it is scheduled to run (which is created as agent) it picks up all records ig… -
Reporting HCM Catalog Group and Folder PermissionSummary Creating report to get the list of accounts under Catalog GroupsContent Hi All, I know that we can able to report within OBIEE Reports by creating Data Source. W…User_2025-02-04-07-19-57-588 46 views 2 comments 2 points Most recent by User_2025-02-04-07-19-57-588
-
Group By Function ErrorContent Hello, I'm trying to used the ranked last function and group by Person Number to pull the employee's latest assignment, but I keep receiving the below error. I'v…User_2025-01-31-00-25-12-234 41 views 2 comments 0 points Most recent by User_2025-01-31-00-25-12-234
-
Report OTBI based on role and delegationContent Hi All, Do you know if is it possible to create an OTBI report that extracts all delegations done through the functionality role and delegation? I saw that these… -
Show Field Data in Column instead of in RowsSummary Working on this in OTBIContent Hi All, I am trying to pull in the last 2 dates an employee was paid. Currently the data appears as 2 separate rows. I am using ra…
-
Line Manager Dashboard PromptsSummary AsOfDate not working in my customised versionContent Hi, I have been trying to copy and then customise the Line Manager Dashboard to suit our organisation which …User_2025-02-05-22-44-35-842 69 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle
-
Need to Use Result of One Column in Formula for Next ColumnContent Hello there Reporting and Analytics experts. I am hoping one of you can help me out with an analysis I am working on. I am trying to get our FTE reports up and g… -
Error while using FILTER/DESCRIPTOR_IDOF in formula with multiple subject areasSummary The logical column referenced by DESCRIPTOR_IDOF does not specify a Descriptor ID columnContent I'm trying to summarize Headcount based on Gender, Ethnicity and …
-
Report to show latest demographic infoSummary Report to show latest demographic infoContent Trying to report on latest demographic info for a population but duplicate rows are being returned when I only want…
-
Creating a line graph of headcounts across the past 6 months (for each country)Content Hi, How would one create a line graph of historical headcounts for each country? The date should be on the x-axis and the FTE headcounts on the y-axis, with the …
-
Generating FTE Headcounts for the past 12 months based on each region/business unit - OTBISummary Generating FTE Headcounts for the past 12 months based on each region/business unitContent Hi, How would one generate a time-series plot of the FTE headcounts ac…