Hi everybody,
I am trying to create a quick report in IFS Apps10. It is important to make the inpurt mandatory.
Generally, I use the marked parameters. But in oracle 14 it doesn’t work anymore.
SELECT * FROM ifsapp.customer_order
WHERE order_no LIKE '&[MCSBL]ORDER_NO'
Can anyone confirm this?
Did the change something?
Best answer by Link
I’ve just found the solution.
It works in IFS only and isn’t a part of PL/SQL.
Hi
the solution ist to avoid this in PL/SQL developer: '&[MCSBL]ORDER_NO'
But if you create a quick report in IFS you can use it there.
+1Hi
Thanks for quick response.
But , this does not seem to be working in IFS 8. But works in IFS 9.
Is it available in IFS 8?
Kind Regards
Hi
I am sure it works in APPS9 and 10. In APPS8 I am not sure.
Don’t put it in the SQL code - only in the quick report in IFS.
+1Hi
Yes, I put it only in quick report in IFS 8, it didn't work.
I guess, it works from IFS 9 onwards.
Thanks again for your help 🙂
Kind Regards
Hi
Yes, I put it only in quick report in IFS 8, it didn't work.
I guess, it works from IFS 9 onwards.
Thanks again for your help 🙂
Kind Regards
Then you are right.
You are welcome. 😊
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
