Reporting and Analytics for ERP
Discussion List
-
How to lock down HSGETVALUESummary: Would like to lock down (hard-code / copy-paste) all "HSGETVALUE" formulas, without locking down all the other formulas in the spreadsheet Content (required): I… -
Subject Area for asset tag numberSummary: Which subject area of assets stores the asset tag number? Content (required): My requirement is to show the asset tag number on the retirements schedule of asse…
-
Large number value pushing out as scientific E numberSummary: I have a rtf template that must show opening balance, total invoices, total credit memos, etc and a closing balance. My amount coluns are pushing out values lik…
-
Subject Areas Exposing PPM KPI'sSummary Do any of the delivered PPM Subject Areas expose the KPI and related informationContent I am not seeing any of the Project-based KPI information such as measures…
-
BI Admin role revokation not workingSummary: Hello Everyone, We have assigned a BI admin role to user and it worked fine. It has all the admin privileges. So far so good. We have realized that the user sho…
-
Check BI role as part of standard user rolesSummary: Hello Everyone, Is there a way or query to check which user roles have enherited the BI Admin/BI auther role ? Please help. Thanks in advance. Content (required…
-
How to filter by Invoice ID that has had the invoice approval state 'Automatic Rejected'.I want to filter a dashboard to show all invoices that still require action to be taken, that were automatically rejected by the system. I want to see all rows of "Payab… -
Error in Financial reporting centerHello, I am trying to upload my balance sheets and income statements in financial reporting center, when I navigate, I can't find the different ledgers to select. In add… -
OTBI - Subject Area - General Ledger - Balances Real TimeSummary: General Ledger - Balances Real Time - can anyone confirm this works correctly with Budget and Actual data Content (required): I am trying to construct reconcili…
-
How to get the link for a custom application pageSummary: How to get the link for a custom application page? Content (required): We have created a custom page in our Fusion Cloud instance, were we have gathered our cus… -
What is FRS formula to populate Sep of last year dynamicallyQuestion We have Balance Sheet in FRWS where user selects specific period (Monthly GL calendar) thru prompt e.g. Jun-22. GL calendar is from Oct to Sep. User always want… -
Is it possible to enable "All Values" as an option in a Table Prompt for an OTBI report?Summary: Table Prompt on OTBI report to include an option for the report to return "ALL" Content (required): We have a dropdown menu (table prompt) on an OTBI report tha… -
FRS POV Dimension LayoutSummary: Content (required): Hello: Some reports have all the defined POV's showing when opening the report, and some only show the POV's that need to be changed (i.e.: …
-
Account Analysis report returns no data - 2nd year in a row this report has become broken in March.Summary: In march, this report starts returning no data. Runs fine in Jan & Feb. Last year, the SR reported back that the data model had been updated for performance rea… -
Is there a foreign exchange gains and losses report available?Summary: As a global company, with entities using +50 currencies, we'd like to see a report to understand what is generating the foreign exchange gains and losses at the…
-
Employee Vacation and Delegation Rules Report is not being translatedSummary: Unable to translate the seeded Oracle report to FRC Content (required): We are trying to translate the Oracle seeded "Employee Vacation and Delegation Rules Rep… -
How to add the segments of the Chart of Accounts to the OTBI Subject AreaSummary: Unable to find the 4th and 5th segments of the Chart of Accounts in the General Ledger or Budgetary Control subject areas Content (required): Our COA has 5 segm…
-
Sample OTBI Report: Payables and ReceivablesSummary OTBI reports covering Oracle Fusion Receivables and PayablesContent This is a set of 13 sample reports showing various receivables and payables transaction detai…
-
Change Excel Sheet name in BI Publisher TemplateContent Hello, Is it possible to rename the Excel Sheet names of a BI Publisher Template Report [Type xpt] which has default output format as Excel (xlsx) ? I have creat…
-
How to format an OTBI report to see the total amount spent in a specific account by month?Summary: Within the expense reporting template, I am trying to create a report that will show the amount spent in a specific account by month. For example, the amount sp…
-
OTBI Payables Invoices to Subledger joinContent We have a requirement to display Payables Invoices data (Payables Invoices Transactions Real Time) and their corresponding Subledger entries & other Subledger sp…
-
Invoice Payment Report with Journal InformationSummary: Invoice Payment Report with Journal Information Content (required): We are looking for a report that contains invoice details (number, amount, date, etc.), the … -
How to create dependent parameter using table valueset for ESS Job?Summary: How to create dependent parameters using a table value set for ESS Job? Content (required): Hi All, How to create dependent parameters using a table value set f…
-
Table to get user password expiration dateSummary: Table to get user password expiration date Content (required): Hi All, Which table stores the user password expiration date? The user wants to create a report. …
-
SQL tables that store invoice and journal approval data like tasks & related rules etc.?Summary: What are the SQL tables with invoice and journal approval data like tasks and related rules like we have for procurement where we have the table POR_AMX_TASKS, …
-
How to create ESS for custom report in multiple languages?Summary: Suppose a custom report whose layout is already available in multiple languages (multiple xlf files). First I logged in EN language, went to the Manage Enterpri…
-
How to join multiple subject areas into one analysisSummary: Requirement to join multiple subject areas in one analysis Content (required): I need to successfully join the following three subject areas: Receivables - Tran…
-
Is it somehow possible to work dynamically with BIP reports directly in Excel?Content (required): Hi all, Is it somehow possible to work dynamically with BIP reports directly in Excel? Hence, have the layout of the BIP reports with the same parame…Daniel Lundsteen Minke 22 views 1 comment 0 points Most recent by Cezar - Fusion Oracle Support-Oracle -
OTBI Access and SQL Query ViewHi For OTBI Report Creation - the access is incomplete. Please observe the Create --> Published Reporting and Actionable Intelligence - only two options What all are the…
-
Invoices Paid on timeSummary: Hi Business is trying to generate the invoices paid on time report in Fusion Cloud Not able to trace the seeded / standard report for the same. Can you please g…