Delete Price List Product Pricing Failed With Error "Can not delete product since Price List has already been assigned"
(Doc ID 2180211.1)
Last updated on JUNE 13, 2018
Applies to:Oracle Financial Services Revenue Management and Billing - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
On : 18.104.22.168.0 version, FT - Financials
1) if the pricelist is not assigned to any customer/account Under this condition,the product should be successfully deleted.
2) when the price list is assigned to any customer/account, deleting the product from price list products would through a validation
'Can not delete product since Price List has already been assigned'
As per the help, the delete button should be disabled in this case. But actual page is no matter the price list is assigned or not, delete icon is available, so customer will receive above error if the price list is already assigned.
SQL> select pl_asgn_status_flg, pricelist_asgn_id from CI_PRICELIST_ASGN a where a.pricelist_id='XXXXX';
==> Please change the XXXXX to your pricelist ID number, you can find it from Manage Price Lists page -- Price List Description.
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