Question

EVENT error with a "custom error"

T
Rank
Userlevel 5
Badge +11

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

S
Rank
Userlevel 6
Badge +12

@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

Just because something is part of a plan doesn't make it right.
T
Rank
Userlevel 5
Badge +11

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;

 

K
Rank
Userlevel 5
Badge +15

Hi @TheoB 

 

On which table/LU have You created event action?

 

Piotr --> https://www.linkedin.com/in/piotr-skowronek-8425aa6/
B
Rank
Userlevel 5
Badge +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

T
Rank
Userlevel 5
Badge +11

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 ! 

B
Rank
Userlevel 5
Badge +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

T
Rank
Userlevel 5
Badge +11

Hi @Bhagya Wickramasinghe 

Thank you for your answer.

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

M
Rank
Userlevel 4
Badge +10

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

T
Rank
Userlevel 5
Badge +11

Hi @MiLeNL ,

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

M
Rank
Badge +2

Hi @TheoB,

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

Thanks,

Milan

dsj
Rank
Userlevel 7
Badge +20

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

DSJ - https://dsj23.me

Reply


Terms & ConditionsCookie settings