BI Publisher
Discussion List
-
How to use RTF templates if Client is having Google Docs and sheets instead of MS Office productSummary: Our client is using Google products only like Google Sheets and Google docs and not having MS office products such as MS word or excel. How do we edit the RTFs … -
Tracking Data Model Usage and associated queriesSummary: How is called the table or view (Oracle fusion) which tracks the information about the queries (data models) run by a user? The goal is to determine which table…Christian Flegler 11 views 1 comment 1 point Most recent by Lee Eslick-Huff Reporting and Analytics for ERP -
How to Attach Process ID(fusionapps_request_id) to File Name when Bursting ?Hi All, Now there is a process which content is a BIP report with bursting. I'd like to attach the process id as a part of bursting file name. But when I use ':fusionapp…
-
Excel template with summary and Detail and Detail sheet should split in to multi sheet, need helpSummary: Excel template with summary and Detail and Detail sheet should split in to multi sheet, need help Content (required): Excel template with summary and Detail ( D…Dineshkumar.A-Oracle 1 view 1 comment 1 point Most recent by KISHAN BUSSA Reporting and Analytics for ERP
-
How can I create an event trigger in a data model with subject area?I have created a report with a data model with subject area and this report works fine, but I want to create an event trigger so that the report is only generated if it …
-
Prompts are not currently supported for analysis that combine criteriaSummary: Combined two SA i.e "Projects Billing - Revenue Real Time" + "Project Performance Reporting Real time" and want to have 'Project name' as Prompt Value and it is…SBJ_PPM_1210 73 views 2 comments 0 points Most recent by Tomasz Kaniuk Reporting and Analytics for ERP -
Customer StatementSummary: Unable to print page number in rtf layout based on the customer Content (required): Hi Team, we have requirement to print the page number in the rtf template ba…
-
LACLS: Dominican Republic (DO) BIP Reports Libro Diario and Libro Major do not render parametersSummary: The Libro Diario and Libro Major BIP reports in the Latin America Cloud Local Solution (LACLS) for Dominican Republic do not work. Parameters do not render. Con… -
Table for Bursting Output ResultsSummary: Does anyone know what table has the results of an individual bursting output from a scheduled BIP report? From the screenshot above you can see that we have one…Lee Eslick-Huff 141 views 2 comments 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP -
Is there a standard report to run showing all terminated users and terminated dates from Oracle ERP?Summary: The customer was inactivated and locked the user from the Security and Console. Please note they are not using the HCM module. However, they would like to displ…
-
Format Automatic Receipts - Override Email CommunicationSummary: At BIP server level, for the complete POD, is there any option to override the TO email address is being used to communicate any email via bursting query? Conte…
-
Is it possible to add a new filed in data model query of Payable Trial Balance seeded report?Summary: We have a requirement to get Supplier name in Arabic in Payable Trial Balance report. User don't want to customize the seeded report as they are using same repo…SireeshaJaladi 141 views 8 comments 0 points Most recent by SireeshaJaladi Reporting and Analytics for ERP
-
How to pull GL JE data for a rolling last 2 periods or last 60 daysSummary: How to pull GL JE data for a rolling last 2 periods or last 60 days Content (required): How can I pull GL JE data from the GL JE Header and Lines tables, so the…
-
Pricing List ReportHi, I am looking to create BI publisher report on Pricing List. If you can share the query and RTF template if any available please do share ThanksMohammed Rafi 31 views 2 comments 1 point Most recent by Mohammed Rafi Reporting and Analytics for ERP -
Query to fetch List of OTBI usersHi Team, We do have a requirement to Create a report for List of users having OTBI access. Regards, RamuVadde Ramu 61 views 3 comments 0 points Most recent by Dharmendra Shukla Reporting and Analytics for ERP
-
How to find from which system or ip submitted a bip reportSummary: can we check from which system or ip a bip report got triggered? we are using a generic login shared across all developers and testers Content (required): can w…Lavakumar 11 views 1 comment 0 points Most recent by Dharmendra Shukla Reporting and Analytics for ERP
-
Obtain the number of SQL executions or the number of executions of the BIP itselfSummary: I want to create a query to extract the number of data model runs or BIP reports run in ERP's BI publisher. Content (required): The objective is to extract the …YUTA TOGASHI-Oracle 41 views 3 comments 0 points Most recent by YUTA TOGASHI-Oracle Reporting and Analytics for ERP
-
How to include invoice attachments from UCM on bursted email outputI have created a custom email notification for invoices requiring receipts. I am using an RTF template for the email body and would like to include manually uploaded inv…
-
Some Prepayment Invoice amount showing doubleSummary: Content (required): Dear All We have an query which will fetch the Prepayment Invoice details , the query is working fine , but it is noticed that some of the i…Shameer Muhammed P M 11 views 0 comments 0 points Started by Shameer Muhammed P M Reporting and Analytics for ERP
-
Extracting Other language description in OTBI ReportSummary: Extracting Other language description for Account Hierarchy in OTBI Report Content (required): Hi All, We are trying to build a OTBI report which displays Accou…
-
How to call an OIC integration from BIP reportSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
Need report that shows all approval assignees who have NOT approved invoiceSummary We are trying to build a report that provides only “open/incomplete” invoice approvals (i.e. only those approval assignees who have NOT approved yet)Content We a…User_2025-01-28-19-14-07-225 557 views 16 comments 2 points Most recent by Dahlia Gaggan Reporting and Analytics for ERP -
Can BI Publisher be used to send XMLs in UBL 2.0 format? If yes, please elaborateSummary: At my client all financial transactions in Receivables are subject to archiving at a 3rd party. The client wants to be able to leverage the Generate Bill flag o…
-
Access DBCS tables in SaaS BI Publisher ReportsSummary Is it possible to access DBCS tables while creating BI publisher reports in SaaSContent Hello We have a requirement to build some BIP reports out of the tables t…Deepika Jain DJ 88 views 3 comments 1 point Most recent by Nathan CCC Reporting and Analytics for ERP
-
How to Zip BIP output containing multiple output filesSummary: Content (required):We are trying to download zip file(containing all output files for particular schedule) using Compress output prior to delivery. Version (inc…
-
Is there a function/package to retain Hebrew Language source text in BI Report output text using SQLI have a Hebrew text file uploaded in UCM. I pass the file from UCM to the Data Set query. The report output display junk characters and does not retain Hebrew character…
-
Table name that holds the Supplier Site Purchasing Tab dataSummary: Table name that holds the Supplier Site Purchasing Tab data Content (required): I'm trying to create a BI Report to monitor when PO's are not communicated out t…Richard Nagle 531 views 1 comment 0 points Most recent by Richard Nagle Reporting and Analytics for ERP
-
SFTP bursting to home directoryHi All We have an issue delivering files to "\" directory for a vendor.. There are no sub directories and oracle documentation mentioned \ should not be used. and when n…Murthy Kodavati 21 views 2 comments 1 point Most recent by Murthy Kodavati Reporting and Analytics for ERP -
How to use Starts With or Contains function in BI Report SQL QuerySummary: Is it possible to use Starts With or Contains function in BI Report SQL Query? If so, how? Content (required): Is it possible to use Starts With or Contains fun…Richard Nagle 262 views 2 comments 0 points Most recent by Richard Nagle Reporting and Analytics for ERP
-
Query to retrieve entries using accounting period from and accounting period to parameterSummary: Query to retrieve entries using accounting period from and accounting period to parameter when both are optional Content (required): Version (include the versio…Abhilash K - Deloitte USI 22 views 3 comments 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP