Category 129
Discussion List
-
Replacing Project attribute with Organization name causes severe performance issueSummary: We enabled Project DFF and included the attribute as a filter as organization name in OTBI. The report runs normal if we filter for specific orgs but when submi… -
How to bursting a report with multiple data sets ?Hi all, I have a BIP report with multiple data sets to query different data to different excel sheets. I'd like to use bursting function on this report, but I found that…Weitao 650 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle Reporting and Analytics for ERP
-
How to create an OTBI Report to display GL Parent/Child values ?Summary: How to create an OTBI Report to display GL Parent/Child values ? Content (please ensure you mask any confidential information): Hello I would like to have a Cha…Cesar Saveedra 225 views 2 comments 0 points Most recent by Cesar Saveedra Reporting and Analytics for ERP
-
FRS Workspace Server Settings - Impact to changing timeout valuesSummary: On Oracle Fusion, Finacial reporting studio, workspace server settings, want to understand the impact of changing the timeout values for session timeout and Kee…
-
GL Segment Level security and OTBI Subject areasSummary: We have a requirement to secure data down to a legal entity/cost center level for dashboard built in OTBI with the GL Transactions real time subject area. How b…amy hardtke 31 views 2 comments 0 points Most recent by Madhavi Godbole Reporting and Analytics for ERP -
Can anyone help in sharing an idea for developing contra account report.Summary: For example, if in parameter, an account is selected, all relevant Debit and Credit which were generated against that account gets reported. Content (required):…Usman Ul Haq 23 views 1 comment 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP
-
Table/Query to find the BPM work flow notification pending with particular personSummary: We are looking for Workflow notifications (Especially Expense report) pending with one particular person for approval. Do we have any table which stores this de…Thanigainathan R 462 views 1 comment 1 point Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP
-
can we pull historical details of CANCELLED ESS jobs from back-end?Problem Description --------------------------------------------------- AUDIT CONCERN: can we pull historical details of CANCELLED ESS jobs from back-end? During an audi…Janardhan ACS-Oracle 35 views 1 comment 1 point Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP
-
How to link between General Ledger, Subledger and Receivables tables in BI PublisherSummary: I'm trying to add information from the Receivables tables to a General Ledger query on income when a transaction has come from the receivables ledger. But I am …
-
Payables Posted Invoice Register to show final approver doubles invoice line amountsSummary: I'm trying to modify the Payables Posted Invoice Register to show the final approver, but the output shows the invoice line multiple times. Content (required): …Niall McColl 32 views 3 comments 0 points Most recent by Niall McColl Reporting and Analytics for ERP -
query for rejected invoices and rejector commentSummary: We're looking for a query that will show rejected invoices and the reason they were rejected as well as the cost center and creator. Content (please ensure you … -
Oracle roles required for developing BI reportSummary: Need to know what Oracle roles are required for an user to develop BI report Content (please ensure you mask any confidential information): Version (include the…
-
Ago Function not working in OTBISummary: We trying to use AGO function for Previous Year Actuals Column in OTBI General Ledger - Balances Real Time. But report is showing null values in Previous Year A…FirozahamedSK 45 views 2 comments 0 points Most recent by FirozahamedSK Reporting and Analytics for ERP
-
Can we call OTBI/Analytics dashboard using SOAP/REST webservices in oracle fusion?Hi , We have a requirement to run/submit the analytics/OTBI dashboard using rest/soap webservices. Please share your inputs. Appreciate your help. Thanks in advance.Bhavani Rikkula 281 views 2 comments 0 points Most recent by Bhavani Rikkula Reporting and Analytics for ERP
-
How to print tables side by side in BI publisherHi, I was trying to develop a rtf template to print the Invoice copy. As part of the requirement, I need to print tables side by side. I was able to add the tables side …AVN 162 views 3 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP
-
REST API to run FRS reports in FusionSummary: Need to know REST API details if any to run FRS reports in Fusion Content (required): REST API to run FRS reports in Fusion Version (include the version you are…Sudha KOVURU 363 views 4 comments 0 points Most recent by Subbareddy Kandala Reporting and Analytics for ERP -
Taxable lines in journal entries not generating in the Deductible VAT Declaration Report for FranceHello, We are encountering an issue whereby taxable lines in journal entries are not being generated in the Deductible VAT Declaration Report for France. Taxable Purchas… -
How can we get GL accounting date for budgetary control ?Summary: Hi Team, We have requirement to build a report which will have accounting date for each line in budgetary control. How can we link budget and GL tables to fetch…Nidhi Chhajed 31 views 3 comments 0 points Most recent by Lakshmanji Karupalli Reporting and Analytics for ERP
-
PVO for GL Secondary Balancing Segment KFF?Summary: On a quest for chart of account segment descriptive labels (KFFs) for secondary balancing segment. Content (please ensure you mask any confidential information)…Josh Vincent 32 views 2 comments 0 points Most recent by Josh Vincent Reporting and Analytics for ERP -
FRS Batch Scheduler/Bundling does not have expand all capability when users click into HTML linkOracle Fusion General Ledger Cloud Service - Version 11.13.23.10.0 and later In Oracle Financial Reporting Studio, after creating a bundle and scheduling reports through…
-
Receivables OTBI report: Line level transaction report with payment informationSummary: I have created an OTBI report to show line level detail of AR transactions using the Receivables- Transactions Real Time subject area. I am looking for a second…Emily McAdams 168 views 3 comments 1 point Most recent by Nathan CCC Reporting and Analytics for ERP -
OTBI Incremental Date Parameter ValuesHi, We have a requirement to run the Payables Invoice Register OTBI report with incremental date parameters. We would like to schedule the Payables Invoice Register OTBI…
-
Is there any termination date set for the Audit report ( or can it be set)?Summary: I was wondering if the audit trail captured in the audit report remains infinitely in the system or does it gets purged/terminated. Content (please ensure you m…Shreshtha Kesarwani 21 views 1 comment 1 point Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP
-
Missing Access for a COA segment in a FRS report for a particular userSummary: Business user is missing access to Geography segment values (in parameter) in all the financial reports. Only able to see three values in the parameter. Content…Akash Verma 58 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany -
Sending Reports to a Google DriveSummary: One of our customers is looking to have certain reports from ERP delivered to a Google drive location. Has anyone tried this and if yes how was it done? Any inp…Govind Srinivasan-Oracle 144 views 2 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP
-
Does BICC support Extensible Flexfields (EFF) ? How do we extract information from EFFs ?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Oracle Business Intelligence Cloud Co…
-
Do we have report which gives user is present in which approval workflowsSummary: We are searching for report which we can run by user name and the report should gives us details in which workflow approval user is present. Eg: PO , Req, Invoi…Nidhi Chhajed 53 views 5 comments 0 points Most recent by Razvan Paduraru-Oracle Reporting and Analytics for ERP
-
Is it possible to extract a single audit report for all the audit enabled products and objects?Summary: Is it possible to extract a single audit report for all the audit-enabled products and objects using the audit policy capabilities of Oracle Fusion? Content (pl…Shreshtha Kesarwani 62 views 1 comment 1 point Most recent by Mihaela Cozma GL-Oracle Reporting and Analytics for ERP
-
Is there a way to hide a specific hierarchy from being available to users when they run FRS reports?Summary: Is there a way to hide a specific hierarchy from being available to users when they run FRS reports? Content (please ensure you mask any confidential informatio…
-
How does SQL Pruning in the data model affects the report performance?Hello, We have a customized version of the AP Aging report. The report performance is slow compared to the standard one. To improve the performance we did some adjustmen…Kristelle 41 views 1 comment 1 point Most recent by Razvan Paduraru-Oracle Reporting and Analytics for ERP