My Oracle Support Banner

RAC for GOP - Setups for Global Order Promising (GOP) When Using a Real Application Clusters (RAC) Environment (Doc ID 266125.1)

Last updated on APRIL 17, 2024

Applies to:

Oracle Global Order Promising - Version 11.5.10 and later
Oracle Advanced Supply Chain Planning - Version 11.5.8 and later
Information in this document applies to any platform.

Goal

For customers who are using Global Order Promsing (GOP), also called Available to Promise (ATP) AND who are using Real Application Clusters (RAC) environment.

When To Use This Note

You must use this note when:
  1. You have Distributed Installation of APS and ERP - The APS Destination applications run on a separate instance from the ERP Source applications
    AND the ERP Source instance is RAC enabled with 2 or more nodes.
  2. The APS Instance may or may not be RAC enabled.
DO NOT use this note when Single instance installation where APS and ERP are on a single instance and RAC is enabled..

Review <Note 279156.1> for restrictions to APS and MRP  concurrent requests on RAC Enabled instance.


How to Check if RAC is installed

In the standard apscheck output from <Note 246150.1>
See Section 9 v$parameter settings
search on cluster
  
This example shows a 2-node RAC installation
cluster_database TRUE
cluster_database_instances 2
  

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
 Data Flow Diagram
 Setups Overview
 Setup Details
 On EBS Applications server - 2 Node example
 On APS Applications Planning server
 Possible Errors Seen When Setup Not Completed - ATP Processing Error returned in the applications
 
SQL Diagnostic Setup Check Scripts:
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.