Reports
Discussion List
-
How to Add Documents of Record from HCM Employment Flow to Approval BIP NotificationSummary: Has anyone had success adding the DoR added during an HCM employment flow to the approval BIP workflow notification? If so, what needs to be added? Thanks! Upda… -
How can i create a current and previous report for location change for a dashboard?Summary: I need to create a location change report using the visa permit type (not null) in the Person Real Time subject area and the Assignment Event Real Time subject …Mark Stoker 11 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
What's New in 21.11?Summary: Okay, so I missed 21.10… it was a busy month. Maybe I’ll retroactively post one for October. At this point, let’s dive into the new features in 21.11. As always… -
Not able to hide the delete button from a reportSummary: Content (required): Hi Expert, We have a requirement to hide the delete button from a report. But we are not able to delete the button. We are using a custom ro…Faizan Rashid 21 views 1 comment 0 points Most recent by Rajesh.Vadlamani Reporting and Analytics for HCM
-
BIP Report - Department HierarchySummary: Does anyone tried creating report in BIP with department levels such as Department Level 1-8. Kindly share the sample query. Thanks Content (required): Version …Hazel De Castro 21 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Goals Report showing Draft StatusSummary All Drafts Status Goals before a certain dateContent Hi, I've been asked to build a report that shows anyone who had a 'Draft' status to their 2020 Goals prior t…User_2025-02-05-22-44-35-842 39 views 4 comments 0 points Most recent by Lavanya Reddy Reporting and Analytics for HCM -
Dashboard take minutes to show resultsSummary: We have a dashboard that presents the result of review documents on one tab and goals on a second tab. When opening the dashboard, it takes quit some time befor…Wouter.Schaap 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Sample OTBI Reports: Budgetary ControlSummary OTBI Reports for Budgetary Control and Carry ForwardContent These are sample reports for customers using Budgetary Control to assist them in managing their contr…Linda Wong-Oracle 723 views 7 comments 7 points Most recent by CA Nirmal Choudhary Reporting and Analytics for ERP
-
Procurement Agent ListSummary: Content (required): Is there a report that will show a list of our procurement agents and the permissions they have been assigned? We feel like many of them are…Annette M 281 views 2 comments 1 point Most recent by Jeff Hare CPA CISA CIA Reporting and Analytics for ERP -
Receivables - transactions real time failing with ODBC-error about Flex fieldsSummary: When I try to create a very simple report with the Subject area "Receivables - transactions real time" I get an error, every time I try to use a fact from the f…Anders W. Langholm 23 views 0 comments 0 points Started by Anders W. Langholm Reporting and Analytics for ERP
-
PERIODROLLING for Annual TurnoverPERIODROLLING for Annual Turnover I have been successful in plotting a Rolling month turnover rate using PERIODROLLING("Workforce Trend"."Period End Headcount",-11,0) . …
-
Adding dimension members through Data Management in PCMSummary Adding dimension members through Data Management in PCM is possible?Content Addition of dimension members through Data Management in PCM is possible? It was answ…User_2025-02-05-23-55-14-602 64 views 7 comments 2 points Most recent by User_2025-02-05-23-55-14-602 Profitability and Cost Management
-
Security profile to restrict line manager to view only one assignment of employees in OTBI reportSummary: Hi All, My line manager is able to see the records for performance document for all Active assignments of employees. How to restrict my OBTI output so only the …Kamini Kaushik-Oracle 31 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Which table stores absence eligibility details?Summary: Which table stores absence eligibility details? Content (required): Hi Team, I want to know the table which store absence eligibility profile details. Thanks. V… -
What’s New in EPM Cloud Narrative Reporting and Reports Release 21.12Summary: What’s New in EPM Cloud Narrative Reporting and Reports Release 21.12 Content: Please refer to the December 2021 What's New Guide to understand the new features…Dave Roberts_-Oracle 24 views 0 comments 3 points Started by Dave Roberts_-Oracle Narrative Reporting -
OTBI with Personal Payment Method DeeplinkSummary: Team, I am working on a Personal payment method OTBI analysis with Deeplink enabled. I am finding one issue like while I am selecting then it I select the assig…Mohan Murali 32 views 3 comments 0 points Most recent by Julian Challenger-Oracle Human Capital Management
-
How to generate a report for HCM users who are not using SSO loginSummary: HI Team, We would need to generate a BI report which will contain all the users who are not using SSO login instead they are using their username and credential… -
How to use MAX Date in OTBIContent Hi I'm getting multiple work relationship records, I would like to return only the latest work relationship record. How can use MAX function to select the latest…User_2025-02-07-19-03-14-525 2.8K views 8 comments 0 points Most recent by User_2025-02-11-05-19-35-410 Reporting and Analytics for HCM
-
BIP report: Users with HR and line manager role should only see their direct/indirect reportsSummary: BIP report: How can we make sure that when an HR User, who is also a Line manager, is only seeing their own reports (direct and indirect) when pulling the repor…Franziska Reichel 214 views 6 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Need an Oracle documentation which list changes done to database or TablesOracle agreed to share a documentation which will help customer identify changes done to Tables which might affect BI Publisher reporting. But, Oracle said there is no d…Vamsi Kuchipudi 11 views 2 comments 0 points Most recent by Vamsi Kuchipudi Reporting and Analytics for HCM
-
workforce management - worker assignment real time returning in correct dataSummary: We are maintain an OTBI analysis which fetches Core HR details adding Grade Step column is fetching incorrect details. PFA snippet for more details Please let m…Manoj Kumar S 31 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
SQL Help for Dates crossing into New YearSummary: HI All, I have a requirement to pull a list of dependents that will be turning 21 within 6 weeks (ie. If I run the report today, I should be pulling into those …User_2025-02-04-08-51-08-912 23 views 6 comments 0 points Most recent by User_2025-02-04-08-51-08-912 Reporting and Analytics for HCM
-
Placing a Report Job on HoldSummary: Content (required): I have a report in OTBI that is scheduled to run every Monday morning. I would like to place the job on hold for the next month (December) a…Annette M 22 views 1 comment 0 points Most recent by Prateek Parasar - GTUK, ACE Pro Reporting and Analytics for HCM
-
Workforce Compensation Page Parameters for EL ExpressionsContent Hello experts, is there an Oracle official documentation which can allow me to have all compensation module parameters (i.e. ManagerId; PlanId; etc.) in order to…Valerio Curzi 33 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
HR Recruitment process metricsContent As part of the end to end recruitment process, I would like to report the following basic metrics..... 1. Job Requisition submitted (by hiring mgr/SDA) to Job Re…User_2025-02-11-13-03-12-474 39 views 3 comments 0 points Most recent by Harriet Reporting and Analytics for HCM
-
Changing Ownership of Scheduled AgentsSummary: We recently had an employee leave the company who was the owner of the majority of our reports and scheduled agents. In an effort to safe time, is there a way t…User_2025-02-11-00-58-38-371 24 views 1 comment 0 points Most recent by Paidiparthi Ravindra Reporting and Analytics for HCM