Oracle Visual Builder Add-In for Excel : Manage Requisition : List of values restriction

Summary:

Purchase Requisitions Using Oracle Visual Builder Add-in for Excel.

We are using the Oracle VBCS Excel add-in to create and manage Purchase Requisitions. All items are linked to Blanket Purchase Agreements (BPAs). To ensure users select the correct agreement details and pricing for each requisition line, I added a List of Values (LOV) to the AgreementNumber field.

The LOV works well when the agreement has a small number of lines. However, when the agreement includes a large number of lines (e.g., 1,000 to 15,000), the query fails to return any results. However, the same query executes successfully when tested in Postman.