Reports
Discussion List
-
How to create AOR based transaction console BI report in oracle fusion hcmHow we can create AOR based transaction console BI report in oracle fusion hcmAnup Karmankar 106 views 1 comment 0 points Most recent by BogdanFarcasanu-Oracle Reporting and Analytics for HCM -
Scheduled Processes Names in Fusion TablesSummary need to find the scheduled process names in the fusion tablesContent Hello guys, I need to build a BI Publisher report related to the scheduled processes in Orac…User_2025-02-04-08-34-10-102 235 views 4 comments 0 points Most recent by User_L2IXR Reporting and Analytics for ERP -
Numbers Format Issue Standard Purchase Order ReportDear All, The format of numbers in the purchase order BI standard report are not displayed correctly, because the NLS_NUMERIC_CHARACTERS setting is not configured at the…George Mattar 23 views 3 comments 0 points Most recent by Dhilip Kumar P. Reporting and Analytics for ERP
-
How can we determine if the BIP report has reached/hit a certain number of billion logical I/O?Summary: We received a notification from Oracle that the one of our report is running for more than 5 hours or exceeding 4 billion Logical I/O. Hence, the report needs t…Sonam Anekar 27 views 1 comment 1 point Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP
-
Generate an audit report for the role modification.Summary: Hi Team, We are seeking clarity on the individuals responsible for creating roles within our system. Upon investigation, we came across Document ID 2175861.1. H…joelroshan92 25 views 1 comment 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP
-
Missing Data in Custom Report for Scheduled ProcessesSummary: We have created a custom report to meet the requirement of viewing all scheduled processes created by all users. In this report, we aim to display columns such …Srikanth Dodla 28 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
How to add background color BIP excel template row wise in HCMHi Folks, May I know how to set the row background colour in the Excel template? Thanks Prakash JayavelPrakash Jayavel 38 views 1 comment 1 point Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
In Payment Approval Notification, Can we add one more pdf attachment?Summary: We want Output of Payables Selected Installments Selection Report along with Disbursement Payment Process Request Status Report in the Payment Approval Notifica…Deepa Kumari 21 views 2 comments 1 point Most recent by Mohammed Qurram Reporting and Analytics for ERP
-
Depreciation Projection Report in Oracle Fusion CloudSummary Depreciation Projection Report in Oracle Fusion Cloud in Fixed AssetsContent Hi Friends, In Oracle Fusion, is there any report to project depreciation, similar t… -
display column based on promptSummary: I want to add a prompt (Yes/No) to display a column. I'd settle for a prompt that forks to two different results tables as well. Content (please ensure you mask… -
How to run US 1099 Electronic Media Report for a specific vendorHi All, We need to submit an electronic file for one vendor we missed. Is there an option to run the US 1099 Electronic Media Report for a specific vendor. There seems t…Lakshmi Kanchi 13 views 2 comments 0 points Most recent by Lakshmi Kanchi Reporting and Analytics for ERP
-
Data Model Default parameter to current periodOn a Data Model for a report I have a parameter for the period that I would like to default to the current period. The parameter is a Data Type of Date and a Parameter T…
-
How to create ESS job to invoke multiple BIP Reports in oracle fusionHi All, We have a requirement to burst multiple-report output through the ESS job and this job will be invoked from OIC. Can you please help how we can achieve it. Thank…Arunkumar Ponnusamy 78 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
How to get the status of ESS Jobs From UISummary: We need to get the details of ESS Job from UI ,we need Current state , count, time ...) Content (please ensure you mask any confidential information): Version (…joelroshan92 63 views 7 comments 0 points Most recent by joelroshan92 Reporting and Analytics for ERP
-
Oracle HCM BIP Report - Employee Hierarchy queryI have a BIP requirement to display the employee details in the report where I need to show the employee details like tree structure. Eg: Manager A has 2 reportees calle…KishoreHari 150 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Human Capital Management
-
VVattikuti 16 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
How to connect to GL Cubes as data source for MDX queriesSummary: Hello, I am trying to run a MDX query in Fusion ERP. But there are no data sources available. How can I create a data source to connect to the GL Cubes within E…rizk7 13 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
Data Security in Custom BI Reports in Oracle Fusion Financials CloudSummary Data Security in Custom BI Reports in Oracle Fusion FinancialsContent Hi, We have lot of Custom BI Reports developed across financials Module ( AP , AR, FA , GL …Udit_Manchanda 508 views 9 comments 2 points Most recent by rahul.gupta.scm Reporting and Analytics for ERP
-
Need to control the access for users from copying/moving BI folders.Summary: Users with BI Author role are able to Move (Drag and drop) the BI folders to a different location. This is causing issues since the report/folder is not found i…Shashikanth Kumar P-Oracle 12 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle BI Publisher Learning Center
-
How to populate Period dynamically as 'Feb-2024' from sysdate while scheduling BIP reportSummary: How to populate Period dynamically as 'Feb-2024' from sysdate while scheduling BIP report Content (please ensure you mask any confidential information): Version…ManishKr 3 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle BI Publisher Learning Center
-
R12 ERP OTBI subject areas to database tables mapping spreadsheetsSummary R12 Financial and Supply Chain Management OTBI subject areas to database tables mapping spreadsheetsContent These spreadsheets are published by Oracle OTBI Devel…User720640-Oracle 2.2K views 14 comments 15 points Most recent by User_2025-10-31-00-30-05-350 Reporting and Analytics for ERP -
Print Receivable Transactions Report Custom templateSummary: Print Receivable Transactions Report Custom template Content (please ensure you mask any confidential information): Hi All, We customized the Print Receivable T…
-
Currency Conversion in OTBI report from Procurement - Procure to Pay Real time subject areaSummary: We have a custom OTBI report created from Procurement - Procure to Pay Real time subject area. The report currently shows all open POs in different currencies. … -
How to add sequence number & date in BI excel templateHi, I have developed a Data model and attached an Excel template in BI. I am able to generate the data as expected. However; we have a requirement to add a sequence numb…Madhu A 482 views 2 comments 1 point Most recent by Manoj venishetti Reporting and Analytics for ERP
-
Recommendations to generate a delimited output over 5GB in FusionAre there any recommendations to generate a delimited output over 5GB without timeout and going into error using a report in Oracle fusion. Currently we are generating e…Abhilash K - Deloitte USI 12 views 1 comment 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for ERP -
Query to fetch accounting period on project cost page in fusionSummary: Query to fetch accounting period on project cost page in fusion Content (please ensure you mask any confidential information): Hi Team, I am looking for query /…Nidhi Chhajed 679 views 4 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Date format issue in RTF formatSummary: We're trying to pass the date period filter criteria to the RTF template as MMM-YYYY, but it keeps coming our as a five digit number. Documentation reflects tha…Jason Parker 16 views 1 comment 1 point Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
Client requesting data to be not split into multiple sheets in excel or rtf templateSummary: Our client is requesting that the output does not be split into different sheets if the count of records are more than 65K in Excel and 1M in RTF while generati…Abhilash K - Deloitte USI 4 views 0 comments 0 points Started by Abhilash K - Deloitte USI BI Publisher Learning Center
-
Is there an excel template based report delivered by Oracle in FusionHas Oracle created any report with excel template inside Fusion Applications?Abhilash K - Deloitte USI 2 views 0 comments 0 points Started by Abhilash K - Deloitte USI BI Publisher Learning Center
-
Unable to see the Goal Plan Approval status in the Employee Goal Plan OTBI ReportUnable to see the Goal Plan Approval status in the Employee Goal Plan OTBI Report. Only the 'Approved' status is displayed under the 'Approval' Status Column. The Subjec…Chaitanya Sai 46 views 1 comment 1 point Most recent by Jacqueline GRANDIN Reporting and Analytics for ERP