Popular Tags
- OTBI 1,494
- Reporting 1,411
- FDI 1,269
- Fusion AI Data Platform 1,048
- Analysis and Data Visualization 1,011
- BI Publisher 890
- Analysis 696
- Oracle Fusion Analytics 626
- OAC 567
- Administration 559
- OBIEE 444
- Fusion HCM Analytics 440
- Analytics 438
- Fusion ERP Analytics 436
- BI Publisher Data Models 367
- Security 311
- HCM 292
- Oracle Analytics Cloud 279
- BIP 272
- Answers 266
- Analyses 256
- Fusion Data Intelligence 249
- Developers 248
- Data Modelling and Datasets 237
- ERP Analytics Content 220
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Financials
Discussion List
-
2Location effective date in Assets Analysis subject areaWe need the ability to answer the question "where was the location of an asset(s)" based on a specific date. Our assets may move from state-to-state on a frequent basis.…Phil Leu 41 views 1 comment 2 points Most recent by Krishna Prasad Kotti-Oracle Oracle Fusion Data Intelligence Idea Lab -
4Add Fiscal Date field to Financials - Balance SheetWhen creating a dataset link from Financials - GL Balance Sheet to the Configurable Account Analysis we get incorrect data when observing ending balances without revalua…Juan Hurtado 41 views 3 comments 4 points Most recent by Mallikarjuna Kuppauru-Oracle Oracle Fusion Data Intelligence Idea Lab -
Lookup line creation countI have created a lookup in manage common lookup. in the lookup i am adding basic details like first name in meaning and last name in description and Tag is having some r…charanjeet 11 views 1 comment 0 points Most recent by Mallikarjuna Kuppauru-Oracle Oracle Fusion Data Intelligence Forum
-
Aquery for manual reconciliationi need a query for manual reconciliation for payables and receivables and external and journal
-
Required SQL to fetch the Unpaid Invoice amount with respect to Installment wiseWe need to display the gross unpaid installment amounts of the invoice totaling 1500, which consists of three installments due on May 15, 2024 (900), May 30, 2024 (300),…User_5ZFCV 165 views 3 comments 0 points Most recent by Sumanth V -Oracle Oracle Transactional Business Intelligence Forum
-
Fusion Reporting Catalog Object Change TrackingWe are implementing Fusion (Financial and Procurement ) , and have built reports in OTBI and Fusion BIP .Is there any way to track changes (like last saved date) in the …User_N1V7T 113 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Oracle Transactional Business Intelligence Forum
-
2Add GL Segment and PO Line Description to the Subject Area Procurement - Receipt AccountingAs a Financial and Procurement analyst I will be able to report and analyze on the the Receipt Accounting transactions (incl. PO Line description) at several levels of t…Roelof de Groot 31 views 0 comments 2 points Most recent by Roelof de Groot Oracle Fusion Data Intelligence Idea Lab -
2Add GL Segments to the Subject Area SCM - Cost AccountingAs a Financial and SCM analyst I will be able to report and analyze on the value of the inflow and outflow transactions of Inventory at several levels of the Item Hierar…Roelof de Groot 31 views 0 comments 2 points Most recent by Roelof de Groot Oracle Fusion Data Intelligence Idea Lab
-
How long does ERP data gets committed to Oracle databaseHi, This question is raised due to a production issue we had when extracting reports from the ff table: AP_HOLDS_ALL PO_DISTRIBUTIONS_ALL These are 2 out of 34 tables th…mikaromo 13 views 1 comment 0 points Most recent by Rajesh L-Oracle Oracle Business Intelligence Applications Forum
-
Michael_B 31 views 2 comments 0 points Most recent by John Hung-Oracle Oracle Transactional Business Intelligence Forum
-
Justification fields when Receipt Missing is tickedI can't find these two fields in the Expenses tables. I tried the exm_expenses and exm_expense_reports. Can someone please help me find the column names and the table na…Varun Dhondea 31 views 1 comment 0 points Most recent by Subha_Tripathy-Oracle Oracle Fusion Data Intelligence Forum -
Can someone help me with the query to get the Product Fiscal Classification code?I need to get the Product Fiscal Classification for a Fiscal Document Capture. I can get the PRODUCT_FISCAL_CLASSIF_ID from cmf_fiscal_doc_lines_vl, but unable to figure…User_1ZWDZ 122 views 1 comment 0 points Most recent by Mallikarjuna Kuppauru-Oracle Oracle Analytics Publisher Forum
-
How to change the Database connection in the existing FRS reportHi Team, While migrating the report to test to Dev1 we are facing problem. Note: We created a report in the Test instance using the GG Database connection. Now the probl…Boobalan_A 347 views 2 comments 0 points Most recent by Renuka Nuguru-Oracle Oracle Fusion Data Intelligence Forum
-
Conversion rate and Conversion date not populating - Budgetary Control - Transactions Real TimeI am trying to create a analysis using 'Budgetary Control - Transactions Real Time' subject area. Where I suppose to display transaction conversion rate and conversion d…Thanigainathan R 22 views 0 comments 0 points Most recent by Thanigainathan R Oracle Transactional Business Intelligence Forum
-
Accounted VAT queryHi, I have a data model which works for the majority of Accounts Payable Invoices in Fusion Financials, but I have isolated tax lines which do not appear. Taking my more…Robert of STAU 341 views 1 comment 0 points Most recent by Sinduja Sekar-Oracle Oracle Fusion Data Intelligence Forum
-
Invoice Line level Subject Area in FAW OACHello, We need to create a Invoice line level report in FAW OAC, but do not find ant relevant Subject area in ERP Financials. Content (required): the Prebuilt AP Invoice…Yogesh Dhanorkar-Oracle 111 views 3 comments 0 points Most recent by Yogesh Dhanorkar-Oracle Oracle Fusion Data Intelligence Forum
-
Have issue with Period Name returning data on two reports - Disposal and Fixed AssetWe have two reports that we are trying to return data on and using the following clause: (this is a parameter and a column in the report) WHERE (fdp.PERIOD_NAME IN(:P_As…Mblankenship 22 views 1 comment 0 points Most recent by Sandeep S. Chauhan-Oracle Oracle Analytics Publisher Forum -
3Ability to drag and drop rows in tables for a custom sortEvery company has a specific way of presenting financial statements, and we need the ability to sort accounts as needed rather than simply alphabetically or by amounts. …Caroline Blanchard 21 views 0 comments 3 points Most recent by Caroline Blanchard Oracle Analytics Idea Lab -
2Need new PVO in BICC for GL_JE_ACTION_LOGCurrently there is no PVO in BI Cloud Connector providing GL Batch action history information for every GL Batch. Specifically, our business has keen interest in the "po…Stéphane Lamy-Bouchard 14 views 0 comments 2 points Most recent by Stéphane Lamy-Bouchard Oracle Transactional Business Intelligence Idea Lab
-
1FAW - Need additional attributes added to Financials - AR Receipts and Applications subject areaThe existing "Financials - AR Receipts and Applications" is missing key attributes which can be found on the Manage Receipts screen in Fusion SaaS: Comments Application …Phil Leu 41 views 0 comments 1 point Most recent by Phil Leu Oracle Fusion Data Intelligence Idea Lab