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
-
Can a customer be setup on Fusion Cloud to be used in both AR and AP (Trading Community ArchitectureSummary Need to be able to issue rebates to customersContent We have to issue rebates to customers on a quarterly basis. It doesn't make sense for us to create credit me… -
Can we keep Job Set trigger in wait queue when multiple processes submitted at same timeSummary Can we keep Job Set trigger in wait queue when multiple processes submitted at same timeContent Hi, We have defined a custom Job Set being triggered from Azure i…
-
Readiness PDF linkContent Previous to 21A update, Readiness docs had both HTML and PDF links. But, now we have only the HTML link. The PDF was very useful for offline viewing. If feasible…
-
Fixed Asset Report- OTBISummary Fixed Asset Report- OTBIContent I created a Fixed Asset OTBI report. The report is working well only recently it starts dropping data. its only reflecting 25000 …
-
ISO Format for the positive pay templateSummary ISO Format for the positive pay templateContent Hello All, We got a requirement for the positive pay in the ISO format but as of now we have only an etext seeded… -
Scheduling jobs using job setContent Hello: We have several processes that need to be run in sequence daily; I was thinking maybe the Job Set was the way to accomplish this; however, after reading t…
-
OTBI Formula HelpSummary Formula help for custom columnsContent Hello, I want to add a couple of custom columns to my OTBI analysis which have formulas in them and I was wondering if som… -
GL Query - Combine Subject Areas in OTBISummary Which subject areas should I combine in OTBI to build a report that provides these parameters?Content Which subject areas should I combine in OTBI to build a rep…
-
OTBI Report that shows the element details field "Description"Summary OTBI Report that shows the element details field "Description"Content I am trying to build a report where I can pull in the field 'Description' on an element. Fo…
-
How to disable Edit option in OTBI Reports?Summary How to disable Edit option in OTBI ReportsContent Need to disable the Edit Option from the OTBI Analysis. Could you please suggest how we can achieve this? -
Newsfeed vs Banner vs PanelSummary Default Home Page Layout OptionsContent Is there a recommended option for Default Home Page Layout? Are there benefits of going with one over the other? Looking … -
Project Invoice DistributionSummary Project Invoice DistributionContent Hello All, I want to know from which table we can get below information:- -
Segment Value Security for Chart of Accounts in Custom BI Publisher reportSummary Enable Segment Value Security for Chart of Accounts in Custom BI Publisher report in bulk modeContent We have a requirement to enable Segment Values Security for…
-
Missing account coding data for Invoices in Workflow tables in PRODContent Hello, We have a custom BI report that tracks the Account coding details for AP Invoices. We are using the workflow tables to get these details. Per my understan… -
BIP Report Error with XDOException: java.sql.SQLSyntaxErrorException: ORA-01722: invalid numberSummary As soon as report is submitted it throws XDOException: java.sql.SQLSyntaxErrorException: ORA-01722: invalid numberCode Snippet WITH tax_cal_datesAS (SELECT (SELE…
-
Influencing the SQL Optimizer in SaaS ERP ApplicationsSummary We have a query that was running perfectly in our non-prod environment for month up until mid December 2020. Then it suddenly timed out and performs poorly.Conte…
-
BI Publisher report with cashing multi-million records query and staggered upload to FTPSummary BIP Maximum Rows for CSV output limit is 2 million. need elegant solution to query database only once for bigger record count and then have staggered upload of r… -
A company wants to sell part of its businessSummary Typical Organization planning for De-MergerContent There is a Company A, who is on oracle Cloud and now it wants to split the business into two parts i.e. Compan…
-
Need number of asset transfers and modifications in 2020Content Hi, I need to find the total number of asset transfers and modifications made in 2020. Is there a BIP query that can return this information please? regards Nige… -
BIP Deeplink in report to view Purchase OrderContent Has anyone added a deeplink in a BIP report to view a PO? Please could you share.
-
Schedule Job Manager in OTBI to export the report output to Object Storage (OCI)Content Is there a way to export an OTBI BI publisher report to object storage (OCI) as part of a Job Manager scheduled job? -
Change Excel Sheet name in BI Publisher TemplateContent Hello, Is it possible to rename the Excel Sheet names of a BI Publisher Template Report [Type xpt] which has default output format as Excel (xlsx) ? I have creat…
-
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…
-
API to Manage Objects in BI CatalogSummary API availability to upload or download BI Catalog objectsContent Is there any working example of managing BI Catalog objects in terms of uploading and downloadin…
-
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 ?
-
General Ledger - Balance Real Time measures are nullSummary when using General Ledger - Balance Real Time OTBI subject area all the measures come back nullContent I have users that are trying to create new OTBI reports fr… -
Best Practice for implementing Financials and then HCMContent My organization has decided to implement Oracle ERP Cloud Financials prior to Oracle ERP Cloud HCM. What considerations should be taken to ensure our minimalist …
-
Listing of all FIN reports in foregin languageContent Hi, Can someone let me know where we can find full list of reports ( jobs) available for Financials offering but with translation on Russian Language? When loggi…