Fusion Financial reporting
Discussion List
-
Manage Audit Policies enabled but output shows 'There are no records to display'Summary: We have enabled 'Manage Audit Policies' for Payables >Invoices (attributes also SELECTED and added) last week. 1) However when we run the "Generate Audit Report…Sinclair support 151 views 3 comments 1 point Most recent by Donna Curtis Reporting and Analytics for ERP -
Customizing the Accrual Reconciliation report to a more usable excel sheetSummary: Business is using the Accrual reconciliation report to reconcile the accrual account with the PO details. Currently business has huge data in this report for ce…
-
Cloud ERP Reporting: 10k / 10QSummary: Has anyone used any of the ERP Cloud Reporting tools to create their 10K /10Q's? Content (required): Version (include the version you are using, if applicable):…Susiemae Palmer-Oracle 31 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Fixed Asset Balances - Real Time subject area is not updatingSummary: Content (required): We have developed a report using the Fixed Asset Extract Balances table and the recent transactions re not updated in the table. The "Extrac…Dian Minshan 41 views 1 comment 0 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for ERP -
ERP Report Sharing CentreSummary LocationContent Hi All, The HCM report sharing centre (https://cloudcustomerconnect.oracle.com/resources/5c46181001/summary) is a hive of activity, but the ERP o…Mark_Daynes 138 views 5 comments 2 points Most recent by Marybeth Snodgrass Reporting and Analytics for ERP -
GL Trial Balance Report Custom TemplateSummary:We've created custom template for TrialBalalnce.xdo, But still ESS job is taking standard template.Is there are changes required in configuration to pick custom …
-
Trending FRS Report to exclude 13th Period?Summary: How to exclude 13th Period in Fusion FRS Report? Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snip…Malmarugan Prakash 31 views 1 comment 0 points Most recent by OmkarAdkar Reporting and Analytics for ERP
-
Access OTBI Data without Job RolesSummary For OTBI Administrators - Is there a way to access Data as a Super User without getting a specific Job Role assigned?Content Hey Guys, We were checking to see if…
-
Period Name parameterSummary: Hi , I am currently working on report which is filters using period_name. when i select single month(period_name), the data looks promising. when multiple perio…Praveen_Chouhan 51 views 2 comments 0 points Most recent by Praveen_Chouhan Reporting and Analytics for ERP
-
FBDI Fails to import Data containing Double Quotes(")Summary: FBDI Fails to import Data containing Double Quotes("). We are loading Items through "ItemImportTemplate" FBDI template. In item description we have data like WO…Lucky Sharma 81 views 8 comments 0 points Most recent by Dhruvjoshi23 Reporting and Analytics for ERP -
How to tackle different date formats being entered by user in Supporting Reference in BIP Report?I have a scenario when users input dates in multiple formats eg.18/Mar/2022, 18/March/2022, 18/03/2022, 2022/03/18 while posting a Journal in the Supporting References. …
-
BI Publisher Output File NameSummary BI Publisher output file name Suffixes Template/Layout NameContent BI Publisher report output file from Oracle Fusion cloud suffixes the Template/Layout name at …Senthilrajan V 80 views 12 comments 2 points Most recent by Ravi Tilekar Reporting and Analytics for ERP -
Vacation and Delegation Rules reportSummary: Hi All, We have a requirement to create the below report for Vacation and Delegation rules in the application. Say when Line Manager is going on Holiday and he …Dharmendra Jha 61 views 3 comments 0 points Most recent by Stephen_J Reporting and Analytics for ERP
-
Bursting Enabled or DisabledHi Team, We wanted to check if we have a table or sql query to check how many reports have bursting enabled so a report or list can be prepared for the same. Please let …Swapnil Kashid 41 views 6 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP -
Dec-XX Balance for Qtr4-XX balance in FRS StudioSummary Dec-XX Balance for Qtr4-XX balance in FRS StudioContent Hi We need to populate QTD balances. The accounting calendar has 2 Adj periods. Adj 0 - XX before Jan-20X…Swapnil Mangnalikar 26 views 3 comments 0 points Most recent by Cezar - Fusion Oracle Support-Oracle Reporting and Analytics for ERP
-
SOX and Smart ViewSummary SOX is asking how they can know Smart View data is accurate and completeContent Hello, Our SOX team is asking how they can know that Smart View data is accurate,…Luisa Stock 27 views 1 comment 1 point Most recent by Cezar - Fusion Oracle Support-Oracle Reporting and Analytics for ERP -
Restrict OTBI report data(using subject area) to logged in userSummary How to restrict OTBI report data(using subject area) to logged in user. Currently it shows all data. Data access given at Business Unit level for the role.Conten… -
21D BIVO list for ERP (Financials, Procurement, Projects and HCM)Summary: I am looking for latest 21D Deprectaed BICCC list for ERP (Financials, Procurement, Projects and HCM). Any link where I can download the latest listing. Appreci…pratyushak 41 views 3 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP
-
Folder/Report Last Modified DateHI Team, After a refresh/upgrade/patch getting applied does the folder last modified date change for each folder. We could see some folders have different last modified …Swapnil Kashid 131 views 3 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP
-
Delivered Asset Transaction History Report runs to error if From/To Asset fields are blankSummary: If we run the Asset Transaction History Report, and only entering the required parameter of Asset Book, it runs to Error within a minute. The "From Asset" and "…
-
BI Cloud Connector (BICC) New featuresHi Does anyone know of any changes coming to BI Cloud connector with Fusion Application 22A upgrade. And can anyone help provide the link to the the New Features documen…Fongang 11 views 3 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for ERP -
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… -
Document Number in OTBI Receivables - Transactions Real TimeContent I am building an OTBI report using Receivables - Transactions Real Time, and I'm looking for the column for 'Document Number'. Does anyone know if this column is…Brian Todd-Oracle 32 views 1 comment 0 points Most recent by Robert G Wilkinson Reporting and Analytics for ERP
-
OTBI - Convert Entered Amount to USD for Non Usd LedgerSummary: Is it possible to convert an Accounted Amount to USD for Non USD Ledger in OTBI (General Ledger Journals Real Time)? Content (required): I have business require…Hannah Dorman 151 views 2 comments 0 points Most recent by Hannah Dorman Reporting and Analytics for ERP
-
Need the table name for SOA Suite Audit Policy configurationSummary: There is a bug in the Transaction Console that allows someone to enable / disable approvals via the Bypass Approvals and this activity is NOT included any of th…Jeff Hare CPA CISA CIA 11 views 2 comments 0 points Most recent by Jeff Hare CPA CISA CIA Reporting and Analytics for ERP -
Table(s) for Enabled / Not Enabled Functional Audit PoliciesSummary: Is there a table that contains the full list of functional Audit Policies that can be enabled / have been enabled already? Content (required): See PDF for scree…Jeff Hare CPA CISA CIA 11 views 1 comment 0 points Most recent by Jeff Hare CPA CISA CIA Reporting and Analytics for ERP
-
SQL for OTBI Analysis historyContent Does anyone know if there is a seeded report/analysis or SQL to pull the history of all OTBI analyses? We have a lot of old OTBI analyses that were created by fo…Mike Burnett 75 views 8 comments 4 points Most recent by Andrew_Schmitz Reporting and Analytics for ERP -
OTBI_EXM: No data for Transaction/Billed/Posted Amount Columns on corporate card expenseSummary: When querying corporate card expenses that have not been added to an expense report, no data is populated for fact columns Transaction Amount, Billed Amount, an…
-
Details about PrivilegesHi Team, Am looking for a report/ query to find details about privileges. We are looking for finding a what is the exact purpose of a privilege. Example: AP_MANAGE_PAYAB…Swapnil Kashid 11 views 2 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP
-
R13 Higher Ed and Public Sector Cloud OTBI subject area to database lineage mapping spreadsheetSummary: This spreadsheet documents R13 Higher Education and Public Sector Cloud OTBI subject areas to database lineage mapping and subject area security Content: This s…Noelle Bartlam-Oracle 201 views 0 comments 1 point Started by Noelle Bartlam-Oracle Reporting and Analytics for ERP