Skip to main content
Question

EVENT error with a "custom error"


Forum|alt.badge.img+13
  • Hero (Partner)
  • 150 replies

Hello to all,
I would like to create an EVENT that triggers when the manual supplier invoice is posted.
If the conditions are not met, I trigger to an error message using this procedure: 

Error_SYS.Record_General('Name LU', 'Custom msg');

Only, when the EVENT is triggered, I don't get my custom error message, but this one:


How can I correct this?
Thanks for your help! 

11 replies

Forum|alt.badge.img+12
  • Hero
  • 217 replies
  • July 27, 2022

@TheoB 

 

It looks like there is an error in your Custom Event PL/SQL. Can you post the block of code?

You can also try simplifying the block to just the Record_General line surround by BEGIN and END; and see if that works. If it does, then slowly add more code and keep testing it. You are not seeing your error because a different error is encountered before your code is reached, is my guess.

 

Thanks,

Joe Kaufman


Forum|alt.badge.img+13
  • Author
  • Hero (Partner)
  • 150 replies
  • July 27, 2022

Hello,
Thank you for your answer.

That is exactly what I did. I started by building my PL/SQL block and then I reduced the code as much as possible.
I only kept the : 
 

BEGIN

Error_SYS.Record_General('ManSuppInvoice','Test');

END;

 


Forum|alt.badge.img+16
  • Superhero (Partner)
  • 398 replies
  • July 27, 2022

Hi @TheoB 

 

On which table/LU have You created event action?

 


Forum|alt.badge.img+13

Hi @TheoB,

Can you please attach a capture of the designed custom event and custom event action?

what is the App version?

Best Regards,
Bhagya


Forum|alt.badge.img+13
  • Author
  • Hero (Partner)
  • 150 replies
  • July 28, 2022

Hi @Bhagya Wickramasinghe and @knepiosko ,

Here is the configuration of my event and my action: 

 

The concerned environment is in V10 and UPD14.

I have already created EVENTS triggering custom error messages, I had never encountered any problem...

Thanks for your help ! 


Forum|alt.badge.img+13

Hi @TheoB,

I checked in the App 10 latest release environment and the same error trigered.

 



Please report it to IFS support. Hope this helps!

Best Regards,
Bhagya


Forum|alt.badge.img+13
  • Author
  • Hero (Partner)
  • 150 replies
  • July 28, 2022

Hi @Bhagya Wickramasinghe 

Thank you for your answer.

If anyone has a workaround in the meantime, I'm interested..!


Forum|alt.badge.img+11
  • Hero (Partner)
  • 100 replies
  • July 28, 2022

Might be a long shot; instead of error_sys.record_general perhaps error_sys.appl_general works?


Forum|alt.badge.img+13
  • Author
  • Hero (Partner)
  • 150 replies
  • July 28, 2022

Hi @MiLeNL ,

I just tried, I still get the same error message...
Thanks for your help!


Forum|alt.badge.img+2
  • Do Gooder (Customer)
  • 5 replies
  • January 12, 2023

Hi @TheoB,

Have you please resolved this issue? I get the same error on a Manual Supplier Invoice.

Thanks,

Milan


dsj
Superhero (Partner)
Forum|alt.badge.img+22
  • Superhero (Partner)
  • 832 replies
  • January 12, 2023

Hi @MilanH @TheoB 

I think you are hitting with the bad depth indicator error.

Please check following IFS Community thread for details

Recommended solution in above thread is to apply oracle bundled patch 12.2.0.1.190716WINDBBP" which was suggested by the solution 264924. But I think it’s better to report this to IFS support and seek their advice since there seems to be some side effects of applying the database patch.

 

Hope it helps!

Damith


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