BICC Extract PVO Availability for POR and DOO Tables

Question

Hi Community,

We are currently working on a data integration setup where we extract Procurement and Order Management-related data into our data warehouse using Oracle Data Integrator (ODI) via BICC.

Could you please help confirm if there are any existing ExtractPVOs available that cover the following tables?

* POR_INFO_TEMPLATES_ALL_B
* POR_REQ_INFO_TEMPLATE_VALUES
* DOO_FULFILL_LINES_EFF_B

These are essential for our reporting needs. If there are no direct PVOs available, any guidance on alternate approaches or custom extract options would also be appreciated.

Thanks in advance for your support!

Best regards,

Partha

RVohra · Answer

If you have checked PVOs and did not find anything then try building a small BIP report that selects from the needed tables (with appropriate security filters), schedule it to output a flat file (CSV/Excel), and load that output into your ETL pipeline.

Bhaskar Konar · Answer

https://community.oracle.com/products/oracleanalytics/discussion/25490/bicc-extract-pvo-availability-for-por-and-doo-tables

Hi @ParthaK,

Welcome to the Oracle Analytics Community.

Please note BICC is not an Oracle Analytics product, it's part of the Fusion family. Fusion applications are covered in the following forum:

https://community.oracle.com/customerconnect

Please take a look. It has multiple categories and pick the one that sounds like being the most adapted and raise your query accordingly.

Thank you.