Sample Reports
Discussion List
-
Generate run balances seeded processSummary: If we run Generate Run Balances need to know what all are the transactions/records are added/updated in the Pay_run_balances tables Content (please ensure you m… -
Absence Calendar / Dashboard (Sample Report)Summary This dashboard creates an absence overview that can be used by either HR or the line manager to get more information about absences for the organization, team, o…Even Kjorsvik-Oracle 1.2K views 16 comments 4 points Most recent by GraemeC Reporting and Analytics for HCM -
Talent Review Meeting Report-Security BIPSummary: How can we limit the visibility of the Talent Review Meeting Report so that facilitators can only view the meetings where they are assigned as a facilitator, wi…
-
Report dashboard prompt showing error - ACIOA5LNSummary: Report dashboard prompt showing error - ACIOA5LN Content (required): One of the working BI report which uses dashboard prompt, suddenly stopped working and show…Swati U 3K views 17 comments 1 point Most recent by Aaron Epstein-261578 Reporting and Analytics for HCM
-
OTBI Element Type Setup report with Costing not showing data if the element is not costedSummary: Hello. I'm trying to report on Element Type Setup with Costing details on OTBI using the "payroll - element enteries history real time" subject area. The report…Laura_Stewart_Sita 22 views 4 comments 0 points Most recent by Laura_Stewart_Sita Reporting and Analytics for HCM
-
Manager information regarding the last active assignment of inactive employeesHello, In Oracle HCM system, the manager information of the employees who left the job is emptied, therefore the managers of the inactive employees are empty in my repor…Cansel Karasoy 17 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Query to get Vacation Rules informationSummary: Query to get Vacation Rules information Hi, We need to create a report for vacation rules for all employees in the system and I know that there is a seeded repo…Kiran345 522 views 14 comments 0 points Most recent by Deepak Kumar Dev-Oracle Fusion Applications Administration -
Send automatic birthday wishes to employees via mail from organization.Summary: Send automatic birthday wishes to employees via mail from organization. Content (required): Hello All, I have a requirement, need to send automatic birthday wis…
-
How to get the the latest balance from HCM ExtractHi, I have created a balance group HCM extract to retrieve the custom balance value. I have selected the UE - PAY_INTERFACE_PAYROLL_REL_UE and selected the process type …
-
Presentation variable in Column Filter possible?Summary: Hello all, Not sure if this is possible - I would like to use a variable inside a column filter, for example for YTD Actual I have filtered on scenario Actual H…Ian.Gooderham 25 views 7 comments 0 points Most recent by Ian.Gooderham Reporting and Analytics for HCM
-
Hcm tables/query which stores CA meal and rest break detailsHi Team, We have client requirement to create report for following details. Time Code(s) = Rest Time Violation and Meal Time Violation Time Card Work Date Attestation Qu…
-
Requesting details on FDIHi Team, We are planning to implement FDI module ( Reporting ); and I am unable to get much details on FDI on CCC as well as on HelpCenter. Can you kindly assist on the … -
salary formatted in rtf templateSummary: Hi everyone, We are customizing compensation letters for a client. We are having problems formatting the amount field for a certain bonus that should be paid to…Gerardo Peluso 134 views 3 comments 0 points Most recent by Chris O-Oracle Reporting and Analytics for HCM
-
Sql query that retrieves the total number of processed hours claimed by an employee in OTLI need sql query that retrieves the total number of processed hours claimed by an employee in Oracle Fusion Time and Labor.
-
We looking employees Names in arabic language like LANGUAGE = 'AR'Summary: Hi Team, We looking employees Names in arabic language. for department name we used Transalation table HR_ALL_ORGANIZATION_UNITS_TL ,,and dept_arabic.LANGUAGE =…AjayKumar Maddipati 109 views 2 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM -
SQL needed to find parent department in department tree for any given department nameSummary: SQL needed to find parent department in department tree for any given department name Content (required): Hi All, Please share SQL to find parent department in …C.R.Balaji 3.1K views 8 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Learning Management - Activity Completion DateSummary: Hi - I am trying to build an OTBI report that would show all activities in a course at the employee level and whether or not they have completed that activity o…
-
How to duplicate a page in the dashboard?Summary: Hello, how to duplicate a page in the dashboard? I want to copy a page in existing dashboard so I could have the same layout. Thanks! Content (please ensure you…
-
Query to find BIP report schedule detailsSummary: Query to find BIP report schedule details Content (required): Hi Team, We have requirement to fetch the schedule details of a BIP report like schedule start dat…Vasanthakumar Ravi 2.5K views 8 comments 1 point Most recent by Dev V Reporting and Analytics for HCM -
Transactions Tables are not storing Data for few TransactionsSummary: Hi Team, I am trying to fetch the transaction details for Time Change Request Approval. But I have encountered that there two tables that were not storing any d…Dasari Dileep 266 views 5 comments 0 points Most recent by kanchana venkatasubramanian Reporting and Analytics for HCM
-
How to remove null values in OTBI? If I change choice list to SQL, the Limit Values disappears.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…
-
How to compare output of two files in oracle fusionSummary: We've created a custom BIP report to get the salaries of each employee. This output from the publisher, we wanted to match with the document with same format wh…zafarkhan 21 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Need to report on Work schedule with attached work pattern and attached holidaySummary: Hi Every one, I need help to develop one absence report where we can see work schedule and attached exceptions and workday/non workday. Below is sample output:-…Krishna Manmohan 12 views 1 comment 0 points Most recent by Phani S-Oracle Reporting and Analytics for HCM -
Optimizing Infolet Loading Time on the SpringboardHello Community, We’ve designed and implemented multiple infolets for employees, line managers, and HR, placing them on the springboard to provide quick access to releva…Harish Vummidi 12 views 1 comment 1 point Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Request for Infolet Samples to Enhance User Experience in Core HR, Absence, ORC, OTL, and PayrollHello Community, I’m currently exploring ways to enhance the user experience for employees, line managers, and HR teams in Oracle Cloud by leveraging infolets effectivel…Harish Vummidi 22 views 0 comments 3 points Started by Harish Vummidi Reporting and Analytics for HCM
-
How to create a Bell Curve in OTBI reportSummary: Client team is expecting to show the Performance Rating Distribution results in a Bell curve model as shown in the attached screenshot. Could you please share a…Santhosh Gangishetty 306 views 14 comments 0 points Most recent by Gimhani Perera Reporting and Analytics for HCM
-
Time Change Request reportSummary: Hi All, Has anyone Developed a BI/OTBI Report on Capturing Details of Time Change Requests? We have a requirement and working on this. Appreciate if anyone can …Abhishek Bhaskar 24 views 3 comments 1 point Most recent by Peeyush Chandel Reporting and Analytics for HCM -
Query to get REQUISTION NUMBER, REQUISITION NAME, CANDIDATE SELECTION PROCESS, REQUISITION STATUSSummary: Can anyone please help me in writing a Oracle SQL Query for BI Report to fetch columns like REQUISTION NUMBER, REQUISITION NAME, CANDIDATE SELECTION PROCESS, RE…a.w.anand 2.1K views 9 comments 0 points Most recent by Gongati Nandish Kumar-Oracle Reporting and Analytics for HCM