Category 81
Discussion List
-
Catalog for Payroll Balances Real timeSummary: Trying to create a report from Payroll Balances Real time SA to match the Balance Results values from SOE with the amount included in the report for the respect…Hem 81 views 1 comment 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM -
Can deduction arrears be one an OTBI report.Summary: Deduction arrears on an OTBI report. Content (required): I need to write an OTBI report for deduction arrears. Is that possible? What subject area do I need to …Donna Valentine 21 views 1 comment 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM -
How can we fetch "Non-Union Benefit Eligibility Dates" in OTBI ?Summary: From the attached screenshot we can fetch all the fields under Extra Information in Workforce Management - Person Real Time subject area except Non-Union Benefi…AaronJai 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
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 11 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 21 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 91 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 12 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 66 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 54 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 22 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 22 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 41 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 41 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 454 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 11 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 547 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM