Category 129
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…User_2025-02-13-14-57-57-487 22 views 1 comment 0 points Most recent by Angus_Little Reporting and Analytics for ERP -
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…CKleu 22 views 3 comments 0 points Most recent by Anders W. Langholm Reporting and Analytics for ERP -
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…
-
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…Oracletechnofunctional 32 views 2 comments 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting and Analytics for ERP
-
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…Oracletechnofunctional 42 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
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…Victor Chrabieh 42 views 2 comments 3 points Most recent by Bhaskar Konar Reporting and Analytics for ERP -
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…User_2025-02-10-15-12-48-631 50 views 1 comment 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP
-
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…Anders W. Langholm 32 views 3 comments 1 point Most recent by Anders W. Langholm Reporting and Analytics for ERP -
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…CA Nirmal Choudhary 155 views 2 comments 0 points Most recent by CA Nirmal Choudhary Reporting and Analytics for ERP -
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…Miriam Rowan 63 views 1 comment 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP -
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…Felicidat 56 views 1 comment 1 point Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP
-
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…Eva Mirzoyan 41 views 1 comment 1 point Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP -
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…Trent M 134 views 3 comments 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP
-
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…Venkatesan 166 views 1 comment 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP
-
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. …Venkatesan 825 views 2 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP
-
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…User_2025-02-11-06-12-35-024 41 views 3 comments 0 points Most recent by Shravan S Kumar-Oracle Reporting and Analytics for ERP
-
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 42 views 1 comment 0 points Most recent by Cezar - Fusion Oracle Support-Oracle Reporting and Analytics for ERP -
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…SaurabhSinghal26 41 views 1 comment 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP
-
OAC Essbase Add-In for Google SheetSummary: Are we able to use smart view in Google sheet? We have heard about OAC Essbase Add-in, Will it replace Smart View for Google sheet? Also, while adding the plug-…Nikhil Bidwaikar 33 views 0 comments 0 points Started by Nikhil Bidwaikar Reporting and Analytics for ERP
-
How to get the GL Segments Flex value set IDs for seeded and custom segments from EBS R12 DBSummary: EBS R12 SQL or base tables to fetch GL Segments Flex value set IDs for seeded and custom segments. Content (required): There is a need to fetch GL Segments Flex…Manu R-Oracle 223 views 1 comment 0 points Most recent by Amrita Gupta-Oracle Reporting and Analytics for ERP
-
Error in join subject area Purchasing Real Time and Requisition real TimeSummary: Hi Team, We are trying to join the subject area Purchasing Real-time and Requisition Real-time, but getting error as below- Error Codes: OPR4ONWY:U9IM8TAC:U9IM8…raban 168 views 3 comments 0 points Most recent by Amrita Gupta-Oracle Reporting and Analytics for ERP
-
Is it possible to generate csv file with column labels of child records even when they don't exist?Summary: Standard BI Publisher behavior is that column labels are not generated for columns of child records when they don't exist. Example: Data Model queries: Data Set…User_2025-02-11-06-12-35-024 31 views 4 comments 0 points Most recent by User_2025-02-11-06-12-35-024 Reporting and Analytics for ERP
-
Customise standard report - new layoutSummary: Standard report which only runs inside Fusion ERP. How to use sample data xml export in Fusion BI Publisher? Content (required): So I have a standard report whi…Robert of STAU 60 views 4 comments 0 points Most recent by Robert of STAU Reporting and Analytics for ERP
-
OTBI - General Ledger - Balances Real Time Subject Area not Returning Budget DataSummary: OTBI - General Ledger - Balances Real Time Subject Area not Returning Budget Data Content (required): Having successfully loaded budget data into Financials fro…User_2025-02-10-15-12-48-631 243 views 3 comments 0 points Most recent by SimonTomey Reporting and Analytics for ERP
-
How to create a Cross-Tab reporting using BIP Excel TemplateSummary: How to create a Cross-Tab reporting using BIP Excel Template Content (required): Hi, We have a complex report layout and we have to develop it using BIP Excel T…