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
-
Joining between database SQL and Excel Data Sources in the Data ModelContent Hi, I hope someone can help me out here. We have created a report where we have defined a data model with a join between an SQL data set and an Excel (xlsx) data… -
OTBI Report for AP Invoice HoldsSummary Sample OTBI Report for ERP Cloud: AP Invoices on HoldContent This is an update on Andy Gough's Topic using the new subject area. I have also enhanced Andy's repo… -
Etext negative number paddingSummary Etext negative number paddingContent Hi All. We have a requirement to dispay a number like -123 as -00012300. Please suggest how this is possible in Etext templa…
-
Bursting A Report With SubTemplatesSummary How to burst a report using a sub template.Content Hi Experts, We have a custom report which uses a sub-template. The report also uses bursting to email. But the… -
saas fusion data retention polity - access to transactional dataSummary what is the period users are able to access transactional data (10 yrs?)Content For Fusion financials, users would like to be able to access transactional data f…
-
what is the difference between YTD AND QTD ?Content what is the difference between YTD AND QTD ? Special in first period.
-
COA Segment Values based on Security RulesSummary COA Segment Values based on Security RulesContent We have a requirement to get the Individual COA Segment Values based on the security rules defined for the Role… -
Safest/default Path to Publishing changes to GL (Essbase) Trees: Publish Chart of Account DimensionSummary We have been experiencing issues in making changes to GL tree structures in OTBI, so I wanted to be clear on what the options are for each step, to eliminate the…
-
Project Actual Costs - Account CodeSummary Project Actual Costs - Account CodeContent We are creating a report using the Project Costing - Actual Costs Real Time subject area. We are pulling cost distribu…
-
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 205 views 1 comment 2 points Most recent by User_2025-02-11-01-36-32-048 -
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…
-
What are the Correct Parameters for OTBI Fusion GL for ESS "Import Oracle Fusion Data Extensions forSummary This ESS request is the very last process in updating KFF OTBI Trees (so we can use OTBI "GL - Balances Real Time"). "All" or (just) "ERP" doesn't work, but "ERP…
-
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… -
in ar i need to get sum lines , sum discount ,sum taxes for each invoice and for each lineContent in ar i need to get sum lines , sum discount ,sum taxes for each invoice and for each line.
-
Help with OTBI Filter ErrorSummary Error when filtering for a date rangeContent Hello, I am having 2 issues. 1. I am trying to create a filter using Invoice Date where report would show all invoic…
-
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…
-
Unsuccessful Login Audit Report & Sign-on Responsibilities Audit ReportSummary Oracle Fusion does have a seeded report/ Bi-report for audit purposes.Content Hi All, We would like to know if there is a fusion seeded report that can give belo…
-
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 ?
-
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…
-
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… -
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…
-
End date or disable a primary ledger in FusionSummary End date or disable a primary ledger in FusionContent Hi Team, There is a requirement from client to remove the not required ledgers from the system. Is there a …
-
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
-
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… -
-
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 101 views 0 comments 2 points Most recent by User_2025-02-10-16-28-01-402
-
Config Snapshot - AHCS and Core Fusion SetupsSummary Documentation for Config Snapshot in Oracle CloudContent Hello Team, Please provide a detailed document for Config Snapshot in Oracle Cloud. Also does it cater f…
-
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…
-
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 …