Category 81
Discussion List
-
OTBI Data Missing After Excel ExportThere are two instances with OTBI reports where I have gotten the message below that have impacted reports. In one report, hyperlinks are not working, and in another, ro…Alexander George Demczak III 23 views 2 comments 0 points Most recent by Sarma Yeddanapudy-Oracle Reporting and Analytics for HCM -
Read-only Privileges for General Ledger TasksSummary: Kindly let us know if there are any read-only roles / view roles available for the following tasks: Financial reporting structure: Manage Chart of Account value…Ananya Das 39 views 1 comment 0 points Most recent by Julien_Dubouis Reporting and Analytics for ERP
-
How can we create drill down charts in Oracle BI Publisher (BIP) ReportsSummary: I want to create an interactive or drill down charts in BIP reports, where clicking on a chart updates the data in other charts and tables. Not sure how to achi…Neha Bhatt 213 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Does anyone know how to restrict data in BIP report based on user who will run it?Summary: How to restrict data in BIP report based on user who will run it? Content (required): Hello I am running report in BIP regarding no performance goal plan. Can y…Hazel De Castro 567 views 5 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
We have BI report but need to send custom schedule like 1st monday, 3rd monday in a monthSummary: Hi Team, We have BI report but need to send custom schedule like 1st monday, 3rd monday like this in a month how will send if through burshting how can we send …AjayKumar Maddipati 24 views 6 comments 0 points Most recent by Dhilip Kumar P. Reporting and Analytics for HCM -
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 28 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 17 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 24 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 32 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 19 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 20 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 74 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 14 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 37 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 27 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 18 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 66 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 536 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 7 views 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 15 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…