Skip to main content
Question

Quick Reports - EE vs Aurena

  • September 21, 2023
  • 0 replies
  • 135 views

Forum|alt.badge.img+11

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

0 replies

Be the first to reply!

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings