BI Publisher
Discussion List
-
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 812 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 42 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 153 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 209 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 255 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. 171 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 -
Benefit Certifications tableSummary: We have a requirement to fetch "Certifications" tab related data in the BIP report. May I know in which tables holds the information on certification? Content (…Satyabrata Nanda 51 views 5 comments 2 points Most recent by Viral Abotiyawala-Oracle Reporting and Analytics for HCM -
BI publisher for Demand Plan custom measures.Summary: Hi all, please I would thank for any help with the following. We need the query below this Demand Plan screens. Example 1. Example 2. We have noticed some table…Juan Jesus 91 views 3 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM -
OTBI if Grade is Null those employees are not fetching in the report.Summary: We are adding version 3 seniority dates in OTBI existing report, added new subject area "Workforce Management - Person Seniority Real Time" when using filter co…challa praveen 71 views 8 comments 0 points Most recent by challa praveen Reporting and Analytics for HCM -
How to display the value to be in line using BI Publisher (rtf)Summary: We want to display value in line from the RTF Template. However it displays as per below. Content (required): Please find attached RTF Template and XML Version …Aries 394 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM -
Disable online Output view for BIP reportsSummary: Disable online output view for BIP reports Content (required): We are trying to restrict the online view of outputs in BIP. We don't find any suitable report op…SayanDutta 41 views 2 comments 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
Disable online Output view for BIP reportsSummary: Disable online view for BIP reports Content (required): We are trying to restrict the online view of outputs in BIP. We don't find any suitable report option fo…SayanDutta 132 views 1 comment 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP -
What time does the User Password Changes Audit Report show?Summary: I'm running the User Password Changes Audit Report and I'd like to know what time zone does the report output show. Content (required): User Password Changes Au…Adrian Svet-Oracle 41 views 4 comments 0 points Most recent by Adrian Svet-Oracle Reporting and Analytics for SCM -
How to Prevent merging columns in excel using RTF template in Fusion BIP ReportsSummary How to Prevent merging columns in excel using RTF template in Fusion BIP ReportsContent Hi Experts, How to Prevent merging columns in excel output using RTF temp…Bala Kasineedi 1.3K views 6 comments 0 points Most recent by User_67JNL Reporting and Analytics for HCM -
Need a Query to Exclude the Terminated Record after 7 daysSummary: First 7 days , The Record should show with Status= Inactive Status and after 7 days The Record should not be shown in the Report. Content (required): Version (i…MilanMohanty 101 views 10 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Which tables do these search results belong to?Summary: When I search Subject Areas the result contains duplicates. Content (required): How do I know to which presentation tables the search results belong, and how ca…Maboagamo 31 views 11 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM