Last updated on AUGUST 28, 2017
Applies to:Oracle iProcurement - Version 12.1.3 and later
Information in this document applies to any platform.
In Oracle iProcurement, Release 12.1.3 with Endeca (Information Discovery) enabled, when deleting a non-catalog smart form from iProcurement Catalog Administrator responsibility, it removes values from POR_NONCAT_TEMPLATED_ALL_B, POR_NONCAT_TEMPLATES_ALL_TL and ICX_CAT_STORE_CONTENTS tables for the template. The user is not warned, however, if the smart form is currently in use with in-flight requisition or there are active requisitions based on this smart form referring the template id of deleted smart form.
Now, when user/requester tries to take action on any returned, withdrawn or rejected requisition, the following error occurs in the shopping cart and the Line Details are automatically getting deleting from PO_REQUISITION_LINES_ALL table.
The non-catalog request template associated with the line is invalid.
1. The smart form should not be able to be deleted if active requisition is present which is limited to the smart form.
2. The requisition line details should not be getting deleted from the database
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