Global HR
Discussion List
-
Post 21B release HRC_TXN_DATA.Data cache column doesn't show XMLSummary Approved/Rejected Global transfer transaction XML data is not coming up in HRC_TXN_DATA data cache column.Content Hi All, We are aware of HRC_TXN_DATA data cache…Hari Arumugam 39 views 1 comment 0 points Most recent by Sahil_Makhiza Reporting and Analytics for HCM -
Tile in Fusion for Managers to directly take them to their Manager ReportsContent We are trying to figure out if it is possible to create a tile in Fusion for anyone with a Manager role to have a tile to take them to our Manager Reports folder…User_2025-02-05-16-39-03-485 45 views 4 comments 0 points Most recent by Wouter.Schaap Reporting and Analytics for HCM -
Bank Account UpdatesContent I was wondering if anyone had a report that was able to pick up changes to bank account information? We currently have a report that pulls the last update date o…User_2025-01-31-00-25-12-234 144 views 4 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM
-
Role security not being enforced on dashboard promptContent I am using "Workforce Profiles - Person Profile Real Time" to create a list of employee certifications by manger (direct and indirect). The "Matrix Manager"."Top…User_2025-01-23-21-24-21-434 17 views 4 comments 0 points Most recent by User_2025-01-23-21-24-21-434 Reporting and Analytics for HCM
-
Detail vs Summary flagContent I have a report that prompts the user for a beginning and ending check date. Is there a way to add a flag to an OTBI parameter that when selected, the report wil…Annette M 29 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
OTBI Dashboard prompt defaultContent I have an OTBI dashboard prompt that I want to default to the current logged in user. However, the session (server) DISPLAYNAME value is in a different format an…User_2025-01-23-21-24-21-434 79 views 5 comments 2 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Extract with a Group RecordSummary The following sample extracts include a group record.Content The following sample extracts provide a list of employees grouped by department with the count of em…Rachel Martorelli-Oracle 120 views 6 comments 4 points Most recent by Mohammed Khan-82529 HCM Extract -
Need help in restricting infolet in Legal Employer Transfer PageContent Dear All, I have created an OTBI infolet on Legal Employer Transfer UI in Assignment section. Now this infolet is visible in all the pages where Assignment secti…User_2025-02-06-14-37-05-233 43 views 4 comments 0 points Most recent by Aliasgar Khambhaty-Oracle Reporting and Analytics for HCM
-
-
HR Help Desk report availabilitySummary Looking for recommendations and examples of reports for managing HR Help DeskContent Does anyone have any tips or suggestions for creating reports for HR Help De…Len M. 39 views 10 comments 0 points Most recent by User_2025-02-10-08-27-16-805 Reporting and Analytics for HCM
-
Ho Do I Call a BI Publisher Report from a Tile on the SpringboardSummary Ho Do I Call a BI Publisher Report from a Tile on the SpringboardContent Hello, We would like to call a BI Publisher report from a tile on the springboard. Does …Daniel McMillian 37 views 8 comments 1 point Most recent by Daniel McMillian Reporting and Analytics for HCM
-
Multiple rows converted to columns grouped by employeeSummary Would like to display multiple phone types by column instead of having separate rows for each oneContent Hi - I am creating a report that shows specific phone ty…
-
Exclude New hires from changes only HCM Extract.Summary Exclude New hires from changes only HCM Extract.Content Hi All, I have to exclude the new hires from changes only HCM Extract. basically i don want the extract t…
-
Salary & Assignment Changes JoinedSummary Report that pulls Salary and Assignment Changes Joined TogetherContent Hi all, Has anyone created a report that pulls both Salary and Assignment Changes joined t…User_2025-01-31-00-25-12-234 112 views 5 comments 2 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM
-
Is it possible to have a WITH clause in OBIEE Logical SQL?Summary Is it possible to have a WITH clause in OBIEE Logical SQL?Content Hi all! Is it possible to have a WITH (subquery) clause in OBIEE Logical SQL? I have to exclude…
-
When applying case statement with group by and aggregate function it is showing error.Summary When applying case statement with group by and aggregate function it is showing error(No fact table exists).I am using 2 subject areas and included fact columns …
-
How to convert numbering format from Indian currency to Dutch (10.13 t0 10,13) to OTBI Report.Summary How to convert numbering format from Indian currency to Dutch (Amount 10.13 to 10,13) to OTBI Report.Content Hi All, We have a requirement to convert amount/curr…User_2025-02-10-16-28-01-402 39 views 5 comments 0 points Most recent by Ninja Reporting and Analytics for HCM
-
Is it possible to create a BI report to search for a string in all the log files for the parent scheContent We submitted a Synchronize Person Assignments from Position and it internally spawned 25 processes. Instead of looking into the individual log files, we wanted t…User_2025-01-22-19-57-39-723 28 views 2 comments 0 points Most recent by User_2025-01-22-19-57-39-723 Reporting and Analytics for HCM
-
How to ensure consistent output of default Date format in OTBISummary Default Date format is different for 2 different users who have same Regional PreferencesVersion Oracle Cloud Application 21B (11.13.21.04.0)User_UM4C6 34 views 1 comment 0 points Most recent by User_2025-02-06-14-37-05-233 Reporting and Analytics for HCM
-
Checklist item and report on there StatusSummary Need a report for onboarding checklist (DoR) which the acknowledgementContent Team, We have onboarding checklist items and using BI publisher for some of them to…Santosh Mudide 54 views 4 comments 0 points Most recent by Santosh Mudide Reporting and Analytics for HCM -
Download approval rule reportContent Good day colleagues! Could you please tell if it is possible to download file with this address: hcm/hrc/db/data/HcmCommonTop/HcmCommonTransaction/ApprovalCompos…Kristina Serikova 27 views 2 comments 0 points Most recent by Dr Surlina Yin-Oracle Reporting and Analytics for HCM -
OBIEE SQL and Listagg functionSummary Need to display a list of degrees and certifications in a list for a reportContent Hi all, I am trying to produce a list of certifications and degrees for each e…User_2025-02-04-08-51-08-912 55 views 2 comments 1 point Most recent by User_2025-02-04-08-51-08-912 Reporting and Analytics for HCM
-
Need inputs to display data in a single record for each employee if an employee is having multiple aContent Hi All, We have a requirement to display Person, Visa and assignment details through OTBI. As of now we are using below two subject areas to achieve this require…
-
Headcount by Age Band in Workforce Trends Real timeSummary Unable to count headcount by Age Band as compared to other attributesContent Hello Experts! I'm hoping this is an easy one! I'm trying to report Period End Headc…Rob F 85 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM