BI Publisher
Discussion List
-
Sub ledger Account table - Data VisibilitySummary Sub ledger Account tabl: Data Visibility for XLA_TRANSACTION_ENTITIES table.Content We are trying to build a BI Publisher report for extracting data for Sub ledg…Senthilrajan V 93 views 4 comments 1 point Most recent by Senthilrajan V Reporting and Analytics for ERP -
Database table details for content stored in UCMSummary Need to extrat details of UCM content in BIPContent Hi Experts , UCM contents has some properties like comments, owner , account , security group etc. Do we have…Manish Pesswani 57 views 3 comments 2 points Most recent by MadhuVitta Reporting and Analytics for ERP -
Parameters Appear Under Data_DS in CSV FormatSummary How to remove the Parameters appearing as fields in CSVContent Hi, We are currently working in a report and the data model is bringing through the fields require…User_2025-02-03-21-40-10-404 52 views 9 comments 2 points Most recent by Wendy Ware Reporting and Analytics for ERP -
What is the best option for incremental extracts in Procurement Cloud 19aSummary What is the best option for incremental extracts in Procurement Cloud 19aContent We have a requirement to extract PO information on the basis of an incremental u…Umamaheswara Reddy Karri 57 views 4 comments 0 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP -
BIP ParametersSummary Add parameter details to report at exportContent I have a requirement to show parameters while exporting a BIP report. When I export the report in an excel I do …Hari Thyagaraj 47 views 4 comments 0 points Most recent by MadhuVitta Reporting and Analytics for ERP -
Remove first blank page of BIP report having rtf templateContent Hi, In a rtf template linked to Customer invoice in Fusion Cloud, I am having 2 IF loops inside which, are sections breaks (continuous & next page). It works fin…
-
How to add Legal Entity Parameter to oracle standard report "Collections Aging by Collector 7 BucketSummary We have a Requirement to add Legal Entity Parameter to existing Standard Report.Content Hi All, We have a Requirement to add Legal Entity Parameter to existing S…User_1B10X 68 views 1 comment 1 point Most recent by User_2025-02-03-21-40-10-404 Reporting and Analytics for ERP
-
OTBI/BIP Reporting Gap AnalysisSummary Implementing Oracle ERP in all 3 modules ( HCM,SCM & Finance)Content Hi, In the process of implementing Oracle ERP modules, there are many custom reports to be b…User_2025-02-05-04-43-06-903 92 views 5 comments 0 points Most recent by Shakher Sharma Reporting and Analytics for ERP
-
Fixed Asset Book Comparison ReportSummary Is there is a fixed asset report that will compare asset detail across different books?Content We need a report that will compare asset detail across different b…User_2025-02-05-01-44-13-448 51 views 2 comments 0 points Most recent by User_2025-02-05-01-44-13-448 Reporting and Analytics for ERP
-
OTBI RequirementSummary Setting a Flag By Updating Attribute Column in Invoice Header TableContent Hi, We designed a report which send notification for cancelled invoices to vendors sho…AnsumanM 40 views 5 comments 2 points Most recent by Manish Pesswani Reporting and Analytics for ERP -
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 593 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 68 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 172 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…
-
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 128 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 59 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 62 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 73 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 60 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 46 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 976 views 4 comments 0 points Most recent by Michelle Haynes Reporting and Analytics for ERP