For partners that build or integrate commercially available applications and service solutions with the Oracle Cloud Platform
For partners that provide implementation or managed services around Oracle Cloud Applications
Hi,
Can someone please provide me working sample query for OTBI. I am sure I am missing something because when I provide below query I do not get error but I also do not get any records while I know for the facts that orders do exits in the application as I also created few of them.
select_physical
headerId, OrderNumber
from "FscmTopModelAM.DooTopAM.Header"
Is Orders data available through the OTBI layer in Order Management / SCM?
Reason I am asking because when I querying direct table (doo_header_all) via BI Publisher, I get the data from this table.
But when I use 'Issue SQL' on OTBI Administration section and write following query -
select_physical
headerId, OrderNumber
from "FscmTopModelAM.DooTopAM.Header"
I don't get any records.
I need your help as I was asked not to use BI Publisher for data extraction (where I want order and line data to be extracted in every 10 minutes) hence evaluating data sync tool but I do not get any data when I used above query.
I have a requirement to capture events from Oracle SCM Cloud and Order Management. For Example, Whenever there is a new Sales order gets created or updated event should be sent. My question here is, does Oracle SCM Cloud support events and if yes, can I use ERP cloud adapter to capture those events on OIC?
Hi Experts,
I have requirement to pull Sales Orders information for analytics purpose where I need to show total numbers of Sales Orders grouped by Statuses, customers, type of items, regions etc.
I am looking for if there is any existing data model that I can use for this? If not, can someone suggest me the query that I would need to build a model?
I also need to extract delta Sales Orders from ERP Cloud in scheduled intervals. After looking into Tables like
DOO_HEADERS_ALL, DOO_LINES_ALL I realized that last_update_date is not indexed. What should my model query look like for these delta extracts?
Thanks
Shalindra Singh
I am new to BI Publisher. I am planning to create the new data models and BIP reports to extract data out from Oracle SCM cloud. Therefore I wanted to know if the BIP Reports and Data model created can be exported as a package from test instance of SCM cloud and can be imported into the production instance of SCM Cloud?
Thanks
Shalindra Singh
Hi,
If I create custom Data Model and Report on BI Publisher and provide input parameters like startDate and endDate where StartDate and EndDate will apply in Last Modified Date of a certain table. Will Last Modified Date column be indexed for better performance?
How to get information on which column as input parameter will give better performance in the large data table and which will not? This is important for me to know before I start creating BI publisher report to extract data out from Oracle SCM cloud for analytical purpose.
Thanks
Shalindra Singh