Provide PVO for All tables to allow use the BICC

Saulo Fernandes-Oracle

Organization Name

BR Malls Participacoes SA

Description

The recommended approach for large scale exporting of data from the SaaS is currently the BI Cloud Connector (BICC), but don't exist PVO for all tables available. So is necessary to provide PVO for all tables in the SaaS.

Use Case and Business Need

Currently, not exist PVO for some tables, so we need to use BIP to extract data from the SaaS, but it isn't recommended for a large scale.

Follow some tables without PVO, for example:

IBY_ACCOUNT_OWNERS
IBY_DOCS_PAYABLE_ALL
AR_SYSTEM_PARAMETERS_ALL
JL_BR_AP_BANK_RETURNS_ALL
JL_BR_LOCAL_HOLIDAY_DATES
JL_BR_LOCAL_HOLIDAY_SETS
ZX_TAXES_B

More details

We can't use the approach recommended to extract the data on a large scale. 

Original Idea Number: 70122c82b0

Jeff Hare CPA CISA CIA

Sorry ...  what does PVO stand for?

Saulo Fernandes-Oracle

Public View Object. Each PVO extracts data from a group of tables in the SaaS.

Cecilia Ratto

I agree. This would be very useful when you need to develop custom ESS Jobs using this tables.

Jose Viinanen

I absolutely agree with Saulo.

We are extracting data from HCM Cloud and found that PVO is also not exists for absence DFFs in ANC_PER_ABS_ENTRIES table.