Reports
Discussion List
-
Lead times reportsSummary: The client is asking me for two reports, and I can't find anything standard. Could you confirm for me? The reports are: Standard report that evaluates the agree…Santiago Fazio 11 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Termination count is not showing correctly in OTBI reportSummary: Termination count is not showing correctly in OTBI report Content (please ensure you mask any confidential information): Hi All, We are developing a HR dashboar…Venkatesan 11 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
Is there a definitive date that Financial Reporting Web Studio will be discontinued?We were informed that Financial Reporting Web Studio will be shutting down at some point in 2024. Is that accurate? Is there a date set for discontinuing FRS?Steven Woods 191 views 2 comments 0 points Most recent by Steven Woods Reporting and Analytics for ERP
-
Help in connecting the table FND_FLEX_VALUES_VL with one of the HR tables in HCM.Summary: Greetings, i need some help in connecting the table FND_FLEX_VALUES_VL with one of the HR tables in HCM. Content (please ensure you mask any confidential inform…
-
How to Link Purchase Order Invoices back to Project Costs?Content Hi All We're working on a Project Statement report that brings back a comprehensive breakdown of the project costs and revenue. For the costs, we were able to br… -
How to query the latest pdf contract from purchase agreements after a change orderSummary: Content (please ensure you mask any confidential information): Hi Everyone, I currently have a query where I am selecting the Contract Number, Description, Star…Steph96 14 views 1 comment 1 point Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM -
Query or report to show B2B Communication details for each supplier siteSummary Query or report to show B2B Communication details for each supplier siteContent Is there a query/analysis/report/data model, etc. available in OTBI to show which…Jennie Wortman 233 views 3 comments 3 points Most recent by Ruthvik Ramesh-IH Reporting and Analytics for ERP
-
Missing PJF Tables/Views (i.e PJF_TASKS_V) In BICC PVO Data Lineage RepositorySummary: Hi Team, We need to extract data from Oracle and send it to our downstream systems. We're using BICC for this data extraction process. Our current challenge is …
-
How to get size of file running in ESS jobSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Unusual behavior of OTBI report -Not displaying 'invoice amount' and 'discountable amount'Hi Team, We have OTBI report which displays invoice discount information. After 24A we are observing it is not displaying 'invoice amount' and 'discountable amount' for …Kalpesh Salunke-Oracle 21 views 6 comments 0 points Most recent by Kalpesh Salunke-Oracle Reporting and Analytics for ERP
-
How to link Account Receivables (AR) module with Costing to get item cost for an invoice lineSummary: Hello Which table should I use/link with 'RA_CUSTOMER_TRX_LINES_ALL' to get the cost price of an invoice line in AR? Content (please ensure you mask any confide…Varun Dhondea 98 views 3 comments 0 points Most recent by Syed_Ibrahim Reporting and Analytics for ERP -
Regarding connectivity between BI Reports and OIC (PaaS)Hi team, Currently we are having few BI reports which call OIC services as data sources. All these connections are secured via basic auth. Since we are currently using O…
-
what is the link between main negotion number with negotion number whic has multiple rounds 2 or 3oracle fusion 11.13.23.10.0 for e.g in my system i have negotition number with this RFX-CSC-230022 this is main one RFX-CSC-230022-2 this is 2nd round RFX-CSC-230022-3 t…Abdur Rehman 22 views 2 comments 0 points Most recent by Abdur Rehman Reporting and Analytics for SCM -
Pre-defined variable to get instance URL for analytics server similar to CURRENT_SERVER_URLHi, We need to include links to drill-down BIP reports in the output of a master report using an RTF template. When creating these links, the instance hostname should be…Ankit_Bhadja 32 views 3 comments 0 points Most recent by Dhilip Kumar P. Reporting and Analytics for ERP -
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 101 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 218 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 1 view 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 32 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 62 views 7 comments 0 points Most recent by joelroshan92 Reporting and Analytics for ERP