Category 81
Discussion List
-
How to give mirror text formatting in rtf templateSummary: For one of the client requirement , in rtf template i need to show the text in mirror look. Please do the needful. If anyone tried this , please help us. Conten…SAKTHI SUNDAR 32 views 1 comment 0 points Most recent by Ankur Miglani Reporting and Analytics for HCM -
How do we get Date performed ,Percentage of Performance Tasks by Status in performanceSummary: Hi All, I am using the Workforce Performance - Performance Task Status Real Time subject area for an OTBI Analysis. Can you please let me know from where Date p…Asha Jennifer 21 views 1 comment 0 points Most recent by Andrew Gillibrand-Oracle Reporting and Analytics for HCM
-
Agent for a BI report?Summary: Content (required): Hi there Is there a way to prepare an Agent for a BI report? Thanks B Version (include the version you are using, if applicable): 22D Code S…Bobby Jourdan 61 views 9 comments 0 points Most recent by Bobby Jourdan Reporting and Analytics for HCM -
Period Rolling Turnover by Employment CategorySummary: I am trying to get a rolling turnover by employment category. This analysis doesn't change any value even if I provide the assignment category filter. The resul…Anita 33 views 2 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
How to customize Goal workflow notificationSummary: How to customize Goal workflow notification Content (required): Hi All, We have a requirement to customize the Goal workflow notification. we need to replace th…
-
Identify the list of reports that a custom role can accessWe have 100s of custom reports within our /Shared Folders/Custom BI catalog folder structure. We have quite a few custom HCM security roles and each custom folder & repo…Pradeep TU 73 views 1 comment 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
How to calculate percentage of Employees with more than 5 hours of learning?Summary: I need to get the percentage of Employees with more than 5 hours of learning for a specific time period in OTBI. So far, I have: a counter for employee names to…A Geyne 41 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Custom report permission with Custom RoleSummary: Hi We have requirement where we wants to give a custom report access to all of the employee of the company. Our organization in using all custom role (Custom Em…Manisha Gupta 23 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Legal Employer LOV not populating while running EEO ReportsSummary: Hi All, While running the EEO-1 report, I am not able to find any Legal Employer coming in the dropdown. We have 3 LEs in the system and in other actions, I am …Gaurav Rath- PGC 51 views 1 comment 0 points Most recent by Abhishek Tiwari, CPP -Oracle Payroll and Global Payroll Interface (GPI) -
23A New Feature Summary and What’s NewSummary: 23A New Feature Summary and What’s New are now published to the Readiness site: https://www.oracle.com/webfolder/technetwork/tutorials/tutorial/readiness/offeri…Cindy Klymov-Oracle 162 views 0 comments 4 points Started by Cindy Klymov-Oracle Reporting and Analytics for HCM -
Add 2 Report Measures: Dept Active FTE and Vacancy Rate %Summary: I have an Analysis that calculates vacancy rate by department. I need expert advice on how to add two measures to the pivot table. I want to add a measure "Dept…
-
Candidate Progress Summary ReportSummary: Content (required): Can anyone share the OTBI sample report to extract the candidate progress summary? Version (include the version you are using, if applicable… -
Payroll costing - position levelSummary: Breaking down the payroll costing report by position. Content (required): For example, if an employee had a position change on the 15th of September, is there a…User_2025-02-11-21-40-21-159 33 views 3 comments 0 points Most recent by PEEYUSHARORA Reporting and Analytics for HCM -
We develop new custom report but we getting some of employes have two recordsSummary: Hi Team, We develop new custom report but we getting some of employes have two records due to terminattion date actuallyin ui no termination date but some have …AjayKumar Maddipati 33 views 4 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
Is there a document for creating a report for Oracle Digital AssistantSummary: We have received a requirement from one of our clients and they want to create a report for ODA Content (required): Basic requirements from the report - What qu…Avik Roy Chowdhury 51 views 3 comments 2 points Most recent by Dr Surlina Yin-Oracle Digital Assistant -
Hi! How can I run a query to pull data within 90 days from the effective date?Summary: I need to create a query to pull data less than 90 days of effective date to use as agent and decrease the number of lines in the reporting. Content (required):…
-
BIP - List of Employees under the Area Of Responsibility of HRSummary: Hello, Does anyone know how to get the list of employees under the Area of Responsibility of HR via BIP Report? Could you please share a query or do you have do…Hazel De Castro 144 views 13 comments 0 points Most recent by User_2025-02-12-21-24-25-654 Reporting and Analytics for HCM
-
How to get location for position in OTBISummary: How to get location for position in OTBI Content (required): I tried using location name column under Position folder from position real time subject area but i…Swati U 152 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
we have head count nearly 9000 employees and coming to this report only showing 5700 plus employeesSummary: Hi team, we have head count nearly 9000 employees and coming to this report only showing 5700 plus employees may i know how to check the issue. person real time…AjayKumar Maddipati 52 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Secured List View - How it works in a BIP ReportSummary: Hello, Is there any documentation or white paper on how secured list view works in a BIP report? Content (required) We used secured list view in our BIP query t…Hazel De Castro 596 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
I am needing SQL for SalaryIdSummary: I am looking for an sql that includes SalaryId for trouble shooting an error I have in data flowing into FAW. I have the SalaryId in the error in FAW but can't …Sharon Ferguson 12 views 2 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Not able to find column as Pending changes in Position subject areaSummary: Not able to find column as Pending changes in Position subject area Content (required): In manage position, we have "Pending Changes" column. see attached. Does…Swati U 45 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How can I calculate Absence Sickness for Employees for 4 absences of 3 days or more?Summary: I need to produce a report for employees that have had more than 4 sickness absences of 3 days or more within a rolling 12 month period. I have managed to creat… -
BI Reporting function that creates link to attachmentsOrganization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Oracle Consulting Description (Requir…Claudio Marini-Oracle 32 views 0 comments 3 points Started by Claudio Marini-Oracle Reporting and Analytics for HCM
-
Logical SQL querySummary: Content (required): I am trying to join the candidate person number to their employee person number to get their days of service since I need this data by recru…Riti Malhotra 42 views 1 comment 0 points Most recent by Riti Malhotra Reporting and Analytics for HCM
-
How do I run a report on average age of employees?Summary: I need to run a quick report on the average age of employees in the whole organisation and per Legal Employer. Content (required): I have the report with employ…User_2025-03-10-21-26-28-299 33 views 1 comment 0 points Most recent by Jahnavi-Oracle Reporting and Analytics for HCM
-
how to restricted otbi report to show employee absencesDear , I have a otbi report which is showing correctly result with all employees absences but issue is its showing for those employee who applied leaves on 2021 Dec to 2…Mirza_Adeel 31 views 6 comments 0 points Most recent by Gary Miller-39965 Reporting and Analytics for HCM -
Is there a way to extract the Manage Privileges details?Every oracle maintenance we are manually checking the Manage Privileges (OBIEE > Administration > Security) if still intact. Are there any way to extract all the details…
-
Get Journal Entries Details For An EmployeeSummary: Team We would need to fetch Accounting Date & Transaction Number From Journal Entries. (GL) For An Employee Columns are: Accounting Date Transaction Number Payr…Manoharan 519 views 1 comment 0 points Most recent by Raluca.S - Fusion GL Oracle-Oracle Reporting and Analytics for ERP
-
Questionnaire Score - 360 FeedbackSummary: Hello everyone, Does anyone know how to fetch Questionnaire Score in a performance document using OTBI? What is the subject area and column folder for this? You…Hazel De Castro 61 views 15 comments 0 points Most recent by Hazel De Castro Reporting and Analytics for HCM