R12 - Can't Find Profile "OM : Use Parallel Queries In Customer Merge" Per Doc 1303181.1 (Doc ID 1335564.1)

Last updated on AUGUST 02, 2017

Applies to:

Oracle Order Management - Version 12.1.1 to 12.1.1 [Release 12.1]
Information in this document applies to any platform.
***Checked for relevance on 25-Jul-2013***

Goal

<Patch 9349882> was applied in customer's instance to correct Customer Merge performance. As part of the documentation - it states to change the OM : Use parallel queries in customer merge profile to NO after creating the custom indexes. Unfortunately, said profile cannot be found in R12.1.1.

Profile option was introduced in:
<Bug 8319409>: GSIAP: POOR PERFORMING SQL DFJC0R6QJ2MRA IN CUSTOMER MERGE
OEXCMOEB.pls-120.8.12010000.2

By applying <patch 9349882> - customer's version of package is:
OE_CUST_MERGE OEXCMOES.pls 120.1.12010000.1 SPEC VALID
OE_CUST_MERGE OEXCMOEB.pls 120.8.12010000.6 BODY VALID

Yet, profile is not found.

***
Researched issue internally. Find that profile option is not in our 12.1.1 test instance but it is in our 12.1.3 instance --

apps check

OM : Use Parallel Queries in Customer Merge ** Not Set At Any Level ** ----

OE_CUST_MERGE OEXCMOES.pls 120.1.12010000.1
OE_CUST_MERGE OEXCMOEB.pls 120.8.12010000.6

**

omsup04 - 12.1.1

apps check

(OM : Use Parallel Queries in Customer Merge ****** DOES NOT EXIST)

OE_CUST_MERGE OEXCMOES.pls 120.1.12010000.1 SPEC VALID
OE_CUST_MERGE OEXCMOEB.pls 120.8.12010000.1 BODY VALID


Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms