To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting and Analytics for ERP
Discussion List
-
Auto Refresh InfotilesSummary: Client would like an invoice “dashboard” experience in Oracle Fusion Cloud that updates in near real time (or auto-refreshes on a set interval) without users ma… -
ORA-00920: invalid relational operator when using Menu parameter with multiple selection enabledSummary: Hi Team, I'm unable to use Menu type parameter in where clause in SQL query in a DataModel when 'Multiple Selection' enabled. Below is the screenshot of the whe…
-
ERP Cloud implementation using Agile methodologySummary ERP Cloud implementation using Agile methodologyContent Good Morning everyone, Has anyone done ERP Cloud implementation using Agile methodology ? Any feedback/le…
-
R13.x FSCM BI Cloud Adapter BI View Object to Database Lineage Mapping SpreadsheetSummary This posting includes R13 FSCM BI Cloud Adapter BI view object to database lineage mapping. Content This spreadsheet is published by Oracle BI Cloud Adapter Deve…
-
How to get relevant FA cost balances between accounts after a category change?Summary: For the below asset, there has been a category change. This resulted in 2 different cost accounts, old and new. Is there a way to get the Cost balances for it a…
-
How to get Branding Image URL for Course created in Oracle Fusion HCMHello Everyone, We are developing a custom report to list courses, and one of the requirements is to display or extract the URL of the uploaded branding image for each c…
-
Query for Transaction Console transactionsSummary: Query for Transaction Console transactions Content (required): I am looking to write a query that contains the below information from the Transaction Console, r…
-
Navigation : My Enterprise -> EnterpriseSummary My Enterprise -> EnterpriseContent Hi, I am trying to navigate to t My Enterprise -> Enterprise menu from the home page. Even if i have all the relevant applicat…
-
Need help with Cost Accounting Distributions CodeSummary: Hy Experts. I am developing a Purchase Register Report where I have to fetch a column named Inventory Charge Account in which this value of Inventory Valuation …
-
How to run US 1099 Electronic Media Report for a specific vendorHi All, We need to submit an electronic file for one vendor we missed. Is there an option to run the US 1099 Electronic Media Report for a specific vendor. There seems t…
-
POV to include and exclude intercompany accountSummary: I am new to FRS. I would like to ask if I can define a dimension and user can choose whether they want to include or exclude a list of intercompany account. Con…
-
Expend All in Financial Reporting StudioSummary: I would like to ask if there any way to expand all the node at one go instead of expand it one by one. Content (please ensure you mask any confidential informat…
-
Create Rules XML File for BI Extender Automation under a custom roleSummary: How to allow ESS Job 'Create Rules XML File for BI Extender Automation' under a custom role (no privilege since a Java type program) Content (please ensure you …
-
Mapping between API entities and fields and BICC BIVO objectsSummary: I'm looking for a mapping between API entities and fields and BICC BIVO objects For example: I want to know which BIVO objects matching the API for REST API for…
-
Analysis Report Prompt is not appearing when running from the InvoicesSummary: Prompt added to the analysis report is not appearing when running it using invoice window. Content (required): Hi, I have created a OTBI analysis report (Not fo…
-
OTBI analysis opens directly without showing prompt when opened from the reports and analytics pageHi team, Facing an issue where an OTBI analysis opens without showing any prompt from the reports and analytics page ( it's added to favourites ) but when opened by navi…
-
Why I am not able to see prompts when I navigate through Reports & AnalysisI created an OTBI report in Accounts Receivable with prompts. When I access the report through Browse Catalog, the prompts appear as expected. However, when I navigate v…
-
Number of picks as a visualization in a dash board in LogfireSummary: I need to Create a visualization in Logfire showing the number of picks for each user. The cycle as following : 1- Order created. 2- Run wave to allocate the qu…
-
How to submit BIP Report in oracle fusion with soap webserviceSummary: How to submit BIP report in fusion with soap Webservice https:///xmlpserver/services/ExternalReportWSSService In this soap webservice need sample payload forsub…
-
In OTBI GL- Balances Real Time subject area 1 segment is missing from the Subject AreaSummary: Since second balancing segment label doesn't have the BI Object Name, we have created the custom label and given BI Object Name to add the Fund segment along wi… -
Does BIP allow additional static attachments, Word and Excel, to be added to a bursting email?Summary: We are customising the standard PO print BIP report and they will all be delivered via email, using the bursting functionality. The email will have a PDF attach…
-
Access to Fusion transactional tables (GL_JE_LINES, XLA, PJC, CMR) using Fusion Data IntelligenceHi, I need to analyze data that in Fusion transactional schema is stored in tables such as: GL_JE_LINES XLA_DISTRIBUTION_LINKS PJC_EXP_ITEMS_ALL CMR_RCV_DISTRIBUTIONS We…
-
Mexico Localization Reporting via Secondary Ledger (MXN)Summary: We have configured a Mexico entity in Oracle Fusion Cloud where the Primary Ledger currency is USD and a Secondary Ledger currency is MXN (local currency). The …
-
SmartView Duplicate name Error from sharded driveSummary: Smartview Spreadsheets are kept in a shared drive (OneDrive). After a hierarchy change (A single value added or moved)we continually see errors like : Essbase E…
-
Change row output number on Oracle OTBI AnalysisHow I am able to change the output of the rows from 75000 to more on an Oracle OTBI analysis? -
Report to obtain the user's transactionsSummary: Report to obtain the user's transactions Content (please ensure you mask any confidential information): Is there a query, process or report to obtain the transa… -
FRC synch timeSummary FR Studio Reports don't appear in FRC immediatelyContent When we create new Financial Reports using FRS, they do not appear in FRC right away. It seems there is …
-
Table for Bursting related information and Bursting Notifications to WorklistDo we have a way to track/report notifications sent from report Bursting? If so, what attributes can we capture (e.g., recipient(s), subject, body etc.)? Does the report…
-
Audit - On Folder Permissions ChangesWe have a requirement on Auditing folder Permissions Changes details on "Reports and Analytics --> Catalog --> Shared folder --> Changes on any of the custom folder perm… -
GL_FRC_REPORTS_B and Custom Folder and Report ListSummary GL_FRC_REPORTS_B is not listing all the reports that are created or modified; Should we run a process to populate the table or does the data in the table gets po…