Reporting and Analytics for ERP
Discussion List
-
Calculate difference between previous and current amountSummary: How to add a column for calculating the difference between yesterdays closing amount and todays opening amount Content (required): We have built a simple OTBI r… -
SQL script for Roles , Privileges, Inherit roles & Data Security PoliciesSummary SQL script for Roles , Privileges, Inherit roles & Data Security PoliciesContent Trying to built a query to fetch Application Roles, Privileges, Data Security & …
-
How to customize Goal workflow notificationSummary: Content (required): Hi All, We have a requirement to customize the Goal workflow notification. we need to replace the word Goal with Objective. Is it possible ?…
-
Can we define custom report view in custom reportDear , We have one custom report (SQL query), now our requirement we have to show data as per user login For example if User ABC login report shows only custom Data whic…
-
Fusion UI Customization TablesSummary: Fusion UI Customization Tables Content (required): Hi All, From which table we can get fusion page customization details like, who did the customization and the…
-
GL Value set DFF's are not available in SmartView/ FRSSummary: GL Value set DFF's are not available in SmartView/ FRS. Please let me know is this standard functionality. My client want to track this. Let me know we have ano…
-
FRS 13 Month Rolling Reports Error Executing Query since 22C UpgradeSummary: Content (required): Hello: Is anyone having issues running FRS rolling reports since the 22C Upgrade? Our other reports are running fine, but we are getting an …
-
Get Journal Entries Details For An EmployeeSummary: Team We would need to fetch Accounting Date & Transaction Number From Journal Entries. (GL) For An Employee Columns are: Accounting Date Transaction Number Payr…
-
FRS Heading not Centering in Excel exportSummary: Content (required): I have an FRS report that has about 13 columns. The header is centered across the report with the ability to autosize. Looks great online bu… -
Need to move Profit and loss FRS report from one instance to anotherSummary: Content (required): I have created a FRS report of profit and loss statement and I need to move it to another instance. Any suggestions on how to do this Versio…
-
How to create an OTBI Report to display POs by running for GL Parent/Child Department valuesSummary: How to create an OTBI Report to display POs by running for GL Parent/Child Department values Content (required): How to create an OTBI Report to display POs by … -
Need to report all journals and subledger activity (drilled data) on one reportSummary Currect reproting only allows reporting by one source at a time, need to see all for one account in single reprot.Version Fusion Cloud 20D -
Export Current Page returns all rows i.e, entire dashboard data in OTBI.Summary: Export Entire Dashboard is exporting all rows but "Export Current Page" no longer exports only the rows on the current page. It is exporting all rows. Please ad…
-
-
Extract Fusion Spend Classification Data using BICCSummary: How to extract Spend Classification Data from Fusion? Content (required): As per Fusion 21C, Oracle has introduced Spend Classification Oracle Procurement Cloud… -
What System Role gives access to PER_LDAP_ROLES?Summary: What System Role gives access to PER_LDAP_ROLES? Content (required): Hi All, I keep forgetting and cannot find a document outlining this but what role gives acc…
-
Which database is used by Oracle Analytics Cloud?Summary: I wanted to understand if Oracle Analytics Cloud sits on the same Cloud Fusion ERP database or it uses a different database. Content (required): To be clear - I…
-
COUNT Function to get specific valuesSummary: Hi Experts, I have created a report to get the sum of certain rows by specific values. For example, the column returns values as either "REC" or "UNR". So the r…
-
FscmTopModelAM.FinGlAccountsCodeComboAM.CodeCombinationPVO returns empty rowsSummary: FscmTopModelAM.FinGlAccountsCodeComboAM.CodeCombinationPVO is not returning any row while runni ng from BICC Content (required): Version (include the version yo…
-
OTBI - Count FunctionSummary: Content (required): I have the below requirement, A report to capture all transaction details and the entry users has already been created. (The format is attac…
-
BIP Cloud - Deployment role missingSummary: BIP Cloud - Deployment role missing Content (required): Please note this idea is related to deployment of BIP reports on "BIP Cloud" Problem Description -------…
-
A report for print options for AR customers - Missing FieldSummary: A report is required to detail the print options for AR customers The issue I am having is location the tables that hold Statement Preferred Delivery Methods fr…
-
AP Aging reportSummary AP Aging reportContent Is there a standard AP Aging report available online? We were advised that the AP Aging report in Oracle can only be run on the current da…
-
How to link the sla to an invoice lineSummary: Need to link invoice lines to the subledger xla and xle files Content (required): Version (include the version you are using, if applicable): Code Snippet (add …
-
How to send and unsend a report based on its content in oracle BISummary: How to send and unsend a report based on its content in oracle BI Content (required): Hi everyone, There's a requirement to have a certain report output mailed … -
FRS - Selecting multiple values for Point of ViewSummary: Selecting multiple values for Point of View Content (required): Hi All, We have a requirement to selct multiple values for the POV when selecting the initial re…
-
After a refresh from Prod to Test (P2T), is there a list of recommended processes to run?Summary: After a refresh from Prod to Test (P2T), no data is showing on neither the inquire on detail balances screen nor the budgetary control dashboard. Content (requi…
-
OTBI Analysis: Is it possible to add a column that summarizes Invoice Amount by Supplier?Summary I'm building an analysis in OTBI and wanted to know if it's possible to have a calculated column that summarizes one of the other columnsContent I'm building an … -
How to change the logo dynamically in fusion home page?Summary: How to change the logo dynamically in fusion home page? Content (required): Hi All, Is it possible to change the logo based on the user login on the fusion home…
-
Current year + 2 as filter in columnSummary: Content (required): Hi I would like to show the forecast for 2 years from now for a specific column. For example in the code below I've used a repository variab…