Skip to main content
Solved

What is the purpose of this database task?

  • May 9, 2023
  • 2 replies
  • 185 views
B
Superhero (Customer)
Forum|alt.badge.img+17

Hello,

What is the purpose of this database task and how can I call it properly? FND_EVENT_ACTION_API.ACTION_EXECUTEONLINESQL

I tried using this and it keeps giving me an error saying SQL is not a valid reference. Is there documentation regarding the formatting of it’s parameters?

 

I also would like to know what the purpose of this other database task is FND_WORKFLOW_CONNECTION_API.START_WORKFLOW and how I can properly call it.

 

I also get an error when I try to invoke this database task.

 

There is no documentation that I could find on the API Explorer or the IFS Cloud technical documentation.

 

Thanks,
Bryan

Best answer by Tomas Ruderfelt

That method is used internally in IFS to execute event actions of type “Execute online SQL”.

By default when you install IFS there is no database task entered for that method, so there is no documentation for it.

It is possible to enter own database tasks for existing methods in the database. I guess that is what has happened here.

2 replies

T
Superhero (Employee)
Forum|alt.badge.img+21
  • Tomas Ruderfelt
  • Superhero (Employee)
  • 500 replies
  • Answer
  • May 10, 2023

That method is used internally in IFS to execute event actions of type “Execute online SQL”.

By default when you install IFS there is no database task entered for that method, so there is no documentation for it.

It is possible to enter own database tasks for existing methods in the database. I guess that is what has happened here.

B
Superhero (Customer)
Forum|alt.badge.img+17
  • bdoucette
  • Author
  • Superhero (Customer)
  • 254 replies
  • May 10, 2023

Hi @Tomas Ruderfelt,

So is it not possible to utilize these database tasks? I’d really love to use the Start_workflow task, as there is no way to get a workflow to run on a schedule, like daily, without piggy backing off of another database task and hoping it always runs.
Thanks,
Bryan


Terms & ConditionsCookie settingsAccessibility statement