Category 81
Discussion List
-
Extracting Performance Goals that have attachments using OTBISummary: I am trying to report on performance goals that have attachments, in OTBI, and have searched all of the relevant subject areas, with no success. Is anyone able …Paul Morrissey 32 views 1 comment 0 points Most recent by Sivakumaran Muthusamy-Oracle Reporting and Analytics for HCM -
Benefits Report of Terminated EmployeeSummary: Hi All, Does any one have a Benefits report of terminated employees which Shows their enrollments with Dates parameter? Thanks Content (please ensure you mask a…Naveen setti 13 views 1 comment 0 points Most recent by MilanMohanty Reporting and Analytics for HCM
-
Is there a way to find out if the users really using the current assigned role that they have?Summary: In the Fussion application, we can pull list of users who has a certain data role. But we wanted to know who among those users in the list that are actually usi…Lorejean Gelacio 31 views 2 comments 0 points Most recent by MilanMohanty Reporting and Analytics for HCM
-
Report to fetch all position Name changes but the job remains sameSummary: I want to fetch a report for the position name updates when we have same job code Content (please ensure you mask any confidential information): we need to find…Rajesh Suvala85 21 views 8 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM -
Line Manager and HR getting different values for years of service formulaSummary: I am working on a report that lists employees that have upcoming birthdays and upcoming anniversaries in the next month. If they have a birthday, that birthday …joshvanlaan 12 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Using Dashboard Prompts When Using OTBI AgentGood day Experts, Is there a way to use the available dashboard prompts in a dashboard when creating an OTBI Agent? For example I have a dashboard where the default peri…JMLMIII 27 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI Export Using Formatted > Excel Row LimitationGood Day, I have a set of data consisting of 90,000+ rows. Exporting via Data > Excel, all rows are retrieving when exported. But exporting using Formatted > Excel, it o…
-
Could it be possible any way to Expiration date of SIN to be mandatory also.Summary: For Canada Location The SIN No is mandatory.Could it be possible any way to Expiration date to be mandatory also. Content (please ensure you mask any confidenti…swarup ghosh 13 views 1 comment 0 points Most recent by Joey O-Oracle Recruiting, Opportunity Marketplace -
Need dashboard prompt based on field with complex formulaSummary: I have a report on a dashboard that has a field that gives me the highest level of education obtained by first ranking the degrees on the employee's records and…
-
Sql Query to get payroll deduction detailsSummary: I am looking for a query which provides terminated employees last earnings and deduction details from payroll. Content (please ensure you mask any confidential …Rahul K-Oracle 440 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Work scheduleSummary: Is the a way to export all work schedules set up and whether they are in use? Thanks Content (please ensure you mask any confidential information): Version (inc…Lara Slater 21 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
Customer wanted automate the T4 slips that should deliver to terminated emps personal email addressSummary: Hi Experts, Need suggestions on how to automate the T4 slips that should deliver to terminated emps personal email address, if anyone implemented this functiona…Rama123-Oracle 11 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
HCM Auditing/ Audit reportSummary: Hi ALL, We'd like to understand what auditing is available and how detailed auditing would be enabled. It may just be an OTBI report, it may require some settin…RamkumarKadhiravan 26 views 1 comment 0 points Most recent by Satyam Roy Reporting and Analytics for HCM -
SSN not removed from headingContent I want to modify alert notification template, where when employee update their contact relation, their SSN number should not be visible to approver. However when…Aanila Nanda-Oracle 13 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM -
Rest API to create individual compensation planSummary: Hi All, Is there any REST/SOAP API available to create individual compensation plan? Thanks, Venkatesan R Content (please ensure you mask any confidential infor…
-
How internal candidates can apply for Hiring events?Summary: How internal candidates can apply for hiring events? After being added to the event, candidates are receiving bell notification to register, they are able to op…
-
Payroll Audit ReportSummary: Hi All, Do we have any option for audit report on Payroll details. Who has accessed a specific salary/payroll screen in the past 7 days? Thanks, Ram Content (pl…RamkumarKadhiravan 22 views 2 comments 0 points Most recent by RamkumarKadhiravan Reporting and Analytics for HCM
-
HR Audit reportSummary: Hi All, I have a question regarding the HR Audit report feasibility. If HR were to identify sensitive data, is it possible to enable auditing on a handful of sp…RamkumarKadhiravan 1 view 0 comments 0 points Started by RamkumarKadhiravan Reporting and Analytics for HCM
-
Last Date WorkedHow to pull "Last Date Worked" from Termination Info? Is there a table in BIP where we can pull this column?Ronel M 3 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Troubleshoot Incorrect Work Pattern SQL QuerySummary: Hello, I am a beginner with SQL and am trying to resolve an issue with an incorrect Work Pattern Report built for us by an Oracle Consultant. I am trying to get… -
Best Approach to Restrict Seeded Folders AccessSummary: We have users from 3 areas such as HCM, Finance and SCM. We have dedicated Custom reports folders for each set of users such as HRs can access 'Custom HCM Repor… -
BI Publisher - pulling Candidate Source Medium and SourceSummary: We have a BI publisher report that we want to use to report on Candidates who are specifcally coming from these two Source Mediums: Referral and "Candidate adde…Evelina Hobson 25 views 3 comments 0 points Most recent by MilanMohanty Reporting and Analytics for HCM
-
Need to change default from email address"bipublisher-report@oracle.com" to customer email addressesSummary: Hi Experts, We are trying to burst the BI outputs and needed to change the default from email address "bipublisher-report@oracle.com" to other. Let's say for le…Rama123-Oracle 238 views 1 comment 0 points Most recent by MilanMohanty Reporting and Analytics for HCM
-
Is it possible to schedule reports under My Client Groups > Compensation > View Administration Rpts?Summary: Is it possible to schedule any of the reports under My Client Groups > Compensation > View Administration Reports? Content (please ensure you mask any confident… -
Need query to get the list of all roles for a given roleSummary: Navigation: Tools > SecurityConsole > Roles If I query a role name, I want display all the roles associated with it. I want to build a query for the same. Pleas…Niranjan_DTCC 42 views 4 comments 0 points Most recent by Dhilip Kumar P. Reporting and Analytics for HCM
-
Need query to get the list of all users for a given roleSummary: Need query to get the list of all users for a given role Could you pleaes provide me the query to get list of all users for a given role. attached the screen sh…User_7A1QO 566 views 1 comment 0 points Most recent by Phani S-Oracle Reporting and Analytics for HCM
-
OTBI Report not match count - Absence ModuleSummary: I built a OTBI report using Workforce Management - Absence Real Time Subject Area, but I noticed in front-end there are 3 Absence Plans for my sample employee b…Joanah 11 views 2 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
SQL query for absence disbursementSummary: Hi Experts, I need to fetch the absence disbursement value for a plan (screenshot attached) using a SQL query. Can some one please help with a sample SQL for th…Pinky Mukherjee 50 views 1 comment 0 points Most recent by Phani S-Oracle Reporting and Analytics for HCM -
BIP Report - How to calculate exact AgeSummary: Hi All, Can anyone please confirm the query to calculate the exact Age in BIP report. I tried multiple functions like Datediff & Months_between but, they are no…Sagar Perala 59 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Can we pass SYSDATE in Share report link URL of reportWe need to pick sysdate instead of static date in report Link. eg: https://fa-****-saasfaprod1.fa.ocs.oraclecloud.com:443/xmlpserver/Custom/XXXX/Reports and Analytics/Co…Sourabh Patial 51 views 13 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM