My Oracle Support Banner

FA:SCM:MFG WorkDefinitions REST API Using Pagination Gives Incorrect Response (Doc ID 3017505.1)

Last updated on APRIL 18, 2024

Applies to:

Oracle Fusion Manufacturing Cloud Service - Version 11.13.24.01.0 and later
Information in this document applies to any platform.

Symptoms

When trying to call the /fscmRestApi/resources/latest/workDefinitions API using pagination as below to get 705 work definitions, few records repeat in both the calls and few eligible records are missing.

offset=0,limit=500 hasMore =true

offset=500,limit=500 hasMore =false

Example,

Call1 :

https://<>/fscmRestApi/resources/latest/workDefinitions?expand=WorkDefinitionResource&onlyData=true&offset=0&limit=500&fields=InventoryItemId,ItemNumber,ItemDescription,OrganizationId,OrganizationCode,StatusCode,WorkDefinitionCode,WorkDefinitionId,WorkDefinitionVersionId&q=OrganizationCode='<>'

Response:
"count": 500,
"hasMore": true,
"limit": 500,
"offset": 0,

Call2:

https://<>/fscmRestApi/resources/latest/workDefinitions?expand=WorkDefinitionResource&onlyData=true&offset=500&limit=500&fields=InventoryItemId,ItemNumber,ItemDescription,OrganizationId,OrganizationCode,StatusCode,WorkDefinitionCode,WorkDefinitionId,WorkDefinitionVersionId&q=OrganizationCode='<>'

Response:
"count": 205,
"hasMore": false,
"limit": 500,
"offset": 500

However, few records were fetched in both calls, and few eligible records were not found in both calls.

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
Cause
Solution


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