My Oracle Support Banner

Need Help In Understanding Which Scripts To Use For Loading Interface Files for Price List Bulk Load (Doc ID 743648.1)

Last updated on MAY 19, 2022

Applies to:

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


Questions To Be Addressed

Q1: We have a primary price list for each currency which contain no items or prices. Under each of these are multiple secondary price lists which contains items and prices. Items are unique to each of these secondary lists (do not appear in multiple secondary lists for primary list).

We do not have any special pricing attributes. We just need to update/insert prices for items. How do we use the Bulk Load Price List program to accomplish this effectively ?

Q2: After the Price Lists are all created, how does one change just the price of some items? 

Q3: If I use the Interface Action Code "Update" and the record is not presently in the table, will it add it or will it error out?

Q4: If I "Update" with a new Start_Date_Active, will it automatically end-date the old unit price based on that date also?


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
 Questions To Be Addressed
 Answers For Questions
 Additional Sources For Information

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