Category 81
Discussion List
-
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 449 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 12 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 1 view 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 33 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 11 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 680 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 41 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 369 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 53 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 12 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 505 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 84 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 53 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 14 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 623 views 9 comments 1 point Most recent by Girish Bhatia Reporting and Analytics for HCM -
SQL Query to get flexfield content about DepartmentsHello, How can I find the info on the following attributes (list down below) of organization units (in this case: departments) in HCM views and tables so that it could b…TomaszWyszomirski 29 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Email Notification Report for NudgesSummary: Email Notification Report for Nudges Content (please ensure you mask any confidential information): Hi Team, Greetings! Is there a way to get the list of email …Parag Hiremath 11 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
How to restrict schedule process page based on usersSummary: How to restrict schedule process page based on users Content (please ensure you mask any confidential information): Hi All, As of now who ever has access to sch…Venkatesan 11 views 1 comment 0 points Most recent by Alexandru Dicu-Oracle Fusion Applications Administration -
What is the table name of evaluation comment during "Share and Release" phase?Summary: What is the table name of evaluation comment during "Share and Release" phase? Content (please ensure you mask any confidential information): During performance…Stefano_Mazzocca 42 views 1 comment 0 points Most recent by Adriana Tudor-Oracle Reporting and Analytics for HCM -
Access run history & older report outputs of OTBI scheduled reportsHi! We have end users who sometimes request previous run versions of scheduled reports. Wondering if there is a way to access run history along with report data output o…Ameya_J 23 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Need to build an analysis report of all pay periods that exist to dateSummary: I'm trying to build an analysis in OTBI that brings me all of the pay period names and dates for all Consolidation Groups in a Legislative Data Group. This is t…sarah_1000 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Link Produce Costing Setup Details with Assignment DataSummary: I am trying to link data from the following two subject areas:- "Payroll - Payroll Costing Setup Details Real Time" "Workforce Management - Worker Assignment Re…Mark Stoker 2 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to run Generate Prenote File report of Payroll of HCMSummary: Hello, I wanted to run the oracle seeded report Generate Prenote File report of payroll module of HCM. But I don't know how to run this report. Thanks Content (…VAIBHAV L 35 views 6 comments 0 points Most recent by Anca Andronic-Oracle Payroll and Global Payroll Interface (GPI)