Reports
Discussion List
-
query to get timecard calculation for an employeeCan anyone help me getting sql query for calculated quantity in Timecards entries of an employee. -
Getting Errore in FRS Report - Internal Essbase JAPI errorSummary: Getting Errore in FRS Report - Internal Essbase JAPI error Content (required): Dear All, I tried to run a FRS Report and I am getting the below error. Error exe… -
Subject area for Employee data (About me)Summary: Hi All I am trying to create a report on employee's 'about me' section. Not too sure what subject area/table to use for this? or if someone has something made a…Jeevan Loyal 41 views 6 comments 0 points Most recent by Jeevan Loyal Reporting and Analytics for HCM
-
How to Find an IP Address of a User who has Logged in Fusion Application ?Summary: How to Find an IP Address of a User who has Logged in Fusion Application ? Content (please ensure you mask any confidential information): Hello, I have a requir…
-
How to Query Cost Code from Oracle Fusion HCM OTL Time Card Tables?Summary: Hi Community, I need help identifying which table/column stores the Cost Code information visible in the OTL Time Card interface in Oracle Fusion HCM. Context: …Vishal Purohit 52 views 2 comments 0 points Most recent by Vishal Purohit Reporting and Analytics for HCM -
Check member usage in reportsIs there a way to know in how many reports is a particular member used? For example - If I want to see which reports have the member FCCS_Total Assets used in them. Is t…
-
I need a query which will fetch Cycle time in days for the formal performance review processSummary: I need a query which will fetch Cycle time in days for the formal performance review process from start to finish Content (please ensure you mask any confidenti…
-
I need a query to fetch top performing employees in talent managementSummary: I need a query to fetch top performing employees in talent management Content (please ensure you mask any confidential information): Version (include the versio…
-
Custom Report for DM Tables in EPBCSSummary: Hello, I want to know if i can generate a report using custom query with a join between Datamanagement tables say AIF_BAL_RULE_PARAMS or AIF_BALANCE_RULES in EP…
-
Quarterly report with Dynamic columns based on period selectionSummary: If we run the report for the November period, it should display Q1, Q2, and Q3 columns in full, while Q4 should show only the values for October and November. S…
-
Sending remittance advice email limitSummary: we are a government department and are now paying a large volume of grant payments. this means an increase to the number of payments and therefore remittance ad…Anne Cilia 41 views 3 comments 0 points Most recent by Gopikrishna-Oracle Reporting and Analytics for ERP
-
Workforce Profiles - Person Profile Real TimeSummary: Hi Expert, I need your assistance. I picked up multiple values by using the above-mentioned subject area and getting values from different sections of a person'…
-
HCM Audit Table Differences - Do the audit tables keep deleted rows and the regular table does not?I want to understand the difference of contents between a "regular" table and an "audit table" that has an "_" underscore at the end of the name. I am calling PER_ALL_AS…
-
Dimension Hierarchy for Descendants in POVSummary: My question using the example below of Descendants of AllSegments: If we were to not use the Prompt function and instead select Descendants of AllSegements in t…
-
Report grid exportSummary: Need the option to export the Grid from Reports. we have recently migrated our reports from Financial Reporting Studio to PBCS Reports. Since then we are unable… -
What’s New in EPM Cloud Narrative Reporting and Reports Release 25.11What’s New in EPM Cloud Narrative Reporting and Reports Release 25.11 Please refer to the November 2025 What's New Guide to understand the new features included in Cloud… -
How to add Dashboard or OTBI analysis on Navigator or Springboard (Home page)This discussion provides step by step guidance on how to add OTBI analysis or Dashboard or any external webpage to application UI home page or on Navigator as new page e…CA Nirmal Choudhary 2.3K views 3 comments 7 points Most recent by SankarBalu Reporting and Analytics for ERP -
How to export a Grid to Excel in Reports?Summary: In FR we were able to export a Grid to Excel. Does Reports have a similar feature? Content (please ensure you mask any confidential information): In FR we were …AndreeaG 21 views 6 comments 0 points Most recent by Dave Roberts_-Oracle Financial Consolidation and Close
-
How to invoke rest api from Oracle BI ReportHow to invoke Rest api/webservice using BI reportShruthiPrabhuram 12 views 0 comments 0 points Most recent by ShruthiPrabhuram BI Publisher Learning Center
-
OTBI Report 8.4 RCE Anexo 11 – No Invoices DisplayedI am experiencing an issue with the OTBI report “8.4 RCE Anexo 11 – Replaces Proposal” under Oracle Fusion Cloud Financials. When I run the report for the September acco…Milagros MR 42 views 5 comments 2 points Most recent by Prateek Agasti Reporting and Analytics for ERP
-
Adding extra filters to Infolets (Order Management - Seeded Infolets)Summary Customization of Order Management landing page to filter the Infolets data along with default filter of 'Source System'Content Currently the system allow users t…Senthilrajan V 154 views 9 comments 1 point Most recent by Nathan CCC Reporting and Analytics for ERP -
NRCS Data Source refresh failed -The latest version is not compatible with the version in the docletSummary: Package Refresh fails with error post migration of the NRCS report from Test to Prod while the POV or Prompts did not change, we get this error during refresh o…
-
Export ReportsSummary: Hello All, we are trying to export some Reports that aren't located within the Financial Reports. I haven't read any documentation or was able to find any withi…
-
Need table name storing reporting period and status after "Finalize Transactions for Tax".We need to retrieve the final reporting status and reporting period in Oracle Fusion tables after running the "Finalize Transactions for Tax Reporting" ESS job. This ESS…
-
Required table for Quick move action for Candidate Selection Process Configuration in ORCSummary: Required a table or SQL query where the information of Quick move action stored for the HCM-ORC setup Candidate Selection Process Configuration. Attached screen…
-
What’s New in EPM Cloud Narrative Reporting and Reports Release 25.10What’s New in EPM Cloud Narrative Reporting and Reports Release 25.10 Please refer to the October 2025 What's New Guide to understand the new features included in Cloud …Dave Roberts_-Oracle 61 views 2 comments 0 points Most recent by Dave Roberts_-Oracle Narrative Reporting
-
SubVars in Prompt Picklist Not Showing in Prompt for BookSummary: We have a report that uses prompts for Years (the default is our subvar for current year - &CurYr). We use this report in a Book and want to set the prompt in t…
-
Need to find the details associated with the Last Update Login value in fusion HCM.Summary: Content (please ensure you mask any confidential information): Hi all, I noticed that in my table, the Last Update Login column contains a key value (for exampl…gimhani nanayakkara 49 views 1 comment 0 points Most recent by Jun Ye-Support-Oracle Applications Security