API to delete value set values

Use the following api to delete unwanted/unusable value set values

 fnd_flex_values_pkg.delete_row (<<flex_Value_id>>);

Flex value id can be select using the following select statement:

Select a.flex_value_id
From FND_FLEX_VALUES_VL a
  ,fnd_flex_value_sets b
Where a.FLEX_VALUE_SET_ID = b.FLEX_VALUE_SET_ID
And b.FLEX_VALUE_SET_NAME = 'XXPM_VALUE_SETNAME'


Don't use this for deleting application seeded value set values. Above solution can only be used for custom value sets.

PLS-00302: component 'PURGE_BUSINESS_EXCEPTIONS' must be declared

When I run concurrent program "Purge Diagnostic and Log Messages", following error occurs:
Purge Diagnostic and Log Messages

ORACLE error 6550 in FDPSTP
Cause: FDPSTP failed due to ORA-06550: line 1, column 20: 
PLS-00302: component 'PURGE_BUSINESS_EXCEPTIONS' must be declared 
ORA-06550: line 1, column 7: 
PL/SQL: Statement ignored 

To overcome the above error "Purge Logs and Closed System Alerts " should be run instead of "Purge Debug Log and System Alerts" in Release 12.2

You can disable concurrent request program  "Purge Debug Log and System Alerts"