BI Publisher
Discussion List
-
BIP extract needs to be split into multiple files for a specific range.Summary Is it possible to split BIP extract file into multiple files for a specific range.Content Hi All, I need to extract Projects and related task information from Or…Sunil Kumar Mallina 71 views 6 comments 1 point Most recent by Soumya Prakash Parhi Reporting and Analytics for ERP -
How to Publish New DashboardContent Hi i have new dashboard in BI and i need to publish after finish and i stuck in below error Destination same as source: /shared/Custom/_portal see in attached Th…Mahgoub S.Mohamed 43 views 1 comment 0 points Most recent by Senthilrajan V Reporting and Analytics for ERP -
Oracle Operational reports - CSV exportSummary Oracle Operational reports - CSV exportContent All, We are reviewing the OOTB cloud ERP operational reports (BI Publisher) with client and what they really like …User_2025-02-06-00-02-39-946 50 views 1 comment 0 points Most recent by Karthikeyan Sukumar Reporting and Analytics for ERP -
Some users do not have the archive and unarchive optionContent Some users do not have the archive and unarchive option, any ideas? Please share if you know. Thanks.User_2025-02-04-05-26-22-197 45 views 6 comments 1 point Most recent by Karthikeyan Sukumar Reporting and Analytics for ERP
-
Can we still use API - APPS.iby_fd_extract_ext_pub to add custom XML tag? in Oracle Cloud FusionSummary Can we still use API - APPS.iby_fd_extract_ext_pub to add custom XML tag? in Oracle Cloud FusionContent Can we still use API - APPS.iby_fd_extract_ext_pub to add…Ananth surampudi 45 views 5 comments 1 point Most recent by Glen Ryen Reporting and Analytics for ERP
-
Custom ESS Job Parameters Display Issues on Submission FormSummary Custom ESS Job Parameters with Custom LOVs do not display correctly on ESS Job Submission ScreenContent I have created a custom ESS job from a Bi Publisher repor…Scott Madole 243 views 3 comments 0 points Most recent by Scott Madole Reporting and Analytics for ERP
-
Period Name- In OTBI reportSummary Need perod name should populate like DEC-FY-20 (DDDFFYY)Content Hello Team, We want to have the Period name in our OTBI report in the format 'DEC-FY-20', 'SEP-FY…Saurabh Sharma_HCL 177 views 1 comment 0 points Most recent by ndryden Reporting and Analytics for ERP
-
How to display VAT for an expense line/reportContent Hi, Between EXM_EXPENSE_REPORTS and EXM_EXPENSES how do I get to display the VAT paid for an expense line/report? Either through a data model/SQL or with an anal… -
line feed when displaying getclob() using data model in oracle cloudSummary line feed when displaying getclob() using data model in oracle cloudContent select sysdate, rtrim(xmlagg(xmlelement(e,id,',').extract('//text()') order by id).Ge…
-
Identify OTBI / BIP reports using a particular columnSummary Identify OTBI / BIP reports using a particular columnContent Hi All, Is there a way to identify OTBI report and BI Publisher reports that are using a particular …User_2025-02-06-00-02-39-946 53 views 5 comments 1 point Most recent by Skolli-Oracle Reporting and Analytics for ERP
-
Paid Status for invoicesSummary Looking for the table that holds the field displaying the Paid Status for invoicesContent Hi, I am looking for the Oracle table that has the field that displays …
-
Report that tracks receipted PO'sSummary Does anybody have a report that tracks receipted PO's?Content Hi all Just wondering with the accruals of receipted items each month, which reports are being run …Tony Roff 54 views 5 comments 0 points Most recent by User_2025-02-01-08-03-13-309 Reporting and Analytics for ERP
-
Instance details for BI Publisher Report Template - Fusion ERP/SCMSummary Water marking Instance details on BI Publisher Report and EmailingContent We have a requirement to display the Instance name as watermark in some of the BI Publi…Senthilrajan V 58 views 2 comments 0 points Most recent by Senthilrajan V Reporting and Analytics for ERP -
Generate file name at runtime in BI publisherSummary Generate file name at runtime in BI publisherContent Hi We have a requirement to generate the output file name with some custom name appended with timestamp in B…ashishgupta0212 35 views 6 comments 1 point Most recent by Sudha KOVURU Reporting and Analytics for ERP
-
Daily Report that highlights supplier submitted invoicesContent Dear, Please can someone advise how to set up a report that can be scheduled daily to provide us with any new invoices that have been submitted by the supplier s…Tony Roff 37 views 4 comments 0 points Most recent by Koteswararao Yenikepalli Reporting and Analytics for ERP
-
GlTrialBalanceReport is not workSummary Standard report General ledger trial balance report giv error fileContent Hi when start run General ledger trial balance report from schadenfreude process error …Mahgoub S.Mohamed 26 views 2 comments 0 points Most recent by Mahgoub S.Mohamed Reporting and Analytics for ERP
-
Payments and Batch details should pull into single row with eText templateSummary Payments and Batch details should pull into single row with eText templateContent Hi Friends, eText payment template file using different groups where always hav…Sudha KOVURU 61 views 1 comment 1 point Most recent by User_2025-02-05-19-52-13-612 Reporting and Analytics for ERP -
BI Report using Saas and Paas DataSummary How to access Paas Database data from SaasContent Hi, I have a requirement to develop a BI Report in ERP Saas using data from the ERP and also from a custom we'v…Gerardo Marin-112339 61 views 1 comment 2 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Drill down in fusion BIP ReportsSummary Using drill down functionality in BIP Reports (using BIP template and output in excel)Content Hi, Does anyone use drill down functionality in BIP Reports (using …
-
How to secure ESS LOV by Business UnitSummary How to secure ESS LOV by Business UnitContent How to secure ESS LOV by Business Unit. i.e. There are two Business Units -> BU1 and BU2 I have access only to BU1.…
-
Combing OTBI Output in one rowSummary Combing OTBI Output in one rowContent I'm using the subject area "Project Costing - Actual Real Time" to result Debits and Credits of Project Cost Expenditure Li…User_2025-02-05-23-22-49-102 108 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
OTBI Customer SurveyContent Oracle BI development is planning OTBI feature improvements. To better understand SaaS customers’ reporting needs, usage and requirement gaps, we are conducting …User720640-Oracle 25 views 0 comments 0 points Most recent by User720640-Oracle Reporting and Analytics for ERP -
Please Save BI Answers Direct Database Query SQL Definition before 19D UpgradeSummary Please save your BI Answers Direct Database Query SQL definition before 19D UpgradeContent Please Note: This notice does not affect BI Publisher SQL data models …User720640-Oracle 90 views 0 comments 1 point Most recent by User720640-Oracle Reporting and Analytics for ERP
-
Deprecating BI Publisher connectivity to the Oracle Fusion TablesSummary Restricting access to Fusion Cloud database via BI Publisher Data ModelContent Heard that Oracle is planning is to restrict the access to Oracle Fusion cloud tab…Senthilrajan V 70 views 7 comments 3 points Most recent by Manish Pesswani Reporting and Analytics for ERP
-
Receipting ReportsContent Hi Is there a report that tracks PO's and the receipted amount? thanks Tony Version 19CTony Roff 47 views 1 comment 1 point Most recent by User_2025-02-06-00-59-55-679 Reporting and Analytics for ERP
-
Table name that stores purchase order attacmentsContent Hi all, please, we are developing a report that should retrieve the purchase order's attachment name. Do you know the table name where attachments are registered…Caio Zioli-Oracle 62 views 1 comment 1 point Most recent by Nishanth B Jain Reporting and Analytics for ERP -
Create smart view report using querySummary Create smart view report using queryContent Hi All, We have created an Oracle BI report to display PO related details using query. And we would like to implement…Anjali Ravichandran 50 views 2 comments 1 point Most recent by Nathan CCC Reporting and Analytics for ERP
-
are there any SOAP/REST services available to Execute Report using JWT token instead of username andSummary are there any SOAP/REST services available to Execute Report using JWT token instead of username and password?Content Hi Team, Are there any SOAP/REST services a…
-
SQL gives me wrong purchase order number for invoiceContent Hi, When I go into the front end of Fusion, I can see that an invoice number of 26427 only has 1 purchase number matched against it which is PO 911753 When I do …
-
Amending SQL slightly brings me: ORA-01427: single-row subquery returns more than one rowSummary ORA-01427Content I am using Oracle Fusion, the finance/payables reporting side of things I have the following code: SELECT DISTINCT PHA.SEGMENT1 FROM AP_INVOICES…