Predefined Lookups in Supply Chain Collaboration

The following table lists the predefined lookups available for Oracle Fusion Supply Chain Collaboration:

Lookup Name

Usage

Lookup Value

Description

ORA_VCS_AGGREG_LEVEL

  • This is a list of bucket forecast aggregation levels that are displayed in the pivot table

  • System lookup

  • No extension possible

ORA_VCS_WEEK_DAY

ORA_VCS_PERIOD_DAY

ORA_VCS_PERIOD_WEEK

  • Aggregation of data by a week and a day in the pivot table

  • Aggregation of data for a defined period and a day in the pivot table

  • Aggregation of data for a defined period and a week in the pivot table

ORA_VCS_COLLAB_TYPE_CODE

  • This is a list of collaboration type codes that are allowed

  • System lookup

  • No extension possible

ORA_VCS_SUPPLY_PLAN

Collaboration on supply forecast with external partners

ORA_VCS_PLAN_BUCKET_TYPE

  • This is a list of bucket types that are allowed

  • System lookup

  • No extension possible

ORA_VCS_DAILY

ORA_VCS_WEEKLY

ORA_VCS_MONTHLY

  • Daily bucket

  • Weekly bucket

  • Monthly bucket

ORA_VCS_PLAN_EDIT_OPTIONS

  • This is a list of options that are available to perform a mass update to a forecast document

  • System lookup

  • No extension possible

ORA_VCS_CURRENT_FORECAST_VAL

ORA_VCS_PREVIOUS_COMMIT_VAL

ORA_VCS_INPUT_VAL

  • Populate the committed quantity for all selected records with the forecast value

  • Populate the committed quantity for all selected records with the previous committed value

  • Populate the committed quantity for all selected records with the value provided

ORA_VCS_PLAN_WATCHLIST

  • This is the collaboration plan watch list category

  • System lookup

  • No extension possible

ORA_VCS_PLAN_ENT_USER_SAVED

Collaboration plan search saved by a user

ORA_VCS_PROCESS_STATUS

  • This is a list of statuses of the forecast commitment process

  • System lookup

  • No extension possible

SUCCESS

FAILURE

PARTIAL SUCCESS

IN_PROCESS

  • Status if all records are processed successfully

  • Status if no records are processed successfully

  • Status if some records are processed successfully

  • Status if some records are currently being processed

ORA_VCS_PUBLISHER_ORDER_CODE

  • This is a list of publisher order codes that are allowed

  • System lookup

  • No extension possible

ORA_VCS_SUPPLY_FORECAST

ORA_VCS_SUPPLY_COMMIT

  • Forecast to supplier

  • Commitment from supplier

ORA_VCS_WEEKDAY

  • This is a list of allowed weekdays in the correct order

  • System lookup

  • No extension possible

ORA_VCS_WEEKDAY_SUNDAY

ORA_VCS_WEEKDAY_MONDAY

ORA_VCS_WEEKDAY_TUESDAY

ORA_VCS_WEEKDAY_WEDNESDAY

ORA_VCS_WEEKDAY_THURSDAY

ORA_VCS_WEEKDAY_FRIDAY

ORA_VCS_WEEKDAY_SATURDAY

  • This is Sunday

  • This is Monday

  • This is Tuesday

  • This is Wednesday

  • This is Thursday

  • This is Friday

  • This is Saturday