Connect Oracle Database to Avalara

Both apps 29Oracle Database 12Avalara 17

• Trigger
  New Column

  Fires when a new column appears on an Oracle table you choose.

• Trigger
  New or Updated Row

  Triggers when a new row is added or modified.

• Trigger
  New or Updated Row (Custom Query)

  Fires for each new or changed row returned by a SELECT statement you write against the connected Oracle database.

• Trigger
  New Row

  Triggers when you add a new row.

• Trigger
  New Table

  Fires when a new table appears in the connected Oracle user's own schema.

• Action
  Add Row

  Add one row to a table on the connected Oracle database.

• Action
  Delete Row

  Delete the rows in a table whose chosen column equals a value.

• Action
  Find Row

  Find the first row in a table whose chosen column matches a value.

• Action
  Find Rows via Custom Query

  Runs a SELECT statement you write against the connected Oracle database and returns every row it matches.

• Action
  Find Row via Custom Query

  Runs a SELECT statement you write against the connected Oracle database and returns the first row it matches.

• Action
  Run Custom Statement

  Runs a statement you write against the connected Oracle database that changes data rather than returning rows, and reports how many rows it changed.

• Action
  Update Row

  Change column values on every row of a table whose chosen column matches a value.

• Action
  Commit Transaction

  Commits a transaction so it is included in tax filings.

• Action
  Create Customer

  Creates a customer in a company, used for exemption certificate tracking.

• Action
  Create Transaction

  Calculates sales tax for a single-line sale and records it as a transaction.

• Action
  Delete Customer

  Deletes a customer record from an AvaTax company, identified by its customer code.

• Action
  Get Company

  Returns one company in your Avalara account.

• Action
  Get Customer

  Returns a single customer record from an AvaTax company, looked up by its customer code.

• Action
  Get Tax Rates by Address

  Returns the combined and per-jurisdiction sales tax rates for a street address.

• Action
  Get Transaction

  Returns one transaction with its calculated tax.

• Action
  List Companies

  Returns the companies in your Avalara account.

• Action
  List Customers

  Returns the customers of one company.

• Action
  List items

  Returns the items (products and their tax codes) defined for an AvaTax company, up to 1,000 records.

• Action
  List nexus

  Returns the nexus declarations (jurisdictions where the company collects tax) for an AvaTax company.

• Action
  List Transactions

  Returns the transactions recorded for one company.

• Action
  Refund Transaction

  Creates a refund (return invoice) for a committed AvaTax sales transaction, fully, partially, tax-only or by percentage.

• Action
  Resolve Address

  Validates an address and returns its normalized form with coordinates.

• Action
  Update Transaction

  Adjusts an existing AvaTax transaction, replacing it with new document details and recalculating tax while keeping an audit record of the adjustment reason.

• Action
  Void Transaction

  Voids a transaction so it no longer counts toward tax liability.

No trigger or action matches that. Ask your agent to add it: it reads the API documentation and builds what you describe.