Oracle Export

The Oracle Export page allows eligible HirePOS invoices to be exported for importing into Oracle.

The page displays invoices that meet the Oracle export requirements and lets you select which records to include. Invoices that have already been exported can also be displayed or excluded from the list.

Open the Oracle Export page in HirePOS.

The Invoices tab displays the invoices currently available for export. Each record includes:

• Exported status

• Invoice number

• Invoice date

• Customer

• Customer code

• Customer PO

• Invoice amount

The total number and value of the displayed invoices are shown below the list.

The Oracle Export page includes invoices that:

• Are in Invoice mode.

• Have an outstanding balance.

• Are dated within the last 60 days.

• Are not assigned to an INTERNAL customer category.

• Do not contain hire items.

By default, invoices that have previously been exported are hidden.

Invoices in the list are selected by default.

Use the checkbox beside an invoice to include or exclude it from the next export. You can also use the checkbox at the top of the list to select or clear all displayed invoices.

To create the Oracle export:

1. Select the invoices you want to export.

2. Click Export Oracle CSV.

3. HirePOS generates the Oracle-formatted export file using the selected invoices.

The generated file contains the billing, customer, invoice line, tax, account and reference information required by the configured Oracle integration.
When an invoice is included in the Oracle export, HirePOS records an Export Date against that invoice.

The Oracle export contains header, billing, invoice-line and account records, with the appropriate Oracle account and transaction information applied for the configured integration.

Click CSV to export the selected invoices using the separate CSV export option.

This can be useful when invoice information is required in a standard CSV format rather than the Oracle-specific export format.

Open the Options tab and use Hide Exported to control whether previously exported invoices appear.

• Enabled — previously exported invoices are hidden.

• Disabled — previously exported invoices are included in the list.

The option is enabled by default.

If the most recent Oracle export needs to be reversed:

1. Click Undo Last.

2. Confirm the Undo Last Export? prompt.

3. Click Yes.

HirePOS removes the Export Date from all invoices associated with the most recent export, allowing those invoices to appear as unexported again.

Note: Undo Last applies to the most recent export batch, not just an individual invoice.

Click Refresh to reload the invoice list using the current Hide Exported setting.