Reports
Discussion List
-
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… -
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 24 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 36 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 90 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 266 views 1 comment 0 points Most recent by Catalina Soare-Oracle BI Publisher Learning Center
-
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.6K 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 33 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 85 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 985 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 3 views 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 3 views 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?
-
Table or Query for Condition column for Separate Remittance Advice in Manage Payment Process ProfileSummary: Hi Team, We need a table or query to get Condition fied under the Separate Remittance Advice in the setup Manage Payment Process Profile. We gone through these …Opkey PA 13 views 1 comment 0 points Most recent by Stephen Westerfield-Oracle Payables, Payments & Cash Management
-
Is it possible to add Approve and Reject buttons in payment process request tabSummary: Is it possible to add Approve and Reject buttons in payment process request tab in payables dashboard Content (please ensure you mask any confidential informati…Venkatesan 6 views 1 comment 0 points Most recent by Bogdan Nita-Oracle Payables, Payments & Cash Management
-
How to create a Fusion Data Intelligence DV Report using OTBI Fusion TableI have an OTBI BIP Report which is sourced from Data model using OTBI Fusion database tables. I need to recreate the report under FDI DV. I am not sure how to find same …
-
How to add Hyperlink to BI Excel template fieldSummary: We have a requirement to show Oracle AR Invoice Page and when click on Invoice Number in BI Excel template. Excel template has list of Invoice Numbers and its d…SireeshaJaladi 370 views 5 comments 0 points Most recent by SatheeshSamy-Oracle Reporting and Analytics for ERP