Skip to main content

We have quick report(s) which work fine in Apps 10 EE, however when the user goes to run the same report no data is returned. 

The quick reports are parameter driven so users can enter a value or leave blank.

Current SQL parameter construct:

where h.del_org_code like upper('%&DEL_Code%')
and upper(h.POSITION) like upper('%&Position%') 

 

We changed the SQL parameter to the following to get it working in Aurena:

where h.del_org_code like upper('%' || '&DEL_Code' || '%')
and upper(h.POSITION) like upper('%' || '&Position' || '%') 

 

Has anyone come across this and do we know why the change is required to allow reports to work in Aurena?

Thanks

Be the first to reply!

Reply