BI Publisher
Discussion List
-
PGP Encryption for RunReport SOAP Web ServiceSummary: Is there a way to encrypt the Report output when the report is extracted using the following SOAP API: Service WSDL URL: https://servername/xmlpserver/services/…Shubham Malik 14 views 1 comment 1 point Most recent by Lee Eslick-Huff Reporting and Analytics for ERP -
Need to know the logic behind the seeded report parameters of Payables Trial Balance ReportSummary: Just wanted to know the logic behind seeded 'Payables Trial Balance Report' parameters which are mentioned below 1.Include Bills Payable 2.Negative Balances Onl…SireeshaJaladi 81 views 3 comments 0 points Most recent by SireeshaJaladi Reporting and Analytics for ERP
-
Feasibility check to customize Disbursement PPP File to generate xml output with attribute values.Summary: Requirement is to customize Disbursement Payment File for a bank to generate an xml output to display attribute values from CE_BANK_ACCOUNTS, IBY_EXT_BANK_ACCOU…Chowdari Malapati Monika 11 views 1 comment 1 point Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
BIP Cloud - Deployment role missingSummary: BIP Cloud - Deployment role missing Content (required): Please note this idea is related to deployment of BIP reports on "BIP Cloud" Problem Description -------…
-
Has anyone successfully implemented secure list views? Do you recommend them?Summary: I’m eager to learn of other users' experience in implementing Secure List Views, particularly from anyone who has implemented them to any significant scale. The… -
ESS Print Job Queue - Oracle Fusion CloudSummary Accessing the ESS Print Job Queue from Oracle Fusion Cloud.Content Hi, As part of performance testing we ran Invoice Print Program for a wide range of dates, cus… -
Concatenating Values in a Database with 'for each' with a delimiterDear all, Is there a way to retrieve data using a 'for each' loop and insert a string between the values? For example: I have the following values in a database table: c…George Mattar 21 views 5 comments 0 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP
-
Why to use FRS or Narrative reports when we have OBTI and BIP toolsHello Oracle Gurus, When we have reporting tools such as OTBI and BIP, why is there a specific need to use Narrative reporting tool or FRS tool?
-
BI Publisher - How to generate the postal bar codeSummary BI Publisher - How to generate the postal bar code and standard payment barcode on billsContent I have a requirement to generate customer correspondence that inc…RichardChan 53 views 6 comments 0 points Most recent by Sonny_Conyers Reporting and Analytics for ERP -
How to sort data in etext template using a hard coded fieldSummary: We have a requirement to sort data using a record type element. this element is custom and is the first column of the level and not present in the xml file. Ple…Abhilash K - Deloitte USI 51 views 3 comments 0 points Most recent by Arun Raj Reporting and Analytics for ERP -
How do we configure DKIM for BI BurstingSummary: How do we get DKIM for BI Bursting when we can have multiple from email address based on business unit Content (required): When the emails are sent out to the c…Arun Rajendran 81 views 3 comments 0 points Most recent by YashSonani Reporting and Analytics for ERP
-
Schedule Report > Dest FTP > Case When There is No Data > Ability to Not Generate Output FileSummary: BIP Report > Schedule Report > Destination FTP > Case When There is No Data > Ability to Not Generate Output File Content (please ensure you mask any confidenti…
-
How to extend timeout to more than 18000 seconds?Hi All, When I run a customer report with huge data, the scheduled report shows failed with exceeds 18000 seconds. The timeout setting in data model properties has a lim…
-
Is there any alternative if table is not available for BICC extractionHi, I was working to do an extraction using BICC and not able to get the PVO for some tables like: RCV_SUPPLY, WSH_FREIGHT_COST_TYPES etc. Is there any work around avail… -
OTBI - YTD -For - Period NameSummary YTDContent All->How to calculate Year-To-Date YTD (total amount for a given period) for a amount column from OTBI. when a user selects Period Name from Parameter…
-
Hot to fetch bursting delivery notification detailsSummary: Looking for a query or table which would fetch bursting delivery notification details. Content (please ensure you mask any confidential information): We have a …Priyanka_Ghosh 141 views 1 comment 1 point Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
Project Class Category Causes Duplicate Rows for Project Financial Information in OTBI and BI PUBSummary: When we want to report on the Project Classifications class categories for a project number there is no clean way to do it. The current solution we are doing re…
-
Reporting Capability Maturity Matrix : Reporting Road MapSummary: I'm trying to develop a notion or framework for "Reporting Capability Maturity", as something organisations could use to assess how good they are at Oracle repo…
-
Table details for ESS Job Display NameSummary: Hi, Can you please suggest which table holds the ESS Job Display Name? I have tried few tables like: request_history_view, ess_request_property but not able to …
-
Custom File Naming for ESS Job Downloads in Oracle FusionSummary: Request for Custom File Naming for ESS Job Downloads in Oracle Fusion Content (please ensure you mask any confidential information): We have created ESS (Enterp…Tauseef-Oracle 121 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
Requisition Approval E-Mail Report Template changes is not getting reflected in output file.Summary: I have customized the seeded report named "Requisition Approval E-Mail Report" but the changes is not getting reflected in the notification. It is taking the la…Palukuri 303 views 1 comment 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP
-
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 72 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 159 views 2 comments 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP