Reports
Discussion List
-
Annual salaries for current and terminated employees in one reportIs it possible to create a report with just a list current and terminated employees and their annual salaries?Ulitka 101 views 15 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Generate .ZIP file from BI Publisher ReportSummary Need to create a BI publisher Report that can output .zip file to be run in HDLContent Hello, We want to create a BI publisher report that can provide us a .zip …
-
Financial Reporting Center - Define Tags (GL_FRC_USER_ACCESS_REPORT_TAGS)Summary: Is anyone using the GL_FRC_USER_ACCESS_REPORT_TAGS table in a BI Publisher report? How are tags defined? https://docs.oracle.com/en/cloud/saas/financials/26c/oc…Meredith Bickell 3 views 0 comments 0 points Started by Meredith Bickell Reporting and Analytics for ERP -
Need sql Query to fetch the Job Applicants in Draft StatusSummary: We have a Requirement to build a BIP Report for fetching the Job Applicants in Draft Status. Can anybody please share the sql query for this requirement. Conten…Milan_Mohanty 32 views 2 comments 0 points Most recent by Milan_Mohanty Reporting and Analytics for HCM -
Intercompany Report displaying value in Partner Amount instead of Entity Amount columnSummary: I have a question regarding out of the box IC report: Lets say there is a transaction recorded by Entity 54001 with a trading partner has an amount of 2,167. Ho…Saraiya Daisy Dhanesh 33 views 6 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
enable gen AISummary: enable generate AI in narrative - any additional costs? Content (please ensure you mask any confidential information): Assuming the client has enterprise perfor… -
How to add dynamic logo to an OTBI analysis ?Summary OTBI Analysis & Dynamic LogoContent Good People, Is there anyway we can add dynamic logo to an OTBI Analysis ? Thanks, SoumyaSoumya Prakash Parhi 126 views 7 comments 1 point Most recent by Tiw.Jyotsna-Oracle Reporting and Analytics for ERP -
Facing performance issue with a query on gl_periods and per_calendar_events tables.On Fusion ERP I have a BIP report with complex query which involvers among others GL_PERIODS and PER_CALENDAR_EVENTS tables. Report parameters are GL Period From and GL …N.V. Mehta 13 views 4 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP -
How to get the only Error message from FAULT_PAYLOAD columnSummary How to get the only Error message from FAULT_PAYLOAD columnContent Hi Experts, Good Day!! We are trying to pull the failed transaction details from transaction c…Charan Kollipara 127 views 6 comments 0 points Most recent by ViswanadhK Reporting and Analytics for HCM
-
BPM Worklist ReportSummary Help on creating BPM Worklist ReportContent Hi, We currently have several requests regarding the BPM Worklist Report in Fusion HCM. Do you have any idea on how t…User_2025-01-29-01-38-21-058 257 views 9 comments 0 points Most recent by ViswanadhK Reporting and Analytics for HCM -
Clarification on Oracle AI Vector Search support within Fusion OTBI, FR and BI Publisher reportsWe are seeking clarification on the use of Oracle AI Vector Search (Vector Database capabilities) within Oracle Fusion reporting solutions. Specifically, we would like t…PrudhviRaju Addagada 5 views 1 comment 0 points Most recent by Srivanth_A Reporting and Analytics for ERP
-
Can we split data into different sheet in CSV output of a BIP report ??I would like to enquire about the Oracle BIP Report CSV output data limit. Do we have a 2 million rows record cap for BIP CSV scheduled report? Can we split data into di…shauli.mukherjee 13 views 2 comments 0 points Most recent by Abhishek Premchandra BI Publisher Learning Center
-
Probation Confirmation LetterSummary: We have a Requirement to send the Probation Confirmation using Oracle BIP Bursting . Can anybody share the Bursting Logic to call the IN .rtf Template or the US…Milan_Mohanty 41 views 3 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
Cross subject area "Receivables - Transactions Real Time" and "Receivables - Customer Real Time", neSummary: Cross subject area "Receivables - Transactions Real Time" and "Receivables - Customer Real Time", need to join the subject area to fetch data as there is no com…Prasad Tummalapalli 5 views 0 comments 0 points Started by Prasad Tummalapalli Reporting and Analytics for ERP
-
Cross Subject Area receivables moduleSummary: Cross subject area "Receivables - Transactions Real Time" and "Receivables - Customer Real Time", need to join the subject area to fetch data as there is no com…Prasad Tummalapalli 2 views 0 comments 0 points Started by Prasad Tummalapalli Reporting and Analytics for HCM
-
Guidance Required – Executing Dynamic SQL in Oracle BI Publisher ReportSummary: We have a requirement where business users will maintain extract configurations through a custom Oracle VBCS screen. For each vendor, the users will configure d…Sanin Antony T 15 views 0 comments 0 points Started by Sanin Antony T Reporting and Analytics for ERP -
Is there any way to identify the last usage date of a role assigned to a user in Oracle Fusion CloudHi Team, We have a requirement to identify the last usage date of a specific role assigned to a user in Oracle Fusion Cloud SaaS. We are looking for a way to determine: …Vignesh_Rajasekaran-Oracle 15 views 0 comments 1 point Started by Vignesh_Rajasekaran-Oracle Reporting and Analytics for ERP
-
Reporting package not being refreshed properlyHi All, We are experiencing an issue while refreshing a Narrative Reporting (NR) reporting package. Upon refresh, not all doclets are updated consistently—only a subset …
-
How to get the the latest balance from HCM ExtractHi, I have created a balance group HCM extract to retrieve the custom balance value. I have selected the UE - PAY_INTERFACE_PAYROLL_REL_UE and selected the process type …
-
How to map new custom data model and Separate Remittance Advice template to PPR process.Summary: I have created new custom data model & template and added it in Disbursement Separate Remittance Advice Formats report. But when run the payrun, still output is…
-
Performance of conditional suppressionSummary: Is there any guidance for best practise on use of conditional suppression Content (please ensure you mask any confidential information): Is there any guidance f…
-
Call Sub Templates inside Main RTF TemplateSummary: We are facing issue while trying to call the sub Template inside the Main RTF Template. It Returns Blank Page Output for the P_COUNTRY Parameter selected from L…Milan_Mohanty 22 views 2 comments 0 points Most recent by Milan_Mohanty Reporting and Analytics for HCM
-
Issue with weekly consolidation/translation from Entity to Parent Currency - HFMHello. I've been trying to figure out where “hidden transactions” are coming from that's causing negative values to show when I make a data grid in Periodic view. I have…User_0CYQ1 14 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Is there any way to get all BI folder level permission details via report?Hi Team, I have a requirement to fetch details of folder level permissions set on each folder in BI catalog. I see different roles/users have different level of access o…Narula Shray 572 views 6 comments 0 points Most recent by Matt Van Asten Reporting and Analytics for HCM -
What role is required to run the report in Lease Accounting Folder?Summary: I'm receiving below error when trying to run the report under Lease Accounting Tab > Leases > Generate Lease Transactions and Balances Report "Exception in Exec…
-
How can I display all selected members in a multi-select prompt, on a text header?Summary: I am trying to display all of the individual selected members that are chosen in a multi-select prompt, on the header of the report, in Narrative Reporting. The… -
Reporting agent is not working as expected on the report gridSummary: As per the 26.07 patch Reporting Agent will be available to enter natural language requests but it seems not working in our application. Content (please ensure …
-
Is the Reporting AI Assistant (Ask Oracle) not working in the July 2026 patch update?Summary: The Reporting AI Assistant introduced in the July 2026 update is not responding to any user queries submitted from the HTML Preview of reports. We would also li…Saikat Dutta-Oracle 53 views 3 comments 0 points Most recent by Dave Roberts_-Oracle Financial Consolidation and Close
-
Bulk update of font style in multiple reportsIs there any way to update the font style of multiple reports at once?