Reports
Discussion List
-
Hide column in a data modelSummary: Hi Team, We have requirement to generate an XML output with parent and child relationships for AR invoice data. We have created a parent dataset with customer_t… -
Need a query to get accounting period of a POWe are unable to find a way to get an accounting period for a purchase order. Could you help with a query? I need the PO# and the accounting period as a column. Also, le…Abhilash K - Deloitte USI 21 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
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 226 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 21 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 21 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 2 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 21 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 31 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 11 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 71 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 65 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 141 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Human Capital Management
-
VVattikuti 11 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 11 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 493 views 9 comments 2 points Most recent by rahul.gupta.scm Reporting and Analytics for ERP
-
Lakshmi Kanchi 57 views 2 comments 0 points Most recent by Lakshmi Kanchi 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 11 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 1 view 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.1K views 14 comments 15 points Most recent by Bea 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 451 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 11 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 632 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 13 views 1 comment 1 point Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP