Category 81
Discussion List
-
BI Publisher reportingI primarily use OTBI for reporting and then copy the SQL from these reports if I need to create a BI Publisher report. I do this because I find it so difficult to find t…Paul Morrissey 21 views 3 comments 0 points Most recent by Bharat Agrawal Reporting and Analytics for HCM -
How can we send the report or notification BI or OTBI different languages based on country or personSummary: Hi Team, I'm new to above type of requirement to convert or send the resptive languaes , how can we achive this type of scanario? Thanks, Ajay Content (please e…AjayKumar Maddipati 11 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
which table can store the information about user's parent & child relationship roles in fusion hcmHi All, Thanks for looking into this issue. I am looking for table, which can store the current logged user parent -child roles(for Ex: One big role have more number of …Ravindr-Oracle 103 views 10 comments 0 points Most recent by Rajesh.Vadlamani Reporting and Analytics for HCM
-
EEO-1 report output format in HCM CloudSummary: EEO-1 report output format in HCM Cloud Content (please ensure you mask any confidential information): We are in the process of generating EEO-1 reporting that …Parag Hiremath 21 views 6 comments 0 points Most recent by AlyssiaKing Reporting and Analytics for HCM -
what is seniority date and how will get in report and diffence between seniority date and Hire dateSummary: Hi Team, what is seniority date, how will get in BI or OTBI report and diffence between seniority date and Hire date. Thanks, Ajay Content (please ensure you ma…AjayKumar Maddipati 31 views 1 comment 0 points Most recent by Aliasgar Khambhaty-Oracle Human Capital Management
-
When manager run the BI report only need to get the details of direct or indirect reportiesSummary: HI Team, When manager run the BI report only need to get the details of direct or indirect reporties how can we develop this requirement? Thanks, Ajay Content (…AjayKumar Maddipati 11 views 1 comment 0 points Most recent by Ellen Manthei Reporting and Analytics for HCM
-
Talent Pools - Succession Plan KPI reportSummary: Need to build report using below fields - either OTBI or BIP. Kindly help please. Content (please ensure you mask any confidential information): Column Name Des…Pradnya_Pampatwar 21 views 1 comment 0 points Most recent by Pradnya_Pampatwar Reporting and Analytics for HCM
-
What is the diffrence between Date start and Orginal_Date_of_hire in PER_PERIODS_OF_SERVICESummary: Hi Team, we have to two columns for Hire_Date in PER_PERIODS_OF_SERVICE table what is difference between. if not why two columns given. Thanks, Ajay Content (pl…AjayKumar Maddipati 52 views 2 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
OTBI Report Job RequisitionWe have an OTBI report is the attached xml. https://us.v-cdn.net/6034893/uploads/LYIGJUNHB6NP/jobrequisition-otbi-xml.txt https://us.v-cdn.net/6034893/uploads/VVZRABE1TC…SauluriR 71 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Is there an OTBI Creation, Modification, Deletion Audit Report Available?Summary: Looking to know if there an audit report available that could be run to see reports and folders that have been created, modified, or deleted. Ideally, we would …G. Class-Peters 11 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to report on Historical Organization Hierarchies?Summary: We have 6 historical versions of our organization tree, but when trying to report on the previous versions in reporting, only the latest organization hierarchy … -
Need to identify the tables that hold sensitive information using Oracle Cloud RecruitingSummary: I need to identify the any tables that hold sensitive information (PII). We have started using Oracle Cloud Recruiting and want to identify tables that have thi…
-
we would need a report with the previous and new cost center OTBI ?Summary: Hi Team, Hope all doing well ! we would need a report with the previous and the new cost center ? Could you please help me on ? Thanks, Ajay Content (please ens…AjayKumar Maddipati 31 views 6 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
IN BI report how to restrict the usersSummary: Hi Team, how to restrict the user in BIP query. suppose i want to restict one person in query how can i restrict. Thanks, Ajay Content (please ensure you mask a…AjayKumar Maddipati 21 views 7 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
OTBI report for learner count, count of learner according to number of courses completedSummary: I have to create a report to get the count of learners who have completed more than 1 course and learners who have completed more than two courses. Also I need …
-
Can you please provide us the details of the report which provides information about all the reportsSummary: Can you please provide us the details of the report which provides information about all the reports along with permission set to that particular report Can you…Shubham Bindal 11 views 4 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Logical SQL join condition for Recruitment and Transaction ConsoleHi, I have a report where I am using below tables for fetching recruitment and postion details like JobRequisitionNumber, RecruiterFullName,DepartmentName,RecruitingType…
-
Bursting BI Publisher HTML EmailHi Experts, I have created the Bursting Definition below for testing purposes. select har.REQUEST_ID as KEY, har.RUN_ID as TEMPLATE, 'en-US' as LOCALE, 'PDF' as OUTPUT_F…Paul Worsley 61 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Gross earnings reportSummary: Is it possible to create a report in OTBI that shows gross earnings per pay for a specific date range? If yes which subject area should we use? can anyone help …Shameer Shaik 31 views 2 comments 0 points Most recent by Shameer Shaik Reporting and Analytics for HCM
-
Using dashboard prompts on multiple-subject area analysisSummary: Using dashboard prompts on multiple-subject area analysis Content (required): Hi all, I created an analysis to track a specific group of managers (narrower than…
-
How to add a specific custom button to a page using Page Composer?Summary: How to add a specific custom button to a page using Page Composer? Content (please ensure you mask any confidential information): I have a custom button that li…Stefano_Mazzocca 541 views 1 comment 0 points Most recent by Vijay Shanmugam-Oracle HCM Redwood Personalization Helper Tool -
Need to fetch HOD comments in Performance managementSummary: I am trying to fetch HOD Comments in Performance task in Fusion HCM? And which table this comments will store? Generally, comments will store in HRA_EVAL_RATING…Venkatasivaiah 1 view 1 comment 0 points Most recent by RWMATTHE-Oracle Reporting and Analytics for HCM
-
How to enable audit for any personalization changes that are done via a sandbox in Oracle HCMSummary: We have a requirement to capture any personalization changes that are done via a sandbox in Oracle HCM application. Kindly let us know how to enable and track t…
-
What does Oracle Cloud use as the out-of-the-box formula for time to fill for a job req?We are in needing to know what formula and/or calculation Oracle Cloud uses on the out-of-the-box Recruiter Dashboard for Time to Fill (Requisition Aging). We are rebuil…Jay_Brannan 11 views 1 comment 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM
-
OTBI with a List of Courses and a link leading to the course pageSummary: Content (required): Hi there, I have created a simple OTBI report with a list of all the courses we have in Fusion Learning - xml code is at the bottom. I wante… -
Need assistance for bursting paramter4Summary: Hi Everyone, I need your assistance regarding the bursting report. I want to add a data source in my subject email but when I try to add it gives me an error. c…
-
ACA Eligibility Process caused duplicate Action Codes to appear with differing datesWe found that the ACA Eligibility Process is duplicating action codes on employees' assignment histories and it's not clear how we would easily query assignment records …
-
Does anyone know which tables I need to use to retrieve the Bonus Amount from the Compensation ModueSummary: I have a requirement to show last years performance bonus amount in a report and I have built most of the information using SQL but I am unsure what tables I ne…User_2025-02-04-08-51-08-912 621 views 6 comments 0 points Most recent by Phils Reporting and Analytics for HCM -
How to get one object from a string in OTBI ReportsHi Team, We have a requirement where would like to get a particular object from a string which has _ in it. Example: This the string we have in one column Evaluation_OLC…Malla Pratibha 21 views 1 comment 0 points Most recent by Bharat Agrawal Reporting and Analytics for HCM
-
HTML Markup values are not working after 23B updateSummary: Good afternoon, I am having issues while trying to save an edit of code within the sandbox > HTML Markup. When making the replacement, the system only saves par…Jorge_Trindade 61 views 8 comments 0 points Most recent by User_3MBEU Reporting and Analytics for HCM