My Oracle Support Banner

Pricing Data Bulk Loader - Are There Scripts That Can Be Used For Line Deletion? (Doc ID 2485977.1)

Last updated on SEPTEMBER 20, 2021

Applies to:

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


We are trying to delete price list lines using Pricing Data Bulk Loader (PDBL).

The lines have creation dates ranging from 2004 to 2016, and were created in 11i and R12. Current instance is now 12.1.3.

QP: Upgrade Pricing Data for Bulk Loader has been run, and queries to validate records with no sys_doc_ref return no records in header, line, or attribute tables.

After inserting in QP_INTERFACE_LIST_HEADERS, QP_INTERFACE_LIST_LINES and QP_INTERFACE_PRICING_ATTRIBS and running QP: Bulk Import of Price List, the program appears to select no lines for processing.

Cannot find any documentation that specifically covers the case of deleting price list lines while keeping price list headers intact.

Logically I think it should be that we want to do this:

Update price list header
Delete price list line
Delete price list line attribute
No changes to qualifiers (not inserting in qualifiers interface table)

However it's not clear that this is correct, and we cannot get this to work after trying various combinations.

Can delete scripts be provided?



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.