Reports
Discussion List
-
Payables Invoices - Transactions Real Time - does not return all invoicesSummary: Payables Invoices - Transactions Real Time - does not return all invoices Content (please ensure you mask any confidential information): Hi - if I run this SQL … -
Payables Invoices by Cost Centre/SupplierSummary Dashboard & reports showing summary of AP invoice value by period/cost centre/supplier, with drill-down to invoice detailsContent Please see attached documents f…Andy Gough 1.1K views 12 comments 13 points Most recent by Samuel Bassey Reporting and Analytics for ERP -
Need the SQL query used in SaaS Service Usage Metrics ReportNeed the SQL query used in SaaS Service Usage Metrics Report (the one with PDF format extracted from MyServices) as we need to use it in a bursting program under BI Publ…
-
Insufficient space to include full field value in add help textSummary: For the BIP template trying to add a field to print the masked bank account number as below but it prints only upto…
-
What subject areas and query should I use to get AR Aging report based on BICC Extractts?Summary: I know the AR Aging report is complex with joins to XLA tables, hz tables, ar_payment_schedules, and other ra/ar tables. We are trying to generate the AR Aging …
-
How do I add the FDI link onto our oracle cloud homepageI am looking for the steps to add a link to FDI from our Oracle Cloud Homepage as shown in the screenshot below:asmith223258 20 views 1 comment 1 point Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
How to Bind List of Values together so when either parameter is select the other auto populatesSummary: Wondering how to bind list of values together so that when a user selects one parameter, then the other is auto populated and then vice versa. So far all I can …
-
How to extract attachments for Journals and Payables Invoices for a given period of timeOur company is being sold and we need an extract of journal and payables invoice attachments for a given period of time for audit purposes. We would like the attachment …
-
SQL Query for bypass Approval transactions of the BPM workflowSummary: The Client is asking to build a report based on the bypass Approval transactions of the BPM workflow. (without Approval). Content (required): we need to build t… -
How to restrict schedule process page based on usersSummary: How to restrict schedule process page based on users Content (please ensure you mask any confidential information): Hi All, As of now who ever has access to sch…Venkatesan 35 views 2 comments 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
In what subject area can i find the details of a Return Lines (Return to Supplier)Summary: Hi In what subject area can i find the details of a Return Lines (Return to Supplier), specifically the details of the receipt number, RMA, Document Number (PO)…Johann Christian 40 views 5 comments 1 point Most recent by Becca Edwards Reporting and Analytics for ERP
-
How to get IP address of Fusion SaaS BI server that sends out email via burstingSummary: How to get IP address of Fusion SaaS BI server that sends out email via bursting. This is needed for white listing the From address to allow email to reach corp…Nirmal Ignatius 57 views 1 comment 1 point Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP -
How to create a parent schedule for multiple schedule of one BI Publisher reportClient has created multiple schedule of one one BI Publisher report using different parameters ex-cost centres and different recipient in each schedule. Is it possible t…Saikat1 25 views 2 comments 1 point Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
Unable to access Usage Metrics Drill-Through ReportSummary: Dear Concern, We have purchased cloud services through a resell/partner model (i.e. partner users) and now when searching found that some users are getting an e…abRoman83 18 views 2 comments 1 point Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
Table or SQL queries for getting Project number along witht Expense report number ?Summary: Hi Team, Can anyone please let us know the table or SQL queries for getting Project number along witht Expense report number ?. Need to connect table PJF_PROJEC…
-
Oracle Fusion BI Publisher Custom Physical SQL SecuritySummary Oracle Fusion BI Publisher Custom SQL - Security ConsiderationsContent Hi, When you create a Business Intelligence Publisher data model with physical SQL, you ha…User_2025-02-05-04-43-06-903 137 views 6 comments 3 points Most recent by Carlos Benassi Reporting and Analytics for ERP -
Using a parameter & variable to represent POD name for deeplinksSummary: It is great we can use deeplinks in OTBI but it would be helpful if a variable could be used to populate the current pod name. Otherwise we need to hard code it…
-
How to add a header to the e-text outputSummary: By default the e-text layout output doesn't have column headers. We have a requirement to add the headers as well for the integration file with the third party.…SuniChacko 398 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
PO Column for Receipt Accounting Source in Oracle Fusion. Which role or privilege needs to be added?Summary: PO Column for Receipt Accounting Source in Custom Account Analysis Report in Oracle Fusion. Which role or privilege needs to be added? Content (please ensure yo…
-
INV_ACCESSIBLE_ORGANIZATIONS_V View Not AccessibleThe INV_ACCESSIBLE_ORGANIZATIONS_V view that is used in our BI reports is previously accessible using other roles even without the Application Implementation Consultant …Czarina Morales 55 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Why do scheduled reports with a daily frequency cannot be received on a weekend (Saturday & Sunday)?Summary: The business users created a schedule for the daily backup of a report, but the backup mail is being received only from Monday to Friday. Mail for Saturday and …Czarina Morales 27 views 3 comments 1 point Most recent by Czarina Morales Reporting and Analytics for ERP
-
How to change the measures in the Chart based on the Dashboard promptSummary: Content (please ensure you mask any confidential information): We have a scenario involving three types of costs: A, B, and C, which have been added as measures…Kasthuri.S 13 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
How can I configure "All" prompts in BI PublisherSummary: Content (please ensure you mask any confidential information): I have a report with some parameters, I would like them to come with the default value "All" and,… -
How to use multiple delivery channels in Bursting query -Fusion BISummary We would like to explore the option to set delivery channel as SFTP and also we want to send delivery status notification to one particular email address .Conten…Sankeerthana Anumasula-Oracle 795 views 6 comments 2 points Most recent by Gurujothi D Reporting and Analytics for ERP
-
PL/SQL Query to ADD Month to a Period NameSummary: I have a scenario where a user will pass input period name. The query should return data of both the current period entered by the user and the previous period.…Nitin Gupta_322 39 views 2 comments 0 points Most recent by Arun Raj Reporting and Analytics for ERP
-
How to add 2 columns in group by in Excel templateSummary: Need to add 2 columns in Group by expression in EXCEL template Content (please ensure you mask any confidential information): below condition is working for 1 c…Thanigainathan R 187 views 2 comments 0 points Most recent by User_6NK6Y Reporting and Analytics for ERP
-
Want to embed only bip report output and not the header sectionSummary: Hi Experts I want to embed below bip report in the supplier page but i could see that when i embed the bip page the header containing web page, home, catalog,fa…mudassirsOrc-Oracle 25 views 5 comments 1 point Most recent by Aishwarya1990 Reporting and Analytics for ERP
-
Inquiry AP ReportSummary: Is there a Payables report that I can run that provides a clean listing of invoices as of a specific date that make up the balances shown on the Payables Trial …
-
Receivables Concatenated Segment is not showing updated account in OTBI report.Summary: Hi, We have an OTBI report using Receivables - Transactions Real Time wherein we have added 'Receivables Concatenated Segment' column but it is showing the Reve…Rahul Kumar Gupta.-Oracle 34 views 0 comments 1 point Started by Rahul Kumar Gupta.-Oracle Receivables & Collections -
No Data Found when Other Users run BIPSummary: I created a simple vendor report with BIP. I can run it fine and see the data such as vendor name, number, address, etc. I have another user, Employee B, who on…