Hi all,
I have a report and i want to create a Before_Report trigger which is like this :
function BeforeReport return boolean is
no_print exception;
begin
dbms_application_info.set_client_info(:P_ORG_ID);
if :CF_cust_trx_type in (1080,1002,1005,1018,1022) then
raise no_print;
end if;
exception when no_print then
fnd_file.put_line(1,'You cannot print this invoice!');
return (TRUE);
end;
It's compiling without errors, but after triyng to generate XML it throws me REP-1316:Before Report Trigger references column 'CUST_TRX_TYPE' at wrong frequency.
Any ideas what to do?
Report Builder 10.1.2.2.0
Thanks in advance,
Bahchevanov.