Agent not able to call second tool
Summary:
Oracle AI agent studio : I am working on designing a agent which can answer/derive Invoice status for a particular invoice user is querying about. User will input either invoice number or supplier number or supplier name; first tool will retrieve the invoice details (these 4 fields : Validation Status, Approval Status, Account Coding Status, Payment Status) and then using second tool will fetch the business rules mapping stored in a lookup and answer invoice status based on this business mapping.
Lookup has these values comma separated in the meaning column : VALIDATED,WORKFLOW_APPROVED,ACCOUNTED,PAID
then definition will have the Invoice status which should be returned back to the user as the response for particular combination of these 4 fields