JBO-25013: Too many objects match the primary key oracle.jbo.Key[300000066689474 ].. (DOO-2685874)

Summary:

We created an extension to retrieve the credit check flag from the customer account profile.

In the setup, we have three records: two are deactivated and one is active. The extension is configured correctly; however, when submitting sales orders, we encounter a primary key error.

vcrow1.setAttribute("CustProfileCustAccountId", custActId);

vcrow1.setAttribute("EffectiveStartDate", "<=" + sqlDate);

vcrow1.setAttribute("EffectiveEndDate", ">" + sqlDate);

I attached the extension

Could you please help us?

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

25D

Code Snippet (add any code snippets that support your topic, if applicable):