Category 81
Discussion List
-
Query to get account numberSummary: Query to get account number present in below screenshot Content (required):Navigation - Payroll>Statement of earnings>Costing Results>Account number. Can anyone…Jaeyshree Kumaran 37 views 1 comment 1 point Most recent by Dharmendra Shukla Reporting and Analytics for HCM -
workforce structure change reporttrying to build a report that captures changes on the department table. We maintain history on our departments, but would like to be able to report on it. If we do the r…Mike Borghoff 85 views 4 comments 1 point Most recent by Prateek Parasar - GTUK, ACE Pro Reporting and Analytics for HCM
-
Subject Area - Department Hierarchy(Department Levels) coming up as blank columnsSummary: Subject Area - Department Hierarchy(Department Levels) coming up as blank columns Content (required): Hi! I'm trying to create a subject area analysis that disp…User_2025-02-11-21-40-21-159 155 views 5 comments 1 point Most recent by User_2025-02-11-21-40-21-159 Reporting and Analytics for HCM -
How do we design action links to navigate to a web page related to that record in HCM?Summary: I would like to be be able to create Action Links in Oracle BI Analysis reports that allow the user to click and then be taken to the record that is being repor…Len M. 31 views 4 comments 0 points Most recent by Srinivas Pendyala-Oracle Reporting and Analytics for HCM
-
View Formatted CLOB Text in BI Report Excel TemplateSummary: We are trying to fetch a formatted CLOB Data in an Excel template. However, the report is fetching HTML tags in the Excel cell . We tried the solution given in …Tanu Shri Patel 285 views 3 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to use one or the other parameter in a SQL querySummary: I have a query that I built that is supposed to either pull in the list of terminated employees based on the date range entered OR a list of terminated employee…User_2025-02-04-08-51-08-912 52 views 3 comments 1 point Most recent by Prateek Parasar - GTUK, ACE Pro Reporting and Analytics for HCM
-
Can we Hide Exporting options from user while running BI Publisher Reports ?Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Kaustubh Deshmukh 33 views 7 comments 1 point Most recent by Kaustubh Deshmukh Reporting and Analytics for HCM
-
Combining two analysisHi Team, Can we combine two or more analysis (columns are same for all analysis) results in a single report? Thanks.
-
Report With the FileURL (Download Link) of an Employee DocumentSummary: We need a BIP report with a download link to an employee's document (DocumentRecords) Content (required): Hi, Is it possible to generate a BIP report with the d…Yaniv 24 views 5 comments 1 point Most recent by Prateek Parasar - GTUK, ACE Pro Reporting and Analytics for HCM
-
Position FTE Over Under - hr_all_positions_f_VL linked to position_fte_sum via position_idSummary: Content (required): We have a data model that was created by a third party and they are linking to HR_ALL_POSITIONS_F to get details on overunder FTE counts. It…Annette M 44 views 13 comments 1 point Most recent by Prateek Parasar - GTUK, ACE Pro Reporting and Analytics for HCM -
Amalgamated Absence DaysSummary: My report is totalling the absence days for all absences of the same reason name and displaying that total on each line of absence in the report. I need it to d…Dawn Cawston - CPS 13 views 6 comments 0 points Most recent by Dawn Cawston - CPS Reporting and Analytics for HCM -
PARAM_EFFECTIVE_DATE based on payroll balance effective dateHi Team, We are creating report using logical SQL. We are fetching balance details for the whole year. So, Assignment details should be based on the balance effective da…
-
Pictorial Representation of Organization TreeSummary: Pictorial Representation of Organization Hierarchy Content (required): HI Team, How we can create Pictorial Representation of Organization tree. Need to display…Reddykrishna Chidella-Oracle 74 views 21 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
HCM Extract schedule SQLSummary: Need SQL to get HCM Extract schedule end date Content (required): Need SQL to get HCM Extract schedule end date Version (include the version you are using, if a…
-
Merged: We invite you to attend a ⭐️ LIVE ⭐️ webinar to deeply understand your Oracle Cloud Applica…This discussion has been merged.Bethany Hubbell 1 view 0 comments 0 points Started by Bethany Hubbell Reporting and Analytics for HCM -
Unable to edit delivered RTF report templateSummary: Unable to edit delivered RTF report template Content (required): Hi, I'm attempting to edit the benefits summary delivered RTF template. The issue I'm running i…User_2025-02-11-21-40-21-159 56 views 7 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
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 54 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 Chidella-Oracle 23 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 48 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 13 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 15 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 12 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 279 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 33 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 12 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