One of our recent requirements is to stop sending the email Notification to the Istore user who falls under the category of
Primary User
Business user.
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
update jtf_um_usertypes_b
set EMAIL_NOTIFICATION_FLAG='N'
where USERTYPE_KEY in ('IBE_BUSINESS','IBE_PRIMARY')
AND EMAIL_NOTIFICATION_FLAG='Y';
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
JTF_UM_USERTYPES_B &
JTF_UM_USERTYPES_TL
I then build my code to set the “ EMAIL_NOTIFICATION_FLAG='N' “ with this API , Below is Simple logic that I build
Declare
Cursor curuserB IS
Select variables
from
JTF_UM_USERTYPES_B B ,
JTF_UM_USERTYPES_TL T
Where b.usertype_id t.usertype_id
And B.USERTYPE_KEY in ('IBE_BUSINESS','IBE_PRIMARY');
BEGIN
FOR recuserB in curuserB
LOOP
JTF_UM_USERTYPES_PKG. UPDATE_ROW(
recuserB.variable1,
recuserB.variable2
recuserB.variable3,,
….
…
);
END LOOP;
END
that all , I am done .
Hope that help you guys too.
No comments:
Post a Comment