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
-
Non - standard SQL data model bind to different templatesSummary Non - standard SQL data model bind to different templatesContent Hi there I was wondering if it was possible to bind a non-standard SQL query parameter to a Repo…User_2025-02-05-10-38-08-223 24 views 3 comments 0 points Most recent by User_2025-02-05-10-38-08-223 -
Dynamic Logo in FRS reportsSummary Dynamic Logo in FRS reportsContent Hi All, Can we have company logo derived dynamically in FRS reports ? Thanks Version 19C
-
BI Publisher Run report Rest API Call Unsuccessful.Summary Trying to access the Run Report Rest API for BI Publisher but without success.Content Hi there, I'm trying to run a POST request against the RunReport task withi…
-
Fusion table which store all Data Model SQL?Content Hi, Can anyone share Fusion table(s) which stores SQL's of all data models? Thanks, Rinku -
Cash to General Ledger Reconciliation ReportSummary Cash to General Ledger Reconciliation BI ReportContent Hi Friends, Did anybody Customized " Cash to General Ledger Reconciliation Report" or developed new report…
-
Deep Link for AR Invoice creationSummary Deep Link for AR Invoice creationContent We were going through document 'Drill down from OTBI adhoc reports to Receivables' and there is Deep link for AR invoice…
-
OTBI HOW TO TURN MEASURE COLUMN INTO YTDSummary OTBI HOW TO TURN MEASURE COLUMN INTO YTDContent Hi Xavier, As per the below the YTD amount gets calculated from 1/Jan to till date. However we have requirment to…
-
OOTB BI Report that can show me enabled and opt in featuresSummary Is there an OOTB BI Report that can show me enabled and opt in featuresContent Hello Does anyone know if there is an OOTB BI Report that can show me which featur…
-
Error while customizing BI Publisher ReportSummary We are trying to customize the Account Analysis Report (ESS Job Name - Account Analysis Report) but getting error while trying to modify the data modelContent Hi… -
Permissions or custom roles to view only OTBI or BIP reportsSummary I need to enable a SCM roles users to just display custom financial reports which created by using BI publisher or OTBI.Content I need to enable a SCM roles user…
-
New Ledger Creation Needed for Private Equity acquisition - Best Practice?Summary Are there Best Practices for new Ledger following acquisiton of our company?Content Our company, MyEyeDr, has been re-acquired by a new Private Equity (PE) firm …
-
View future scheduled ESS jobs in SaaSSummary We have a requirement to extract the future scheduled jobs for a user.Content Test Case: Admin wants to know what are the future jobs scheduled for a user. In ca…
-
GeoCoding for locations attached to business unitsContent Hello, This might not be the right forum but not sure where to post it. We have a requirement where we would want to know the latitude and longitude information …
-
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 & …
-
Edit InfoletsSummary Roles required for editing InfoletsContent Hello - I am in the ERP Cloud application and I can see the OOB inflolets and able to view them. I do not see the edit…
-
FRS - Member Descriptions and AliasSummary Alias concatenating Name and Description, and Description is blankContent Can anyone help explain why the Member Alias (Default) in FRS merges the Value and the …
-
MOAC in BIP ReportsSummary Implementing MOAC in BIP ReportsContent Hello,Trying to implement security based on the role assigned to a user. Following below note, however, have not been abl…
-
BIP Report ParamtersSummary BIP Output via ScheduleContent Hello - I scheduled a BIP report and the export output shows the parameters as columns in the excel file. The requirement is such …
-
Inventory List of Stored ProceduresSummary Looking for documentation on delivered stored proceduresContent Where can I find more information about the stored procedures that can be called from BI Publishe… -
DFF Updates / AlertsContent Hi Team, Can we get alert when the DFF is updated or changed by user and can we know who changed it. Regards, Sridhar -
What is the best option for incremental extracts in Procurement Cloud 19aSummary What is the best option for incremental extracts in Procurement Cloud 19aContent We have a requirement to extract PO information on the basis of an incremental u… -
BIP ParametersSummary Add parameter details to report at exportContent I have a requirement to show parameters while exporting a BIP report. When I export the report in an excel I do …
-
Couldn't Integrate a OTBI report including Project details and Project Contract DetailsSummary Can i Create an OTBI Report combining Project Details and Project Contract DetailsContent When i create new OTBI report add in it Projects details from subject a… -
BI Publisher : Setup Data Source and extract data from itContent Hi, In BI Publisher, I am looking to setup a new data source to extract specific business unit related from it in the data model. Also, Out of all the data sourc…
-
OTBI/BIP Reporting Gap AnalysisSummary Implementing Oracle ERP in all 3 modules ( HCM,SCM & Finance)Content Hi, In the process of implementing Oracle ERP modules, there are many custom reports to be b…
-
How to add account flex field as parameter for custom BIP reportSummary How to add account flex field as parameter for custom BIP reportContent Hi All - I have requirement to create custom BIP report which has to developed around GL …
-
Report on email approvalSummary How to obtain email approval information?Content We have a requirement to analyse our Fusion user population and check who have/have not logged into the system r…
-
ERP Developer LicenseSummary Financials IntegratoinContent I'm new to Oracle Financials. I'm interested in building a connector between Oracle Financials and another product. I was curious t…
-
Multiple Parameter List - With 2 Column Values Concatenated (BI Publisher)Summary ORA-00909: invalid number of arguments message when executing report with multiple parms.Content It is a business requirement to have Cost Centre code and Descri…
-
Comprehensive Reporting Role in Fusion CloudSummary Role that has Access to all the Subject Areas/Dashboards/Reports. (Object Level as well as Data Level)Content Do we have a role other than BI Administrator that …