This discussion is archived
2 Replies Latest reply: Apr 4, 2013 7:31 PM by Hussein Sawwan-Oracle RSS

REP-1517: incompatible frequency

996528 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points