BI Publisher
Discussion List
-
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…
-
Does Oracle Fusion Allow a Link to Microsoft Power BI?Summary I'm looking to see if Fusion would allow Microsoft Power BI to link to the Servers In Order to Build ReportsContent My company uses Microsoft Power BI for alot o…
-
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 127 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 54 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 61 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 71 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 44 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 58 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 53 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 45 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 27 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 45 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 63 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 79 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 962 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 41 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 139 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 466 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 52 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 22 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 57 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 27 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 159 views 2 comments 0 points Most recent by Angela.Ahrens Reporting and Analytics for ERP
-
BI Publisher Report sporadically fails - database error?Summary Error message: SQL or ORA exceptions caused due to invalid SQL, database package state or some database exceptionsContent The error message "SQL or ORA exception…User_2025-02-01-06-21-55-603 34 views 1 comment 0 points Most recent by User_2025-01-30-01-18-25-142 Reporting and Analytics for ERP
-
SQL to Report on List of User Logins Per DaySummary seeking a listing of unique user loginsContent Can anyone provide SQL, or perhaps just table name, to get a list of unique user logins into Fusion? Thanks, Wendy