Calling a StoredProcedure in PX Action Tab generates an error

Products

• CA Identity Manager
• CA Identity Governance
• CA Identity Portal
• CA Risk Analytics
• CA Secure Cloud SaaS - Arcot A-OK (WebFort)
• CLOUDMINDER ADVANCED AUTHENTICATION
• CA Secure Cloud SaaS - Advanced Authentication
• CA Secure Cloud SaaS - Identity Management
• CA Secure Cloud SaaS - Single Sign On

Issue/Introduction

When we try to call Stored Procedure through a Policy Xpress (PX), Action Tab, an exception is generated.

Environment

Identity Manager 12.x

Cause

As per Policy Xpress Action implementation, for selection or retrieving of any data value should be use Data Tab and to update and insert action for any attribute value should be use Action Tab 

Resolution

If your Stored Procedure, even executing an INSERT or UPDATE into it, returns any value you must configure in Data Tab.