Script IEXSTCLSSGL.sql Does Not Work for Cancelled or Closed Strategies.

(Doc ID 2060668.1)

Last updated on JANUARY 10, 2017

Applies to:

Oracle Advanced Collections - Version 12.1.3 and later
Information in this document applies to any platform.


On : 12.1.3 version, Collections Administration

You have run iexstclssgl.sql script to cancel strategies but you still find Work Items in 'To Be Created' status on these cancelled Strategies.  This script is supposed to cancel the strategy based on the strategy template id as well as all of the Work Items.  However, if you have manually added a Work Item by using the  'Change Work Item' button in the Strategy tab, then running IEXSTCLSSGL.sql will not cancelled these newly added Work Items.   Instead these Work Items will be left in 'To Be Created' status.   Also, the IEXSTCLSSGL.sql does not work for cancelled or closed strategies.





Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms