search_invoices
Search Accounts Payable invoices in Oracle Fusion by supplier name, invoice number, date range, status, or business unit.
Instructions
Search Accounts Payable invoices in Oracle Fusion. Examples: search_invoices({"supplier": "google"}) finds invoices from Google. search_invoices({"invoice_number": "INV-001"}) finds a specific invoice. search_invoices({"date_from": "2024-01-01", "date_to": "2024-03-31"}) finds invoices in Q1 2024.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| q | No | Advanced Oracle REST filter. Use Oracle syntax with semicolons as AND. | |
| limit | No | ||
| offset | No | ||
| status | No | Invoice validation status. Values: 'Validated', 'Needs Revalidation', 'Unvalidated' | |
| date_to | No | End of invoice date range. Format: YYYY-MM-DD | |
| supplier | No | Supplier/vendor name to search for. Partial match from start, automatically uppercased. | |
| date_from | No | Start of invoice date range. Format: YYYY-MM-DD | |
| business_unit | No | Business unit name, exact match. | |
| invoice_number | No | Exact invoice number. |