My Oracle Support Banner

A Script Is Being Run During an Adop Cycle to Update the Qualifiers Results in Error: ORA-20002: "Seed Data Table QP_PTE_SEGMENTS has not been prepared for patching" (Doc ID 2663250.1)

Last updated on MAY 01, 2020

Applies to:

Oracle Advanced Pricing - Version 12.2.6 and later
Information in this document applies to any platform.


How can one resolve the following error(s) while running a custom procedure to update their qualifiers?

ORA-20002: Seed Data Table QP_PTE_SEGMENTS has not been prepared for patching
ORA-06512: at "APPS.QP_PTE_SEGMENTS+", line 8
ORA-04088: error during execution of trigger 'APPS.QP_PTE_SEGMENTS+' in Package QP_Qualifiers_Util Procedure Insert_Row

They are running a custom procedure to update Customer Name Qualifying Attributes to Party ID Qualifying Attributes

A script is being run during an ADOP cycle to update the data.
Custom code calls API QP_Modifiers_PUB.Process_Modifiers for update to add a new line level qualifier record and to update an existing list line qualifier record (customer name) by adding an End Date


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

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