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
-
Report on LicencesSummary Self licence audit processContent Hi All, I have a report that shows me the Users by Service we are subscribed to, but I am wondering if anyone has put together … -
OTBI analysis timeoutContent Hi, we have a customized OTBI analysis report in sharefolder. Some users could run the report successfully serveral months ago, but recently they can't get the r…
-
Stop Email Bursting on Lower EnvironmentsSummary Prevent Seeded Process to Send EmailsContent Hi Experts, Need Help!! Recently we had got Production environment cloned to Test, so the data was also occupied, Th…
-
Ability to Act as another user in OTBISummary In OBIEE on premise we have the capability to 'Act As' another user is this available in OTBIContent Wanted to find out if anyone knows if the ‘Act As’ functiona… -
Add a custom calculation columnSummary I want to add a couple of columns into my analysis which contain custom formulasContent Hello, I am sure this is a very simple answer but I was hoping someone wo…
-
query to get ar receipt reversal reason nameContent when i reverse receipt.i entered a reason i need a query to get a reason name
-
get balance for each rowContent invoice amount receipt amount balance 100000 30000 70000 40000 30000 30000 0 how can i get balance value using bi ?
-
who open report ?Content after xreated report , i need to know who(user) open report ? and time ?
-
OTBI Report on Cross subject areasSummary PPM-AP Cross subject area reportContent We are implementing fusion Financials and PPM. The current practice is, project managers in PPM get to know the details o…
-
R13.18A OTBI BI Catalog LockdownSummary With 13.18A release customers will no longer be able to modify the shipped BI catalog content.Content R13.18A OTBI Product Alert This product alert is published … -
Payables invoices consolidated to 1 currency in OTBISummary Write report for AP Invoices from different BUContent We have many business units in our system and each of them are having different ledger currency. We would l…
-
Do we have the same/similar reports from fusion cloudSummary Do we have the same/similar reports from fusion cloudContent All, Do we have the same/similar reports from fusion cloud Miscellaneous Receipts Register EBS R12 R…
-
Date format issue with Excel template in BIPSummary Date format issue with Excel template in BIPContent Hi Friends, We have date format issues while using Excel template in BIP so could you please suggest if anyon… -
each query in sheet on excelContent on bi i created a report with 3 query. i need each query exist in separate sheet on excel.
-
Report timeoutContent Hi, One BI report is timing out in the shared folders. But the same report is completing perfectly fine in local folder. Any suggestions? Thank you. Added the be… -
Raw data extraction from Oracle Fusion to Datalake/SFTP serverSummary Exporting data from Oracle Fusion to SFTP Server - Unable to handle systematic deletesContent Hi All, We have a requirement where we need to push raw data into a…
-
Custom Job running concurrently & seeded program running sequentiallySummary Custom Job running concurrently & seeded program running sequentiallyContent We have developed the custom program basing on seeded program. Where we noticed cust… -
How to get the back dated(History Record) data using OTBI Real Time Subject Area for Finance Module.Content Hi All, Good Day !!! Can any one help me how to get back dated(History Record) data using OTBI Real Time Subject Area to create report like Aging Report etc., Re…
-
OTBI Administrations security manage privileges changes impact of upgradesSummary Are changes to OTBI Administrations security manage privileges need to be reapplied after upgradesContent We would like to make some additional features of OTBI …
-
Reporting from both Oracle ERP Cloud and PaaSSummary How to build report using data from both Oracle ERP Cloud and PaaSContent How to build a report using data from both Oracle ERP Cloud and PaaS? What are the vari… -
OTBI Procurement Subject Area shows Communication Date same for Original and Change Order PO DocumenSummary OTBI Procurement Subject Area shows Communication Date same for Original and Change Order PO DocumentContent Hi, We got to see that PO Communication date to supp…
-
How to restrict Audit Reports on basis of AORSummary How to restrict Audit Reports on basis of AORContent Hi All, I have a requirement to restrict data access on the output of Audit reports via Navigator - Tools - … -
How to create custom OTBI Subject Areas in Oracle CloudSummary How to create custom OTBI Subject Areas in Oracle CloudContent Hi Experts, My client is Oracle cloud 20 C. My client have non oracle application that contain pro…
-
Warning for payment with 0 amountSummary Warning for payment with 0 amountContent Sometimes we need to adjust the invoice amount by creating a debit memo and after that make payment for these 2 transact… -
Explore the VBA code of ADF SpreadsheetSummary Explore the VBA code of ADF SpreadsheetContent I want to explore the VBA code of the ADF Spreadsheet. is there generic password for that ? -
OTBI AP invoices detailsSummary OTBI AP invoices detailsContent I created a report for AP unpaid invoices my question is how I can make a hyperlink to the invoice number to open the invoice dir…
-
How to export a report to a CSV format?Content Hi team, I create a a simple table format data set, and create a simple layout by this data set. I'd like to view this report on CSV format, but the result does …
-
Using Task Number instead of Task IDSummary I want to use Task Number as a Prompt but when i am searching with task number. system search with task IDContent Hi, I am using Task Number value in a Prompt. M… -
Fiscal Year format has commaSummary Is there anyway to change the default format of Fiscal Year in OTBI to remove the ','Content While in OTBI it appears that all of the finical subject areas that …
-
Remove last page and logoContent Hi, In the AR invoice report which is run using Print Receivables Transaction the report runs for 132 pages everything is fine but found that it is printing last…