Reports
Discussion List
-
Users cannot see their own accrual balanceSummary: Users cannot see their own holiday accrual balance in OTBI accrual report Content (required): I have an OTBI report showing Accrual Balances using the Accrual R…s_b 21 views 2 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
US Reporting for Legal ComplianceSummary: Content (required): Hi team, An US client asked us some Reporting for Legal Compliance. We found that Oracle HRMS and Oracle HRMS provide support for several co…Gabriele Falso-Oracle 24 views 2 comments 0 points Most recent by Gabriele Falso-Oracle Reporting and Analytics for HCM -
Termination Report needed (workflow initiated date vs the actual termination date)Summary: We are in need of a report which will help us catch "late terminations". Report should have a date in which the workflow was initiated, and then the termination…
-
Denied the delete option from everywhere.Summary: Hi Team, I have created a custom role, and I want to denied the delete option from which function need to denied for my custom role and only the "BI Author Role…User_2025-02-12-18-16-01-181 41 views 3 comments 0 points Most recent by Rajesh.Vadlamani Reporting and Analytics for HCM -
Manage Report Jobs screen shows owner as fusion_apps_prov_patch_appidSummary: Manage Report Jobs screen shows owner as fusion_apps_prov_patch_appid Content (required): Hi, The Manage Report Job screen shows the Owner as "fusion_apps_prov_…Christopher Jothi - HCM-Oracle 104 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM -
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 -
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 38 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
-
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) . …
-
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… -
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.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 35 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 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 529 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 132 views 5 comments 15 points Most recent by Visu Reporting and Analytics for HCM -
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 32 views 4 comments 0 points Most recent by Franziska Reichel Reporting and Analytics for HCM