Skip to main content
Question

Custom Procedure call in a Custom Menu IFS Cloud


Forum|alt.badge.img+8
  • Sidekick (Customer)
  • 76 replies

We have a custom menu that we use that calls a custom procedure that we wrote in house. Today, in IEE, this menu is setup with a PL/SQL Block that calls our custom package. Does anyone have an idea of how we could do this in cloud?

We have a background job that runs today along with this menu item. Could I set it up to call the db task instead? We normally just have the users RMB and then click this menu item and it starts the background job without taking them off of this screen.

 



 

 

3 replies

dsj
Superhero (Partner)
Forum|alt.badge.img+22
  • Superhero (Partner)
  • 828 replies
  • May 7, 2024

Hi @Anna 

 

As you may already aware, custom menus with PLSQL logic is not supported in IFS Cloud and you need to refactor it. Hope following guidelines would help to decide what is good for you.

  • PLSQL logic used in the menu action can be replaced with a workflow - Create a workflow and call it using the type Execute Workflow
  • Custom menu calling a custom made procedure (your scenario) - Implement the custom procedure as a customization. Create a projection configuration, add your custom procedure as a custom action and call that action using type Execute Action

More details on custom action configurations

Custom Action Configuration - Technical Documentation For IFS Cloud

 

Hope it helps!

Damith


AltRuslaC
Do Gooder (Partner)
Forum|alt.badge.img+2
  • Do Gooder (Partner)
  • 9 replies
  • January 6, 2025

Hello ​@dsj .

I ordered from R&D custom procedure (inside custom package). Procedure have 3 easy parameters. Developer created the new package and the procedure in the IFS Developer Studio. However, on added action in the configuration projection I don't see this procedure for choice. Research the sql query by LOV showed, that query select data from view "CUSTOM_ACTION_METHODS"(and himself view get data from table "Custom_Action_Methods_MV") but my procedure not in to this view. What I do not right? How custom procedure get into view "CUSTOM_ACTION_METHODS"(and table "Custom_Action_Methods_MV")?


AltRuslaC
Do Gooder (Partner)
Forum|alt.badge.img+2
  • Do Gooder (Partner)
  • 9 replies
  • January 7, 2025

All thanks :) figured it out! For shows custom method needs to refresh dictionary!(Solution Manager\System Information and Utilities\Refresh Server Cache)


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