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

Last updated on APRIL 04, 2025

Applies to:

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

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

	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

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