2 Replies Latest reply: Apr 4, 2013 9:31 PM by Hussein Sawwan-Oracle RSS

    REP-1517: incompatible frequency

    996528
      function CF_txt_value_displayFormula return Varchar2 is

      begin

      declare
      stmt_type VARCHAR2(300);
      source_type_recv number ;
      source_value_lpn VARCHAR2(820);
      Trn_type_id Number;

      begin
      stmt_type := :P_TXN_TYPE_LO;
      source_type_recv := :txn_designation_id;
      source_value_lpn := :LPN;
      Trn_type_id := :transaction_type_id;

      if stmt_type = 'Intransit Shipment' and Trn_type_id = 21 then
      RETURN (:txn_designation_id);
      else
      if stmt_type = 'Subinventory Transfer' and Trn_type_id = 2 then
      RETURN (:LPN);
      else

      return 0;

      end if;
      end if;

      end;
      RETURN NULL;
      Exception
           when too_many_rows then
           return null;
           when no_data_found then
           return null;
           when others then
           return null;

      end;

      After Running the report im getting error = REP-1517: Column 'CF_txt_value_display' references column 'transaction_type_id', which has incompatible frequency.

      Edited by: 993525 on Apr 5, 2013 10:11 AM