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 SEPTEMBER 12, 2023

Applies to:

Goal

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

Solution

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