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

Antara Roy Chowdhury

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.

Mallikarjuna Kuppauru-Oracle

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