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

Last updated on JANUARY 01, 2016

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.



BUSINESS IMPACT
-----------------------
last record not updated

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms