Category 81
Discussion List
-
No Results- The specified criteria didn't result in any data in WorkForce Manag.- Person Real TimeSummary: Hello Oracle Experts. We are trying to create an OTBI for generating the employees loaded in the Fusion ERP. We don't have HCM in scope, it is only SCM and Fina…Lokesh_619 73 views 5 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
How to Automate BACS file to be placed in UCM server?Summary: We have a requirement where BACS File generated using "Make EFT payments process" should be automatically sent to UCM(Oracle WebCenter Content). If anyone has f…
-
Report a journey task status "not applicable"Summary: How can I report, via OTBI, the status "not applicable" if an employee clicked on it during the completion of a journey? It won't appear as a completed task on …Jacqueline GRANDIN 23 views 4 comments 0 points Most recent by Jacqueline GRANDIN Reporting and Analytics for HCM
-
How to fetch Level 1 department for a person via SQL codeWhats the sql code behind level 1 department in Worker assignment real time subject area?
-
Is there any API to mass create B2B Trading Partners in CMKSummary: Is there any API to mass create B2B Trading Partners and Manage Customer Collaboration Config in CMK Content (please ensure you mask any confidential informatio…Babu Chalamalasetti 4 views 2 comments 0 points Most recent by Babu Chalamalasetti Reporting and Analytics for HCM -
Infolets sampleHi Experts, Can someone share infolet samples/catalog files for employee and manager ? Thanks in advance. Regards, NivyaNivya Mathire 32 views 3 comments 0 points Most recent by Nivya Mathire Reporting and Analytics for HCM -
How can I optimize/simplify my KPI formula in order to reduce the time of the report to load?Summary: It takes 13mins to load my report using the formula since I have to add 2 values on my KPI formula before getting the percentage. Is there a way to optimize my …John Patrick Diaz 12 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Sql query in dashboard prompt for bi publisher parameterSummary: Hi All, I am developing one Absence report by BIP report. The requirement of this Absence report is to show the employee's absence details in his dashboard. For…Sai Krishna Chelikani 123 views 2 comments 0 points Most recent by Sai Krishna Chelikani Reporting and Analytics for HCM
-
procurement work confirmatSummary: Subject Area for Purchase Order Work Confirmation Please i need to know if there's a subject area in OTBI which stores the data for work confirmation for procur…Mona_ahmed 13 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Report Hours Worked/Processed by PayrollSummary: I need to be able to report hours processed by payroll from beginning of the year to current. I cannot use the timecards. I thought it would be in the payroll r…Jessica D 22 views 1 comment 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Does anyone have a EEO-4 that meets the layout specifications they would be willing to shareSummary: We are required to submit an EEO-4 report by December 5, 2023. Content (required): The EEO-4 report is a mandatory biennial data collection that requires all st…Emily Wilde 22 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Restrict/Hide "CORRECT" option in Person Assignment screenSummary: Looking for an option to restrict or hide the "CORRECT" Option available in the Person Assignment screen thereby not allowing business users to modify any perso…
-
Report for Changes OnlySummary: We are currently not able to pull out a report with the last change done for a person in the system. Content (required): We have multiple reports in Oracle base…
-
Learning - Reporting on Penetration RateSummary: We would like to be able to report on the penetration rate of our learning module. I think the idea is to report the percentage of people assigned to a learning… -
Person Real Time Subject Area and Future Hire DateSummary: I have a simple report/analysis using the subject area Workforce Management - Person Real Time. This report is used to extract 2 custom Extra Information fields…
-
OTBI Formatted and Data Export LimitWe are exporting OTBI reports that has more than 300k rows. We're able to export 75k rows in Formatted Excel and 300k rows in Data format options. Anyone has specific nu…CAMIL_Q 169 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Reporting Capability Maturity Matrix : Reporting Road MapSummary: I'm trying to develop a notion or framework for "Reporting Capability Maturity", as something organisations could use to assess how good they are at Oracle repo… -
Is it feasible to Print an Entire Dashboard (with multiple pages)?Summary: Is it feasible to Print an Entire Dashboard (with multiple pages)? Content (please ensure you mask any confidential information): I would like to print an Entir…Harish Malik 31 views 4 comments 0 points Most recent by Harish Malik Reporting and Analytics for HCM -
Headcount as of date - security scopeContent (required): I am working on a headcount dashboard for HR employees, so that they can see the headcount as of date (number of employees, FTE etc). I am facing an …Jacqueline GRANDIN 12 views 5 comments 0 points Most recent by Michael Grant Reporting and Analytics for HCM
-
How can we enable visibility on OTBI Absences for a user?Summary: Hi all, We have a user who as per their profile can access Absence Records, but cannot view Absence reports in OTBI - any idea how to get round that? Any privil…Cora_Stanciu 13 views 1 comment 0 points Most recent by Nivya Mathire Reporting and Analytics for HCM
-
cant show HR Representative in Otbi reportHello , I want to create a otbi report where i want to see my subordinates which is i am HR representative. I am the line manager of some employee and HR Representative …Mirza_Adeel 35 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Measuring the Completeness of Onboarding Task by EmployeeSummary: Measuring the Completeness of Onboarding Task by Employee Content (please ensure you mask any confidential information): In the Onboarding report use the Checkl…Thulasi Ram 3 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Differance between data table ending with "_" and normal data table?Summary: Differance between same data tables but ending with "_" table? Content (please ensure you mask any confidential information): Hi Team, I have a query. what is t…
-
What payroll field and table track if a deduction (element) was actually deducted from gross?Summary: If an employee's gross pay is not large enough to accommodate all of his/her payroll deductions (i.e. taxes, benefit deductions, 401K), it looks like Oracle ded…BeachDreamer 101 views 1 comment 0 points Most recent by BeachDreamer Reporting and Analytics for HCM -
Report to get the list of employees with change in payroll groupSummary: Report to get the list of employees with change in payroll group Content (required): Hi Team, Greetings! The change in payroll group, especially from weekly to …Parag Hiremath 31 views 5 comments 0 points Most recent by Gail Wilmoth Reporting and Analytics for HCM -
Differance between table and view?Summary: What is the differance between table and view? Content (please ensure you mask any confidential information): Hi Team, Can some one will help me the below query…
-
Subject area changesSummary: Advanced notice of SA Changes. Content (please ensure you mask any confidential information): Document 2431130.1 provides guidance on subject areas that can be …Ms_Oracle 32 views 1 comment 0 points Most recent by Abdul Rauf Mohammad-Oracle Reporting and Analytics for HCM -
AccidentAccidentally created....Justin Hittell-14055 12 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Types of keys in data tables?Summary: How many types of keys are there in data tables? Content (please ensure you mask any confidential information): Hi Team, I have some queries. How many keys are …
-
Returning information from the middle of the valueSummary: Hi our work location fields are in the format "UK-[city]-[street address]", but when I run an analysis I only want to return the city name. Is this possible? Is…