Workflow Policy Trigger Mechanism

(Doc ID 1489650.1)

Last updated on DECEMBER 10, 2015

Applies to:

Siebel Workflow - Version 8.1.1.2 SIA[21215] and later
Information in this document applies to any platform.
**Checked for relevance on 10-DEC-2015***

Goal

Qn1:Is it possible to create a workflow policy which can be triggered based on old value of the field . For example this workflow needs to be triggred if a Activity record changes status from Pending -> Completed but not when its being changed from In Progress -> Completed
 
Qn2:CREATE OR REPLACE TRIGGER SIEBEL.S_SRV_REQ_XM_ESCL_T1
  after update on SIEBEL.S_SRV_REQ_XM
 for each row
declare
  "b1-67EGZV" boolean := FALSE;
  begin
  if updating('ATTRIB_34') and
  (:new.ATTRIB_34 = 'Completed' or :old.ATTRIB_34 = 'Completed') then
  "b1-67EGZV" := TRUE;
  end if;
  if "b1-67EGZV" = TRUE then
  insert into SIEBEL.S_ESCL_REQ (REQ_ID, CREATED, BT_ROW_ID, RULE_ID, TBL_NAME, CREATED_BY, GROUP_ID)
  values (S_ESCL_REQ_S.nextval, SYSDATE, :new.ROW_ID, '1-67EGZV',
  'S_SRV_REQ_XM', :new.LAST_UPD_BY, '0-122XZ');
  end if;
  end;
/

 (:new.ATTRIB_34 = 'Completed' or :old.ATTRIB_34 = 'Completed') Is this intended
 

Solution

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