One of our recent requirements is to stop sending the email Notification to the Istore user who falls under the category of
Oracle has provided a Standard Workflow “JTF Approval” to handle any email notification to Istore users who register them self through customer istore web site including these 2 types of users.
Options available to me was either
1. Modified the Oracle Standard workflow. – That is not feasible at all, because that is Oracle Standard workflow.
2. Direct UPDATE statement on the table jtf_um_usertypes_b
where USERTYPE_KEY in ('IBE_BUSINESS','IBE_PRIMARY')
This is pretty straight forward and it is on time only , but we are back to square 1 , this is Direct Update on Oracle Standard table that is not recommended solution and Oracle will not support that at all.
With none of options are good choice , I executed couple of queries and found one Standard API provide for Oracle to do same thing.
API Name - JTF_UM_USERTYPES_PKG. UPDATE_ROW
This API was doing a simple update in the table
I then build my code to set the “ EMAIL_NOTIFICATION_FLAG='N' “ with this API , Below is Simple logic that I build
Cursor curuserB IS
JTF_UM_USERTYPES_B B ,
Where b.usertype_id t.usertype_id
And B.USERTYPE_KEY in ('IBE_BUSINESS','IBE_PRIMARY');
FOR recuserB in curuserB
that all , I am done .
Hope that help you guys too.