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
Problems that run through this table
What the extract does not carry · The export ceiling · The extraction pattern