Oracle Analytics Publisher

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Publisher

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Unable to find PVOs for BICC extract for the views CTO_MATCH_V, CTO_SALES_V

Received Response
1
Views
1
Comments
Antara Roy Chowdhury
Antara Roy Chowdhury Rank 1 - Community Starter
in Oracle Analytics Publisher

We need to extract data related to Configured Item Structure from Supply Chain Orchestration using Oracle Integration Cloud. As per Oracle recommendation we cannot use BIP Report to extract data as this would be an Anti pattern. Therefore we need to know the PVOs available for the extracting this data through BICC, related to the tables and views CTO_MATCH_V, CTO_SALES_V, CTO_MATCH_HEADERS, CTO_MATCH_LINES. Additionally if there is any other way (REST API or any other extraction method other than BIP) to extract this data we would guidance for the same.

Answers

  • Mallikarjuna Kuppauru-Oracle
    Mallikarjuna Kuppauru-Oracle Rank 8 - Analytics Strategist

    Hi @Antara Roy Chowdhury

    Welcome to the Oracle Analytics BI Publisher Online Forum!

    To enhance your experience and foster meaningful interactions, we encourage you to personalize your profile by setting up a display name and uploading a profile picture. Your display name will be how others recognize and engage with you in discussions, while a profile picture adds a personal touch to your forum presence. Take a moment to update your profile with a display name and an image representing you. Let's create a vibrant and engaging community together!

    As per your question, your looking for an PVO for SCM application.

    use Below to get the help/answer for your question ?

    Fusion covered in a parallel forum (the question can't be moved there):

    https://community.oracle.com/customerconnect

    Regards,

    Arjun