Make input mandatory in quick report

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 '&gMCSBL]ORDER_NO'

Can anyone confirm this?

Did the change something?

Page 1 / 1

I’ve just found the solution.

It works in IFS only and isn’t a part of PL/SQL.

Hi,

What is the solution?

Regards,

Hi @TecAkshaK

the solution ist to avoid this in PL/SQL developer: '&gMCSBL]ORDER_NO'

But if you create a quick report in IFS you can use it there.

Hi @Link ,

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 @TecAkshaK

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.

Hi @Link,

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 @Link,

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.

Sign up