"Too Many Matching Records Found. Specify Additional Criteria To Limit The Number Of Records" Error When Calling SOAP WS (Doc ID 2949045.1)

Last updated on MAY 18, 2023

Applies to:

Symptoms

On : NA version, Webservice

ACTUAL BEHAVIOR
---------------------
Calling a SOAP WebService through a trigger in Contract Object will have the following outcome:

adf.webServices.ContractServiceV2.getContractByPrimaryKey(ContractId) will have no issue while the related contracts of a contract are under 500 records.

However if the contract has 500 or more related contracts an error will pop: "JBO-25089: Too many matching records found. Specify additional criteria to limit the number of records". This error is being received both in SOAP and UI

EXPECTED BEHAVIOR

----------------------

The response payload should return all records regardless if they are over 500.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Go to SOAP WebService

2. Call adf.webServices.ContractServiceV2.getContractByPrimaryKey(ContractId) for a contract with related contracts

3. If the records are above the 500 mark, the error will pop up

ERROR
-----------------------

Cause

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