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
-
SQL Table to bring in Audited by from the AP module to a BI reportSummary SQL Table to bring in Audited by from the AP module to a BI reportContent I am searching for the SQL table to bring in Audited by from the AP module to a BI repo… -
Financial Reporting Studio will not work after installationSummary FRS installed, but error message says it is not installed.Content FRS was installed according to Doc ID 2051105.1, and computer shut down and rebooted. Get the f…
-
In Fusion Applications Update 19D, Oracle will discontinue the Direct Database QueryContent Dear , In Fusion Applications Update 19D, Oracle will discontinue the Direct Database Query. meaning you will no longer be able to create, modify or run these ty…
-
Drill to Fusion from a BI Publisher ReportContent Hi, I have created a very useful data model that will allow our users to search for payments, what I would like to do is link the invoice numbers to oracle fusio… -
ESS Jobs to be run to create Cube'sContent Hi Team, Can you please let me know the list of steps to be run to publish the data to cube, so that we can design FRS reports. I'm working on FRS reports, when …
-
Expenses Overview Real Time subject areaSummary A summarization program needs to be run to gather information before data is available in this area.Content We are creating some test reports from the Expenses O… -
manager data access for usersSummary manage data access for users - users without data accessContent On Manager data access for user page what sql or tables do i use to get USERS WITHOUT Data Access…
-
Reports based on SaaS extensions built in PaaSSummary How to created reports consolidating data from JCS-SX and ERP CloudContent Does any one have a documentation or experience on what's is the best way to achive th… -
Barcode in ReportContent Hi, I have requirement to print barcode in the invoice report and let me know how to progress on this Barcode number in invoice report will be in the format of … -
created_by or last_updated_by - how to find username on those fieldsSummary created_by or last_updated_by - how to find username on those fieldsContent in gl.created_by and gl.last_updated_by I get a number or email address. How do i get…
-
otbi procurement subject areaSummary Has any one used procure to pay real time and pruchasing real time subject area togetherContent I am trying to get po number ,invoice number from procure to pay …
-
Oracle BIP Report RTF Template - Distribution Accounting Date DisplaySummary Oracle BIP Report RTF Template - Distribution Accounting Date DisplayContent Hi All, Hope you are doing well. Could you please suggest me on below rtf template r…
-
New Cost Center Name Displays DifferentSummary New Cost Centre Name Displays Different FRS Rerport ParametersContent I have created a new Cost Centre, by adding its value in the 'Value Set Values' for the Cos…
-
Remove SpaceContent Hi, Below is the query which concatenates all the category names and provides in single column value which works fine. I have registered this report as ESS Job w…
-
Balance Sheet totals different for different usersSummary Balance Sheet totals are different for two different users, same reportContent Two users in our office have opened the same Balance Sheet report, same parameters…User_2025-01-31-00-03-48-847 34 views 5 comments 0 points Most recent by User_2025-01-28-21-13-11-074
-
List of Seeded OTBI reports in Oracle ERP CloudSummary List of Seeded OTBI reports in Oracle ERP CloudContent Hi, Is there a way to get the list of seeded OTBI reports from our instance? I would also like to query th… -
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… -
Can we find all scheduled BI Reports instead of navigating to each reportSummary Can we find all scheduled BI Reports instead of navigating to each reportContent I was trying to find if we can find all scheduled BI Reports instead of navigati…
-
Public Sector - budget to actualsSummary Budget to Actuals reports in Public SectorContent Hello, Have any other public sector Oracle Cloud users developed a good budget to actuals report? We have one t… -
Print Receivables Transactions: Email Delivery --Override email address for non prod instanceSummary How to override or block emails to customers in non prod instanceContent For Print Receivables Transactions-Email Delivery , Is it possible to have an override e…
-
OTBI computed field and graphSummary creating computed field and graphContent Hi all, I am very new to Oracle Fusion business intelligence. Background: * Fusion 19C * try to analyze the company's em…User_2025-02-06-11-24-12-541 40 views 0 comments 2 points Most recent by User_2025-02-06-11-24-12-541
-
Receiving Error When Prompting Values from Field Created from a Case StatementSummary Cannot function ship the following expression: EVALUATE. (HY000)Content I have created a Dashboard Analysis and Prompt from the following subject area: Subledger…User_2025-02-05-07-37-39-271 23 views 0 comments 1 point Most recent by User_2025-02-05-07-37-39-271
-
Security setup for users who are creating BI reportsSummary What job role does an employee require to create and run BI reportsContent Morning everyone, We are currently implementing Oracle Expense Cloud. Our BI team has …
-
"Apps Document Currency Code" in Procurement - Procure To Pay Real TimeSummary "Invoice Currency" missing in Procurement - Procure To Pay Real Time Subject Area.Content In 19B version, the invoice currency seems to be missing in Procurement…
-
XML Structure of BIP reportContent Hi, I need to create a BIP report which is extracted as an XML. Below is the sample xml structure and sample XSD. How do I define an attribute of an element whil…
-
Prompts is not showing in reporting analyticsContent While running reports in report analytics the defined prompt is not appearing but the prompt is showing under browse catalog page. can you please give me input t… -
PO-Requisition cross-subject area reportSummary PO-Requisition cross-subject area report in fusion saasContent I am trying to create a simple cross-subject OTBI Analysis to display PO details alongwith the Req…
-
What role can be assigned to give a user OTBI access for report writing?Summary What role can be assigned to give a user OTBI access for report writing?Content What role can be assigned to a user for OTBI access for report writing? I can see…User_2025-01-31-00-03-48-847 106 views 6 comments 1 point Most recent by User_2025-01-31-00-03-48-847
-
Changes to BIP report are not reflectingSummary Changes to BIP report are not reflecting in the data. We have changed few columns in the Dataset but the report output displays old column data.Content Changes t… -
Journal Entry Reserve LedgerSummary Customization of the Journal Entry Reserve LedgerContent I'm customising the Journal Entry Reserve Ledger report - I am trying to add new data columns and change…