Periodic update of start date, end date, conditions and prices in Price Adjustment Matrix
Our Pricing solution has price lists with price adjustment matrix. In the price adjustment matrix for each item, we have various condition columns, price and Start and End Date.
We used FDBI to load the price list data. However, we have a challenge to update existing price adjustment matrix records because FBDI needs reference IDs. Between the initial FBDI load and Update activity, the user may have made manual changes or new entries directly.
Dear Experts - I need your advice on the best way to update the price adjustment matrix records using FBDI or other ways.
NOTE - The Manage Price List ADFDi has a major handicap that it does not have price adjustment matrix level start and end date. I raised Oracle SR and they asked to file an Idea.