Skip to main content
Solved

IFS10 Upgrade - Report rule customer invoice issue

  • April 7, 2020
  • 3 replies
  • 349 views
N
Do Gooder (Customer)
Forum|alt.badge.img+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 

Best answer by MKG019

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

ALHAGMO

3 replies

MKG019
Hero (Partner)
Forum|alt.badge.img+13
  • MKG019
  • Hero (Partner)
  • Answer
  • April 8, 2020

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

durette
N
Rusiru Dharmadasa
Superhero (Employee)
Forum|alt.badge.img+20

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

Rusiru
N
Do Gooder (Customer)
Forum|alt.badge.img+4
  • njowett
  • Author
  • Do Gooder (Customer)
  • April 15, 2020

Hi @MKG019 Mukesh 

 

That has sorted my problem out.

Thankyou very much for your help 

 

@Rusiru  problem solved

 

Kind regards 

 

Nick 

Terms & ConditionsCookie settingsAccessibility statement