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
Oracle Advanced Pricing - Version 184.108.40.206 to 12.2.2 [Release 11.5 to 12.2] Information in this document applies to any platform.
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?
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!