To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting and Analytics for ERP
Discussion List
-
Is there a way for the values in the page prompt to be displayed as the tab name on excel when its dSummary Need to have the tab label name in Excel output with the value on the prompt for FRS ReportContent Is there a way for the values in the page prompt to be display… -
Terminate an employee for NON-HCM Customers to redirect approvals in Fusion FinancialsSummary Terminate an employee for NON-HCM Customers to redirect approvals in Fusion FinancialsContent We have implemented Fusion Financials and we don't want HCM Cloud S…
-
ERP - Testing Automation ToolsContent We would like to know of any success stories of companies who have automated their testing in Oracle ERP (Financials or Procurement). I've been looking around, a… -
GL Query - Combine Subject Areas in OTBISummary Which subject areas should I combine in OTBI to build a report that provides these parameters?Content Which subject areas should I combine in OTBI to build a rep…
-
Reporting with Hierarchies in OTBISummary Fusion OTBI - Hierarchies are not showing in all General Ledger subject areasContent Background/Requirement: My client wants an OTBI analysis which includes vari… -
Projected Cash Balances with Selected Installment Report KitContent The Projected Cash Balances with Selected Installments sample report provides Public Sector Entities visibility into their Projected Cash Balances once a Payment… -
OTBI Formula HelpSummary Formula help for custom columnsContent Hello, I want to add a couple of custom columns to my OTBI analysis which have formulas in them and I was wondering if som… -
Infolet Dashboard to be Printed as a Page for Management ReportingSummary Infolet Dashboard to be Printed as a Page for Management ReportingContent We have built Risk Management Infolet section and Client wants to download this as a re… -
Financial Reporting Studio Desktop - DecommissionSummary Transition from Desktop to Web toolContent Hi, We are using Financial Reporting Studio Desktop tool since 5 years ago for development of ERP Financial Reports, a… -
Extract Cost Center from "Code Combination Description" field - (Procurement - Spend Real Time) subjSummary Extract Cost Center from "Code Combination Descpription" fieldContent I am using "Code Combination Description" field as one of my select columns from (Procureme…
-
Best practice for Developing Custom BIP reports and securing them in ERPSummary Looking for best practices for custom BIP reports for ERP which can be secured by Role and Data Access Sets similar to UIContent Hi, Our client has complex enter… -
Tables to query files imported to ERPSummary We want to create a report that list the files imported to the ERP from external systems for reconciliation purposes.Content Hello evryone, Anyone can hep me to …
-
Transaction Query exampleSummary example of a GL Transaction query flexible to a range of parametersContent Seeking an Oracle Cloud example of a GL transaction query that returns line item detai…
-
Page Break in ReportsContent Hi, In he invoice report which is run for range of invoice I am able to print each invoice in new page . For example if the invoice number 100 has two lines the … -
OTBI Report that shows the element details field "Description"Summary OTBI Report that shows the element details field "Description"Content I am trying to build a report where I can pull in the field 'Description' on an element. Fo…
-
Segment Value Security for Chart of Accounts in Custom BI Publisher reportSummary Enable Segment Value Security for Chart of Accounts in Custom BI Publisher report in bulk modeContent We have a requirement to enable Segment Values Security for…
-
Project Invoice DistributionSummary Project Invoice DistributionContent Hello All, I want to know from which table we can get below information:- -
General Ledger - Balances Real Time Subject Area: not returning Beginning and Ending BalanceSummary General Ledger - Balances Real Time Subject Area: not returning Beginning and Ending BalanceContent I am trying to create an analysis based on General Ledger - B… -
1099 Data ReportContent Are you reporting 1099 data based on accounting date or payment date?
-
Logiacl sql for cross subject area analysisSummary Logiacl sql for cross subject area analysisContent Hello All, I am trying to create a cross subject area logical sql for receivables as below. However I still ge…
-
Updating non-logical OTBI to Logical SQL OTBI without rebuilding?Summary Updating non-logical OTBI to Logical SQL OTBI without rebuilding the original OTBI?Content I need to update an existing OTBI (non-Logical SQL) to use Logical SQL…
-
OTBI usage tracking in 21ASummary OTBI usage tracking in 21AContent In this new subject area below, will that only track usage within the CRM subject areas or will that track report usage in the … -
SOAP request for BI Publisher report works for Test pod but not for Production podSummary SOAP request for BI Publisher report works for Test pod but not for Production podContent I am running BIP report by using SOAP request. the problem is that it w… -
A company wants to sell part of its businessSummary Typical Organization planning for De-MergerContent There is a Company A, who is on oracle Cloud and now it wants to split the business into two parts i.e. Compan…
-
Need number of asset transfers and modifications in 2020Content Hi, I need to find the total number of asset transfers and modifications made in 2020. Is there a BIP query that can return this information please? regards Nige… -
Depreciation reserve of assetContent We're building a Fixed Asset Balances report out of Subject area Fixed Asset Balances - Real Time'. But we are not able to get the balances for Accumulated Depre…
-
Power BI and OBIEESummary How to create a connection between Oracle Cloud (FIN and/or SCM)?Content Hello, we would like to start using Microsoft Power BI for BI Reporting, instead of OTBI…
-
ESS Schedule Process Job Name not availableSummary ESS Schedule Process Job/Program Name not able find any tableContent Hi All, We need to build a BIP Report for audit purpose with all ESS job details but unfortu… -
BIP Deeplink in report to view Purchase OrderContent Has anyone added a deeplink in a BIP report to view a PO? Please could you share.
-
Direct vs In-direct suppliersContent All - How to identify in Oracle Procurement cloud the direct vs in-direct suppliers? Also is there a field in OTBI that can tell direct vs Direct suppliers? I se…