Sample Reports
Discussion List
-
Oracle BIP Report Excel template output displaying Number values as TextHi, We have created the new custom BIP Report with Excel template and when we download the report output into Excel, then all Number values are displaying as text, these…Nagaraju Vandavasi 41 views 5 comments 0 points Most recent by User_26T18 Reporting and Analytics for ERP -
How to display date in the format (like April 1st 2025) using RTF tags.The requirement is to display the date like April 1st, 2025 in the RTF Template using RTF Tags.Nalsoft Pvt Ltd 23 views 3 comments 0 points Most recent by Hari Haran Reporting & Analytics for Fusion Service
-
I am trying to populate latest date record to be printed for BPA from PO tables in a custom BIPPer the business requirement, we need to print COO from BPA attached to the shipment, if the shipment lines having country of origin code is NULL, and since there maybe …Shahid Qureshi 01 3 views 0 comments 0 points Started by Shahid Qureshi 01 BI Publisher Learning Center
-
the end date of assignment is 4712for the previous assignmentHi, Currently just Working on one requirement where i encountered a scenario is(Using Per_all_assignments_m) The person has four Assignments Active employee where the en…Kande Likhitha 2 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Query to get import/update customer in Oracle Fusion based on load request IDI am trying to import/update customer and wanted to get import error messages for those customer through the BI report. But getting few error messages even the customer …Zaid123 12 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service
-
Does BI Publisher SFTP delivery connection support with Azure SFTP server ?Does BI Publisher SFTP delivery connection support with Azure SFTP server ?KabirB 37 views 3 comments 0 points Most recent by Z-Man-Oracle Reporting & Analytics for Fusion Service -
Query to get supplier details along with bank details associated with that supplierSummary: Query to get supplier details along with bank details associated with that supplier Content (please ensure you mask any confidential information): Version (incl…Ritu123 2 views 1 comment 0 points Most recent by Sunil Jami-Oracle Supply Chain Planning and Collaboration
-
Issue with dependent parameters of report in fusion HCMHi Team, We have a requirement to create a report which would fetch the latest extract flow name w.r.t Legislative data group. Currently we have two parameters of LDG an…
-
Did oracle will allow to trigger bursting email to 60K candidates at once?Hi Team, We have requirement to trigger bursting email notifications to 60K candidates. Did our fusion application will allow to send notification to the 60K employees a…MaheshRayudu7 2 views 1 comment 0 points Most recent by MaheshRayudu7 Reporting and Analytics for HCM
-
Absence is wrongly calculating in OTBI reports when applied in advanced mode.Hi Folks, While submitting the absence in Advanced mode, the balance is calculating for whole week even if i apply for two days in a week. What might be the issue? Pleas…
-
How to Create a Data Set Using a Web Service in Oracle FusionHi Experts, I tried to create a data set in BI Publisher using a web service that returns valid XML data. I referred to this document: Creating a Data Set Using a Web Se…Krishan_Palihakkara 32 views 1 comment 0 points Most recent by Angel Jimenez-Support-Oracle Reporting & Analytics for Fusion Service
-
Is there a query that returns all valid grades ever associated with a position with eff datesWe found an issue on Positions where Valid Grades, previously deleted via HDL, are returning as a valid grade in the UI when any change is made on the Position itself. W…desirae_coleman 11 views 0 comments 0 points Started by desirae_coleman Reporting and Analytics for HCM
-
Multiple Delivery By options in Oracle BI ReportSummary: Hi All, I have developed Oracle BI report in fusion, facing an below issue - I have 4 data sets A,B,C,D and joined A-B and A-C-D, included KEY in all the datase…Avilash1265 2 views 1 comment 0 points Most recent by Raghavan p-Oracle BI Publisher Learning Center
-
Sql query or Table name for Offering and Functional area for Opt in features in Oracle fusionSummary: Hi Team, We are stuck to find the table or query for Functional area and Offerings. Navigation: My Enterprise → New feature or Offerings. We have the below tabl…Opkey PA 50 views 1 comment 0 points Most recent by Prasanth Senthivel-Oracle Reporting & Analytics for Fusion Service
-
Report data size exceeds the maximum limit (524288000 bytes). Stopped processing.Summary: I am building a custom report - Payable Trail abalance. But while running the report, I am getting Report data size exceeds the maximum limit (524288000 bytes).…Ritu123 111 views 3 comments 1 point Most recent by Erick.B Reporting & Analytics for Fusion Service
-
I want to restrict last line of any receipt line to be printed in EDI Etext template for the clientWe have 2 new BIP report enhancement requirement To restrict every receipt's last line to be restricted in the query, please see screenshot below for your reference the …Shahid Qureshi 12 views 2 comments 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Need a report which lists all reports with roles required to run thoseIs it possible create a report that lists all reports in fusion Financials and the security role that is required to run each of these reports. Business is asked constan…Vinay414 32 views 1 comment 0 points Most recent by Razvan Paduraru-Oracle Reporting and Analytics for ERP
-
Payroll Report Pulling Wrong Assignment Manager in BI ReportI'm working on updating a Payroll Last Row Validation Report. It is currently pulling the wrong assignment manager for the last effective dated change on their employmen…Nicole A. 22 views 6 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
Getting not a group by function for the query in BIP reportGetting : ORA-00979: not a GROUP BY expression for the query in BIP report. Below is my query I am getting this errow while adding any sub query(Payment Terms). In the g…
-
Data is not showing up in the RTF templateI am developing LMAR debtors ledger report. In the RTF template the closing balance data is not coming. Even if the header part is not coming. I am attaching the Report …
-
While I am using (AP_INVOICES_PKG.GET_POSTING_STATUS( aia.INVOICE_ID ), the query is processing onlyWhile I am using (AP_INVOICES_PKG.GET_POSTING_STATUS( aia.INVOICE_ID ), the query is processing only and at least I am getting timeout error. Here is my query. Can you p…
-
Custom BIP report for Accounts payable trial balanceI am developing a Custom BIP report for Accounts payable trial balance. Here the paramters are legal entity, as on date and business unit. When I am trying to put the as…Ritu123 9 views 1 comment 0 points Most recent by Bodhisattwa Mukherjee-Oracle Reporting & Analytics for Fusion Service
-
How to Configure Request Payload for POST Method in BIP DataModelHello Oracle Community, I am currently working on a project where I need to invoke a REST API from a BIP DataModel/Report. However, I'm facing an issue with configuring …
-
course usage reportHello, I would like to create a report to see course usage to potentially achieve trainings that have not been used for a while. Any suggestions on how to create this re…Sara.Zhao 12 views 1 comment 0 points Most recent by Abdul Rauf Mohammad-Oracle Reporting and Analytics for HCM
-
How to download .PDF attachment from Contract through BIP report in fusionDears, We have a requirement to download .pdf attachment from contract. How we can download the above attachment (24000065-1 (1)نسخة التوقيع.pdf) from BI report. Thanks,…
-
Foreign key Column & Foreign Table for GL_JE_ACTION_LOG table using HISTORY_IDWe are not able to find the join for GL_JE_ACTION_LOG using HISTORY_ID field. I can able to see in Oracle Docs that HISTORY_ID is the Unique Identifier assigned to user …
-
Export Material plan into Excel for all items to review supplies, demands and net inventoryHi there, We are looking for the ability to export the 'Material Plan' view in Fusion into Excel for all items. Issue we are hitting is the 'Material Plan' view does not…Tom Harris 39 views 2 comments 0 points Most recent by Sandeep Pati-Trinamix Supply Chain Planning and Collaboration
-
SQL query to get multiperiod accounting in Accounts PayableSummary: Hi Gurus, I am struggling to get the correct data for multiperiod accounts details to match the GL account (Deferred). Build a query from AP to SLA but getting …Birley Varghese 324 views 4 comments 0 points Most recent by Yahya Khan Reporting & Analytics for Fusion Service
-
Getting the data in un-structured formate in excel file while extracting the dataSummary: Hi Team, We are trying to export the data for IBY_SYS_PMT_PROFILES_VL in excel format and we are getting in un-structured formate. Means some rows data are not …
-
Drill down query for GL->XLA->AR(Receipt Category)Drill down query for GL->XLA->AR(Receipt Category). I have a custom report where I have to pick the details from GL_JE_Lines tables, and RA_CUSTOMER_TRX_ALL, AR_CASH_REC…