BI Publisher
Discussion List
-
Terms & Conditions in PO PDFSummary: Hi Fellow Developers, The requirement is to host Terms and Conditions file in Oracle cloud and it should be printed as hyper link in PO PDF. when ever a Supplie…Dhilip Kumar P. 47 views 4 comments 0 points Most recent by Dhilip Kumar P. Reporting and Analytics for ERP -
How to concatenate elements with same name in etext templateSummary: How to concatenate elements with same name in etext template Content (please ensure you mask any confidential information): We are working in etext template for…Nidhi Chhajed 190 views 1 comment 1 point Most recent by MiaM-Oracle Reporting and Analytics for ERP
-
Does anyone know about what X-invoices format? or ZUGFeRD format? how we can adapt with RTF TemplateCurrently we are using RTF Format template for invoices, and we are sending Invoice details in PDF. But recently Germany business users asking the invoices details in ZU…Srikanth Doodapaka 61 views 1 comment 0 points Most recent by MiaM-Oracle Reporting and Analytics for ERP
-
Can someone suggest me with respect to performance tuning of the query?Issue is with a BIP report for optimizing the report query FYI this is AR report for Aging bucket. please find my initial findings below, request you to please provide y…Shahid Qureshi 61 views 7 comments 0 points Most recent by James McBride Reporting and Analytics for ERP
-
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 3K 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 13 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 306 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 https://us.v-cdn.net/6034893/uploads/XBAKK1LFAVL0/wp-fusionbipaudit-5459609.pdf I saw a very old post relating to using BIPUBLISHER_V, quoting the PDF attached, …
-
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 23 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 335 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 518 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 155 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 208 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 12 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 832 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 473 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 21 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 5.1K 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