Reports
Discussion List
-
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 40 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 11 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 31 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.6K 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 191 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 21 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 21 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 32 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Custom ESS jobs error outSummary: We have 7 custom reports where created a related ESS job definitions and created custom role (with appropriate Privileges) to run those custom ESS jobs. Job is …AnilJaMI 61 views 4 comments 0 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP
-
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 21 views 1 comment 0 points Most recent by Paidiparthi Ravindra Reporting and Analytics for HCM
-
Fiscal Year, quarter and Month in OTBI reporting as a parameter and also as a fields.Summary: We have a requirement to report Employee Details based on Fiscal Year, Fiscal Quarter and Fiscal Period. In the subject Area Workforce Management Assignment Eve…Venkateswaran Murali-Oracle 531 views 2 comments 1 point Most recent by Venkateswaran Murali-Oracle Reporting and Analytics for HCM
-
Dynamic Dates for Parameters or SchedulesSummary Is there a list of dynamic dates for use in parameters or in schedules?Content Hi all - I did review this post (https://cloudcustomerconnect.oracle.com/posts/862… -
Not a Question: Dynamic Date Parameters in BI ReportContent This is not a question and I have shared the info, For most of the BI Reports we have the input parameter as "AsOfDate" alias Sysdate or current date. Sometimes …Janardhana Kondaveeti 129 views 5 comments 15 points Most recent by Visu Reporting and Analytics for HCM -
Is supplier audit report available in fusion?Summary: We are looking for standard report to track old value and new value when supplier name, supplier bank number, etc is changed. Please let us know is there any st…
-
Dashboard with two Prompts: Selecting a value in the first Prompt changes the value in the second PrContent Hello All, In the dashboard “Performance Evaluation Comparison FCU Second Half”, there are two different Prompts, each Prompt uses the same field in OTBI "Perfor…
-
How to exclude logged in user from BIP report?Summary: Logged in user needs to get excluded from their own BIP performance report Content (required): Hi, we have built a custom BIP report for performance data for ma…Franziska Reichel 31 views 4 comments 0 points Most recent by Franziska Reichel Reporting and Analytics for HCM
-
Delegation ReportSummary: Content (required): Is there a report or a subject area in which we can report all current delegations? We want to find which people are delegating to others an…Annette M 21 views 2 comments 1 point Most recent by Wiktor Ornatowski-Oracle Reporting and Analytics for HCM
-
How to customize Subledger Period Close Exception ReportSummary: How to customize Sub-ledger Period Close Exception Report Content (required): Ledger Set Parameter to be added to the report. when i'm trying to edit datamodel,…Lydia Jayasingh 154 views 7 comments 0 points Most recent by Lydia Jayasingh Reporting and Analytics for ERP
-
Termination - reporting offboarding commentsSummary: Content (required): We are trying to create a report that selects all terminated employees within a date range, along with the term action reason. Many times ou…Annette M 61 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
SQL or tables for Resignation Workflow Approver historySummary: Resignation Workflow Approver history Content (required): Hi all, I need to pull our the workflow details of Resignation workflow in BI. So please let me know f…Aditya Lanka 421 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM