Reports
Discussion List
-
Using Session Variable can be used in BIP report to restrict data based on the user who will run it?Summary: Is Using Session Variable can be used in BIP report to restrict data based on the user who will run it? Content (required): Hello, I am running a BIP report reg…Hazel De Castro 41 views 7 comments 0 points Most recent by Hazel De Castro Reporting and Analytics for HCM -
Report to find details of history of all reportsHi Team, Could you please let me know if there is a way/ there is a report to retrieve details of all custom reports (OTBI/BIP) in terms of last updated by and last upda…Swapnil Kashid 41 views 2 comments 1 point Most recent by Swapnil Kashid Reporting and Analytics for ERP -
Is it possible to have an audit for FR reports?Summary: Customer wants to know if by any way we can get usage statistics for FR reports from system. They have a bunch of legacy FR reports and want to know which ones …
-
Need a query to get the Fixed Assets category combination along with all its account combinationsSummary: Need to get the following accounting combinations of the category combinations in accounting rules; Cost, clearing, depreciation reserve, depreciation expense,c…Dian Minshan 1.6K views 1 comment 0 points Most recent by Ahmed Mousa Reporting and Analytics for ERP -
View all intercompany AR and AP invoices in one place in Supply Chain Financial OrchestrationSummary: Hello All, I would like to see a consolidated/aggregated AP/AR invoices for BU/LE in Supply Chain Financial Orchestration. Or atleast query and view the AP/AR i…Vishnuvarth Subramanian-Oracle 31 views 1 comment 0 points Most recent by Satya Ganti-Oracle Supply Chain Financial Orchestration
-
How can we fetch "Non-Union Benefit Eligibility Dates" in OTBI ?Summary: From the attached screenshot we can fetch all the fields under Extra Information in Workforce Management - Person Real Time subject area except Non-Union Benefi…AaronJai 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Need a BI Publisher Add-In Supported by MS Office 365Summary Need a BI Publisher Add-In Supported by MS Office 365Content Hi, We need a BI Publisher Add-In Supported by MS Office 365. Please provide a link to download the … -
Waterfall Chart data decimal issueSummary Color bar not showing up correctly due to 1 decimal.Content Hi, We are having an issue with the waterfall chart. 1. When we keep the decimals up to 1 the zero da… -
BI publisher not workingSummary Unable to use BI publisher in ExcelContent Hi folks! I need to modify a Excel Template for a Oracle Cloud report. It seems that my BI publisher is not working pr…
-
How do I schedule a Job, So that a Job starts when earlier scheduled Job is completed.Summary: Schedule a Job for 10 sets of Employees so that each job set starts before earlier Job completes Content (required): I need to schedule a Job for 10 sets of emp…Anjan Polimera 11 views 1 comment 0 points Most recent by Anjan Polimera Reporting and Analytics for HCM
-
Table for Pension Scheme name stored at PAE at UK calculation CardSummary Table for Pension Scheme name stored at PAE at UK calculation CardContent Hi Experts, I am try to pull the Active Qualifying Scheme for employee stored at PAE UK…
-
OTBI Previous Job History/Records Without Logical SQL or Custom-SQL/BIP - Possible?Summary History records of a personContent Hello, Can anyone please help me with the below scenario? I would like to get previous job changes/history (and few additional… -
Is there a way to display the values selected in the Prompt on the DashboardSummary Is there a way to display the values selected in the Prompt on the DashboardContent I created a dashboard, which contains the prompt and result area. as shown in… -
full outer join in BIP fusionHi, I have two queries and I want to use full outer join in BIP but it does not work. I am using select * from t1 full outer join select * from t2 on t1.A = t2.A but giv…Morad Alshammari 31 views 10 comments 0 points Most recent by Morad Alshammari BI Publisher Learning Center -
ESS Job ArgumentSummary ESS Job ArgumentContent Good People, We have a single argument for an ESS Job which is a STRING field. Unfortunately in the values we have DATA with comma e.g. A…Soumya Prakash Parhi 59 views 2 comments 1 point Most recent by Ghanshyam M-Oracle Reporting and Analytics for ERP -
Cannot Open Next Generation Reports in ExcelContent It's not possible to download next gen reports in Excel. I found a document on the Oracle Support. The Excel download is currently not available (only for Narrat…User_NJ6WE 57 views 5 comments 0 points Most recent by Ija Vidaurri Financial Consolidation and Close
-
Send remittance advice report querySummary: Send remittance advice report query Content (required): We want to customize send remittance advice process. And we need the seeded report data model query acce…Priyanka More-Oracle 123 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
To create custom subject areaHi All, Could you please let us know if there is a way to register a sql query as a custom subject area that can be used for creating an OTBI report. Our requirement is …Swapnil Kashid 81 views 4 comments 1 point Most recent by Swapnil Kashid Reporting and Analytics for ERP
-
OTBI Analysis takes about 20 minutes to return results, how to improve performance?Summary: OTBI Analysis for Master Headcount Report takes 20 minutes to display results. Content (required): Our client is migrating from EBS to HCM Cloud. Currently they…Vinay Hardas 71 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Merging cells for header row in management report gridSummary: Hi, I am wondering if if is possible to merge the cells of a row in a management report grid to be able to generate a heading row (top row or somewhere else)? I…
-
How to get a PTO Accruals report with ONE line of data for balance per EE?Summary: We are using a 3rd Party for our PTO Accruals (UKG). Primary issue: Some EE's are in 2 plans, so they have 2 lines of data. The issue is that UKG will only pick…
-
How to get a details of Clock Entries missing for 3 days or more (OTL Module)Hello all (Report Description: The list of employees who have missing clock entries for 3 days or more should appear in the custom report) can anyone please tell me wher…
-
Transaction (requisition and/or expense report) - approvers and actionsSummary Provide end-users with a report (or reports) that identifies approval status (and history) on requisitions and/or expense reports).Content Boise State has a requ…User_2025-01-28-03-18-28-504 80 views 8 comments 0 points Most recent by Mihaela Vlad Reporting and Analytics for ERP -
OTBI - Unpaid Invoice By Payment methodSummary OTBI - Unpaid Invoice By Payment methodContent This report helps to identify unpaid invoice details for any enterprise.Soumya Prakash Parhi 154 views 2 comments 8 points Most recent by Swapnil Kashid Reporting and Analytics for ERP
-
Audit Report for FranceSummary Does Anyone use Audit Report for FranceContent We are trying to use the provided Audit Report for France and we are running into issues. Did anyone use this repo…Tina Valtchev 33 views 8 comments 2 points Most recent by amy hardtke Reporting and Analytics for ERP -
How to remove/supress subtotal lines in SmartviewSummary Is it possible when drilling down in a Smartview report to 'remove subtotal rows' in the same was as you can with a standard pivot table output?User_2025-02-11-02-45-23-645 180 views 2 comments 1 point Most recent by Ekta Nayak-Oracle Reporting and Analytics for ERP
-
Organization Audit ReportSummary BIP Audit Query to tract the mutations happened with respect to Departments.Content Hi All, We have a BIP requirement to tract down the mutations that are happen…User_2025-02-10-16-28-01-402 47 views 4 comments 1 point Most recent by Karen Long Reporting and Analytics for HCM
-
Segregate visibility on OTBI to allow users to report only on Recruiting Subject AreasSummary: Content (required): Hello, The customer is requesting us the possibility to let Recruiters to access the OTBI and create some custom reports only related to Rec…gguittini 41 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Pass an employee ID parameter from an analysis to a Skills pageSummary: We want to have an OTBI analysis table of employee information with a link per person that takes the viewer to the Skills and Qualifications page with the emplo…User_2025-02-05-22-55-58-511 41 views 2 comments 0 points Most recent by User_2025-02-05-22-55-58-511 Reporting and Analytics for HCM