Solved

IFS10 Upgrade - Report rule customer invoice issue

  • 7 April 2020
  • 3 replies
  • 302 views

Userlevel 2
Badge +4

Hi 

i’m having some issues with report rules i have brought over from an Apps 8 environment.

 the rules are based on the report ID - CUSTOMER_ORDER_IVC_REP

 

error log im seeing is 

Rule ID=10 ORA-31011:ERROR Evaluating Expression=''[@CUSTOMER_ORDER_IVC_REP\CUSTOMER_NO]'' result_key=132038formatter_properties=LocaleCountryUS

 

any assistance would be greatly appreciated 

 

thanks 

 

Nick 

icon

Best answer by MKG019 8 April 2020, 04:14

View original

3 replies

Userlevel 6
Badge +13

Hi Nick,

You need to make changes in report Rule action replace all slash symbol to / e.g Expression=''[@CUSTOMER_ORDER_IVC_REP/CUSTOMER_NO] ".

I also had same issue IFS8 report Rule in 10 giving same error. 

 

Regards, 

Mukesh Gupta

Userlevel 7
Badge +19

Hi Nick,

 

If you still cannot get it resolved after Mukesh’s comments, please attach a screen shot of report rule condition and actions. So we can check and help.

 

Best Regards,

Rusiru

Userlevel 2
Badge +4

Hi @MKG019 Mukesh 

 

That has sorted my problem out.

Thankyou very much for your help 

 

@Rusiru  problem solved

 

Kind regards 

 

Nick 

Reply