Reports
Discussion List
-
Run report that will show users that have run BIP or OTBI reports over timeframeSummary: Good afternoon. Any suggestions around how to produce an audit report (we don't have auditing enabled) to produce a list of users that have run Human Capital Mg…Rich R 11 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
In OTBI, how to set the filters to fetch data between the last 3 years to the current year?Hello, I'd like to create an analysis to fetch Performance Rating from the last 3 years up to this year based on "- Competencies"."Review End Date". How to set a dynamic…Lise_Rekik_Acc 31 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Timecard Time Attributes Not Appearing in OTBI Timecard Subject AreasWe have Time Attributes set up that can be viewed in the application by navigating to Setup & Maintenance -> Workforce Deployment -> Time and Labor -> Time Entry Layout …
-
Termination ReportSummary: We are new to Oracle and looking to build a simple termination report that returns all terminated workers. Current problem we have is that it's returning termin…Darrin N 274 views 14 comments 0 points Most recent by Manmohan Mohapatra-Oracle Reporting and Analytics for HCM
-
Reports - dynamic user variablesSummary: Hi all, Currently we are building a report with specific formatting. It is however the customers desire to maintain a high level of flexibility in order to stre…
-
Changed information not shown in the Audit ReportsSummary: Hi, Regarding Address or Legislative information changes within the Audit Reports ; The log does not display all the fields that have been created, updated, mod…
-
Custom folder structureSummary: My client wants to change the Custom folder structure. My client does not want path to be Shared Folders > Custom > Human Capital Management. My client wants to…Consultant Ian 11 views 2 comments 0 points Most recent by Consultant Ian Reporting and Analytics for HCM -
Accessing unrounded numbers in Narrative ReportingSummary: Hi, My client currently has a report where the numbers are scaled to millions. However, they are wondering if there's a way to also access the original, unround…
-
Is there a report that lets you know when there is an empty position with direct reportsSummary: Hello - We are trying to find out if there is an alert, notification, or OTBI report that is delivered when there is an empty position with direct reports. We w…G. Class-Peters 31 views 6 comments 0 points Most recent by G. Class-Peters Reporting and Analytics for HCM -
What is the alternative of EXTRACTVALUE function and how to use it?Summary: Hi All, As EXTRACTVALUE function is no longer supported in Oracle SQL, the Data Models designed using EXTRACTVALUE is throwing error. The alternative is suggest…Robinson Ng 104 views 3 comments 0 points Most recent by Jordan Ritchie Reporting and Analytics for HCM
-
sql statement to get the performance document current taskSummary: sql statement to get the performance document current task Content (please ensure you mask any confidential information): Hi Team, I need these below two column…Malak 953 views 3 comments 0 points Most recent by Himavarsha Sathpadi Reporting and Analytics for HCM
-
Unable to find Title field (on Record External Learning Experience page) in OTBI ReportHi Team, We are unable to find below field in my OTBI report. Could you please help us to find the same. Field Name: "Title" (on Record External Learning Experience page…User_2025-02-12-02-03-48-970 41 views 9 comments 0 points Most recent by User_ZKDAR Reporting and Analytics for HCM -
Need assistance on Bursting report for Visa and Passport expirationSummary: Hi, Our requirement: The alert should trigger Worker and AOR on Worker passport expires. The Notification should be sent before 30days. Currently Alert composer…RamkumarKadhiravan 1 view 0 comments 0 points Started by RamkumarKadhiravan Reporting and Analytics for HCM -
PlanningFeasibility to attach reports in the Approval Workflow
-
Any Suggestions of how to improve HCM Extract completion time!Summary: We are facing an issue with the custom HCM extract which is running and taking a long time to generate the XML output (5 employee data for 10 minutes). We have …
-
Query for Projects, Subledger and General Ledger - RevenueSummary: I have a similar issue to this post; - https://community.oracle.com/customerconnect/discussion/660682/query-for-projects-subledger-and-general-ledger But I am l…
-
Creating a Report Book in EPBCSSummary: Content (please ensure you mask any confidential information): Hi, We have created bunch of reports (not financial reports) in EPBCS and resides in Navigator→ R…
-
Can you pull columns from one OTBI analysis report to another like a Vlookup?Summary: We have created a Checklist Task which has a DFF that generates a Person Number ("Checklist Task Details"."PER_PERSON_ALLOCATED_TASKS_DFF_DESC_NOMINEENAME_") an…Stephanie McInnes 214 views 6 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Role for OTBI reportSummary: Role for OTBI report Content (please ensure you mask any confidential information): Hello experts, we have created a custom role (BI-Abstract) that allows users…Oriana L. 11 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Can multiple users be entering inline Notes in one report to different line items simultaneously?Summary: Can multiple people be working in the same report, entering Notes on different line items of an inline Note Template as long as a dimension member (like account…Stephanie Philopoulos 33 views 1 comment 0 points Most recent by Komala Reddy-Oracle Narrative Reporting
-
How to return the max value based on a column?Summary: Content (please ensure you mask any confidential information): I've created a report using Workforce Learning - Learning Records Real Time subject area. The fol…Giuseppe Cannova 79 views 2 comments 0 points Most recent by Sai Darbha-Oracle Reporting and Analytics for HCM -
Oracle Best Practice of Creating Management Reports Remote Library (Planning) or NRSummary: Hello experts, we are in the process of building Budget Book with around 50+ Management Reports, need oracle's recommendations on the below 2 scenarios. Create … -
OTBI for Model Profile vs Person Profile Competency Gap AnalysisSummary: Content (please ensure you mask any confidential information): Hello Experts, We have a requirement to pull Person Talent Profile Competencies ratings and Model…
-
Ability to view history for a Note in Narrative ReportingSummary: Is there functionality to view history for a Note aside from the original author and date and most recent modified by and date? Content (please ensure you mask …Stephanie Philopoulos 31 views 1 comment 0 points Most recent by Dave Roberts_-Oracle Narrative Reporting
-
Model Profile vs Person Profile Competency Gap AnalysisContent Hi All, Wondering if anyone had a great analysis comparing the competency minimum proficiency level identified in a model profile to the assessed competency prof…Lauren Owen 142 views 3 comments 0 points Most recent by Sivakumaran Muthusamy-Oracle Reporting and Analytics for HCM
-
BIP Data Model Error: ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actualSummary BIP Data Model Error: ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actual: 4445, maximum: 4000)Content Hi, Can anyone please suggest a…Manisha Chakraborty 130 views 10 comments 0 points Most recent by Viswanadh Reporting and Analytics for HCM
-
Absence update history not availableSummary: Currently when the employee update the existing absence record and submit it, the back end does not hold both the data on the absence entry table. Unfortunately…Sobitha Venkatraman 1 view 1 comment 0 points Most recent by Vali-Oracle Reporting and Analytics for HCM
-
Data isn't retrived due to special character in Business Unit promptSummary: Hey, We have an issue with our Performance dashboard. The dashboard is based on OTBI analysis reports and the Performance subject area. One of our BU was create…Markovich Chen 21 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to identify C-Suite leader in headcount reportI'm trying to add a column that will identify our C-Suite leaders for each employee in headcount report. C-Suite leader would be the CEO - 1 or whomever is the top-most …S. Johnson 21 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM