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

Last updated on JULY 14, 2016

Applies to:

Oracle Advanced Pricing - Version 11.5.10.2 to 12.2.2 [Release 11.5 to 12.2]
Information in this document applies to any platform.



Goal

Questions To Be Addressed

Q1: We have a master 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
master 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?

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms