Skip to main content
Question

Credential for Custom Event Action

  • November 7, 2024
  • 6 replies
  • 46 views

msurasky-price
Sidekick (Customer)
Forum|alt.badge.img+8

Hi friends!

I have some questions about Custom Events in IFS Cloud

Under which credentials does IFS execute a SQL Custom Event Action in IFS Cloud?

Is there any documentation on how to trace custom events? More specifically I want to know

  1. if a PLSQL fails, how can I see the ORA error (like for example a bug in the PLSQL Logic that normally would trigger some typical error such as ORA-00933 - “SQL Command Not Properly Ended”)
  2. When precisely a Custom Event was triggered (Something similar to the History Log bug for Custom Event Actions)

Thanks!

6 replies

wahelk
Hero (Former Employee)
Forum|alt.badge.img+11
  • Hero (Former Employee)
  • 115 replies
  • November 8, 2024

This is the documentation in IFS cloud.

Manage Event Actions - Technical Documentation For IFS Cloud

you have to trigger the custom event based  crud operations like insert, update , delete.

if it failed due to syntax error or a proper logic error, it pop ups the error when its triggered .

since PLSQL event action type is depreciated, recommendation is to use workflows(BPA).

 

https://docs.ifs.com/techdocs/23r2/040_tailoring/500_business_process_automation/

 


AveTonitM
Sidekick (Partner)
Forum|alt.badge.img+9
  • Sidekick (Partner)
  • 132 replies
  • November 8, 2024

@wahelk You wrote “since PLSQL event action type is obsolete”

In Cloud 24R1 custom event actions of type “Online SQL” still exist in the application. Can You provide some timeline when the event action type SQL will be obsolete?


wahelk
Hero (Former Employee)
Forum|alt.badge.img+11
  • Hero (Former Employee)
  • 115 replies
  • November 8, 2024

Hi Toni,

 

sorry a misinterpret.  its actually depreciation notes. I have no idea when they are going to obsolete the functionality .


msurasky-price
Sidekick (Customer)
Forum|alt.badge.img+8
  • Author
  • Sidekick (Customer)
  • 44 replies
  • November 8, 2024

There are so many implementations of IFS Cloud solutions using SQL Custom Events, lots of Customers are using it.

I’ll be surprised if there is not a HUGE pushback if they really decide to fully remove that option.


msurasky-price
Sidekick (Customer)
Forum|alt.badge.img+8
  • Author
  • Sidekick (Customer)
  • 44 replies
  • November 8, 2024

@wahelk I read the documentation you included in your response 

Manage Event Actions - Technical Documentation For IFS Cloud

 

Yet I don’t see any information that would answer the question regarding “how to find out when precisely a Custom Event was triggered” (Point B in my original question). 

Do you know if Event trigger history is even captured in IFS?


wahelk
Hero (Former Employee)
Forum|alt.badge.img+11
  • Hero (Former Employee)
  • 115 replies
  • November 8, 2024

Tech docs are updated with depreciation notes  I am not sure there is direct way to see history of events triggered.

 


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