Reporting and Analytics for ERP
Discussion List
-
Grouping Columns into oneSummary: Is it possible to group different members into one column in financial reporting studio Content (required):Financial reporting studio Version (include the versi… -
Report on Report Usage in FRSSummary: I am trying to gather information on which users run which reports in FRS. I have created an OTBI Usage report but that report does not include reports in the F…
-
Need a query to get negotiation approver list in oracle fusionSummary: Content (required): Hello everyone, I need a query to get negotiation approver list in oracle fusion.Please advise! BR, Sushan Peiris Version (include the versi… -
Getting warning while creating Content Data setSummary: Getting warning while creating Content Data set Content (required): Hi All, Got a requirement to show attachments in the PO PDF report. So we try to customize t…
-
Where is WF_ROUTING_RULES located? Vacation Rules table?Content Hi, I'm trying to do reports for vacation rules and I have read I can use WF_ROUTING_RULES but or the life of me I can't find where these reside Any clues? Do I …
-
Period name taken as a parameter tag display in a wrong format in excel outputSummary: Content (required): Hello Everyone, I recently created a BIP report using excel with the "xls" format and using the xml exported, I ,created the report in an ex…
-
Extracting Other language description in OTBI ReportSummary: Extracting Other language description for Account Hierarchy in OTBI Report Content (required): Hi All, We are trying to build a OTBI report which displays Accou…
-
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 -------…
-
Rest API to GET reports from BIP in Fusion Financials SAASSummary Is there a Rest API to get BI Publisher reportsContent Hi All Is there a Rest API to call BI Publisher reports from Fusion Cloud Financials within SAAS financial…
-
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…