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…
-
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…
-
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…
-
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…
-
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… -
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…
-
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.…
-
Combing OTBI Output in one rowSummary Combing OTBI Output in one rowContent I'm using the subject area "Project Costing - Actual Real Time" to result Debits and Credits of Project Cost Expenditure Li…
-
BICS migration to OACSummary BICS migration to OACContent Hi All we have BICS on Paas which is not implemented yet and Oracle recommend to migrate to OAC. We need to know do we really need t…
-
Sales Credit information not available in Projects - Cross Subject Area Analysis - Real TimeSummary Sales Credit information not avaible in Projects - Cross Subject Area Analysis - Real TimeContent Sales credit information such as salesperson name, percent, sta…
-
ESS Job Definition Table NameSummary Which Table Stores the ESS Job Definition Table NameContent Good People, I am just asking the Table Name / View Name that stored the ESS Job Definition Details ,… -
"Supplier - Supplier Real Time"."- General"."Alternate Site Name" with Error: 14025Summary While developing an OTBI Report using two Subject Areas ( "Payables Invoices - Transactions Real Time" and "Supplier - Supplier Real Time"), "Supplier - Supplier…
-
R13 Avaliable Cloud Reports in ExcelSummary Avaliable Cloud Reports in ExcelContent Hello : I was wondering if you can share with me the avaliable Cloud Reports in Excel. Thanks for your help Best Regards
-
In Oracle Fusion 20A update Data models will be discontinue or not?Content Dear All, In Oracle Fusion 20A update Data models will be discontinue or not?. And you have to migrate your reports which is created on data models. Can anyone k…