BI Publisher
Discussion List
-
Connect Oracle Fusion BI Publisher and Oracle e-Commerce using Web Services Data SourceSummary: Is it feasible to connect Oracle Fusion BI Publisher and Oracle e-Commerce using Web Services Data Source ? If yes, can you provide us with any white paper docu…SUDHIRNARAHARISETTI 41 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP -
How to remove certain part of a column after parenthesis in BI reportSummary: Hi All, I want to remove the part of Tax Reporting Unit column from where the parenthesis is starting. Please suggest the function to use this in sql. Example: …Dona Das-Oracle 51 views 6 comments 0 points Most recent by Dona Das-Oracle Reporting and Analytics for HCM -
In Xsl template we are getting error like:sun.util.calendar.ZoneInfo cannot be cast to java.util.SimSummary: Hi Team, Hope everyone is doing good! We have an requirement, where we have to use Current date condition in xsl template as mentioned below, but we are getting…MaheshRayudu7 61 views 2 comments 0 points Most recent by MaheshRayudu7 Reporting and Analytics for HCM -
Need to identify tables that contain BPM configurations - Application PreferencesContent Looking to identify the table(s) that contain Application Preferences for BPM Worklist. See screen shot below.Jeff Hare CPA CISA CIA 225 views 6 comments 2 points Most recent by Pallavi S Reporting and Analytics for ERP -
OTBI Anaylsis to retrieve Security roles by usersHello, How can I create an OTBI Analysis to pull users along with their Security Roles or by able search the Role to see all the users using that role? Any help is appre…Gail Wilmoth 41 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Just like for each that populate several rows in Excel Template, can we do the same for columns?Summary: Hello, For the Recruiting module, our client wants to have a report that dynamically populates the Questions found in Questionnaires of Job Requisitions based o… -
Oracle BI Publiser for fusion . Applying parameters for excel dataset on element by expression.Summary: Content (required): Hi Gurus, I'm using an excel dataset with 'Element by expression' as explained on the image image . The question is: is it possible filterni…Enzo Venturini 31 views 2 comments 0 points Most recent by Enzo Venturini Reporting and Analytics for HCM -
Need a report that shows assignment numbers that DO NOT have a tax card associationSummary: I'm looking for help on developing a query that will fetch Employee Name, Person Number, Assignment Number, and Assignment Effective Start Date for any assignme… -
How to hide Mark as read and Mark as unread links based on condition in workflow notificationSummary: How to hide Mark as read and Mark as unread links based on condition in workflow notification(Checklist task) Content (required): Hi All, We got a requirement t… -
Supplier Qualification Infolets page showing initiatives status graph by login baseSummary: Supplier Qualification have Infolets page showing initiatives status by graphical view by the login base and customer want to see the globally ,how many initiat…SivaRamaKrishna-Oracle 31 views 3 comments 0 points Most recent by SivaRamaKrishna-Oracle Reporting and Analytics for ERP -
how to call fast formula from SQLSummary: how to call fast formula from SQL Content (required): Hi All, Is it possible to call Fast formula from SQL to verify the FF results? Thanks, Venkatesan R Versio…Venkatesan 801 views 4 comments 1 point Most recent by Ketan Prajapati Reporting and Analytics for HCM -
Clubbing of SOA Instances while Invoking a web service using BIP reportSummary Clubbing at SOA instance instead of creating new instance while calling a external web service from SaaS BIP report as a Webservice type of BIP report.Content We… -
How to create the seeded AR Receivable Template ?Summary: How to create the seeded AR Receivable Template ? Content (required): Hello We have customize the AR seeded template , but it seems is not working when the user…Cesar Saveedra 61 views 3 comments 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections -
SCM Dashboard ReportI am looking for end to end O2C lifecycle details in report. Do we have any sample report report with this requirement ? Below are the columns I am looking into it. Sale…Oracletechnofunctional 61 views 2 comments 0 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for SCM -
How to pull data from Human Capital Management and Workforce Management subject areas?Summary: How can data from the Human Capital Management Approval Notification and Archive Real Time and Workforce Management Person Real Time subject areas be effectivel…Basti 41 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Is there any Oracle seeded report which shows reconciliation status as one of its column?Summary: Oracle seeded report showing "Reconciliation status" (Reconciled/Unreconciled) as output. Content (required): Oracle seeded report showing "Reconciliation statu…User_2025-03-10-17-00-26-818 51 views 1 comment 0 points Most recent by Hussian Sharief M-Oracle General Ledger & Intercompany -
How to improve performance of Analytics?we have a custom BI analytic, this analytic is made up of pure calculated columns. So the analytics when loading becomes slow. How to improve performance of Analytics?Alfredo 61 views 3 comments 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Sales -
How to enable the File Data Sources in Oracle BI PublisherSummary: How to enable the File Data Sources in Oracle BI Publisher? The guide shows how to do it but we are getting the error (Fusion Middleware Administrator's Guide f…Raymond Alvizo 21 views 2 comments 0 points Most recent by Raymond Alvizo Reporting and Analytics for ERP -
Sandbox- Customize create AP invoiceI have a requirement to make the 'product type' field as non editable in the 'Create Invoice' Page from the supplier portal. Do we have a document with the steps to how …KanikaGupta 152 views 1 comment 0 points Most recent by Mirela C. Radu-Oracle Payables, Payments & Cash Management -
Action buttons not displayed in email approval notificationsSummary: Action buttons aren't being displayed in email approval notifications - all the user sees is Content (required): We're using the standard invoice approval templ…Niall McColl 193 views 6 comments 0 points Most recent by Sandeep Nayak-Oracle Payables, Payments & Cash Management -
OTBI Dashboard Record Count MismatchHi Team, We have built a dashboard and that has a record count to count the number of rows. We could see the record count shows different numbers for people with differe…Swapnil Kashid 81 views 6 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP -
BIP Report for batch monitoring of Scheduled HCM ExtractsSummary: Feasibility of BI Report for batch monitoring of Scheduled HCM Extracts. Content (required): Would like to know if it's possible to pull Scheduled HCM extracts …Kate Calderon 21 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM -
Changes to bursting query in "Transactions Print Data Model" noticed in 21BSummary Changes to bursting query in "Transactions Print Data Model" noticed in 21BContent As we faced some issues with emailing invoices thru customized AR Invoice repo…Umamaheswara Reddy Karri 252 views 9 comments 2 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections -
Bursting body and pdf attachmentHello, I want the message body of an e-mail I prepared with bursting to appear as follows, and I also want to add a pdf to this e-mail. How can I do that? -
Impossible to get report output for only some usersSummary: Impossible to get report output for only some users when launching them Content (required): Hello experts, we have been having problems since November 2022 for …Oriana L. 177 views 3 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM -
How can I have a data model for Line Managers with Inactive - Payroll Eligible status?Summary: The organization decided to just use one BU. In so doing, there are expense reports generate and managers have not assigned to the new BU. Content (required): W… -
How to Find All Scheduled ESS Jobs, Frequency, Submitted By, And Other Inofmration?Summary: Just like the title says, we are having trouble find that information. I wrote the SQL Below which does return the required information but in XML/BLOB Format. …Abdulwahab-KFH 1.4K views 2 comments 0 points Most recent by Abdulwahab-KFH Reporting and Analytics for ERP