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 SEPTEMBER 22, 2018

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

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

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