Fusion Financial reporting
Discussion List
-
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 51 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 174 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 "…
-
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 232 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
-
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 402 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 11 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 11 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 59 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 74 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 144 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 31 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 42 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 21 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 12 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 59 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 21 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 43 views 4 comments 0 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP