Reports
Discussion List
-
Table to get information regarding Schedule ProcessSummary How to get information what schedule process are scheduled through BI ReportContent How through BI report can we find, that what schedule processes are scheduled…User_2025-01-29-18-45-19-617 1.3K views 2 comments 0 points Most recent by Pradvin Prabhakar Reporting and Analytics for HCM -
Report to show 2 sets of data based on dates selected by the userSummary Report needs to show several fields for different dates(not necessarily the current and previous values)Content Hi All, I have built a query that returns data ba…User_2025-02-04-08-51-08-912 29 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Need to be able to identify all BIP Reports and Analyses that use particular field as filterSummary Need to be able to identify all BIP Reports and Analyses that use particular field as filterContent Does anyone know if there is an Oracle program that will iden…Rich R 48 views 3 comments 0 points Most recent by Pradvin Prabhakar Reporting and Analytics for HCM -
How to hide data model and edit access for BI ReportsContent Hi Export, We have a requirement to give only view access for BI Report and nothing other than. So we are planning to hide the data model so that a user can not …MohammadAfghanul Khair 273 views 4 comments 0 points Most recent by MohammadAfghanul Khair Reporting and Analytics for HCM -
New Role only seeing their information on any report ran in Reports & AnalyticsSummary PAYADMIN_READONLY_DATA_DATAContent Created a new role in HCM and it only when reports are ran it only shows their information, unless it is a line manager, then …Gabe K 51 views 3 comments 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
OTBI Environment variablesSummary Display current user details in environmentContent Hi, Has anyone come across any OTBI environment variables. Or is there a subject area that displays the curren…User_2025-02-05-23-02-10-916 94 views 4 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
ESS Access to Custom BI Publisher ReportSummary Access to a Custom BI Publisher Report as Employee Self ServiceContent Hi Friends We have a custom BI Report and one of the parameters is the name. Right now thi…Mansur Khalil 80 views 15 comments 1 point Most recent by AshishERPCloud Reporting and Analytics for HCM -
Time entry hours by various time codes otbi/reportSummary Time entry hours by various time codesContent Hi, We have some time codes which are not payroll time types specifically. Either they are part of 'Regular Hours' …Anuradha T 60 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Check-In Performance Template BIP table Joins.Summary Can anyone please explain how goals and its feedback are tied/joined to check-in peformance template for reporting purpose using BI Publisher.Content We have a B…User_0REWN 69 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Create dashboard prompt using column with custom formulaSummary Analysis has calculated column with bins. How can I create a dashboard prompt using this column?Content I created a column that bins seniority years (seniority u…
-
Requisition approval notificationSummary Can we use seeded BIP Requisition approval notification as a FYI notification for submitter?Content Hello, We have a requirement to send a FYI notification for t…
-
Multiple attachments through BIP BurstingContent Hi All, Can we send multiple attachments (PDF, Excel) for an employee through BIP bursting in a single mail? Thanks, Visu
-
Approved GoalsSummary Need to find dates when Goals were approvedContent Hi, I need to find all Goals that were approved between the 20th - 23rd July but when I look I see there are m…User_2025-02-05-22-44-35-842 23 views 4 comments 0 points Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM
-
OTBI Anchoring date variationSummary Try to change Anchoring date in Performance Subject AreaContent Hi all we try to change in our OTBI reports the Anchoring Date of Performance Subject area: 1) Wo…Marco Francia 34 views 2 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
PER_JOBS_F.APPROVAL_AUTHORITY Translate ValuesSummary Trying to pull in the Name (translate value) for the Approval Authority code on JobVersion 20B -
Transfer ReportingContent Hello everyone, I am trying to get a transfer report built in OTBI. I have the basis of the report built and it is pulling the employees that I am looking for. H…Andy Whalen 59 views 2 comments 0 points Most recent by User_2025-02-01-03-43-13-079 Reporting and Analytics for HCM -
Rehire Date as a PRESENTATION_COLUMNSummary Rehire Date as a PRESENTATION_COLUMNContent Hi All, My business user complains to me that Rehire date is not a presentation column and is not as easy as adding a…Sriharsha Devraj 52 views 1 comment 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Full-Time Equivalent Measure Will Not SuppressSummary When the Full-Time Equivalent measure was pulled into a Benefits report, the FTE is not suppressing, even though the column properties have been set to suppress.…Kei Sato 38 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
OTBI Bursting ReportSummary Bursting report is not splitting out rows to recipientsContent Hello! I have an OTBI bursting report for absence balances. I've included a column with the user n…Susan Anderson 95 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Hiding prompt while exporting data from dashboardSummary Hiding prompt while exporting data from dashboardContent Hi Team, Can you please let me know how to hide the dashboard prompt while exporting data to excel. Than…
-
Can we lock the column order in the report outputSummary Can we lock the column order in the report outputContent Hi Team, Can we lock the column order in the dashboard output so that customer will not change the order…
-
BI report Name change and path changeSummary Impact AnalysisContent Team, We have a request to change report name and path of few reports . These reports are scheduled already. Just wanted to know what woul…
-
How to update the link for an embedded reportSummary Links for Embedded reportsContent Hi All, I am attempting to update the link for an embedded report after a recent copy from our production to test environment. …User_2025-02-04-08-51-08-912 34 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Matrix Manager - Additional DetailsSummary Reporting on additional details of Matrix ManagerContent Hello Reporting Guru's! I'm wondering if anyone has found a way to report on a matrix manager's details …Jessie Jones 48 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Identify users logged into the applicationSummary Identify users logged into the applicationContent Hi All, does anyone know if there is a report or process that can be run to check which users are logged into t… -
Using LIKE with FILTER() in an AnalysisContent I am trying to build a simple tile that gives the total number of employees with a job name that contains 'Director'. Example - 'Director of Compliance' I run in…User_2025-02-10-08-27-16-805 32 views 3 comments 2 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
SQL to pull Previous Line ManagerSummary Sample SQL to pull Line Manager from the Previous Assignment RowContent We have created a data model that pulls most current assignment row where actions = Promo…
-
OTBI Learning - Department, job, grade... at enrollmentSummary OTBI Learning - Trying to get department, job, grade... at enrollment date (Offering Start Date) instead of actual oneContent Hello guys, As per title, I am tryi…User_2025-02-05-11-42-08-011 60 views 3 comments 0 points Most recent by User_2025-02-05-11-42-08-011 Reporting and Analytics for HCM
-
Tables for getting user information under Security consoleSummary Query to get security console User infoContent Hi All, I am developing a BI Publisher report to get the User information that is available under Security console…SuryaMuralidharan 910 views 5 comments 0 points Most recent by Ravi Shinde Reporting and Analytics for HCM
-
New Line of data for each variableSummary Just checking options available to prevent multiple lines if data in reportsContent Hi, I think I know the answer to this already but apart from using BI Publish…User_2025-02-05-22-44-35-842 24 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM