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
-
How can i get two different BU BalancesContent Dear , I have one ledger but two Business units. For that i need balances for both Business units. So create a query from gl_balances table but issue is its show… -
LicensingSummary Oracle Database Cloud Multitenant Service - S5 & Oracle Java Cloud Service - SaaS Extension - S1Content Does anyone know what these 2 products are for? Oracle Da… -
OCI – ERP Analytics: Getting Started With Oracle Fusion ERP Analytics, 30 March 2021, 9 a.m PT - SubContent Submit your questions for the OCI – ERP Analytics: Getting Started With Oracle Fusion ERP Analytics session to have them answered during the live event. Post you… -
Export Query to Excel Timing OutSummary Exports Timing OutContent We are using firefox for our browser, the export works (from AR, AP or GL) for awhile and then we get a message - a connection to the s…
-
BICC - Selecting Columns from Data Stores Impacts other reportsSummary How to configure BICC reportsContent We are currently working on our migration to Oracle Fusion. I am tasked with looking at extracting data via BICC. How can I …User_2025-02-11-01-36-32-048 153 views 1 comment 2 points Most recent by User_2025-02-11-01-36-32-048 -
Subject Area for Supplier CountrySummary I want to be able to bring the suppliers country into a report but can't find the right subject areaContent Hello, I have created an analysis in OTBI and I want …User_2025-02-04-19-45-49-438 21 views 2 comments 1 point Most recent by User_2025-02-04-19-45-49-438
-
in gl how i get balance for each account(ptd,qtd and ytd)Content i need to get balance for each account (ptd,qtd and ytd). also i need to get balance for each account and cost center (ptd,qtd and ytd).
-
Number of Accounting Periods in Accounts Receivable for OTBI ReportingContent We have a thirteen period calendar setup in Oracle, each period is four weeks. When we attempt to write OTBI reports we are only seeing 12 periods. My question i…
-
how i get gl date in ar moduleContent i created a new report in ar ar module, i use table RA_CUSTOMER_TRX_ALL but i can't find gl date for invoice, how i get gl date ?
-
BI Report Bursting queryContent Hi All, We have requirement that notification should be sent to team member when they are added to project. Since we dont have this feature in oracle we were thi…
-
Can a customer be setup on Fusion Cloud to be used in both AR and AP (Trading Community ArchitectureSummary Need to be able to issue rebates to customersContent We have to issue rebates to customers on a quarterly basis. It doesn't make sense for us to create credit me…
-
OTBI data modelSummary Is there a place where we can understand the data model (tables) for OTBI reports?Content Is there a place where we can understand the data model (Tables) for OT… -
HOW TO: Embedding Contextual Dashboard — Page Binding ParametersSummary Documentation to embed a dashboard as a webpage in ERP pages with contextual prompts using binding parametersContent We've been live with Oracle Cloud Financials… -
What table does Configuration Owner field come from?Summary Receivable module - What table does Configuration Owner field come from?
-
Oracle Docs Links not working error: From RFC 2068 Hypertext Transfer Protocol -- HTTP/1.1:Summary When trying to access oracle docs links on Help Centre the links to the docs produce an error and cannot directly accessContent We have just recently identified … -
How to Drill down from Parent to child report in OTBI?Content Hello, For GL module, We need to drill down from summary to detail in OTBI subject areas. In summary report we have header_id, When we click header_id in summary…
-
OTBI report to fetch Absence types and related absence plans with approval status, used balance, carSummary OTBI report to fetch Absence types and related absence plans with approval status, used balance, carryover, accruals.Content Hi All, We have an OTBI requirement …User_2025-02-10-16-28-01-402 90 views 0 comments 1 point Most recent by User_2025-02-10-16-28-01-402
-
Need query to get Punchout item detailsSummary Need query to get Punchout item detailsContent Hi Experts, We have a requirement to get punchout item details in existing PO PDF report, Can you please provide m…
-
FRS Reports - Suppression of Formula RowSummary In FRS Report tool, if I insert a Formula Row (multiple), is there a way to suppress this row if it is 0.00?Content I recently created an FRS report using the FR…
-
Code migration tool -Automation of BIP report MigrationSummary Any code migration tool which can migrate BIP report from one instance to other automatically without manual intervention
-
Account Analysis Report too large to downloadSummary Account Analysis Report too large to downloadContent Delivered Account Analysis Report was timing out. We extended timeout period, but now are unable to download…
-
downloadESSJobExecutionDetails returns NULL when the ESS Job Output Size is more than 2GBSummary downloadESSJobExecutionDetails returns NULL when the ESS Job Output Size is more than 2GBContent Hi, We have an Integration built to send Oracle POET(Project,Org…
-
Unable to preview BI Publisher output in RTF:Summary Unable to preview BI Publisher output in RTF:Content Hi Guru, I am facing one strange issue in BIP Desktop , i am able to load and design the RTF but when i am t…
-
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…