BI Publisher
Discussion List
-
Deep Link to open Payment info in view mode?Summary Deep Link to open Payment info in view mode?Content Hi, The deep links page in Fusion cloud show the following for the link to the payment https://.oraclecloud.c…Michelle Haynes 643 views 2 comments 0 points Most recent by Manish Pesswani Reporting and Analytics for ERP -
Data restriction on Data Model in Fusion CloudContent Hi, I am trying to restrict data to users having privilege to create Data Model wrt business unit e.g: There are 2 business units BU_1 and BU_2. If a user logs i…Rinku Gautam 76 views 6 comments 1 point Most recent by Manish Pesswani Reporting and Analytics for ERP -
BIP Report Parameter - DATE & TIME - TIME ZONESummary DATE & TIME - TIME ZONEContent Good People, How to create BIP report parameter in yyyy-MM-dd'T'HH:mm:ss'Z' format and compare it with last_update_date ? Thanks, …Soumya Prakash Parhi 188 views 1 comment 1 point Most recent by Soumya Prakash Parhi Reporting and Analytics for ERP -
Multiple Parameter List - With 2 Column Values Concatenated (BI Publisher)Summary ORA-00909: invalid number of arguments message when executing report with multiple parms.Content It is a business requirement to have Cost Centre code and Descri… -
Rtf Template : Print specific texts on specific pagesSummary Oracle Fusion BIPContent Hi All, In Oracle Fusion BI Publisher, I need to print certain texts on specific pages depends on how many pages gets printed in Custome…Rinku Gautam 144 views 4 comments 0 points Most recent by Rinku Gautam Reporting and Analytics for ERP -
Listing name of purchase order attachments in a reportSummary OTBI subject areas do not provide the filenames of attached documentsContent I need to produce a report that lists the names of all the attachments for purchase …User_2025-01-28-20-19-02-475 65 views 5 comments 0 points Most recent by MadhuVitta Reporting and Analytics for ERP -
BIP Report ParametersSummary BIP Report ParametersContent Hi -> BIP Report Parameters: Can we make BIP report parameters in the required order if there are more parameters. Ex: I have 20 par…Amarnath Govindu 68 views 3 comments 0 points Most recent by alexey.shtrakhov Reporting and Analytics for ERP -
BPM - capture comments in a ReportSummary BPM - capture comments in a ReportContent Hello All, We have a requirement to build the report to fetch all the invoices where Approvers either Rejected or Reque… -
CSV output Date FormatSummary CSV output Date FormatContent Hello all, I have created one Report using new data model (OBIEE data source) and an Subject Area Analysis based query. I have crea…User_2025-01-30-21-01-20-715 75 views 14 comments 2 points Most recent by User_2025-02-03-21-40-10-404 Reporting and Analytics for ERP -
Table of Contents formattingSummary How to format the Table of Contents within the BIP templateContent Hi All I am working on the Negotiation Layout which is being customised for the production of …User_2025-01-31-15-11-25-562 48 views 0 comments 0 points Most recent by User_2025-01-31-15-11-25-562 Reporting and Analytics for ERP -
Bursting : Split Files by Number of RecordsContent Good People, How can we split files based on number of records in BI ? e.g. Say the extract is having 700 records , I want it to be split into 4 files , 3 of 200…Soumya Prakash Parhi 66 views 2 comments 2 points Most recent by Soumya Prakash Parhi Reporting and Analytics for ERP -
Date an Invoice is Accounted (Posted to the GL)Summary Date an Invoice is Accounted (Posted to the GL)Content I need to build a BI Publisher report for accounted invoices that includes the date an invoice was account…Barbara-H 66 views 3 comments 0 points Most recent by Soumya Prakash Parhi Reporting and Analytics for ERP -
BI Publisher Report printing in PCL PrinterSummary PCL PrinterContent Good People, How to use BIP to print documents in PCL Printer ? I mean how to convert PDF to PCL in BIP ? or Generate the PCL output using BIP…Soumya Prakash Parhi 58 views 0 comments 2 points Most recent by Soumya Prakash Parhi Reporting and Analytics for ERP -
Print Amount in Arabic in OTBI ReportSummary Print Amount in Arabic in OTBI ReportContent Hi, We have developed a report where every month we sent a balance confirmation letter to customer. This balance cou…Sanin Antony T 34 views 3 comments 0 points Most recent by Sanin Antony T Reporting and Analytics for ERP
-
How to show PO Number from Lines PageSummary How to show PO Number from Lines Page -- rtf templateContent Hi All, We have an custom requirement of printing Purchase Order Number from PO lines pages from eve…Amarnath Govindu 54 views 2 comments 0 points Most recent by Amarnath Reporting and Analytics for ERP -
How to join the tables and develop new report using PAAS and SAAS CloudSummary How to join the tables and develop new report using PAAS and SAAS CloudContent Hello, We have requirement to develop report by combining the tables in PAAS cloud…PravinKumar Munnaluri 72 views 1 comment 1 point Most recent by User_2025-01-31-00-25-14-130 Reporting and Analytics for ERP -
Ignore Skipped Instances on resuming paused report BIP JobSummary Ignore Skipped Instances on resuming paused report BIP JobContent Hello all, We have almost more than 100+ Reports and ESS Jobs that are scheduled and as part of… -
Accounts Receivable Report (transactions and receipts)Summary Need ad-hoc AR report identifying customer billing and receivable transactions (including accounting information)Content Boise State has a requirement to provide…User_2025-01-28-03-18-28-504 92 views 5 comments 0 points Most recent by Rasu P Reporting and Analytics for ERP -
SQL Link between GL and ProjectsSummary Report which shows project transaction that have flown through to GLContent Hi Does anyone know the links/joins between GL and Projects, we are trying to build a…User_2025-01-30-20-23-15-920 1K views 4 comments 0 points Most recent by Michelle Haynes Reporting and Analytics for ERP -
Extract Arabic words using regexpSummary I want to extract arabic words from a text.Content SELECT 'user11018780 51 views 2 comments 0 points Most recent by user11018780 Reporting and Analytics for ERP -
Outbound Emails (Sent to Customers) Extract in Oracle Fusion CloudSummary Outbound Emails Extract in Oracle Fusion CloudContent Hi, We have requirement to extract the outbound emails (Sender Email ,To Email, Subject,Status ,Sent Date e…Udit_Manchanda 152 views 2 comments 0 points Most recent by Udit_Manchanda Reporting and Analytics for ERP -
Looking for a table which stores the parameter values in ERP cloud ESS schedule requestsSummary Need a table name which stores attached Attribute2 value in ESS Scheduling process screenContent Need a table name which stores Attribute2 parameter values, Norm…User_2025-03-07-21-11-01-091 566 views 4 comments 0 points Most recent by Massimo D.-Oracle Reporting and Analytics for ERP -
Hide/remove default reports from LOV in schedule jobsSummary How to hide default reports so that they dont show and cant be picked in schedule job list?Content Is it possible to remove standard ess reports from showing up … -
contracts history tablesSummary need the oks contracts approval flow history in a reportContent Hello guys, My team need the approval flow history for contracts in a report and I am not able to…User_2025-02-04-08-34-10-102 57 views 3 comments 0 points Most recent by Ramesh Nayak Reporting and Analytics for ERP -
Standard Report - Process OptionsSummary Standard Report - Process OptionsContent Hi, When we try to run any Standard/seeded report, process options contains various options/LoV. In that what is the use… -
Is it possible to repete LOV(Data validation)to each row in BI Excel template outputSummary In the excel template row grouping we have created LOV for a single column, while generating excel reports and LOV applied to first row only, I need to repeat LO…Kalieswaran S-Oracle 26 views 0 comments 0 points Most recent by Kalieswaran S-Oracle Reporting and Analytics for ERP -
Receivable Aging ReportSummary issues when selecing multiple ledgersContent Hello all, Did anyone manage to customize the Receivables to Ledger Reconciliation Report in order to select multipl…User_2025-02-04-08-34-10-102 66 views 2 comments 0 points Most recent by User_2025-01-23-21-21-21-128 Reporting and Analytics for ERP -
How to stop notifications for PO's at instance level.Content How to stop notifications/transmissions for Purchase Orders at instance level? Version Rel 13 19AAmarnath Govindu 30 views 0 comments 0 points Most recent by Amarnath Govindu Reporting and Analytics for ERP -
How to create dependent LOV Parameters for custom ESS Jobs using view criteria in cloud?Content How to create dependent LOV Parameters for custom ESS Jobs using view criteria in cloud? Please Find attached Screen shot explaining the issue in detail. Your re… -
OTBI Dashboard - Drilldown FunctionalitySummary OTBI Dashboard - Drilldown FunctionalityContent Can anyone provide me with guidance on the exact URL that should be used with OTBI dashboard to drill down from O…User_2025-01-27-23-32-25-448 163 views 2 comments 0 points Most recent by Angela.Ahrens Reporting and Analytics for ERP