My Oracle Support Banner

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 and later
Information in this document applies to any platform.


On : 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.

To check if your price list is assigned, you may using following SQL:
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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.