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 11.5.10.2 and laterInformation in this document applies to any platform.
Goal
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?
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 |