BI Cloud Connector
Discussion List
-
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…Kalyan Reddy 61 views 1 comment 0 points Most recent by User_2025-01-28-08-43-27-760 Reporting and Analytics for ERP -
How to setup private key authentication with sFTPContent Hi all, I'm trying to setup a sFTP connection to a vendor using private key authentication. I'm being told that Oracle needs to have a password setup, but the ve…User_2025-02-05-20-24-10-848 37 views 1 comment 0 points Most recent by Mike Borghoff Reporting and Analytics for HCM -
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…Vamshi Mohan 70 views 2 comments 0 points Most recent by Sudha KOVURU Reporting and Analytics for ERP -
How to extract Report from BI publisher Using BICC as a single CSV/zipSummary Not able to extract as a single CSV from a reports of multiple view objectsContent Hi Team, I have a report based on Lead, in which we have customer details, pro… -
Limitations of OTBI reportsContent Can someone please share the limitations on OTBI reporting compared to BI reporting. I'll inputs regarding the performance, number of records/columns that can be…User_2025-02-08-08-48-00-058 626 views 5 comments 0 points Most recent by User_2025-02-08-08-48-00-058 Reporting and Analytics for ERP -
Not-for-Profit Statement of ActivitiesSummary Seeking sample Statement of ActivitiesContent Statement of Activities quantifying revenue and expenses of our not-for-profit entity for a reporting period. The n…User_2025-02-11-03-09-13-126 21 views 0 comments 1 point Most recent by User_2025-02-11-03-09-13-126 Reporting and Analytics for ERP -
Is it possible to customize the output csv file name after job in BICCSummary How to customize the zip file and CSV file after In BICC extract jobContent Hi All, Im exporting fusion application data to OCI using BICC, the file is generatin…Sudheer Vadla 149 views 1 comment 1 point Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
Is there any rest api to run the report and download outputSummary Rest api for BI analysisContent Hi, Is there any rest api availbe to run and BI analysis and download the output. eg: Lead analyis Regards, Sudheer. -
What Role or Privilege should a user get to be able to archive and OTBI reports?Content What Role or Privilege should a user get to be able to archive and OTBI reports? is archive button is not displayed for a user?Walid Hamdy 56 views 2 comments 1 point Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM -
OTBI Analysis error - ODBC driver returned errorSummary I developed an analysis and it works for one user and error for anotherContent Hi All, I created one analysis and it runs find for one user and error to other on…Peoplesoft 50 views 3 comments 1 point Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
What table holds the query associated with an User EntityContent Look for information where in the Fusion Database where the User Entity is stored? Trying to build an extract/report to generate details about a specific user en…Joe Roberts-Oracle 143 views 1 comment 0 points Most recent by Akash Kiran Jana Reporting and Analytics for HCM -
Query to retreive Custom BI Report details in CloudSummary Query to retreive Custom BI Report details in CloudContent Hi Team, Which table will give the information of the custom BI Reports created in Oracle ERP Cloud? T…Abhilash K - Deloitte USI 698 views 7 comments 0 points Most recent by Dharmendra Shukla Reporting and Analytics for ERP -
How to fetch invoice_no and invoice_date from wsh_ tablesSummary Need to fetch invoice_no and invoice_date from wsh_ tablesContent Need to fetch invoice_no and invoice_date from wsh_ tables or from doo_ tablesNageshwaran1 25 views 3 comments 1 point Most recent by Nageshwaran1 Reporting and Analytics for ERP -
Cross posting this idea in ERP Reporting and Analytics forum - ability to Audit OTBI report configurSummary Cross posting this idea - ability to Audit OTBI report configurationsContent Here is an Idea posted in Financials - General that I thought would be of interest t…Jeff Hare CPA CISA CIA 34 views 0 comments 0 points Most recent by Jeff Hare CPA CISA CIA Reporting and Analytics for ERP -
Cash bases accouting reportsSummary Cash bases accouting reportsContent Hi - Any one come across reports requirement on cases bases?if yes, how you Achieved? pls suggest..Sandeep Kumar-245021 28 views 1 comment 0 points Most recent by SandeepPaspunuri Reporting and Analytics for ERP -
Join between wsh_deliveries and rcv_shipmentsSummary Join between wsh_deliveries and rcv_shipments to fetch shipment_num, invoice no & dateContent Join between wsh_deliveries and rcv_shipments tables to fetch shipm…Nageshwaran1 131 views 4 comments 0 points Most recent by Nageshwaran1 Reporting and Analytics for ERP -
Is it possible to create a data source for ERP Cloud from Oracle Analytics Cloud (OAC)?Summary My company is moving to Oracle ERP Cloud, but end users want to still use OAC as the primary source for Reporting and AnalyticsContent My company is moving to Or… -
After 20C OAC DataSync from ERP Cloud fetching 0 recordsSummary We are observing in Data Sync the PVO's are getting 0 records while fetching data from ERP cloudContent We are seeing this currently in all instance where the Da…Kammarapalli Venkatesh-Oracle 45 views 2 comments 1 point Most recent by Kammarapalli Venkatesh-Oracle Reporting and Analytics for ERP -
Need a web service to trigger BI report with multiple parameters.Summary Need a web service to trigger BI report with multiple parameters.Content Hi Team, Can anyone please help me with web service code to trigger a BI report. Basical…User_2025-02-06-09-04-00-039 37 views 4 comments 0 points Most recent by Mallikarjuna Maganti Reporting and Analytics for HCM -
Unable to open/view the xdmz format ( data model) and xdoz format ( report ) uploaded in Report CataSummary Unable to open/view the xdmz format ( data model) and xdoz format ( report ) uploaded in Report Catalog pageContent Hi Team, I'm new to reporting area and need s…User_2025-02-10-05-51-05-868 51 views 3 comments 1 point Most recent by User_2025-01-30-00-54-17-530 Reporting and Analytics for ERP -
From which customer table can we find order_type fieldSummary From which customer table can we find order_type fieldContent Please suggest from which customer table can we find order_type fieldNageshwaran1 55 views 6 comments 0 points Most recent by Pradvin Prabhakar Reporting and Analytics for ERP -
How to Print the attachment in PO ReportSummary We have a requirement to get the attachment from a PO should get displayed on the View PDF document. Kindly SuggestVersion 11.13.20.04.0Yogesh Kumar-234569 146 views 3 comments 0 points Most recent by Lucky Sharma Reporting and Analytics for SCM -
Can we create a multiple selection paramter in the custo ess job?Summary Can we create a multiple selection paramter in the custo ess job?Content Hello , We have create a one custom job for the BIP report and now the users are excepti…Koteswararao Yenikepalli 57 views 1 comment 0 points Most recent by Vikas Tiwari Reporting and Analytics for ERP -
How to get invoice_number against transaction in RA_CUSTOMER_TRX tableSummary How to get invoice_number against transaction in RA_CUSTOMER_TRX tableContent Please help us to get invoice_number against transaction in RA_CUSTOMER_TRX tableNageshwaran1 97 views 5 comments 0 points Most recent by Nageshwaran1 Reporting and Analytics for ERP -
How to give an accees to a user to run custom ess jobSummary How to give an accees to a user to run custom ess jobContent Hello , I have created one custom report and i have creates custom ess job as well , Now i want to g…Koteswararao Yenikepalli 94 views 3 comments 0 points Most recent by Vikas Tiwari Reporting and Analytics for ERP