摘自于115MSCUG.pdf (P59-74)

一，Data collection 相关名词

Oracle Applications Data Store (ADS) Represents all the source data tables used to build and maintain the planning data store within Oracle ASCP. It represents a single source data instance.

Operational Data Store (ODS) Part of Oracle ASCP that represents all the planning data tables that act as destination for the collected data from each of the data sources (both ADS and Legacy). This acts as the input for the snapshot portion of the planning process. ODS and PDS share the same physical tables where a special plan identifier (for example, -1) is used for distinction.

Planning Data Store (PDS) Represents all the tables within Oracle ASCP which encompass those in the ODS and other output tables from planning, including copies/snapshots of the input data used for the current planning run striped by the appropriate plan identifier.

二，Data collection 包括两个程序

_ Pull program (收集数据源到staging table)

Collects the data from the ADS, and stores the data into the staging tables. This pull program is a registered AOL concurrent program that could be scheduledand launched by a system administrator. If you are using a legacy program, youmust write your own pull program.

_ ODS Load (从staging table把数据转移到ODS)

A PL/SQL program which performs the data transform. and moves the data from the staging tables to the ODS. This collection program is a registered AOL concurrent program that could be scheduled and launched by the system administrator.

三，Collection Workbench 查询收据收集平台与planner workbench功能相似

Collection Workbench is a centralized data repository providing collected data from the source. Data from different source instances can be viewed using the Collection Workbench. The functionality here is similar to the Planner Workbench functionality. For more information on the Planner Workbench

四，Collection Strategy（收集策略）

Major features included for the data collection process include:

_ Multiple Source Instances

_ Pull Architecture

_ Detect Net Changes to Synchronize Oracle Applications and Oracle ASCP

_ Multi-Process Collection Architecture

_ Data Consolidation

_ Projects/Tasks, and Seiban Numbers

_ Oracle Applications Version and RDBMS Version

_ Support for Several Configurations

五，Collection Setup Steps

1） Setup > Instances

2）Collection > Data Collection

A） ATP Data Pull中collection type参数

Complete refresh collects all data.

Incremental Refresh collects only the incremental changes in the transactional data since the most recent refresh

B） Planning ODS Load

3）Collection > Workbench