Category 81
Discussion List
-
Table which stores the goal commentHi Team, I am working on BIP report to get the Goal details, I am using below tables for the report. HRG_GOALS HG HRG_GOAL_PLAN_GOALS HGPG HRG_GOAL_PLANS_VL HGPL HRT_REV…Saurabh_Mharolkar 38 views 2 comments 0 points Most recent by Saurabh_Mharolkar Reporting and Analytics for HCM -
Report on SkillsSummary: Report on Skills Content (please ensure you mask any confidential information): Hello experts, does anyone know if there are standard or shared reports about Dy…Oriana L. 30 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
How to update Candidate Name and address using HDL?Hi Team, I am trying to update Candidate Name and Address using HDL, but getting below error. Please let me know which date we need to pass while updating Candidate Name…Saurabh_Mharolkar 152 views 2 comments 0 points Most recent by Juan Carlo Culibra-Oracle HCM Data Loader (HDL) -
Each sheet of a BIP report extraction is extracted to a different Excel fileSummary: Each sheet of a BIP report extraction is extracted to a different Excel file Content (please ensure you mask any confidential information): Hi Each sheet in the… -
How to maintain the number format when a BIP report is exported to ExcelSummary: Maintain the number format when a BIP report is exported to Excel Content (please ensure you mask any confidential information): Hi When a BIP report is extract… -
Can customers report on Signer's IP Address for electronically signed documents within Oracle HCM?Summary: We have a need to report on all of the various components of electronically signed documents/forms within Oracle HCM Onboarding Journeys. These data items shoul…Marnetta Griffin 17 views 1 comment 1 point Most recent by Claudiu Postolache-Support-Oracle Journeys -
Can I make an Academic Year 'Time' dimension in OTBI?Asking for a colleague Hi all, I need to show workforce trends over time by Academic Year e.g. 2023/24 = 1 September 2023-31 August 2024. I have successfully made time s…Mark Stoker 14 views 1 comment 0 points Most recent by Abdul Rauf Mohammad-Oracle Reporting and Analytics for HCM -
Person Legislative Information Field Teacher Reference Number no longer showing dataSummary: After 24c was implemented on our Production environment we noticed that one of the fields in the subject area was no longer producing any data. The field in que…Mark Stoker 79 views 18 comments 0 points Most recent by Rebecca Hawker Reporting and Analytics for HCM -
Areas of Responsibility - No Results when including Worker DataSummary: No Results is being returned when including any Worker data into an analysis for Areas of Responsibiltiy Content (required): We are creating an analysis using t…David Bean-259734 460 views 14 comments 0 points Most recent by Adam Gates-Oracle Reporting and Analytics for HCM -
Performance Manager Not Appearing in AnalysisSummary: We are trying to create a report for our Performance Reviews that is able to show us an individuals Performance Review Status, Score, and other details. As part…Brent_Beardsley 16 views 2 comments 0 points Most recent by Brent_Beardsley Reporting and Analytics for HCM -
Is it possible to realize OTBI analysis to extract manager different from line manager data?Summary: Possibility to realize OTBI analysis to extract manager different from line manager data? Content (please ensure you mask any confidential information): Hello, …Caterina Ruggiero 5 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Download PDF DashboardsSummary: Download PDF Dashboards Content (please ensure you mask any confidential information): Hello experts, we would like to download a dashboard as pdf but it seems … -
Show Only Maximum Current Year Enrollment Coverage Start DateSummary: I have an OTBI Benefits report that should show only current year max enrollment coverage start date . The Enrollment Coverage Start Date field has the below co…JHaden3 37 views 4 comments 0 points Most recent by Sarma Yeddanapudy-Oracle Reporting and Analytics for HCM -
Date Format not convertedSummary: I am trying to get date in the format of 'Monday, 1st of January, 2020' using the query below in data model: select TO_CHAR(SYSDATE, 'Day, DDth "of" Month, YYYY… -
Where can I update the below highlighted text under Navigator --> Me --> Benefits?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Shilpa Varghese 17 views 2 comments 0 points Most recent by Shilpa Varghese Reporting and Analytics for HCM
-
Create an Effective Date Parameter for OTBI ReportSummary: Hi. I am sorry if this question has been asked before. I am looking to add a Effective Date Parameter to an OTBI report so when the user goes to run the report,…Jose Guerra 2.1K views 20 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Query to get Payroll costing details to match with EFT paymentsSummary: Need query to fetch the Costing of payments - Accounts, Account Type, Cost amount (Debit & Credit), Accounting date and prepayment details. It needs to be match…Priyabrata Prusty 698 views 5 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
I Combined two subject areas but two records coming with active status but only one activeSummary: Hi Team, We have Combined two Subject Areas but assignemnt status showing as active with two records both are active but diffrence is one is with termination da…AjayKumar Maddipati 45 views 10 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
How to display the output of a BIP Report in multiple excel sheetsSummary: How to display the output of a BIP Report in multiple excel sheets Content (please ensure you mask any confidential information): Hi, we created a BIP Report, w…Barile Alberto 400 views 4 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Do we have feasibility to get the employees without performance document attached in OTBI report?Summary: Do we have feasibility to get the employees without performance document attached in OTBI report? This should be work based on Prompt basis like review period, … -
Oracle cloud HCM sql queries to fetch details of employees who left the organization(ex-employee)Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Srujana Reddy 61 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
BU prompt in OTBI report isn't working. Whatever BU is selected, data is being returned for all BUsSummary: I have created a report with both a graph and a pivot table designed to return a count of faculty members with different attributes. I need these counts to be b…David Pearson 26 views 2 comments 0 points Most recent by David Pearson Reporting and Analytics for HCM -
Exceeded Configured Maximum Number Of Allowed Output Prompts- error code WVIMVZWVSummary: Exceeded Configured Maximum Number Of Allowed Output Prompts- error code WVIMVZWV Content (required): Exceeded Configured Maximum Number Of Allowed Output Promp…Swati U 514 views 8 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Learner evaluation reportSummary: Content (please ensure you mask any confidential information): Hi Team, I have created learner evaluation report where in I want each question text to be a colu…Shikha Agarwal 90 views 8 comments 0 points Most recent by Jayanthi Shetty Reporting and Analytics for HCM
-
HCM Compensation/Payroll Element Entries History Real Time Excluding Inactive / Terminated EmployeesSummary: Payroll - Element Entries History Real Time does not appear to be returning data if the employees latest assignment is inactive (the employee is terminated). Co…bwdata 65 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
What parameters to pass when scheduling TimecardApprovalNotificationBulkReport to get XML fileSummary: Hi experts, We have a requirement to get the XML file from a seeded report - TimecardApprovalNotificationBulkReport. However, when scheduling the report, there'… -
I need sql query to get employee timezone like employee working timezoneI need sql query to get employee timezone like employee working timezoneLakshmiVanarasi 18 views 1 comment 0 points Most recent by Satyam Roy Reporting and Analytics for HCM -
Is there a table which holds the certificate information within the security consoleSummary: Is there a table which holds the certificate information within the security console for users. I need to see what certificates employees have associated with t… -
Report on Active/Inactive UsersWe have a list of users (not employees, these are users created in the security console; our implementation partner) and I want to report on these users and whether or n…Alex Cardenas 647 views 9 comments 1 point Most recent by Girish Bhatia Reporting and Analytics for HCM