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
-
In Cloud Data Model, is combining multiple Select using "With" Statement with trailing joins allowedSummary: Hi R&A forum: In a Data Model for Cloud ERP or Cloud HCM, is SQL beginning "WITH ( as " allowed ? See Code snippet. Thank you, Content (required): In a Data Mod… -
need to connect oracle data from php or via MS power bi to retrieve dataSummary: need to connect oracle data from php or via MS power bi to retrieve data Content (required): need to connect oracle data from php or via MS power bi to retrieve… -
Getting the error 'ORA-31011: XML parsing failed' when calling the SAAS report through webserviceSummary: I am getting the below error when calling the SAAS report through webservice call from my pl/sql procedure. 400 Bad Request 400 Bad… -
Any AP standard dash boardSummary: Hi, We are looking for any standard AP dash board for information like AP Aging, Supplier spending which can be enabled Content (required): Version (include the…
-
Location of Tax Recovery Rate used for requisition or Purchase Orders in data tablesSummary: I'm trying to find where in the data tables the Tax Recovery Rate used on a requisition or a Purchase Order is stored. Content (required): This is the Tax Rate …
-
Unable to see Creation date of Project Enterprise Resources in any subject areasSummary: We have below requirements:- Report to be sent to resource pool manager when a resource with back dated date is entered (for ex: Resource is created with date 0…
-
Dynamic recipient email to be picked from OTBI analysis columnsSummary: We prepared an OTBI report where tasks to be started on the current date, task owner, task owner email, and project manager email is displayed. We need to sched…
-
CASDK-0004 Connectivity Error Between OIC And ERP Using OAuth Security PolicyHi Experts , We are trying to establish connectivity between ERP and OIC. In OIC we are using ERP adaptor to connect to fusion. We intend to use OAuth Authorization Code…
-
Access to Vertex Tax Error reports - not displaying in scheduled processesWe use Vertex for tax calculations and in the document referenced below, there is an error report that should be available via Scheduled Processes. I'm on the admin team… -
Send Report to Employee That Have a Certain RoleSummary: Our finance team is interested in scheduling a report to be sent to any employee who has a particular role. The report should have parameters set to filter for … -
How to create Dependent List of Values parameter in ESS Job with User-defined (SQL) LOV as SourceSummary: I would like to know if it is possible to create a parameter in an ESS Job that is dependent on another LOV parameter that has a User-defined (SQL) LOV Source. …
-
How to encrypt the bip report response with SOAP web serviceSummary: Hi Experts Currently the response from the SOAP web service returns the BIP report data in base64 encoded format but I want to encrypt the response in some othe…
-
How to send large attachments in BIP email deliverySummary: How to send large attachments in BIP email delivery Content (required): Email delivery failed in BIP for large report output. Below is the error, 'emailOutbox r…
-
CASE WHEN Formula Not Displaying CorrectlySummary: CASE WHEN STATEMENT shows two different results pending the format export Content (required): I'm using the following CASE WHEN statement to label a value eithe…
-
Fixed assets OTBI cross-subject area reportingI have created a dashboard based on the Subject Area Fixed Assets - Asset Depreciation Real Time. My colleague is asking me to filter the records based on the asset stat… -
Is it possible to create a tile which will open a BI report?Summary: Is it possible to create a tile which will open a BI report? Content (required): Hello We would like to add a tile to the Procurement tab, that when you open th…
-
OTBI Analysis - How to pass only Date for column that is having date and timeSummary: Content (required): The below condition is failing as Application Creation Date is returning date with timestamp and Current_date is returning only date. Applic…
-
Delete BI Folder with permission set to OpenSummary: Delete option Enabled even when permission is set to Open Content (required): With admin user we created the following folder structure Shared Folders>Custom>Cu…
-
Need to perform YTD calculation over ap_checks_all for reportSummary: Hi Forum: my customer would like to insert a YTD column right after Payment_Amount (SQL is over ap_checks_all) but there is no seeded YTD in ap_checks_all table…
-
Oracle BIP or OTBI reports output in Non-English languages in Oracle Fusion Financials (SaaS)Summary: Oracle BIP or OTBI reports output in Non-English languages Content (required): Hi Team , We are looking for the Oracle BIP or OTBI reports output should be in H…
-
Provision a Vision Demo Instance for Customer WorkshopSummary: We are going to conduct the initial round of the requirement gathering workshop for a customer. Can I know if there is option for us to provision a Vision demo …
-
Bursting To FTP server Not WorkingSummary: Bursting To FTP server Not Working Content (required): Hi All, I have developed one report where I want to place the file in the ftp server and for that i have …
-
How to work with Multiple selection and NVL function In ParameterSummary: How to work with Multiple selection and NVL function Content (required): Hi All, Hope everyone is doing well. I have a below requirement for which i need you he…
-
Fusion UI personalization not reflected immediatelySummary: Fusion UI personalization not reflected immediately Content (required): Hi Experts, We created one DFF for GST number and this field should be mandatory when th…
-
Need recommendation for Printer Model for Label Printing for a Manufacturing ClientSummary: Hi Team, we are trying to find recommendation for Printer Model for Label Printing for a Manufacturing Client. Any help you can provide would be really helpful.… -
A fresh environment with no dataSummary: A fresh environment with no data Content (required): Dear all, I would like to ask if a test or production instance can be refreshed, but not as p2t or t2t, so … -
Unable to view xml tags in RTF templateSummary: Content (required): Hello all, I'm facing difficulty in editing old custom reports and seeded reports since the XML tags are not visible as they should be. For … -
Unable to print from ERP cloud to on-premise Print serverSummary: We implemented in Integration between Oracle ERP Cloud and On-Premise print server as mentioned in Doc ID 1964157.1 and completed all steps mentioned in above d…
-
Would anyone with experience with OTBI be willing to serve on a panel with OATUG ERP CLoud SIG?Summary: I am the VP of the OATUG ERP Cloud SIG who is hosting a panel in September called " ERP / HCM Cloud: OTBI, Third Party – lessons learned / improvement opportuni… -
How to run seeded PO Dashboard from the Procurement iconSummary: How to run seeded Dashboard from the Procurement springboard icon Content (required): Hello There is one PO Dashboard and the users wants to run from the Procur…