Reports
Discussion List
-
SQL script for job roles inherited by data rolesSummary: Trying to build a query to fetch users with their data roles and inherited job roles. I am able to fetch the data roles and job role assigned assigned directly …Vaishnavi Agrawal 72 views 3 comments 0 points Most recent by Ranveer.Tiwari-Oracle Reporting and Analytics for ERP -
Extract data store for Receivables Customer RecordsHello - we're working to build out reporting using a third party data warehouse tool. We've already connected Oracle with this tool and mapped almost all objects except … -
Required Tables that stores min-max values for Replenishment planningSummary: As part of report development, we required min-max values for Replenishment planning. Please provide the details of tables that has to be used to derive the val…User_WCAA0 13 views 2 comments 0 points Most recent by Thierry Lamote Supply Chain Planning and Collaboration
-
Construction Industry Scheme (CIS)Summary:Construction Industry Scheme (CIS) Under the Construction Industry Scheme (CIS), contractors deduct money from a subcontractor’s payments and pass it to HM Reven…Sofia Chen 53 views 1 comment 1 point Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
Does anyone have the Payables invoice register report as oracle SQL QUERY.I want to create a BI report that is the same as the payable invoice register (the one seeded in Schedule process ) , due to filtering option (i can't filter by invoice …Omran Zeaiter 33 views 1 comment 0 points Most recent by Shivam Chauhan-Oracle Payables, Payments & Cash Management
-
How to add multiple Digital Signature based on Legal Entity for Print Receivables Transactions job.Summary: There is a requirement to attach the Digital Signature to AR invoice dynamically based on Legal Entity (digital signature varies for each LE). For this requirem…
-
Hyperlinking PO Number, AP Invoice Number on BI Publisher reportsSummary Hyperlinking PO Number, AP Invoice Number on BI Publisher reportsContent We have a BI Publisher report where we are showing Project profitability and showing all…User_2025-01-28-19-49-26-512 416 views 19 comments 2 points Most recent by alexey.shtrakhov Reporting and Analytics for ERP -
Oracle OTBI Report View does not run for wider searchThe only table/view I have been able to identify, that provides OTBI report usage statistics is the BIPUBLISHER_V view as provided by Oracle. This view consistently eith…Marko Puskac 21 views 2 comments 0 points Most recent by Marko Puskac Reporting and Analytics for ERP
-
Create Customer StatementHi All, while calling Create Customer Statements ESS job same We Have requirement to pass 'cycle' and 'generate bill parameters' into Statement Generation Data Model. /s…Veeragopathi 2 views 1 comment 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections
-
Cannot access name on errored out EssBIPJobSummary: 24C version The errored out process name is not displayed, when i check from Report job history page, not able to check the details of this ess bipjob, can anyo…Shahid Qureshi 31 views 2 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
ORA-06512: at "SYS.XMLTYPE", line 169Summary: Hi, i have created the AR Invoice Auto Mail by taken the reference of "Print receivable transactions", if i schedule the report the report should send the invoi…Siva BVP-Oracle 89 views 1 comment 1 point Most recent by Daniel S.-Oracle Receivables & Collections
-
While the ESS job names are visible in the ui, they are only partially displayed in the BIP ReportSummary: While the ESS job names are visible in the user interface, they are only partially displayed in the BIP Report, with approximately 50% of the job name informati…
-
Is there any REST API to get the information of Key Flexfield Segments?Summary: Hi Team, Is there any API to get the information of Key Flexfield Segments under "Manage Key Flexfield Structures". We need the fields in below attached screens…Opkey PA 11 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
OTBI Data Discrepancy for "Performed Action" Approve in Procurement - Requisitions Real TimeSummary: Hi Community, I'm encountering an issue in OTBI (Oracle Transactional Business Intelligence) when retrieving data from the Subject Area: Procurement - Requisiti…
-
How to minimize the input parameters for the multiple Grid in a single FRS ReportSummary: Hello Exports, I have Created the complicated Income statement (IS) in (FRS) and the same/single report having 4 different Grid (Child) with in a report. While …Steeph 11 views 1 comment 0 points Most recent by veerendranath pulivarthi-Oracle General Ledger & Intercompany
-
Connect Two Subject Areas Without Common Attribute or Dimension in OTBI (Answers Report)Hello experts, I need assistance with connecting data from two different subject areas for a report in OTBI: Receivables - Transactions Real Time Subscription Management…Valerij Astafev 24 views 1 comment 0 points Most recent by Skolli-Oracle Reporting and Analytics for ERP
-
Need SQL Query for Project Custom ReportSummary: Hi Please help us to answer the table and the column for this project budget information (all project not specific project): Version Status Project Number Task …Awal 44 views 1 comment 0 points Most recent by Andreea Versanu-Oracle Reporting and Analytics for ERP
-
What is the Retention policy for BIP Jobs run in Fusion ERP Cloud?Summary: What is the Retention policy for BIP Jobs run in Fusion ERP Cloud? Do we have more information on maximum value/minimum value for retention? Also Is there a cos…Abhilash K - Deloitte USI 11 views 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
Pivot Table in OTBI Not Displaying Response Value DataSummary: Where I need to transform data from a vertical format to a horizontal format using a pivot table. My original data looks like this: Buyer Name Question Name Sup…Warunyu.N34 22 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Is there a way to sort date type columns by default?Summary: Is there a way to sort date type columns by default? We want to sort this column with the DD/MM/YY format but by default we can only sort it by MM/DD/YY, if we …Manuel Riobóo Córdoba 23 views 1 comment 2 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Keyboard Accessibility Tab Order in Oracle Analytics Cloud Fusion Data IntelligenceIs it possible to set a tab order for a Keyboard Accessibility requirement in Oracle Analytics Cloud part of Fusion Data Intelligence? It currently take 30 tabs to get t…Yagnesh_Analytics 1 view 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Enter prompt variable in SOAP executeXMLQuery requestSummary: We have a report on which i have added a prompt variable to filter based on the email address. This works in the report itself: But when i try to get the report…Nick H 11 views 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
How to create and submit BIP reports by batch (request set)Summary: How to create and submit BIP reports by batch (request set) Content (please ensure you mask any confidential information): There is a client requirement to run …Babasaheb Bhujbal 21 views 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Need to generate and include a sequence number in custom BI publisher eText template for non paymentSummary: Need to generate and include a sequence number in custom BI publisher eText template for non payment Content (please ensure you mask any confidential informatio…Ishtiaque AHmed 1 view 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
unsupported report object's type - [catalog]Currently we are using the following webservice to upload a report into BI Publisher https://fa-exsj-test-saasfaprod1.fa.ocs.oraclecloud.com/xmlpserver/services/External…Sankhya 21 views 1 comment 2 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
How to create deep link for Items in Product Information Management module?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…S Javir 3 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Applying filter to report attribute but keep the rank as unfiltered.I am creating "Rank" function on a calculated measure. It works fine. But when I filter on a column value the rank changes. Is there a way I can apply filter on an attri…Raghu_Nandan 12 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Function in FRS Webstudio report to go back on GL Average Daliy Balance Cube on an exact dateOur client wants to run Daily P&L built on GL Average Balance Cube using FRS and compare current date PATD balance to same day PATD balance for last month. This is also …
-
Specific user cant extract data from xla_transaction_entities .Need to Know role for this XLA tableSummary: Specific user can't extract data from xla_transaction_entities .Need to Know role for this XLA table We have made one report where we are using this table but a…