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

• 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

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