Get Started with Redwood: Oracle Cloud SCM and Purchasing
Fusion Financial reporting
Discussion List
-
Privileges required by the FAWService account that is created in Oracle Fusion ERP and used by FAWWe are creating the FAW instance and configuring out of box Pipeline between ERP and FAW to get the ERP data. For this purpose we need to create a user in ERP that can b…Seema_Intact 23 views 4 comments 0 points Most recent by Matt Luscombe Reporting and Analytics for ERP -
Need help to modify SQL to retrieve the journal approver field pleaseSummary: I am trying to update the GL Ledger script to include the following additional fields Journal Approver name beginning and closing GL account balances for the se…
-
How to convert date to Thai and Buddhist era in Custom BIP Report.Summary: Convert date to Thai and Buddhist era in Custom BIP Report. Content (please ensure you mask any confidential information): We have requirement to show dates in …
-
Query to get credit memo details applied for an invoiceSummary: Content (please ensure you mask any confidential information): I am looking for the details of credit memo applied for an AR invoice. For the invoice 1004830 he…Rahul K-Oracle 2K views 1 comment 0 points Most recent by Lucky Sharma Reporting and Analytics for ERP
-
wanted to use Home state a as parameter.i wanted to use Home state as a parameter in above query. How can i add it?Chetana Pawar 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Human Capital Management
-
Difference between Ess Job Derived attributes and AttributesSummary: Content (please ensure you mask any confidential information): We are creating Custom ESS job for one custom report requirement. We need know, what is the real-… -
Can we enable or disable report one parameter field based on other parameter field input?Summary: We received requirement like, 1) Choose field say start date or end date from drop down 2) Choose Operator Prior/After/Between from drop down 3) Enter Date : Da…Nikatfusion 97 views 1 comment 0 points Most recent by Sridhar Gupta Yerram-Oracle Reporting and Analytics for ERP
-
Unable to find custom ESS job created in the scheduled job screenI have created ESS job but unable to find the same in scheduled job screen to run, I have ran "Import User and Role Application Security Data" and "Retrieve Latest LDAP …Thanigainathan R 526 views 4 comments 0 points Most recent by Vijaya Sekhar A-Oracle Reporting and Analytics for ERP
-
Trouble with GaugesSummary: I'm trying to create a simple gauge that shows the percent balance left, but the gauge is not reflecting the correct information. Content (required): I'm using … -
Looking for query to get details of Review Budgetary Control Balances screen informationSummary: Content (please ensure you mask any confidential information): I am creating a custom report to get the details of Review Budgetary Control Balances screen. Ver…Rahul K-Oracle 26 views 5 comments 0 points Most recent by Rahul K-Oracle Reporting and Analytics for ERP
-
GL Detail Report w/ Subledger DetailsSummary: Finalize/Tweak built custom OTBI report to export the last bits of data needed by our auditors. We've built a custom OTBI report that exports GL and SLA numbers…Henry Imgrund 64 views 1 comment 1 point Most recent by James McBride Reporting and Analytics for ERP
-
Customer require to extract FRS report data in XML or SQL format. Is this possible?Hi All, Customer require to extract FRS report data in XML or SQL format. Is this possible?Janitha Perera 1 view 2 comments 0 points Most recent by Janitha Perera Reporting and Analytics for ERP
-
Is it possible to change the date to be used in aging transactions in the seeded AR Aging report?Summary: Is it possible to change the date to be used in aging transactions in the seeded AR Aging report? Content (please ensure you mask any confidential information):…Francine Gemora 85 views 6 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
Left Outer Join between the same tableHello, I am trying to get a list of all expense reports and populate the Expense Report History.Event Date only when the Event Status is a specific one. So I attempted t… -
Drill down to ERP pages through Infolets as standard onesSummary: Hi, We want to create objectives that are actionable that is, as the standard ones from Oracle. For example, create an infolet that shows the number of invoices…Emma Fayos García 21 views 2 comments 1 point Most recent by Emma Fayos García Reporting and Analytics for ERP
-
Can anyone suggest some tips to optimize SQL queries for slow running BI reportsSummary: Can anyone suggest some tips to optimize SQL queries for slow running BI reports. Please share your thoughts. Content (please ensure you mask any confidential i…Lucky Sharma 32 views 3 comments 0 points Most recent by Lucky Sharma Reporting and Analytics for ERP -
Standard Memo Line Report - Revenue CodingSummary: I have a customer requirement to be able to export a list of all standard memo lines and their associated Revenue coding, required fields highlighted in .JPG. C…
-
How to enable external directory in Oracle FRS schedulerSummary: How to enable external directory in Oracle FRS scheduler Content (required): We want to be able to send the output of FRS using a batch scheduler on an external…
-
In which Subject Area can I found the end date of an account.Hello, I am trying to bring the value of the End date of a GL account in an OTBI report . This value can be inputted in Manage chart of accounts value set values feature…Vlad CONSTANTIN 12 views 2 comments 0 points Most recent by Vlad CONSTANTIN Reporting and Analytics for ERP
-
How to query the emirate in Customer Account Site addressHello, We are currently creating a Customer report, and we need to retrieve the Emirate under the Customer Account site address. From which table and what field can this…Kristelle 14 views 1 comment 0 points Most recent by Dhilip Kumar P. Reporting and Analytics for ERP
-
Is is possible to create an audit report that has all FRS BIP and OTBI reports?Summary: Is there a way to get details of report along with the last run date individually (individual report for each areas) for reports & analysis - in OTBI and a Fina…Soare Oldrich Alexandru-Oracle 22 views 4 comments 0 points Most recent by Rich Merkel Reporting and Analytics for ERP
-
Error generating view. Error getting cursor in GenerateHeadSummary: We are stuck with this error: I have executed these processes: Publish Chart of Account Dimension Members and Hierarchies to Balances Cubes Create Rules XML Fil…Bo Tøpgaard 280 views 6 comments 0 points Most recent by Neha D-Oracle Reporting and Analytics for ERP
-
Is it possible to store both US and Local Legal Entity Identifiers in Oracle?Summary: Our business team would like to know if it's possible to store multiple registration numbers for an Entity in Oracle. Content (please ensure you mask any confid…Tina Valtchev 13 views 1 comment 0 points Most recent by Julien_Dubouis Reporting and Analytics for ERP -
Oracle BI Report > Parameter based on LOV having string limitationsSummary Oracle BI Report Parameter dissappeared due to long string value on listContent Hello Community and experts, I am building a BI report based on a SQL query, and …Robinson Antunez 167 views 8 comments 0 points Most recent by Satyam Roy Reporting and Analytics for ERP
-
OTBI Dashboard not reflecting the analysis dataSummary: When certain parameters are used in a dashboard, a couple columns return null values. The raw analysis does include data for these columns. This just started oc…
-
Error detail information in import journal execution reportSummary: In the process of creating a custom report for import journal execution report, we are unable to fetch the data for error status. We are able to fetch data for …
-
Is there a definitive date that Financial Reporting Web Studio will be discontinued?We were informed that Financial Reporting Web Studio will be shutting down at some point in 2024. Is that accurate? Is there a date set for discontinuing FRS?Steven Woods 189 views 2 comments 0 points Most recent by Steven Woods Reporting and Analytics for ERP
-
ERP Secured ViewsSummary List of secured views to secure ERP data in BIP reportsContent Could you please let me know how can we secure data in datamodel for Financials data? We couldn't …User_2025-01-25-01-31-47-378 109 views 3 comments 1 point Most recent by Ashish_Jain -Oracle Reporting and Analytics for ERP -
Role/Privelege for Explain Plan from SQL Query on data modelOne of our Reporting analyst user is getting an error that occurs when attempting to generate an Explain Plan from a SQL query on his reports. "Error Msg = ORA-01039: in…Vijay Ramani VJ 90 views 4 comments 0 points Most recent by Vijay Ramani VJ Reporting and Analytics for ERP -
How to Link Purchase Order Invoices back to Project Costs?Content Hi All We're working on a Project Statement report that brings back a comprehensive breakdown of the project costs and revenue. For the costs, we were able to br…