My Oracle Support Banner

Multiple Queries While Updating Child Records Via Workflow Step (Doc ID 2354954.1)

Last updated on JANUARY 31, 2018

Applies to:

Siebel CRM - Version 15.18 [IP2015] and later
Information in this document applies to any platform.


On : 15.18 [IP2015] version, Siebel Workflow

Multiple Queries while updating child records via workflow step

While we are updating order item status with search spec "[Order Header Id] = '"+[&Object Id]+"'", we are observing from log that status is getting updated for each row_id individually rather than updating in bulk(i.e order_id). Just want to know is this the expected functionality.

Please find the attached log and SIF for SIS OM Submit Order Process workflow . Please find Update order_item sql at step "Update Line Items Open"( in wf SIS OM Submit Order Process).

The below query is triggering to update status for all order line items individually.

  DB_LAST_UPD = current_date,
  LAST_UPD = :2,
  LAST_UPD_BY = :3,
  STATUS_CD = :5


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.