ASCP Setup

Oracle Advanced Planning Suite has a component architecture that separates the transaction data and associated processing (for example, inventory receipts and order entry) in a source instance from the planning calculations done in a destination instance. This allows planning calculations to be done on a different physical machine
than the machine that performs transactions and results in better system response. It also allows planning calculations (demand planning, inventory planning, supply planning and order promising) to be applied simultaneously to information from across multiple source instances, which is useful when transaction information for a global supply chain is spread across multiple instances. Oracle Demand Planning also uses athird instance, an Express database, to hold data while multidimensional manipulation of demand data occurs.

The source can be any ERP system, but out-of-the-box integration to the Oracle Advanced Planning Suite destination instance (planning server) exists in some cases but not in all cases.

Set up for Oracle Advanced Planning Suite consists of steps for the source, steps for the destination, and steps for Express.

APS may be implemented in two possible configurations:
Centralized Planning
A centralized configuration implies that the ERP applications and APS share the same Oracle instance on one server.
Decentralized Planning
A decentralized configuration implies that the ERP applications and APS are executing within two separate Oracle instances, possibly on the same server.

  • Both configurations are supported using a consistent architecture with the sole distinction being that the decentralized configuration requires the use of database links to pull data into the MSC data store
  • APS nomenclature employs Source and Destination when speaking of the ERP transaction data store and the planning data.  Data, at the source, is collected into the destination or operational datastore (ODS) where planning activities occur. If a centralized configuration is implemented, both the source and destination are operating within the same Oracle instance. 

In Oracle Advanced Planning, transaction processing and planning occur in separate database instances, the source instance and the destination instance. If you deploy any Oracle Advanced Planning module using this multi-instance configuration, please note the important restriction that both source and destination database instances must be on the same major release of the Oracle database; either both instances must be on Oracle 8i or both instances must be on Oracle 9i. The configuration source on 8i with destination on 9i is not supported and the configuration source on 9i with destination on 8i is not supported.
The following figure is a flowchart illustrating the source and destination setup steps.

Multti-Machine Implementation

For small implementations, source, destination, and Express can reside on the same machine and be in the same instance.

For larger implementations where system throughput is more important, the various instances can be deployed on separate machines. A two-machine deployment configuration is appropriate when the size of the demand planning data is relatively small.

A three-machine deployment allows for the manipulation of high-dimensionality, large-scale demand planning data to occur on a machine separate from the planning calculations done on the planning server. The following figure illustrates this configuration.

The Advanced Supply Chain Planning concurrent manager may also be deployed on a separate machine.

Setup Flowchart

 Implementing APS in centralized mode is only possible when collecting from an 11i source.A centralized implementation does not require database links.  Since the planning flexfields are included in 11i, submitting the concurrent process, Create Planning Flexfields is not required.  All other setup discussed in this document are required.

It is very informative regarding architecting ASCP and Demand Planning. if i go for a de-centralized architecture, as per your diagram, only one DB instance is required? i am refering to "Same DB instance" comment under planning server. Can you please clarify?

In case we are using one instance is it required to create instance and DB link?

Oracle Applications Fusion Cloud - Inventory

Oracle Cloud/Fusion Procurement training will help you develop the fundamental skills required to set up and use the Procurement module. This training covers all the tasks, setups, forms and reports used in Procurement and related modules