Analytics Catalog/Data dictionary/VCS_COLLAB_ENT_HIST
Explore the catalogReportsModulesEnterprise modelOTBI subject areasBICC PVOs
Oracle Fusion · Data dictionary

VCS_COLLAB_ENT_HIST

SharedUsed in 1 subject areas29 reporting columns

history / audit log.

Primary key: not yet catalogued for VCS_COLLAB_ENT_HIST — reference Oracle Tables & Views guide.

Columns

ColumnKeyIn reportsDescription (inferred)
BUCKET_COUNT_CH_MONTHLYBucket count ch monthly.
BUCKET_COUNT_CH_WEEKLYBucket count ch weekly.
BUCKET_COUNT_FH_MONTHLYBucket count fh monthly.
BUCKET_COUNT_FH_WEEKLYBucket count fh weekly.
COLLAB_SOURCE_IDIdentifier for the collab source.
COLLAB_UOMCollab unit of measure.
COMMIT_DATECommit date.
COMMIT_DUE_DATECommit due date.
COMMIT_HORIZON_CQTYCommit horizon cqty.
COMMIT_HORIZON_END_DATECommit horizon end date.
COMMIT_HORIZON_FQTYCommit horizon fqty.
COMMIT_MISMATCH_COUNT_MONTHLYCommit mismatch count monthly.
COMMIT_MISMATCH_COUNT_WEEKLYCommit mismatch count weekly.
CTF_MAPE_MONTHLYCtf mape monthly.
CTF_MAPE_WEEKLYCtf mape weekly.
FORECAST_CHANGE_COUNT_MONTHLYForecast change count monthly.
FORECAST_CHANGE_COUNT_WEEKLYForecast change count weekly.
FORECAST_CHANGE_MAPE_MONTHLYForecast change mape monthly.
FORECAST_CHANGE_MAPE_WEEKLYForecast change mape weekly.
FORECAST_HORIZON_END_DATEForecast horizon end date.
FORECAST_HORIZON_FQTYForecast horizon fqty.
LAST_PUBLISHED_PLAN_NAMEName of the last published plan.
MAX_FORECAST_VERSIONMax forecast version.
NOTE_TO_PLANNERNote to planner.
NOTE_TO_SUPPLIERNote to supplier.
PUBLISHED_DATEPublished date.
PUBLISH_BY_PARTYPublish by party.
PUBLISH_CYCLE_END_DATEPublish cycle end date.
PUBLISH_CYCLE_START_DATEPublish cycle start date.

Used by reports

No cataloged report reads from this table yet — it's part of the broader Fusion dictionary.

Where this surfaces in OTBI

The OTBI subject areas that expose this table. You can't join across them in OTBI — the owned conformed model joins them on shared keys.

Need the extract + dbt staging for VCS_COLLAB_ENT_HIST?
We ship parameterized SQL, BICC config, and dbt models you own.
Talk to us