Fusion Financial reporting
Discussion List
-
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 "…Brad Kirschner 3 views 0 comments 0 points Started by Brad Kirschner 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 231 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 12 views 1 comment 0 points Most recent by Jeff Hare CPA CISA CIA 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 409 views 0 comments 1 point Started by Noelle Bartlam-Oracle Reporting and Analytics for ERP
-
Report to find details of history of all reportsHi Team, Could you please let me know if there is a way/ there is a report to retrieve details of all custom reports (OTBI/BIP) in terms of last updated by and last upda…Swapnil Kashid 41 views 2 comments 1 point Most recent by Swapnil Kashid Reporting and Analytics for ERP
-
How to get L3 Hierarchy account in GL transaction analysis OTBI reportSummary How to get L3 Hierarchy account in GL transaction analysis OTBI reportContent Hi , There is a requirement to add L3 hierarchy of the 'Natural Account' segment al…Sellapalaniappan V-Oracle 38 views 1 comment 0 points Most recent by Ahmed Mousa Reporting and Analytics for ERP
-
Attempting to Extract GL Journal Workflow ApproversSummary: Asking how to access the workflow metadata around assigned approvers in Oracle ERP. Content (required): I am attempting to create a report with BIP that extract…Jonathan Keller - UCD 12 views 0 comments 0 points Started by Jonathan Keller - UCD Reporting and Analytics for ERP -
Need a query to get the Fixed Assets category combination along with all its account combinationsSummary: Need to get the following accounting combinations of the category combinations in accounting rules; Cost, clearing, depreciation reserve, depreciation expense,c…Dian Minshan 1.5K views 1 comment 0 points Most recent by Ahmed Mousa Reporting and Analytics for ERP -
Which table will hold the information of period of an Asset BookSummary: Which table will hold the information of period of an Asset Book Content (required): Which table will hold the information of period of an Asset Book Version (i…Lydia Jayasingh 12 views 4 comments 0 points Most recent by Lydia Jayasingh Reporting and Analytics for ERP
-
ESS Job ArgumentSummary ESS Job ArgumentContent Good People, We have a single argument for an ESS Job which is a STRING field. Unfortunately in the values we have DATA with comma e.g. A…Soumya Prakash Parhi 60 views 2 comments 1 point Most recent by Ghanshyam M-Oracle Reporting and Analytics for ERP -
I need a query to obtain Review Budgetary Control Balances screen informationSummary: I am kind of new with Oracle fusion budget control module and We require to create a report where We need the information that appears in the Review Budgetary C…Robinson Antunez 1.4K views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
To create custom subject areaHi All, Could you please let us know if there is a way to register a sql query as a custom subject area that can be used for creating an OTBI report. Our requirement is …Swapnil Kashid 78 views 4 comments 1 point Most recent by Swapnil Kashid Reporting and Analytics for ERP
-
OTBI - Unpaid Invoice By Payment methodSummary OTBI - Unpaid Invoice By Payment methodContent This report helps to identify unpaid invoice details for any enterprise.Soumya Prakash Parhi 147 views 2 comments 8 points Most recent by Swapnil Kashid Reporting and Analytics for ERP
-
Audit Report for FranceSummary Does Anyone use Audit Report for FranceContent We are trying to use the provided Audit Report for France and we are running into issues. Did anyone use this repo…Tina Valtchev 32 views 8 comments 2 points Most recent by amy hardtke Reporting and Analytics for ERP -
Report Time out IssueSummary: There is an issue on report execution time out. When a long period report run on any finance side. Then after sometime an error occured on time out. Same report…Rohan Raghuvanshi 43 views 2 comments 0 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP
-
Filter ReceiptHi, I am receiving output of the query as below I would like to modify the below query to have separate queries one query to display row number 1,2,3 which are highlight…Mohammed Rafi 22 views 6 comments 1 point Most recent by Dhruvjoshi23 Reporting and Analytics for ERP -
Does the AR Transaction Register Report is an OTBI or BI ReportSummary: I need to customize the AR Transaction Register Report , I need to add some additional fields Content (required): I need to customize the AR Transaction Registe…martingabriel Kinovisques 11 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
OTBI Costing - Receipt Accounting Real Time subject area missing a transaction type on filterSummary I am trying to create a report in OTBI to record items I can see withing Supply Chain Execution > Receipt Accounting > Review Receipt Accounting DistributionsCon…User_2025-02-04-14-03-09-386 65 views 4 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Edit a standard report without regenerating sample data?Summary: Hi, I am editing a standard report (BIP) in Fusion Financials and have added the new field to the data model using the trick of exporting the zip (xdmz) content…User_2025-02-10-15-12-48-631 23 views 2 comments 0 points Most recent by User_2025-02-10-15-12-48-631 Reporting and Analytics for ERP
-
Receivables - transactions real time failing with ODBC-error about Flex fieldsSummary: When I try to create a very simple report with the Subject area "Receivables - transactions real time" I get an error, every time I try to use a fact from the f…Anders W. Langholm 21 views 0 comments 0 points Started by Anders W. Langholm Reporting and Analytics for ERP -
Anyone with Insightsoftware Reporting tool experience?Summary: Looking for anyone who has experience with using Insightsoftware's tool for Oracle Financial Reporing Content (required): Looking for feedback on Insightsoftwar…
-
Custom ESS jobs error outSummary: We have 7 custom reports where created a related ESS job definitions and created custom role (with appropriate Privileges) to run those custom ESS jobs. Job is …AnilJaMI 52 views 4 comments 0 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP
-
How can I see who an invoice is currently located at in OTBI?Summary: I need to be able to see who's the "Active user" on an invoice in this moment, preferably using a subject area... Content (required): I have searched high and l…Anders W. Langholm 22 views 2 comments 0 points Most recent by Anders W. Langholm Reporting and Analytics for ERP
-
21D known issues - Just a thread to note down any issues ppl with this release have facedSummary: Opening this thread to note down issues with 21D. Currently we have this release in our lower environment and are testing - so I thought to have a thread that c…Dhruvjoshi23 13 views 3 comments 0 points Most recent by Dhruvjoshi23 Reporting and Analytics for ERP -
Subject Area Security - Unable to view data from relative subject area despite having role assignedSummary: Subject Area Security - Unable to view data from relative subject area despite having role assigned Content (required): I am currently attempting to troubleshoo…User_2025-02-11-21-40-21-159 288 views 3 comments 0 points Most recent by Ghanshyam M-Oracle Reporting and Analytics for ERP