My Oracle Support Banner

Workflow NextRecord Operation Does Not Process The Last Record As NoMoreRecords Returns True Early (Doc ID 1674175.1)

Last updated on NOVEMBER 22, 2019

Applies to:

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

Symptoms

On : 8.1.1.11 SIA [23030] version, Siebel Workflow

ACTUAL BEHAVIOR
---------------
Workflow NextRecord Step does not process the last record NoMoreRecords returns true early

EXPECTED BEHAVIOR
-----------------------
record traversing should happen till last record

STEPS
-----------------------

 Create a workflow to loop through account records based on below criteria. branching condition is based on NoMoreRecords and NumAffRows.(NoMoreRecords "fasle" and NumAffRows >0)

 1) Navigate to Account Screen > Account List

2) create 4 account records
3) update DUNS# of any of the account record to 1234
4) update Parent HQ DUNS# of other 3 accounts as 1234.
 Make sure Parent Account is null for all records
5) simulate the workflow
6) based on the query defined, it should pick up 3 records(where Parent HQ
Duns# is 1234) and loop 3 times and update parent account with account whose
duns#1234. You can see that after looping twice the NoMoreRecords property is
returned as true and skips the last record.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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