java Webservices: I have 4 instance of a webservice running .. every service select data from INBOUND_REQUEST table for reprocessing..
INBOUND_REQUEST table structure with data

requestID, Account_cd, Requestmsg, createdDateTime, status
1,APPLE,<DUMMY Message 1>,12-Jan-2024 1:00AM, PENDING
2,APPLE,<DUMMY Message 2>,12-Jan-2024 1:10AM, PENDING
3,APPLE,<DUMMY Message 3>,12-Jan-2024 1:15AM, PENDING
4,APPLE,<DUMMY Message 4>,12-Jan-2024 4:00AM, PENDING
5,GOOGL,<DUMMY Message 1>,12-Jan-2024 1:00AM, PENDING
6,GOOGL,<DUMMY Message 2>,12-Jan-2024 2:00AM, PENDING
7,FF,<DUMMY Message 1>,12-Jan-2024 1:00AM, PENDING
8,FF,<DUMMY Message 2>,12-Jan-2024 2:00AM, PENDING
9,FF,<DUMMY Message 3>,12-Jan-2024 3:00AM, PENDING
10,ABC,<DUMMY Message 1>,12-Jan-2024 3:00AM, PENDING
11,ABC,<DUMMY Message 2>,12-Jan-2024 3:03AM, PENDING
12,ABC,<DUMMY Message 3>,12-Jan-2024 3:04AM, PENDING
13,ABC,<DUMMY Message 4>,12-Jan-2024 3:06AM, PENDING
14,qqq,<DUMMY Message 1>,12-Jan-2024 2:00AM, PENDING
15,qqq,<DUMMY Message 2>,12-Jan-2024 3:03AM, PENDING

I need to provide all request in Table grouped by account Name to every Instance. i.e.
if all the request for APPLE are picked by Instance 1 it should not be picked by Instance 2.
Example:

Instance 1 (APPLE 1,2,3,4) (qqq 14,15)
Instance 2 (GOOGL 5,6)  
Instance 3 (FF 7,8,9)  
Instance 4 (ABC 10,11,12,13)  

how to achieve this in java Spring boot with Oracle DB?