You are browsing the archive for collections.

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

Collections Concurrent Programs

Oracle Collections Concurrent Programs

CONCURRENT PROGRAM SHORT CODE CONCURRENT PROGRAM NAME
IEX_PUTAPI_PVT_MASTER IEX_PUTAPI_PVT_MASTER
IEX_PUTAPI_PVT IEX_PUTAPI_PVT
IEXCCH IEX: Collector Call History
IEXDPT IEX: Collections Dispute History
IEXPAY IEX: Collections Payment History
IEX_CREATE_DELINQUENCIES IEX: Create Delinquencies
IEX_SCORE_COLLECTIONS IEX: Score Collections Customers
IEX_PROCESS_PAYMENTS IEX: Process Payments for Collections
IEX_PROCESS_PROMISES IEX: Promise Reconciliation
IEX_SEND_DUNNING IEX: Send Dunnings for delinquent customers
IEX_CALLBACK IEX: Create Dunning And Broken Promise Call Backs
IEX_AGING IEX: Age Delinquencies
REPORT_CB IEX: Report All Contracts
IEX_SEND_CURE_REQUEST IEX: Send Cure Request
IEX_GENERATE_CURE_REFUND IEX: Generate Cure Refund
IEX_GENERATE_CURE_AMOUNT IEX: Generate Cure Amount
RECALL_FROM_EXT_AGENCY IEX: Recall Transfer
NOTIFY_RECALL_EXT_AGENCY IEX: Review Transfer
IEX_CLEAR_DEL_BUFFERS IEX: Clear Delinquency Buffers Table
NOTIFY_CUSTOMER IEX: Notify Customer
PROCESS_PENDING IEX: Process Pending
IEX_CREATE_STRATEGY IEX: Strategy Management
IEXDLMGB IEX: Delinquencies Management
IEX_CASE_RS_LOAD_BAL_CONC IEX: Case Owner Load Balancing
IEX_SCORE_OBJECTS IEX: Scoring Engine Harness
NOTIFY_EXT_AGENCY IEX: Notify Ext Agency
IEX_SCORE_DELINQUENCIES IEX: Score Delinquencies
IEX_SCORE_HISTORY_PURGE IEX: Purge Score History Table
IEX_CNSLD_STR_CONC IEX: Consolidate Strategies
IEX_CNSLD_PROM_CONC IEX: Consolidate Promises
IEX_CNSLD_DLN_CONC IEX: Consolidate Delinquencies
IEXSTRPT IEX: Strategies Report
IEX:RAISE_DEL_CREATE_EVENT IEX: Raise Delinquency Create Event
IEXGAR IEX: Generate Access Records for Collections
IEX_RESOURCE_TO_AR_COLLECTORS IEX: Resource Collectors to AR Collectors
IEX_COLLECTORS_TO_RESOURCE IEX: AR Collectors To Resource Collectors
IEXXMLGEN IEX Xml Generated and Delivery
IEX_METRIC_REFRESH IEX: Refresh Metric Summary Table
IEX_TERRITORY_ASSIGNMENT IEX: Territory Assignment
IEX_POPULATE_UWQ_SUM IEX: Populate UWQ Summary Table
IEXPCLRP IEX: Payment Collector Report
IEXPCMRP IEX: Payment Campaign Report
IEXCCSRP IEX: Collector Campaign Schedule Report
IEXPRCRP IEX: Promise Reconciliation Report
IEX_BULK_XML_DELIVERY IEX: Bulk XML Delivery Manager
IEX_CHILD_XML_DELIVERY IEX: Child XML Delivery Manager
IEXDATA IEX: Collections XML Preview Data Source
IEXACLSB IEX: Assign Collections Level