Global HR
Discussion List
-
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 47 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. 42 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 45 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…
-
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 113 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 44 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 31 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 30 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 61 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 29 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 61 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 91 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to add drill down feature on Formula ColumnSummary How to add drill down feature on Formula ColumnContent Hi Experts I created an analysis using "Workforce Management - Worker Assignment Real Time" to see the Age…Dharmendra Shukla 43 views 6 comments 0 points Most recent by Dharmendra Shukla Reporting and Analytics for HCM -
How to Implement Specialized Reporting Security in OTBI for Fusion HCMSummary Creating Custom Roles for Specialized Reporting Access in Oracle Transactional Business Intelligence (OTBI)Content By default OTBI would always enforce Fusion HC…user714053-Oracle 712 views 2 comments 6 points Most recent by Tamer El-Tonsy - Tatonsy Reporting and Analytics for HCM
-
Query to fetch data model output in hdl formatContent We are trying to automate HDL process using BI publisher report and Extract. Data model query to include output for Worker dat file with two metadata lines (Assi…Kavya Sreenivasulu 786 views 3 comments 0 points Most recent by Kiran Kancherla Reporting and Analytics for HCM
-
Filter Logical SQL based on dashboard prompt with multiple valuesContent Hi Thurrock are developing a customised version of the Line Manager Dashboard to suit their needs. An important aspect is having the ability to drill-down throug…User_2025-02-06-09-29-18-902 185 views 13 comments 0 points Most recent by Raymund Jerome Reporting and Analytics for HCM
-
Which table stores active/inactive user details flag?Summary Which table stores active/inactive user details flag?Content Hello, I developed the below SQL to get all the users details with role details. But this query retu…
-
Goal Plan Status ReportContent Hi, I am looking for a report that will tell me the goal plan status and if anything requires approval. Has anyone created something like this? I tried using the…tiffnyc 69 views 13 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
How to remove Extra blank lines in Excel output from BI Publisher RTF templateSummary How to remove Extra blank lines in Excel output from BI Publisher RTF templateContent Hi Experts, How to remove Extra blank lines in Excel output from BI Publish…Bala Kasineedi 82 views 4 comments 0 points Most recent by Bala Kasineedi Reporting and Analytics for HCM
-
Analysis of platform usabilityContent Hello experts Does anyone have any query analysis or report that enables us to see system data like. Users who are accessing most the POD (LOGINS) Which Modules …Pedro Teixeira 24 views 3 comments 1 point Most recent by Caroline Gladwin-Oracle Reporting and Analytics for HCM -
Need details on right place to get each salary component exact value but not adjustmentSummary Need details on right place to get each salary component exact value but not adjustmentContent In current configuration, monthly salary basis is configured with …
-
Pull data between 2 dates using Subject AreasSummary Pull data between 2 datesContent Good Evening, Has any one had luck with pulling historical information in between 2 dates? For example, we had someone who was o…User_2025-01-23-21-37-42-476 46 views 1 comment 0 points Most recent by Nivya Mathire Reporting and Analytics for HCM
-
Is it possible to created Facts/Measure in Logical SQLSummary Is it possible to created Facts/Measure in Logical SQLContent Hi all, I need to pivot and show percentage of a column but seems like it is not possible to create…Raymund Jerome 40 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI Report error for employeesSummary OTBI Report error for employeesContent Hi Team, I have enabled a HCM infolet to show personal details and is working fine from admin user. but when custom employ…Vinod SM Gowda 79 views 3 comments 1 point Most recent by Srinivas Pendyala-Oracle Reporting and Analytics for HCM -
Employees with Leave Status within a Specific MonthSummary Employees with Leave Status within a Specific MonthContent We are tracking leaves through Manage Employment using Action and Assignment Status. Our HRBPs would l…Kathleen Nguyen 29 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Table(s) that store Persons Language, Degree, Prior Work Experience, Licenses/Certificate InformatioSummary Looking for the hcm tables that store Person info such as Language, Degrees, Prior Experience, LicensesContent Hi, We want to create data model(s) to pull the Pe…