LCann-Oracle — Oracle Analytics

Welcome to the Oracle Analytics Community

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

LCann-Oracle Rank 1 - Community Starter

Comments

  • Another comment on extract vs. nonextract PVOs. The nonextract PVOs are used throughout Fusion Applications just not OTBI/BICC. They contain a lot of columns that are required outside of "reporting". The extract PVOs are scaled down to only include columns deemed required for reporting purposes.
  • If the VO is marked as customized then changes made by Oracle to seed data/starter selections will not get included in extracts. Best practice would be to edit/close (touch, don't need to actually make a change) to get the VO marked as customized. That way any changes coming from Oracle will not affect your extracts/jobs.