Category 81
Discussion List
-
Capturing the time of activitySummary: Content (required): hi there I am running a report for a classroom course with several offerings. A few of the offerings happen in the same room on the same dat…Bobby Jourdan 13 views 2 comments 0 points Most recent by Bobby Jourdan Reporting and Analytics for HCM -
Need a report that shows everyone is a Closed Life Event StatusSummary: Could someone provide me with the correct criteria that shows everyone who is in a closed Life Event Status. I am using the subject area "Benefits Enrollments R…User_2025-02-11-00-58-38-371 32 views 1 comment 0 points Most recent by Adam Gates-Oracle Reporting and Analytics for HCM -
Is it possible to download the BIP output files to the particular folder in Machine?Summary: Is it possible to download the BIP output files to the particular folder in Machine? Suppose when we run any report, is there a way to download the output files… -
Workforce Learning - Learning Management Real TimeSummary: Can anyone please help me with the table names/SQL that is being used in the Workforce Learning - Learning Management Real Time subject are .we have requirement…minati_behera-Oracle 93 views 2 comments 0 points Most recent by minati_behera-Oracle Reporting and Analytics for HCM
-
Error uninstall Oracle BI Publisher Desktop 1670:Unable to Load module with error code:1114Summary: We are trying to uninstall Oracle BI publisher Desktop , but we are getting below error 1670: Unable to load module c:\Users\Admin... Error Code: 1114 Could you…
-
How do I schedule a Job, So that a Job starts when earlier scheduled Job is completed.Summary: Schedule a Job for 10 sets of Employees so that each job set starts before earlier Job completes Content (required): I need to schedule a Job for 10 sets of emp…Anjan Polimera 16 views 1 comment 0 points Most recent by Anjan Polimera Reporting and Analytics for HCM
-
How to create date range parameter i.e. Date from and Date to in OTBI report?Summary: How to create date range parameter i.e. Date from and Date to in OTBI report? Content (required): We want to fetch payment details from specific date range in O…Priyanka More-Oracle 1.5K views 4 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM
-
OTBI Analysis takes about 20 minutes to return results, how to improve performance?Summary: OTBI Analysis for Master Headcount Report takes 20 minutes to display results. Content (required): Our client is migrating from EBS to HCM Cloud. Currently they…Vinay Hardas 72 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
User folder not visible in right pane due to system limitation of 300 folders at a timeSummary: Per Doc ID 2443757.1 users folder permission can be set by navigating to folder. However though I can see the user folder in left pane can't navigate to the sam…
-
How to Calculate Payroll ReversalsSummary: How to include payroll reversal values in calculation Content (required): We have BI publisher report that calculates Payroll distribution for all of our employ…GauravGupta39 62 views 5 comments 0 points Most recent by Ellen Manthei Reporting and Analytics for HCM
-
Create LOV for countries defined in the system and few more custom valuesSummary: Can we create an LOV that will include all countries already defined in the system plus few more custom values. Content (required): Version (include the version…
-
Value of a LOV is restricted depending on logged in userSummary: How can we restrict the values included in an LOV depending upon the logged in User Content (required): Version (include the version you are using, if applicabl…
-
Email Notification when Employee Changes Their NameSummary: I would like to setup an email notification to go out to a particular address each time an employee changes their name. Or optionally one email per day with a l…User_2025-02-12-02-38-00-520 23 views 4 comments 0 points Most recent by Vinayak | Camptra Tech Reporting and Analytics for HCM
-
How to get a PTO Accruals report with ONE line of data for balance per EE?Summary: We are using a 3rd Party for our PTO Accruals (UKG). Primary issue: Some EE's are in 2 plans, so they have 2 lines of data. The issue is that UKG will only pick…
-
How to get a details of Clock Entries missing for 3 days or more (OTL Module)Hello all (Report Description: The list of employees who have missing clock entries for 3 days or more should appear in the custom report) can anyone please tell me wher…
-
How to burst different notifications to different mail IDs based on exit interview responsesSummary: How to burst different notifications to different mail IDs based on exit interview responses Content (required): We have implemented the Offboarding Process in …
-
OTBI Filter CriteriaSummary: Need help to add a filter criteria in OTBI analysis. I am using the below filter criteria which is working in payroll subject area: "Balance Types"."Balance Nam…Mohan Murali 24 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
HCM - Administrator Role for Report Scheduling in HCMSummary: Create an Admin record in HCM for Report Scheduling Content (required): Is there a way to create a user account in HCM that can be used as a central scheduler f…
-
Segregate visibility on OTBI to allow users to report only on Recruiting Subject AreasSummary: Content (required): Hello, The customer is requesting us the possibility to let Recruiters to access the OTBI and create some custom reports only related to Rec…gguittini 44 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
SQL to return all job roles where a particular duty role is usedSummary: SQL to return all job roles where a particular duty role is used Content (required): Hi Team, Please share SQL to return all job roles where a particular duty r… -
Pass an employee ID parameter from an analysis to a Skills pageSummary: We want to have an OTBI analysis table of employee information with a link per person that takes the viewer to the Skills and Qualifications page with the emplo…User_2025-02-05-22-55-58-511 48 views 2 comments 0 points Most recent by User_2025-02-05-22-55-58-511 Reporting and Analytics for HCM
-
DFF value is not coming in the OTBI reportSummary: Content (required): Hi Expert, We have created a DFF in the document of record and when we are using the OTBI report to fetch the data for this specific dff the…Faizan Rashid 479 views 2 comments 0 points Most recent by Faizan Rashid Reporting and Analytics for HCM -
Is there a UE that can fetch LE details including LE addressSummary: Requirement is to get all active LEs and their respective address along with Bank Details for the UE. Content (required): I tried using the below UE but it does…Vibha Pandey - Oracle 15 views 1 comment 0 points Most recent by Raghavendra M Reporting and Analytics for HCM
-
Can we get offering old and new status?Summary: Hi All, I am working on a report where the requirement to get the old and the current status of the offering. I queried mentioned below tables to get the status… -
Adding data element to a data model (Adding Full_Name to EEO-1 report)Summary: Assistance requested in adding Full_Name to a data model Content (required): We have some EEO-1 reports that were built by someone else prior to my arrival. One…
-
Source System ID for Work TermsSummary: Sample Query to extract SSID for Worker.dat >>>> Work Terms object upload Content (required): We have a requirement to extract SSID of work Terms object for Wor…Dhajani Perera 577 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Best practices on how to combine HR data from other non Oracle applications with Oracle CloudSummary: I would like to know how other customers have linked data from other applications to their Oracle cloud solution. we have OAC and use ADW as a data source and a…Robert Geddes 13 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Converting UTC to EST time zone in Logical SQLSummary: Our report is built with logical sql, the approval dates are displaying in UTC time zone and we need these to reflect EST time zone. Need help with syntax. Cont…Denise Izzi 2.5K views 7 comments 0 points Most recent by Rajesh.Vadlamani Reporting and Analytics for HCM -
Aggregate function in OTBI AnalysisSummary: Please share some documentation on using various aggregate functions on any column of an OTBI analysis Content (required): Need to use aggregate functions acros…Hem 403 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM