Category 81
Discussion List
-
Report for Eligible Benefit plan details for EmpHi We have process Open enrollment and life event is in started state, and emp can enroll into the benefit plans , but we need to created a report which display emp deta… -
Employee historical rowsSummary: Looking to get a report of all employees in the system and all of their historical records. If we run the Worker Assignment Real time subject, it can pull histo…Mike Borghoff 51 views 3 comments 1 point Most recent by Mike Borghoff Reporting and Analytics for HCM
-
Drill down reportSummary: Drill down report Content (required): I have created analysis with two columns as department and head count, I have created action link on headcount column whic…Reddykrishna 21 views 2 comments 0 points Most recent by Sovitendu Jalli-Oracle Reporting and Analytics for HCM -
How to show all organization/department levels in hierarchical tableSummary: I'm trying to build an analysis showing all departments in each legal entity but only get departments that have employees connected to them. Content (required):…Matti Bugge 32 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Adding a column that calculates the % based on absolute numbersSummary: Content (required): Hi there I am sure this must be fairly simple but ... I have a report with pie chart for people completed, not started and in progress for L…Bobby Jourdan 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Print performance document from MobileSummary: When i try to print a performance document from mobile, it's blank. I created a custom button to print it Content (required): Talent Management Version (include…
-
RestAPI -for HCMSummary: I have to extract organization information from HCM using RestAPI but I struggle to find the "organization tree" Could someone tell me how to get an overview of… -
In any of the OTBI Subject area, multiple Manager_Type are not available.Summary: When I am using workforce management checklist real time subject area for the 'Contact Person for external' type of manager I am unable to find column where the…User_2025-02-11-23-20-16-609 11 views 7 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
What tool(s) are recommended for populating a data warehouse?Summary: Content (required): We are currently using BIP because the EDW has requested full tables. We're looking into the alternatives due to our volume (35,000+ workers…Scott Paulin 11 views 1 comment 0 points Most recent by Dilpreet Kaur Reporting and Analytics for HCM
-
Dynamic file name and dynamic sheet name for excel templateSummary: Content (required): I need to run the report for every month and output generated via Excel template. I need the output file name with the month and year for wh…Jaeyshree Kumaran 263 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Dynamic Pivot in excel templateSummary: Content (required): I have 2 sheets on my excel template output. the second has all the output columns and their data. Based on second sheet I need to create a …Jaeyshree Kumaran 31 views 1 comment 0 points Most recent by Nivya Mathire Reporting and Analytics for HCM
-
Filter out a double entry and leave only one entry in Person Profile Real Time subject areaSummary: Filter out a double entry and leave only one entry in Person Profile Real Time subject area Content (required): Hi there, We have a report that lists all the va…Bobby Jourdan 11 views 4 comments 0 points Most recent by Ellen Manthei Reporting and Analytics for HCM
-
OTBI Column decodeHi In OTBI report , we need to decode the column value , like if column value is 'ABC' the we need to decode the it 'BCD', how can we do this please? Thanks
-
Report on all the comments that the enrolled users have done in Enrollee Self-service conversationSummary: Content (required): Hi there I want to run a report on all the comments that the enrolled users have done in Enrollee Self-service conversation in a course. Is …Bobby Jourdan 1 view 2 comments 1 point Most recent by Bobby Jourdan Reporting and Analytics for HCM
-
In a scheduled report send outcome only if the result of a specific query is 20Summary: In a scheduled report send outcome only if the result of a specific query is 20 Content (required): We need to count the number of extract run. If the result is…Nicola Petri 21 views 4 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
HCM - Employee termination manager approval comments - how to reportSummary: Content (required): It has been noted that the comments made by managers in the approval of a termination are only part of workflow and can not be reported on. …Annette M 71 views 3 comments 0 points Most recent by Sowdha Murugan Reporting and Analytics for HCM -
Not able to view entire data in assignment and performance related subject areaSummary: I am using performance document status Real time/worker assignment real time subject areas but in the respective subject area I am able to see only my record. I…Kamini Kaushik-Oracle 21 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
For how long the Job Run History of a BIP report is maintained in Oracle Fusion?Summary: Content (required): Hi Team, For how long, the report job history for a BIP report is available in Oracle Fusion? How often the history is purged? Is it configu…MandeepGupta 21 views 2 comments 1 point Most recent by MandeepGupta Reporting and Analytics for HCM -
Not able to view entire employees details in Subject area only able to view own recordSummary: I am using Assignment and performance related subject area to fetch details of employee but when I am using my subject area it is only displaying only my data. …Kamini Kaushik-Oracle 98 views 3 comments 2 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Trying to create a calculated item using fields from two subject areasI have created a report using balances and calculation cards. The report will run and return data from both areas but when i try to create a new field using a formula th…Sharon Harper 21 views 1 comment 0 points Most recent by Ellen Manthei Reporting and Analytics for HCM
-
Position Details with Grade Minimum and MaximumSummary: I am trying to get a report of all active positions, their grades and pull in grade min and max. I don't want to base this off of worker assignment since I want…Jennifer Wiggs 11 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to integrate data to our custom web site using data module build in Oracle BI PublisherWe are building intranet for our office and we want to use the data available with oracle BI publisher. We have already created data module in BI Publisher but currently…Kiran Kancherla 11 views 2 comments 0 points Most recent by Kiran Kancherla Reporting and Analytics for HCM
-
How to connect two data groups using number DBI and text DBI in HCM Extracts?Summary: In sql we can use to_char(HDOR.documents_of_record_id) = to_char(FAD.pk1_value) but in HCM Extracts is there any way to connect. Please help me on this. Content…User_2025-02-05-14-11-28-072 31 views 0 comments 0 points Started by User_2025-02-05-14-11-28-072 HCM Extract
-
Accessing OTBI analysis using a linkSummary: Just like we can access the BI report using the link to the report where we can use _xmode to hide all the BI page buttons. Can we also access OTBI analysis usi…Abhishek Nigam 51 views 2 comments 1 point Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM -
Applying filter for the analysis report with in the dashboard.Summary: Content (required): Currently we are building a dashboard with number of analysis/reports on Headcount using 'Workforce Management - Workforce Trend Real Time' …Su Ma 51 views 5 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Invoice Line DFFsSummary: How to associate invoice line dff fields back to the invoice line via sql Content (required): The table PJB_BILLING_EVENTS holds attribute_number1 field for inv…dwright 11 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Extract the Report Name and Description (Audit Report)Summary: Extract the Report Name and Description (Audit Report) Content (required): Hi Team, We have requirement to export all the report name, report path and report de…[Deleted User] 11 views 4 comments 0 points Most recent by Nivya Mathire Reporting and Analytics for HCM
-
Recruiting - Need to show Offers made that were Declined and the reason givenSummary: Does anyone have a report or dashboard built that will return this? The business needs to review the reasons given for recruiting offers made to candidates that…Rich R 11 views 2 comments 0 points Most recent by Sovitendu Jalli-Oracle Reporting and Analytics for HCM -
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…User_ENPUR 201 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM