You may follow the above link and delete the duplicated price lists and re-upload the price list once again to rectify the issue. Otherwise see if the below note helps you:
Sample API to Delete Price List Lines from Price List (Doc ID 362667.1)
Hope this Helps!
Thanks for the reply.
I also wanted to know, is there any standard program in Oracle Apps to upload the pricelist ?
I believe there are no standard programs except for manual upload. But a quick search revealed some APIs, check if it helps you:
Thanks again for the reply.
We are also using the same API i.e. qp_price_list_pub.process_price_list to upload the pricelist, but if the user is uploading the same pricelist multiple times it is allowing to upload without giving any error. Ideally as I understan it should not allow to upload the same data again.Please advise.Regards,Shruti