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
-
Can we invoke a ess job uisng action link on BI DashboardSummary We are creating go to reports dashboard and we need to create a link on a dashboard that invokes account analysis reportContent Is it possible to create action l… -
Custom ESS Job Parameters Display Issues on Submission FormSummary Custom ESS Job Parameters with Custom LOVs do not display correctly on ESS Job Submission ScreenContent I have created a custom ESS job from a Bi Publisher repor…
-
Period Name- In OTBI reportSummary Need perod name should populate like DEC-FY-20 (DDDFFYY)Content Hello Team, We want to have the Period name in our OTBI report in the format 'DEC-FY-20', 'SEP-FY…
-
How to display VAT for an expense line/reportContent Hi, Between EXM_EXPENSE_REPORTS and EXM_EXPENSES how do I get to display the VAT paid for an expense line/report? Either through a data model/SQL or with an anal… -
line feed when displaying getclob() using data model in oracle cloudSummary line feed when displaying getclob() using data model in oracle cloudContent select sysdate, rtrim(xmlagg(xmlelement(e,id,',').extract('//text()') order by id).Ge…
-
Quarterly Patching - TestingSummary Quarterly Patching - TestingContent Hi I was just wondering what other customers do around the quarterly patching for financials? We tend to read the notes for a…
-
Identify OTBI / BIP reports using a particular columnSummary Identify OTBI / BIP reports using a particular columnContent Hi All, Is there a way to identify OTBI report and BI Publisher reports that are using a particular … -
otbi reports - how do i find out you last modified report?Summary otbi reports - how do i find out you last modified report?Content otbi reports - how do i find out you last modified report? i only see owner and that is person …
-
Oracle/FRS/SmartView - Submit Data FunctionContent Hi, I download my FRS report into SmartView via the 'Export to Query Ready Mode' functionality. Once in SmartView I see there is a 'Submit Data' button. Does thi…User_2025-02-05-23-08-18-294 41 views 4 comments 0 points Most recent by User_2025-02-05-23-08-18-294
-
GDPR Data columns in finance for maskingSummary GDPR Data columns in finance for maskingContent Hi: What are the GDPR data which needs to be masked in Oracle finance GL and Cash management? In HCM, we used to …User_2025-02-05-23-07-28-232 39 views 2 comments 0 points Most recent by User_2025-02-05-23-07-28-232
-
ERP – Oracle Financials Cloud: Overview and Investment Strategy, 11 December 2019, 9 a.m. PT - SubmiContent Submit your questions for the ERP – Oracle Financials Cloud: Overview and Investment Strategy session to have them answered during the live event. Post your ques…
-
ANNOUNCEMENT: Opt-In Features with Expiry DatesSummary Some Opt-In Features introduced since Update 19B have expiry dates, be aware that at this point they will become automatically enabled and you may need to prepar… -
How to best analyze ESS Job Schedules?Summary How to best analyze ESS Job Schedules?Content We have a basic need which we are struggling to find an answer to: How do we best analyze the jobs from ESS schedul… -
Lineage document for Oracle Analytics For Fusion ERPSummary This document provides the lineage report from Subject Area to data warehouse table and column.Content Enclosed Oracle Analytics For Fusion ERP subject area to d…
-
Financial reporting studio report using a custom heading repeats when expandingContent We are using a custom heading with expansion enabled, the member and its children are renamed as well. How can we edit this so that the Custom heading only appea…User_2025-02-06-00-15-19-515 36 views 6 comments 2 points Most recent by User_2025-02-05-07-43-41-391
-
Financial Reporting Studio - Pages Function / Data AccessSummary Financial Reporting Studio - Pages Function / Data AccessContent My client has multiple Legal Entities that deal in different Currencies and Ledgers. They wish t…User_2025-02-05-23-08-18-294 42 views 2 comments 0 points Most recent by User_2025-02-05-07-43-41-391
-
Paid Status for invoicesSummary Looking for the table that holds the field displaying the Paid Status for invoicesContent Hi, I am looking for the Oracle table that has the field that displays …
-
Report that tracks receipted PO'sSummary Does anybody have a report that tracks receipted PO's?Content Hi all Just wondering with the accruals of receipted items each month, which reports are being run …
-
Instance details for BI Publisher Report Template - Fusion ERP/SCMSummary Water marking Instance details on BI Publisher Report and EmailingContent We have a requirement to display the Instance name as watermark in some of the BI Publi… -
Does any one know which table stores about Fusion environment refresh information in SAAS..Summary Does any one know which table stores about Fusion environment refresh information in SAAS..Content Hi All, Please let me know if any one know, which database tab…User_2025-02-04-15-10-30-884 42 views 4 comments 3 points Most recent by Maria Centeno-Cloud ERP-Oracle
-
Generate file name at runtime in BI publisherSummary Generate file name at runtime in BI publisherContent Hi We have a requirement to generate the output file name with some custom name appended with timestamp in B…
-
Daily Report that highlights supplier submitted invoicesContent Dear, Please can someone advise how to set up a report that can be scheduled daily to provide us with any new invoices that have been submitted by the supplier s…
-
Data Access by Legal Entity instead of Business UnitSummary How to assign data access to users by Legal Entity using custom Database ResourceContent A client has a requirement for billing managers to manage receivables ac… -
Generate Summary Metrics for Expenses - Scheduled Process & OTBISummary Seeding Data for OTBI Subject Area: Expenses - Employee Expense Overview Real Time via Scheduled Process - Options and FrequencyContent While working through rep… -
GlTrialBalanceReport is not workSummary Standard report General ledger trial balance report giv error fileContent Hi when start run General ledger trial balance report from schadenfreude process error … -
Payments and Batch details should pull into single row with eText templateSummary Payments and Batch details should pull into single row with eText templateContent Hi Friends, eText payment template file using different groups where always hav… -
BI Report using Saas and Paas DataSummary How to access Paas Database data from SaasContent Hi, I have a requirement to develop a BI Report in ERP Saas using data from the ERP and also from a custom we'v…
-
Drill down in fusion BIP ReportsSummary Using drill down functionality in BIP Reports (using BIP template and output in excel)Content Hi, Does anyone use drill down functionality in BIP Reports (using …
-
How to use Seniority Date in Analysis?Summary 19D release includes new Seniority Date fields which I can't figure out how to useContent Hi, According to the documentation for the 19D release, Seniority Date …
-
How to secure ESS LOV by Business UnitSummary How to secure ESS LOV by Business UnitContent How to secure ESS LOV by Business Unit. i.e. There are two Business Units -> BU1 and BU2 I have access only to BU1.…