FA:SCM:INV: 'Too many objects' Error Raised While Using openPickLines API (Doc ID 2973306.1)

Last updated on SEPTEMBER 12, 2023

Applies to:

Symptoms

On : 11.13.23.07.0 version, Inventory

After 23C update, the OpenPickLines REST resource fails with a "Too many objects match the primary key oracle.jbo.Key" error.

This error can occur when a picking line is split during pick confirm. After this split, one of the picking lines is pick confirmed and the second picking line is not picked (kept open). The REST resource will fail if the OpenPickLines REST resource returns this open picking line as part of the search criteria.

ERROR
-----------------------
“Too many objects match the primary key oracle.jbo.Key”

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

1. Split a picking line during pick confirm.
2. Pick confirm one of the picking lines. (Keep the second picking line open.)
3. Call the OpenPickLines REST resource with the open picking line in the search criteria.
4. Receive error “Too many objects match the primary key oracle.jbo.Key”

Cause

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