"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:
Oracle Fusion Enterprise Contracts Management Cloud Service - Version 11.13.23.01.0 and laterInformation in this document applies to any platform.
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
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 |
References |