BI Publisher
Discussion List
-
sql query to fetch item number detailsSummary: We need a SQL query to fetch the item number, business unit, inventory item id, unit cost, total cost, sub inventory code, organization name. Kindly let us know…Dilip.Murugan-Oracle 2.9K views 11 comments 0 points Most recent by Harshitha S Motagi Reporting and Analytics for ERP -
cashflow statement report querySummary: Hi All, Does any one have 'Cashflow Statement Report' query?? if you have could you please share. Thanks in Advance. Content (please ensure you mask any confide…Amarnath Podaralla 11 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management -
How to join INV_TRANSFER_ORDER_HEADERS with GL_JE_LINES to get period name?Summary: I am using INV_TRANSFER_ORDER_HEADERS,INV_TRANSFER_ORDER_lines table in my report to get transfer data but i want to run this report for particular month and ad… -
Fixed Assets To and From Period range parameterSummary: I'm editing a DM for a fixed assets report. My task is to create a "To Period" and "From Period", the issue is in the SQL no matter how I've written it in to be… -
Extra blank page in the output from BI Publisher RTF template due to using page break to get multiBI Publisher - RTF Template Report Output - Extra Blank Page is getting generated at the end of the Output.Srini_Venkat 256 views 1 comment 1 point Most recent by Shankar-Oracle Reporting and Analytics for ERP -
How to stop/disable email bursting from BIP reports after P2T refreshSummary: Hi All, We have multiple custom BIP reports with email-bursting queries. When the P2T happens, we want to disable the email bursting from the custom reports. Si… -
ERP BI Publisher - HTTP Data SourceWe are planning to use an external API as a data source in BIP within Oracle ERP Cloud. Can anyone confirm if "HTTP" as a data source will be de-supported in a future re…Rohit Varma - Architect 21 views 1 comment 1 point Most recent by MiaM-Oracle Reporting and Analytics for ERP -
Oracle Fusion BIP SQL using BIPUBLISHER_V to pull data from Audit Tables via BIP for custom reportsHi Guys I saw a very old post relating to using BIPUBLISHER_V, quoting the PDF attached, but would like to know if this is still relevant for the latest versions of Orac… -
Is it possible to pull the approvers for Job Requisition Approval?Summary: We are trying to create a BI report to know with whom the Job Requisition Approval is pending with. We have used the below query to pull the details but when th…Raje 28 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
Include Dynamic dates in File Name for Scheduled Custom ReportSummary: We are scheduling a weekly custom report to run each Tues night for the previous weeks' data (ie. Jun-17 thru Jun-25) Is it possible to include the date paramet… -
ESS Jobs DashboardSummary: ESS Jobs Dashboard Content (please ensure you mask any confidential information): Hi Team, Greetings! As you know -we submit/schedule multiple ESS jobs. Is ther…Parag Hiremath 318 views 5 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
How to translate Amount in Words from English to Arabic language in rtf templateSummary: we have a requirement to print Payment amount in Words (English) to Arabic language in check template. The expectation is that, translate below given English te…SireeshaJaladi 515 views 9 comments 0 points Most recent by ArjunReddy88 Reporting and Analytics for ERP -
RTFtemplate sorting data is there any limitWe want to sort the data in alphabetical order for “Payment Process request status report”. This is the seeded report provided by oracle when PPR is ran. Seeded report i…SivaRamaKrishna-Oracle 13 views 1 comment 1 point Most recent by MiaM-Oracle Payables, Payments & Cash Management -
Supplier data model missing a column in displaySummary: The tax ID column is missing in a custom data model for one user. Content (please ensure you mask any confidential information): I created a data model (SQL que… -
How to get deep link in Excel Template on a particular field in BI ReportWe are trying to get a deep link as a hyper link on a particular column in Excel Template in oracle fusionLakshmiVanarasi 134 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP -
Error when generating report, unsupported output format XLSXWe've received an error on one of our reports. Error message is the following: "Output failed. [INSTANCE_ID=bip.bi_serverHA] [OUTPUT_ID=158261] oracle.xdo.servlet.data.D…Francisco Carrillo-Robles 209 views 3 comments 0 points Most recent by Ajay Sharma Reporting and Analytics for ERP -
how to exclude our custom application data from being picked by Account Analysis Report?Summary: Recently We has implemented a custom application. Data for this custom application flows through accounting hub. The data volume is huge (millions of data each … -
Invoice Print Template Translation to Arabic Language converts Amount and Date also in ArabicSummary: Invoice Print Template Translation to Arabic Language converts Amount and Date also in Arabic Content (please ensure you mask any confidential information): We … -
Is it possible to develop BI report to fetch data from VBCS pageSummary: Is it possible to develop BI report to fetch data from VBCS page Content (please ensure you mask any confidential information): Hi All, Is it possible to develo… -
Created a BIP report from subject area Payables-Payments Disbursement Real to concatenate columnsSummary: Created a BI publisher report using Subject area from Payables. There is no option to concatenate two or more columns. I need to concatenate the payee address f…PSehgal2388 11 views 1 comment 0 points Most recent by James McBride Reporting and Analytics for ERP -
Report to get employee's default expense accountSummary: Hi, Can you please suggest if OTBI report is possible to develop to get employee's default expense account? If Not can you please share any SQL query which can …Ninja 746 views 3 comments 0 points Most recent by Aravindkumar Shah Reporting and Analytics for ERP -
Need help on getting correct YTD_DEPRN (YTD Depreciation) and DEPRN_RESERVE (Depreciation Reserve)Summary: Can someone pls provide inputs on where can we find correct base table and column for YTD Depreciation and Depreciation Reserve for a specific Asset and Book wi… -
permissions to access reports and analytics catalogSummary: Cloud ERP R13 Content (please ensure you mask any confidential information): I have a user with BI Administrator but when trying to access Tools > Reports and A…Service Desk Claremont 412 views 4 comments 0 points Most recent by Service Desk Claremont Reporting and Analytics for ERP -
How to reorder columns in xpt templateSummary: How to reorder columns in xpt template Content (please ensure you mask any confidential information): Hi Team, We have created xpt template and we need to re-or…Nidhi Chhajed 12 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
How to call an OIC integration from BIP reportSummary: I have created an app driven integration with two request parameter. How can I submit the integration from BIP report? Content (required): I got a blog https://…Ananya Sadhukhan 4.9K views 19 comments 0 points Most recent by Adi Salomons Oracle-Oracle Reporting and Analytics for ERP -
ExternalReportWSSService runreport data is inconsistentSummary: When we call a HCM report which has employee info, the contact details info-the phone number value is coming inconsistently. Sometime it gives a empty/null valu…KarthikeyanPK 41 views 2 comments 1 point Most recent by KarthikeyanPK Reporting and Analytics for ERP -
Is there a tool or a way of extracting all a list of all reports OTBI, BIP and OACHi All, Is there a tool or a way of extracting all a list of all reports OTBI, BIP and OAC. Thanks & Regards, Keerthana SekarKeerthana Sekar 81 views 8 comments 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting and Analytics for ERP -
Fusion to SFTP - File got corruptedSummary: By bursting query we are transferring a fusion report to SOA SFTP. But in SOA SFTP the files seems to have missing lines. i.ie., Fusion report has 18k lines in … -
BLOB in sql query datamodel, how to display readable values?Summary: In BI in a datamodel, how to display in readable format a BLOB value? select adhocschedule from fusion.request_history This value only displays: ��¿¿ ¿dgodard22 103 views 4 comments 0 points Most recent by Rajesh Kumar Gunda Reporting and Analytics for ERP -
Sql query to get PO Change Order line Details.Summary: Required sql query to get following PO Change Order line Details. Columns: Attribute Change From and Change To Content (please ensure you mask any confidential …Praneeth Nalluri 608 views 1 comment 0 points Most recent by Fazal Subhan Reporting and Analytics for ERP