You are browsing the archive for APS.

ASCP Collection Methods

Oracle ASCP Collection Methods:

There are three ways data can be collected into Oracle ASCP or APS or Value Chain Planning suite.

1) Standard Collections:

  • Complete Refresh: In this all existing collected data will be purged and new data is imported.
  • Targeted Refresh: Similar to Complete Refresh but for each object. You can selectively choose which objects require completed refresh, only those targeted objects will be refreshed.
  • Net Change refresh: Imports only the changes that happened since last refresh. This methods work for supply / demand changes.

Objects supported under Net change mode.

  • Sales Orders
  • Reservations
  • Master Production Schedules demands
  • Master Demand Schedules demands
  • WIP Component Demands
  • WIP repetitive item demands
  • Forecast demands
  • User demands
  • Master production schedule supplies
  • User supplies
  • Purchase Order Supplies
  • On-hand supplies
  • Work orders in Oracle WIP
  • Resource availability
  • Supplier capacity
  • Bill of Material
  • Routing Operations
  • Components needed for Routing
  • Resources attached to Routing
  • Resource requirements for WIP Jobs
  • Resources for WIP Jobs
  • Items
  • Item categories
  • Capacity

Not supported objects for Net change Method

  • Category sets
  • Default item category
  • Simulation sets
  • Department resources
  • Resource shift setup
  • Hard reservations
  • Projects or project tasks
  • UOM
  • Sourcing rules
  • Bills of Resources
  • Calendars
  • Shipping networks
  • Parameters
  • Planners
  • Suppliers
  • Resource groups
  • Demand classes
  • Available To Promise rules
  • Trading Partners


2) Continuous Collections:

Continuous collections systematically decides whether to run targeted refresh or net change based on a given threshold value (parameter). It runs based on snapshot data.

3) Legacy Collections:

This method is useful to import data from non-oracle ERP systems. Data is imported from flat files or from staging tables. Oracle provides the templates for each data/transaction objects, if data uploaded in that format, oracle imports data into planning server.

ASCP Standard Collections

ASCP Standard Collections

Oracle ASCP Collections pull the data from source (ERP) system for planning purpose. If your source system (ERP) is Oracle Apps, then out of the box collections programs will collect the data without any custom interface. Oracle ASCP supports any version (10.7, 11i, 12) of Oracle Apps ERP to collect the data. After data is collected ASCP Plan must be run with refreshed data to review the latest recommendations.

Data collections are done in two stages. During first stage (1) Data is pulled from ERP system and kept in Staging tables. During second stage (2) Data is loaded into ASCP instance.

ASCP Collections – Data Pull Parameters:

ASCP Collections - Data Pull

ASCP Collections - Data Pull

  • Instance
  • Collection group
  • Number of workers
  • Timeout (Minutes)
  • Purge previously collected data
  • Collection Method
  • Analyze Staging Tables
  • Approved Supplier Lists (Supplier Capacities)
  • ATP Rules
  • Bills Of Materials/Routings/Resources
  • Bill Of Resources
  • Calendars
  • Demand Classes
  • End Item Substitutions
  • Forecasts
  • Items
  • Key Performance Indicator Targets
  • Master Demand Schedules
  • Master Production Schedules
  • On Hand
  • Planning Parameters
  • Planners
  • PO Receipts
  • Projects/Tasks
  • Purchase Orders / Purchase Requisitions
  • Reservations
  • Resources Availability
  • Safety Stock
  • Sales orders
  • Sourcing History
  • Sourcing Rules
  • Subinventories
  • Supplier Responses
  • Suppliers/Customers/Orgs
  • Transportation Details
  • Unit Numbers
  • Units of Measure
  • User Company Association
  • User Supplies and Demands
  • Work In Process
  • Sales Channel
  • Fiscal Calendar
  • Internal Repair Orders
  • External Repair Orders
  • Payback Demand/Supply
  • Currency Conversion
  • Delivery Details

ASCP Collections – ODS Load Parameters:

ASCP Collections - ODS Load

ASCP Collections - ODS Load

  • Instance
  • Timeout (Minutes)
  • Number Of Workers
  • Recalculate sourcing history
  • Purge sourcing history
  • Refresh collected data in APCC repository

Oracle Advanced Supply Chain Planning Tables

Oracle ASCP – List of database tables:

  • MSC_ABC_CLASSES
  • MSC_ALLOCATIONS
  • MSC_ALLOCATION_ASSIGNMENTS
  • MSC_ALLOCATION_RULES
  • MSC_ALLOC_DEMANDS
  • MSC_ALLOC_RULE_TIME_PHASES
  • MSC_ALLOC_SUPPLIES
  • MSC_AMONG_VALUES
  • MSC_ANSWERS
  • MSC_APPS_INSTANCES
  • MSC_ASSIGNMENT_SETS
  • MSC_ATP_PARAMETERS
  • MSC_ATP_PEGGING
  • MSC_ATP_RULES
  • MSC_ATP_SUMMARY_RES
  • MSC_ATP_SUMMARY_SD
  • MSC_ATP_SUMMARY_SO
  • MSC_ATP_SUMMARY_SUP
  • MSC_AVAILABLE_TO_PROMISE
  • MSC_BILL_OF_RESOURCES
  • MSC_BIS_BUSINESS_PLANS
  • MSC_BIS_INV_CAT_MV_TAB
  • MSC_BIS_INV_DATE_MV_TAB
  • MSC_BIS_INV_DETAIL
  • MSC_BIS_PERFORMANCE_MEASURES
  • MSC_BIS_PERIODS
  • MSC_BIS_RES_DATE_MV_TAB
  • MSC_BIS_RES_SUMMARY
  • MSC_BIS_SUPPLIER_SUMMARY
  • MSC_BIS_TARGETS
  • MSC_BIS_TARGET_LEVELS
  • MSC_BOMS
  • MSC_BOM_BOD_INTERFACE
  • MSC_BOM_COMPONENTS
  • MSC_BOM_TEMP
  • MSC_BOR_REQUIREMENTS
  • MSC_CALENDARS
  • MSC_CALENDAR_DATES
  • MSC_CALENDAR_EXCEPTIONS
  • MSC_CALENDAR_SHIFTS
  • MSC_CAL_WEEK_START_DATES
  • MSC_CAL_YEAR_START_DATES
  • MSC_CAPACITY_PLANS
  • MSC_CATEGORY_SETS
  • MSC_CATEGORY_SET_ID_LID
  • MSC_COLL_PARAMETERS
  • MSC_COMPANIES
  • MSC_COMPANY_ID_LID
  • MSC_COMPANY_RELATIONSHIPS
  • MSC_COMPANY_SITES
  • MSC_COMPANY_SITE_ID_LID
  • MSC_COMPANY_USERS
  • MSC_COMPONENT_SUBSTITUTES
  • MSC_CRITERIA
  • MSC_CRITICAL_PATHS
  • MSC_DEMANDS
  • MSC_DEMAND_CLASSES
  • MSC_DEMAND_MV_TAB
  • MSC_DEPARTMENT_RESOURCES
  • MSC_DESIGNATORS
  • MSC_ERRORS
  • MSC_EXCEPTION_DETAILS
  • MSC_EXCEPTION_PREFERENCES
  • MSC_EXCEPTION_THRESHOLDS
  • MSC_EXCEPTION_THRESHOLD_VALUES
  • MSC_EXC_DETAILS_ALL
  • MSC_FCTI_HEADERS_INTERFACE
  • MSC_FCTI_LINES_INTERFACE
  • MSC_FILES
  • MSC_FORECAST_UPDATES
  • MSC_FORM_QUERY
  • MSC_FULL_PEGGING
  • MSC_GANTT_QUERY
  • MSC_GROUPS
  • MSC_GROUP_COMPANIES
  • MSC_INSTANCE_ORGS
  • MSC_INST_PARTITIONS
  • MSC_INTERORG_SHIP_METHODS
  • MSC_ITEMS
  • MSC_ITEM_CATEGORIES
  • MSC_ITEM_CUSTOMERS
  • MSC_ITEM_EXCEPTIONS
  • MSC_ITEM_ID_LID
  • MSC_ITEM_SOURCING
  • MSC_ITEM_SUBSTITUTES
  • MSC_ITEM_SUPPLIERS
  • MSC_JOB_OPERATIONS
  • MSC_JOB_OPERATION_NETWORKS
  • MSC_JOB_OP_RESOURCES
  • MSC_JOB_OP_RES_INSTANCES
  • MSC_JOB_REQUIREMENT_OPS
  • MSC_LATE_ORDER_MV_TAB
  • MSC_LOCAL_ID_DEMAND
  • MSC_LOCAL_ID_ITEM
  • MSC_LOCAL_ID_MISC
  • MSC_LOCAL_ID_SETUP
  • MSC_LOCAL_ID_SUPPLY
  • MSC_LOCATION_ASSOCIATIONS
  • MSC_MATERIAL_PLANS
  • MSC_NEC_COMPARE_PLANS
  • MSC_NEC_EXC_DTL_COMPARE
  • MSC_NET_CHANGE_CRITERIA
  • MSC_NET_RESOURCE_AVAIL
  • MSC_NET_RES_INST_AVAIL
  • MSC_OE_DATA_TEMP
  • MSC_OPERATION_COMPONENTS
  • MSC_OPERATION_NETWORKS
  • MSC_OPERATION_RESOURCES
  • MSC_OPERATION_RESOURCE_SEQS
  • MSC_ORG_ACCESS
  • MSC_OUTBOUND_ENTRIES
  • MSC_PARAMETERS
  • MSC_PARTNER_CONTACTS
  • MSC_PDR_PARAMETERS
  • MSC_PDR_PARAMETERS_NEW
  • MSC_PERIOD_START_DATES
  • MSC_PLANNERS
  • MSC_PLANS
  • MSC_PLAN_BUCKETS
  • MSC_PLAN_ORGANIZATIONS
  • MSC_PLAN_ORG_KPIS
  • MSC_PLAN_ORG_STATUS
  • MSC_PLAN_ORG_STATUSES
  • MSC_PLAN_PARTITIONS
  • MSC_PLAN_REFRESHES
  • MSC_PLAN_SCHEDULES
  • MSC_PO_REQUISITIONS_INTERFACE
  • MSC_PO_RESCHEDULE_INTERFACE
  • MSC_PQ_RESULTS
  • MSC_PROCESS_EFFECTIVITY
  • MSC_PROFILES
  • MSC_PROJECTS
  • MSC_PROJECT_TASKS
  • MSC_PURCHASE_ORDER_INTERFACE
  • MSC_QUERY
  • MSC_QUESTIONS_B
  • MSC_QUESTIONS_TL
  • MSC_REGIONS
  • MSC_REGIONS_TEMP
  • MSC_REGION_LOCATIONS
  • MSC_RELATED_EXCEPTIONS
  • MSC_REPETITIVE_PERIODS
  • MSC_RESERVATIONS
  • MSC_RESOURCE_CHANGES
  • MSC_RESOURCE_GROUPS
  • MSC_RESOURCE_INSTANCE_REQS
  • MSC_RESOURCE_REQUIREMENTS
  • MSC_RESOURCE_SHIFTS
  • MSC_ROUTINGS
  • MSC_ROUTING_OPERATIONS
  • MSC_SAFETY_STOCKS
  • MSC_SALES_ORDERS
  • MSC_SCHEDULING_RULES
  • MSC_SECURITY_RULES
  • MSC_SELECTION_CRITERIA
  • MSC_SEQUENCE_DEPENDENT_SETUPS
  • MSC_SERIAL_NUMBERS
  • MSC_SHIFT_DATES
  • MSC_SHIFT_EXCEPTIONS
  • MSC_SHIFT_TIMES
  • MSC_SIMULATION_SETS
  • MSC_SINGLE_LVL_PEG
  • MSC_SNAPSHOT_TASKS
  • MSC_SORT_DATA
  • MSC_SOURCING_HISTORY
  • MSC_SOURCING_RULES
  • MSC_SOURCING_TRANSACTIONS
  • MSC_SQLLOAD_PARAMETERS
  • MSC_SR_ASSIGNMENTS
  • MSC_SR_RECEIPT_ORG
  • MSC_SR_SOURCE_ORG
  • MSC_ST_ASSIGNMENT_SETS
  • MSC_ST_ATP_RULES
  • MSC_ST_BILL_OF_RESOURCES
  • MSC_ST_BIS_BUSINESS_PLANS
  • MSC_ST_BIS_PERIODS
  • MSC_ST_BIS_PFMC_MEASURES
  • MSC_ST_BIS_TARGETS
  • MSC_ST_BIS_TARGET_LEVELS
  • MSC_ST_BOMS
  • MSC_ST_BOM_COMPONENTS
  • MSC_ST_BOR_REQUIREMENTS
  • MSC_ST_CALENDARS
  • MSC_ST_CALENDAR_DATES
  • MSC_ST_CALENDAR_EXCEPTIONS
  • MSC_ST_CALENDAR_SHIFTS
  • MSC_ST_CAL_WEEK_START_DATES
  • MSC_ST_CAL_YEAR_START_DATES
  • MSC_ST_CATEGORY_SETS
  • MSC_ST_COMPANY_USERS
  • MSC_ST_COMPONENT_SUBSTITUTES
  • MSC_ST_CO_PRODUCTS
  • MSC_ST_DEMANDS
  • MSC_ST_DEMAND_CLASSES
  • MSC_ST_DEPARTMENT_RESOURCES
  • MSC_ST_DESIGNATORS
  • MSC_ST_GROUPS
  • MSC_ST_GROUP_COMPANIES
  • MSC_ST_INTERORG_SHIP_METHODS
  • MSC_ST_ITEM_CATEGORIES
  • MSC_ST_ITEM_CUSTOMERS
  • MSC_ST_ITEM_SOURCING
  • MSC_ST_ITEM_SUBSTITUTES
  • MSC_ST_ITEM_SUPPLIERS
  • MSC_ST_JOB_OPERATIONS
  • MSC_ST_JOB_OP_RESOURCES
  • MSC_ST_JOB_REQUIREMENT_OPS
  • MSC_ST_LOCATION_ASSOCIATIONS
  • MSC_ST_NET_RESOURCE_AVAIL
  • MSC_ST_NET_RES_INST_AVAIL
  • MSC_ST_OPERATION_COMPONENTS
  • MSC_ST_OPERATION_NETWORKS
  • MSC_ST_OPERATION_RESOURCES
  • MSC_ST_OPERATION_RESOURCE_SEQS
  • MSC_ST_PARAMETERS
  • MSC_ST_PARTNER_CONTACTS
  • MSC_ST_PERIOD_START_DATES
  • MSC_ST_PLANNERS
  • MSC_ST_PROCESS_EFFECTIVITY
  • MSC_ST_PROFILES
  • MSC_ST_PROJECTS
  • MSC_ST_PROJECT_TASKS
  • MSC_ST_REGIONS
  • MSC_ST_REGION_LOCATIONS
  • MSC_ST_RESERVATIONS
  • MSC_ST_RESOURCE_CHANGES
  • MSC_ST_RESOURCE_GROUPS
  • MSC_ST_RESOURCE_INSTANCE_REQS
  • MSC_ST_RESOURCE_REQUIREMENTS
  • MSC_ST_RESOURCE_SHIFTS
  • MSC_ST_ROUTINGS
  • MSC_ST_ROUTING_OPERATIONS
  • MSC_ST_SAFETY_STOCKS
  • MSC_ST_SALES_ORDERS
  • MSC_ST_SERIAL_NUMBERS
  • MSC_ST_SHIFT_DATES
  • MSC_ST_SHIFT_EXCEPTIONS
  • MSC_ST_SHIFT_TIMES
  • MSC_ST_SIMULATION_SETS
  • MSC_ST_SOURCING_HISTORY
  • MSC_ST_SOURCING_RULES
  • MSC_ST_SR_ASSIGNMENTS
  • MSC_ST_SR_RECEIPT_ORG
  • MSC_ST_SR_SOURCE_ORG
  • MSC_ST_SUB_INVENTORIES
  • MSC_ST_SUPPLIER_CAPACITIES
  • MSC_ST_SUPPLIER_FLEX_FENCES
  • MSC_ST_SUPPLIES
  • MSC_ST_SYSTEM_ITEMS
  • MSC_ST_TRADING_PARTNERS
  • MSC_ST_TRADING_PARTNER_SITES
  • MSC_ST_UNITS_OF_MEASURE
  • MSC_ST_UNIT_NUMBERS
  • MSC_ST_UOM_CLASS_CONVERSIONS
  • MSC_ST_UOM_CONVERSIONS
  • MSC_ST_WORKDAY_PATTERNS
  • MSC_ST_ZONE_REGIONS
  • MSC_SUB_INVENTORIES
  • MSC_SUPDEM_HDRS_INTERFACE
  • MSC_SUPDEM_LINES_INTERFACE
  • MSC_SUPPLIER_CAPACITIES
  • MSC_SUPPLIER_FLEX_FENCES
  • MSC_SUPPLIER_LT_OUTCOMES
  • MSC_SUPPLIER_PLANS
  • MSC_SUPPLIER_REQUIREMENTS
  • MSC_SUPPLIES
  • MSC_SUP_DEM_ENTRIES
  • MSC_SUP_DEM_HISTORY
  • MSC_SUP_HEADERS_INTERFACE
  • MSC_SUP_LINES_INTERFACE
  • MSC_SYSTEM_ITEMS
  • MSC_TEMP_ALLOC_DEMANDS
  • MSC_TEMP_ALLOC_SUPPLIES
  • MSC_TEMP_REGION_LOCATIONS
  • MSC_TEMP_SALES_ORDERS
  • MSC_TEMP_SUMM_RES
  • MSC_TEMP_SUMM_SD
  • MSC_TEMP_SUMM_SO
  • MSC_TEMP_SUMM_SUP
  • MSC_TP_ID_LID
  • MSC_TP_SITE_ID_LID
  • MSC_TRADING_PARTNERS
  • MSC_TRADING_PARTNER_MAPS
  • MSC_TRADING_PARTNER_SITES
  • MSC_UNDO_DETAILS
  • MSC_UNDO_SUMMARY
  • MSC_UNITS_OF_MEASURE
  • MSC_UNIT_NUMBERS
  • MSC_UOM_CLASS_CONVERSIONS
  • MSC_UOM_CONVERSIONS
  • MSC_USER_ADV_EXPRESSIONS
  • MSC_USER_EXCEPTIONS
  • MSC_USER_EXCEPTION_COMPONENTS
  • MSC_USER_EXCEPTION_NTFS
  • MSC_WIP_JOB_DTLS_INTERFACE
  • MSC_WIP_JOB_SCHEDULE_INTERFACE
  • MSC_WORKBENCH_DISPLAY_OPTIONS
  • MSC_WORKDAY_PATTERNS
  • MSC_X_EXCEPTION_DETAILS
  • MSC_X_SECURITY_RULES
  • MSC_ZONE_REGIONS