Perform Additional Database Task

  1. Log in as apps account.
  2. Execute the following script:
    SET serveroutput ON
    declare
      status1 boolean;
    begin
      status1 := cdr_profiles_pkg.SAVE 
    ('DMW:Set Based Processing Enabled','$YESNO$NO','SITE');
      if status1 then
       dbms_output.put_line('Success');
      else
       dbms_output.put_line('Failure');
      end if;
    end;
    /
    commit;
  3. Make sure that executing the following query returns the result as $YESNO$NO:
    select cdr_profiles_pkg.value('DMW:Set Based Processing Enabled') from dual;

    If the result of the query is not $YESNO$NO, contact Life Sciences Support.