Category 81
Discussion List
-
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 51 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 53 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 23 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 43 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 43 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 426 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 520 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 11 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 378 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Not getting any data when opening the reportSummary: Content (required): Hi Expert, We have built a report and it is an Individual Compensation report, I have all the roles but when I am assigning payroll admin an…Faizan Rashid 34 views 11 comments 0 points Most recent by Faizan Rashid Reporting and Analytics for HCM
-
Users cannot see their own accrual balanceSummary: Users cannot see their own holiday accrual balance in OTBI accrual report Content (required): I have an OTBI report showing Accrual Balances using the Accrual R…s_b 21 views 2 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Need inputs to get the Target Element Name under Status Processing RulesSummary: Need inputs to get the Target Element Name under Status Processing Rules in Element UI Content (required): We can have a link between Pay_Element_types_vl and P…
-
US Reporting for Legal ComplianceSummary: Content (required): Hi team, An US client asked us some Reporting for Legal Compliance. We found that Oracle HRMS and Oracle HRMS provide support for several co…Gabriele Falso-Oracle 21 views 2 comments 0 points Most recent by Gabriele Falso-Oracle Reporting and Analytics for HCM -
How do I access a .dat file that has been loaded into the systemSummary: I am trying to review file that was processed through our recruitment application but I can't figure out how to review the actual .dat file Content (required): …User_2025-02-04-08-51-08-912 22 views 2 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
User Login DetailsSummary: Hi I am looking for a BI / OTBI report that would give me the user login details. Content (required): I looking for a report that contains, User Name, Email, Pe…Manoj B. Cheruvathoor 408 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
OTBI reports to replicate delivered reports in Workforce Compensation > Pay for PerformanceSummary: Workaround solution following 21D release "improvement" Content (required): It has been decided by Oracle to disable reports in order to improve the performance…Amandine C-Oracle 32 views 1 comment 2 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM