I´m developing an AI Agent in Oracle AI Agent Studio to interact with our Accounts Payable (AP) Invoice data. However, I've hit a critical roadblock: my agent's queries only return a maximum of 500 records, severely limiting its analytical capabilities.
This 500-record cap means the agent cannot access the complete set of AP invoices, rendering its insights incomplete and unreliable. The agent needs to be able to query the entire universe of payable invoices, regardless of the total count.
My goal is for the AI Agent to accurately answer critical, real-time business questions about all existing payable invoices, such as:
Total Number of Invoices: "How many payable invoices are there in total?"
Vendor Specifics: "How many invoices are there for the supplier 'XYZ Corp'?"
Overdue Analysis: "Which invoices are currently overdue, and what is the total overdue amount?"
Total Liabilities: "What is our total outstanding Accounts Payable liability?"
Upcoming Payments: "What is the maximum amount due in the next payment cycle?" (i.e., the largest next payment date or highest amount among the next payments).
Current Problem: Because the agent is only working with the initial 500 records, the answers to all these questions are fundamentally flawed.
What I need help with:
Is there a known configuration, setting, or limitation within Oracle AI Agent Studio or the underlying data source (e.g., a Business Object, a REST API call) that enforces this 500-record limit?
How can I modify the agent's data retrieval method or the query definition to correctly implement robust pagination or bypass this limit to access all relevant AP invoice records?
Specifically, if the agent uses a REST API or Business Object, what is the best practice within the Agent Studio to loop through or retrieve subsequent pages of data to ensure a full dataset is processed for analysis?
Any guidance on how to architect the data retrieval layer of the AI Agent to handle large datasets effectively would be greatly appreciated. I need to be able to analyze all payable invoices, not just the first 500.