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