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
-
Which table stores 'Transaction Number' in Project CostsSummary Looking for backend table that stores 'Transaction Number' in Project CostsContent Hi All, I'm looking for backend table that stores 'Transaction Number' in Proj… -
Reports with hardcoded parameters performing better then those with bind variablesContent Hello, We have a peculiar problem, we have a query for gl balances report which when run by hardcoding the Legal entity and period runs fine fetching all our dat…
-
Error in BI Desktop InstallationContent Hi, During BI Desktop installation I finding the error as attached any inputs will be helpful Download URL : https://www.oracle.com/middleware/technologies/busin… -
Change Order History on POSummary Status, Amount and Qty of POContent Hello, How and what fusion tables can I get the status, calculated amount and quantity of a change order? Basically get the l…
-
Tools for backing up, managing version history of BIP ReportsSummary Looking for tips on how others are backing up or managing versions of BIP reports.Content Our team is exploring the idea of using BitBucket or GitHub (or another… -
Policy Predicate ErrorSummary When querying some tables and views we are getting Policy Predicate ErrorContent Selecting data from per_person_names_f or hz_parties is giving a policy predicat… -
OBIEE 12c / Financial Reporting Studio usage with Oracle Fusion Financial CloudSummary Financial Reporting Studio for Customized Reporting needContent Hi, With earlier releases of on premise ERP products from Oracle we used OBIA for any seeded / cu…
-
eText Template for Payment BatchContent Hi, In the delimited eText Template it works fine when payment is made for single invoice for a supplier. If invoice batch is submitted (which has more than one …
-
Validation in eText TemplateContent Hi, I need to have validation on the payment date if the payment is made after 17 00 on Friday it should print Monday as payment date For example if the payment …
-
ORDSSummary Ad Hoc Question on Oracle REST Data ServicesContent Is ORDS free if you use Fusion SaaS? I went to a presentation on Oracle Rest Data Services at Open World and …
-
Report on Chart of Account Additions/Revision and CancellationSummary Report on Chart of Account Additions/Revision and CancellationContent Hi, Do we have any seeded report in Fusion Financial which gives details information Chart …
-
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 32 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…