Posts

  • 1-6 of 6
  • Shalindra Singh
    To Extract Order Header and Line details using OTBI5.0
    Topic posted November 26, 2018 by Shalindra SinghBlue Ribbon: 750+ Points, tagged Analyses, OTBI, Reports, Sample Reports in General OBIEE public
    Title:
    To Extract Order Header and Line details using OTBI
    Summary:
    looking for Sample query that works to get Header and line details of available orders using OTBI
    Content:

    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"

  • Shalindra Singh
    Is Orders data available through the OTBI layer in Order...15.0
    Topic posted November 20, 2018 by Shalindra SinghBlue Ribbon: 750+ Points, tagged BI Publisher, OBIEE Answers, OTBI, Report Output, Setup/Administration, SQL in General OBIEE public
    Title:
    Is Orders data available through the OTBI layer in Order Management / SCM?
    Summary:
    Is Orders data available through the OTBI layer in Order Management / SCM?
    Content:

    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.

  • Shalindra Singh
    Does Oracle ERP Cloud Adapter Support Events for Oracle SCM...Answered3
    Topic posted November 8, 2018 by Shalindra SinghBlue Ribbon: 750+ Points, tagged Adapters, Cloud, ERP Cloud, Integration in Integration > Integration public
    Title:
    Does Oracle ERP Cloud Adapter Support Events for Oracle SCM Cloud
    Summary:
    Does Oracle ERP Cloud Adapter Support Events for Oracle SCM Cloud?
    Content:

    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?

     

  • Shalindra Singh
    BIP Reports to Extract Sales Order and related fields from...1
    Topic last edited September 11, 2019 by Shalindra SinghBlue Ribbon: 750+ Points, tagged Reporting in Oracle Analytics public
    Title:
    BIP Reports to Extract Sales Order and related fields from Oracle ERP Cloud
    Summary:
    BIP Reports to Extract Sales Order and related fields from Oracle ERP Cloud
    Content:

    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

    Version:
    Release 13
  • Shalindra Singh
    Are BIP for Oracle SCM Cloud optimized?4
    Topic last edited September 11, 2019 by Shalindra SinghBlue Ribbon: 750+ Points, tagged Reporting in Oracle Analytics public
    Title:
    Are BIP for Oracle SCM Cloud optimized?
    Summary:
    If Reports are called with input parameters, will those column be indexed for better performance
    Content:

    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

    Version:
    11.1.1.7
  • Shalindra Singh
    BIP Report Export and ImportAnswered1
    Topic last edited September 11, 2019 by Shalindra SinghBlue Ribbon: 750+ Points, tagged Reporting in Oracle Analytics public
    Title:
    BIP Report Export and Import
    Summary:
    Can I package all BIP reports created for my integration and export it
    Content:

    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

    Version:
    11.1.1.7