Reports
Discussion List
-
Steps to customize standard BI Report and Add ParametersContent Hello All, We have a requirement to customize standard BI Report to add parameters and modify the data model. Do we have any oracle document about this process ?…Sridhar Gupta 107 views 8 comments 0 points Most recent by Yugesh Keluskar Reporting and Analytics for ERP
-
Hello, I need help with SQL query joining 3 subject areasSummary: Hi, I need some help to verify my query. I'm trying to join 3 subject areas: "Workforce Profiles - Person Profile Real Time", "Workforce Performance - Performan…
-
Customize Report failed to generateSummary: Customize report in Report and Analytic fail to generate in this moth Content (please ensure you mask any confidential information): I have a customize report t…
-
We need to display the Tax Rate value of the Purchase Order line in OTBI.Summary: We need to display the Tax Rate value of the Purchase Order line in OTBI. So, we need to find out the subject area that we can create OTBI and display the value…
-
BIP Report to list all Custom ReportsSummary BIP Report to list all Custom Reports.Content Ho to fetch list of all custom reports from cloud instance (Oracle Cloud SaaS). I know how to fetch them from BIP A…Amarnath 2.3K views 9 comments 1 point Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
User Login History of ERPCan someone help me with any seeded report that will give me the last date/time that each Oracle user has signed into ERP like we have for EPMBehera_Ankeeta 23 views 2 comments 1 point Most recent by James McBride Reporting and Analytics for ERP
-
Procure-to-Pay RT subject area - approver nameSummary Procure-to-Pay RT subject area - approver nameContent I am attempting to update my existing P-to-P reports to leverage the P-to-P RT subject area; this subject a…
-
SQL query to create list of values for past 24 monthsSummary: I've been searching and attempting to create a List of Values to be used in a Data Model for a report to make the parameter selection dynamic year over year ins…
-
How to pass system date in subject line of email notification when scheduling an Ess jobSummary: I am scheduling ESS job set, our requirement is to print system date in email notification subject line and attachment name. How to configure dynamic date (Sysd…VasanthaFusion90 15 views 1 comment 0 points Most recent by VasanthaFusion90 Reporting and Analytics for ERP
-
ReportService API appears to be deprecated or marked as obsolete in the April 25B update.Summary: As part of the April 25B Patch activity, we noticed that the ReportService API (/xmlpserver/services/v2/ReportService?wsdl) deprecated or obsolete?. Could you p…Chaitanya2324 75 views 2 comments 1 point Most recent by Sridhar Gupta Yerram-Oracle Reporting and Analytics for ERP
-
Is there something similar to srw.abort_program in Fusion ERP bip reportIn Oracle report writer one could abort the report using SRW.ABORT_PROGRAM Built in. Is there similar built in in FUSION ERP BIP Report?
-
I have to create a actual vs budget amount report for revenue and expense accounts in OTBI.Summary: I have to create a actual vs budget amount report for revenue and expense accounts in OTBI. I have used GL balances real time subject area. The columns selected…
-
Validation Status from AP InvoiceSummary: I am creating the Data Model of our BIP Report and I need to find out which field from what table should I use as Validation Status. Content (please ensure you …
-
To connect Oracle Fusion database table with Oracle APEX to create oracle APEX ReportSummary: How to connect Oracle Fusion database table with Oracle APEX to create oracle APEX Report
-
OTBI reportOTBI reportVineet Srivastava Graviton 21 views 1 comment 0 points Most recent by Erick.B Reporting and Analytics for ERP
-
BIP SFTP Bursting vs BIP SOAP API calloutSummary: Advantages of BIP API download option (for data reports) Vs BIP report sent to SFTP channel Content (please ensure you mask any confidential information): We us…Abdullah Munaz 42 views 2 comments 0 points Most recent by Akash Katiyar-Oracle Reporting and Analytics for ERP
-
SQL query to display Purchase Category hierarchySummary: SQL query to display Purchase Category hierarchy Content (required): For anyone who might find this useful, I've written a SQL to pull the Purchase Category hie…
-
Logged in User display on OTBI reportHi Team, Both below do not generate the logged-on user at filter condition on OTBI once moved into 24A even if a person's security profile is active on view employee's o…GopalS 208 views 1 comment 0 points Most recent by Catalina Soare-Oracle BI Publisher Learning Center
-
Financial Reporting Studio Issue: 2025 Data Not Appearing CorrectlyDear Oracle Support, We are encountering an issue in Financial Reporting Studio (FRS) that is affecting the display of 2025 data in our reports. Problem Description: Whe…Patrick Chrabieh 32 views 4 comments 0 points Most recent by Patrick Chrabieh Reporting and Analytics for ERP
-
Import Oracle Fusion Data Extensions for Transactional Business Intelligence having an impact.Summary: There's an issue with HCM Reports having said that some columns were not available and the root cause of it was when Import Oracle Fusion Data Extensions for Tr…
-
Using rest api in fusion BI publisher data modelSummary: Is there any way to use rest api fusion BI publisher data model, I need to consume external data source and create a report in oracle fusion Content (required):…ShivaShiva 1.5K views 6 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
Required a field name and Table name for Manage Payment MethodsSummary: Hi Team, We need backend tables and a column for the field "Automatically assign payment method to all payees" under Usage rule → Manage Payment Methods. I coul…Opkey PA 34 views 1 comment 0 points Most recent by Krishna Pulicherla-Oracle Payables, Payments & Cash Management
-
Custom Job Set not showing for one userSummary: We have created job sets in a lower environment and the users that need to access it are able to with the exception of our Director of Projects. She is still no…Damien Curtis 66 views 5 comments 0 points Most recent by ChaitanyaBarge Reporting and Analytics for ERP
-
Procurement OTBI DashboardsSummary ERP Procurement OTBI Reports and Dashboards uploaded for the CommunityContent Sharing a procurement to pay dashboard with multiple tabs containing example report…Alan-Oracle 904 views 14 comments 16 points Most recent by Mohamed Attia-Allah Reporting and Analytics for ERP
-
Percentage formula doesn't work for expandable columns.In the "Financial Reporting Center" section by opening the "Workspace for Financial Reports" several reports have been configured. I have an issue... In column A (as an …Michele Ferro-Oracle 1 view 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
How to pass last 2 quarters as period parameters in General Ledger-Transactional Balances Real TimeHow to pass last 2 quarters as period parameters in General Ledger-Transactional Balances Real Time We are trying to create a Analysis report based on General Ledger-Tra…Pradeep Kumar Reddy V 1 view 1 comment 0 points Most recent by Lakshmi Alagappan-Oracle General Ledger & Intercompany
-
How to restrict User From Submitting Create Accounting for a Certain SubledgerSummary: How to restrict User From Submitting Create Accounting for a Certain Subledger Content (please ensure you mask any confidential information): Hi All, We have a …
-
Table to get the field of Condiion under Manage Chart of Accounts MappingsSummary: We need a table and column where the Condition field information stored for the setup "Manage Chart of Accounts Mappings". Attached the screenshot with highlite…
-
how add user variable to report header #2Summary: I need to add user variables into a report header. Is there any way to do this? What is shown below doesn't work.
-
how add user variable to report headerIs there any way to put a user variable into the header of a report?