My Oracle Support Banner

Query performance issue in Oracle Trade Management (OZF) while removing person using DRT tool (Doc ID 2429166.1)

Last updated on JULY 30, 2018

Applies to:

Oracle Trade Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Performance issue may happen due to following columns while removing person using DRT Tool.

 

Table: OZF_RESALE_HEADERS_ALL

Columns:

BILL_TO_CONTACT_PARTY_ID

SHIP_TO_CONTACT_PARTY_ID

 

Table: OZF_RESALE_LINES_ALL

Columns:

SHIP_FROM_CONTACT_PARTY_ID

SOLD_FROM_CONTACT_PARTY_ID

END_CUST_CONTACT_PARTY_ID

BILL_TO_CONTACT_PARTY_ID

SHIP_TO_CONTACT_PARTY_ID

 

 

Cause

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
Symptoms
Cause
Solution
References

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