Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

REP 1316 at wrong frequency

863006Nov 16 2011 — edited Nov 16 2011
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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 14 2011
Added on Nov 16 2011
1 comment
2,738 views