# Oracle Fusion Cloud ERP

> Read financial records and manage payables invoices in Oracle Fusion Cloud ERP.

App · 25 actions. Web page: https://docs.lodol.com/docs/integrations/oracle-fusion-cloud-erp

## Actions

### Create payables invoice

Create a payables invoice and its lines. Use a test environment for QA; submitting an invoice can start financial approval processes.

**Inputs**

- Invoice number (`invoice_number`, text, required): The unique number for supplier invoice.
- Invoice date (`invoice_date`, date, required): The date on the supplier invoice. The value can either be provided while creating an invoice or populated by default to the system date.
- Accounting date (`accounting_date`, date, required): The accounting date captured on the invoice that is finally used to default to invoice lines and distributions. The value can either be provided while creating the invoice or derived based on the Accounting Date Basis option on the Manage Invoice Options for the invoicing business unit.
- Terms date (`terms_date`, date, required): The date used with payment terms to calculate installment along with due date and discount dates. The value can either be provided while creating an invoice or derived based on the Terms Date Basis option from the Supplier Site or from the Manage Invoice Options for the invoicing business unit.
- Invoice amount (`invoice_amount`, number, required): The invoice amount in transaction currency. The value must be provided while creating an invoice.
- Invoice currency (`invoice_currency`, text, required): The currency code used on the invoice. The value can either be provided while creating an invoice or populated by default from the Supplier Site or from the Manage Invoice Options for the invoicing business unit.
- Payment currency (`payment_currency`, text, required): The currency used to make a payment. The value can either be provided while creating an invoice or populated by default from the Supplier Site or from the Manage Invoice Options for the invoicing business unit.
- Payment method code (`payment_method_code`, text, required): The user-entered payment method code that helps to uniquely identify a payment method.
- Business unit (`business_unit`, text, required): Indicates the business unit name for the invoice. The value can either be provided while creating an invoice or populated by default from the profile option DEFAULT_ORG_ID. It cannot be updated once the invoice is created.
- Supplier (`supplier`, text, required): The supplier name on the invoice. The value must be provided while creating the invoice. It cannot be updated once the invoice is created.
- Supplier site (`supplier_site`, text, required): The name of the physical location of the supplier from where the goods and services are rendered. The value must be provided during creation action. It cannot be updated once the invoice is created.
- Description (`description`, text): The statement that describes the invoice.
- Payment terms (`payment_terms`, text): The payment terms used to calculate installments and to calculate due dates, discount dates, and discount amounts for each invoice. The value can either be provided while creating an invoice or populated by default from the Supplier Site or from the Manage Invoice Options for the invoicing business unit.
- Invoice lines (`invoice_lines`, list, required): Invoice lines.

**Outputs**

- `data` (object): Oracle Fusion Cloud ERP response data.

**Example output**

```json
{
  "data": {
    "BusinessUnit": "example",
    "CreationDate": "example",
    "InvoiceAmount": 1.0,
    "InvoiceCurrency": "example",
    "InvoiceDate": "example",
    "InvoiceId": 1,
    "InvoiceNumber": "example",
    "LastUpdateDate": "example",
    "Supplier": "example",
    "SupplierSite": "example",
    "resource_key": "example"
  }
}
```

### Delete payables invoice

Delete an eligible, unvalidated payables invoice. Oracle refuses deletion for invoices that have progressed beyond the allowed state.

**Inputs**

- Payables invoice (`resource_key`, text, required): Opaque key from the resource_key field returned by List payables invoices.

**Outputs**

- `data` (object): Oracle Fusion Cloud ERP response data.

**Example output**

```json
{
  "data": {}
}
```

### Get bank

Get bank.

**Inputs**

- bank (`resource_key`, text, required): Opaque key from the resource_key field returned by List banks.

**Outputs**

- `data` (object): Oracle Fusion Cloud ERP response data.

**Example output**

```json
{
  "data": {
    "BankName": "example",
    "BankPartyId": 1,
    "CreationDate": "example",
    "LastUpdateDate": "example",
    "resource_key": "example"
  }
}
```

### Get bank account

Get bank account.

**Inputs**

- bank account (`resource_key`, text, required): Opaque key from the resource_key field returned by List bank accounts.

**Outputs**

- `data` (object): Oracle Fusion Cloud ERP response data.

**Example output**

```json
{
  "data": {
    "BankAccountId": 1,
    "BankAccountName": "example",
    "CreationDate": "example",
    "LastUpdateDate": "example",
    "resource_key": "example"
  }
}
```

### Get bank branch

Get bank branch.

**Inputs**

- bank branch (`resource_key`, text, required): Opaque key from the resource_key field returned by List bank branches.

**Outputs**

- `data` (object): Oracle Fusion Cloud ERP response data.

**Example output**

```json
{
  "data": {
    "BankBranchName": "example",
    "BranchPartyId": 1,
    "CreationDate": "example",
    "LastUpdateDate": "example",
    "resource_key": "example"
  }
}
```

### Get expense report

Get expense report.

**Inputs**

- expense report (`resource_key`, text, required): Opaque key from the resource_key field returned by List expense reports.

**Outputs**

- `data` (object): Oracle Fusion Cloud ERP response data.

**Example output**

```json
{
  "data": {
    "BusinessUnit": "example",
    "CreationDate": "example",
    "ExpenseReportId": 1,
    "ExpenseReportNumber": "example",
    "LastUpdateDate": "example",
    "resource_key": "example"
  }
}
```

### Get invoice line

Get invoice line.

**Inputs**

- Payables invoice (`resource_key`, text, required): Opaque key from the resource_key field returned by List payables invoices.
- Invoice line (`line_key`, text, required): Opaque key from List invoice lines.

**Outputs**

- `data` (object): Oracle Fusion Cloud ERP response data.

**Example output**

```json
{
  "data": {
    "Description": "example",
    "LineAmount": 1.0,
    "LineNumber": 1,
    "LineType": "example",
    "resource_key": "example"
  }
}
```

### Get journal batch

Get journal batch.

**Inputs**

- journal batch (`resource_key`, text, required): Opaque key from the resource_key field returned by List journal batches.

**Outputs**

- `data` (object): Oracle Fusion Cloud ERP response data.

**Example output**

```json
{
  "data": {
    "CreationDate": "example",
    "JeBatchId": 1,
    "LastUpdateDate": "example",
    "Status": "example",
    "resource_key": "example"
  }
}
```

### Get payables invoice

Get payables invoice.

**Inputs**

- Payables invoice (`resource_key`, text, required): Opaque key from the resource_key field returned by List payables invoices.

**Outputs**

- `data` (object): Oracle Fusion Cloud ERP response data.

**Example output**

```json
{
  "data": {
    "BusinessUnit": "example",
    "CreationDate": "example",
    "InvoiceAmount": 1.0,
    "InvoiceCurrency": "example",
    "InvoiceDate": "example",
    "InvoiceId": 1,
    "InvoiceNumber": "example",
    "LastUpdateDate": "example",
    "Supplier": "example",
    "SupplierSite": "example",
    "resource_key": "example"
  }
}
```

### Get payables payment

Get payables payment.

**Inputs**

- payables payment (`resource_key`, text, required): Opaque key from the resource_key field returned by List payables payments.

**Outputs**

- `data` (object): Oracle Fusion Cloud ERP response data.

**Example output**

```json
{
  "data": {
    "BusinessUnit": "example",
    "CheckId": 1,
    "CreationDate": "example",
    "InvoiceAmount": 1.0,
    "InvoiceCurrency": "example",
    "LastUpdateDate": "example",
    "PaymentNumber": 1,
    "resource_key": "example"
  }
}
```

### Get receivables invoice

Get receivables invoice.

**Inputs**

- receivables invoice (`resource_key`, text, required): Opaque key from the resource_key field returned by List receivables invoices.

**Outputs**

- `data` (object): Oracle Fusion Cloud ERP response data.

**Example output**

```json
{
  "data": {
    "BusinessUnit": "example",
    "CreationDate": "example",
    "CustomerTransactionId": 1,
    "LastUpdateDate": "example",
    "TransactionNumber": "example",
    "resource_key": "example"
  }
}
```

### Get standard receipt

Get standard receipt.

**Inputs**

- standard receipt (`resource_key`, text, required): Opaque key from the resource_key field returned by List standard receipts.

**Outputs**

- `data` (object): Oracle Fusion Cloud ERP response data.

**Example output**

```json
{
  "data": {
    "BusinessUnit": "example",
    "CreationDate": "example",
    "LastUpdateDate": "example",
    "ReceiptNumber": "example",
    "StandardReceiptId": 1,
    "Status": "example",
    "resource_key": "example"
  }
}
```

### List bank accounts

List bank accounts. Gets one page; to see more, run it again with the next page it gives.

**Inputs**

- Limit (`limit`, number): Limit. From 1 to 500.
- Offset (`offset`, number): Offset. At least 0.
- Query (`query`, text): Oracle filter expression, for example InvoiceNumber="INV-100". Leave empty to list all records.
- Order by (`order_by`, text): Oracle attribute and direction, for example LastUpdateDate:desc.

**Outputs**

- `data` (object): Oracle Fusion Cloud ERP response data.

**Example output**

```json
{
  "data": {
    "count": 1,
    "hasMore": false,
    "items": [],
    "limit": 1,
    "offset": 1,
    "totalResults": 1
  }
}
```

### List bank branches

List bank branches. Gets one page; to see more, run it again with the next page it gives.

**Inputs**

- Limit (`limit`, number): Limit. From 1 to 500.
- Offset (`offset`, number): Offset. At least 0.
- Query (`query`, text): Oracle filter expression, for example InvoiceNumber="INV-100". Leave empty to list all records.
- Order by (`order_by`, text): Oracle attribute and direction, for example LastUpdateDate:desc.

**Outputs**

- `data` (object): Oracle Fusion Cloud ERP response data.

**Example output**

```json
{
  "data": {
    "count": 1,
    "hasMore": false,
    "items": [],
    "limit": 1,
    "offset": 1,
    "totalResults": 1
  }
}
```

### List banks

List banks. Gets one page; to see more, run it again with the next page it gives.

**Inputs**

- Limit (`limit`, number): Limit. From 1 to 500.
- Offset (`offset`, number): Offset. At least 0.
- Query (`query`, text): Oracle filter expression, for example InvoiceNumber="INV-100". Leave empty to list all records.
- Order by (`order_by`, text): Oracle attribute and direction, for example LastUpdateDate:desc.

**Outputs**

- `data` (object): Oracle Fusion Cloud ERP response data.

**Example output**

```json
{
  "data": {
    "count": 1,
    "hasMore": false,
    "items": [],
    "limit": 1,
    "offset": 1,
    "totalResults": 1
  }
}
```

### List business units

List business units. Gets one page; to see more, run it again with the next page it gives.

**Inputs**

- Limit (`limit`, number): Limit. From 1 to 500.
- Offset (`offset`, number): Offset. At least 0.
- Query (`query`, text): Oracle filter expression, for example InvoiceNumber="INV-100". Leave empty to list all records.
- Order by (`order_by`, text): Oracle attribute and direction, for example LastUpdateDate:desc.

**Outputs**

- `data` (object): Oracle Fusion Cloud ERP response data.

**Example output**

```json
{
  "data": {
    "count": 1,
    "hasMore": false,
    "items": [],
    "limit": 1,
    "offset": 1,
    "totalResults": 1
  }
}
```

### List expense reports

List expense reports. Gets one page; to see more, run it again with the next page it gives.

**Inputs**

- Limit (`limit`, number): Limit. From 1 to 500.
- Offset (`offset`, number): Offset. At least 0.
- Query (`query`, text): Oracle filter expression, for example InvoiceNumber="INV-100". Leave empty to list all records.
- Order by (`order_by`, text): Oracle attribute and direction, for example LastUpdateDate:desc.

**Outputs**

- `data` (object): Oracle Fusion Cloud ERP response data.

**Example output**

```json
{
  "data": {
    "count": 1,
    "hasMore": false,
    "items": [],
    "limit": 1,
    "offset": 1,
    "totalResults": 1
  }
}
```

### List invoice lines

List invoice lines. Gets one page; to see more, run it again with the next page it gives.

**Inputs**

- Payables invoice (`resource_key`, text, required): Opaque key from the resource_key field returned by List payables invoices.
- Limit (`limit`, number): Limit. From 1 to 500.
- Offset (`offset`, number): Offset. At least 0.

**Outputs**

- `data` (object): Oracle Fusion Cloud ERP response data.

**Example output**

```json
{
  "data": {
    "count": 1,
    "hasMore": false,
    "items": []
  }
}
```

### List journal batches

List journal batches. Gets one page; to see more, run it again with the next page it gives.

**Inputs**

- Limit (`limit`, number): Limit. From 1 to 500.
- Offset (`offset`, number): Offset. At least 0.
- Query (`query`, text): Oracle filter expression, for example InvoiceNumber="INV-100". Leave empty to list all records.
- Order by (`order_by`, text): Oracle attribute and direction, for example LastUpdateDate:desc.

**Outputs**

- `data` (object): Oracle Fusion Cloud ERP response data.

**Example output**

```json
{
  "data": {
    "count": 1,
    "hasMore": false,
    "items": [],
    "limit": 1,
    "offset": 1,
    "totalResults": 1
  }
}
```

### List ledger balances

List ledger balances. Gets one page; to see more, run it again with the next page it gives.

**Inputs**

- Limit (`limit`, number): Limit. From 1 to 500.
- Offset (`offset`, number): Offset. At least 0.
- Query (`query`, text): Oracle filter expression, for example InvoiceNumber="INV-100". Leave empty to list all records.
- Order by (`order_by`, text): Oracle attribute and direction, for example LastUpdateDate:desc.

**Outputs**

- `data` (object): Oracle Fusion Cloud ERP response data.

**Example output**

```json
{
  "data": {
    "count": 1,
    "hasMore": false,
    "items": [],
    "limit": 1,
    "offset": 1,
    "totalResults": 1
  }
}
```

### List payables invoices

List payables invoices. Gets one page; to see more, run it again with the next page it gives.

**Inputs**

- Limit (`limit`, number): Limit. From 1 to 500.
- Offset (`offset`, number): Offset. At least 0.
- Query (`query`, text): Oracle filter expression, for example InvoiceNumber="INV-100". Leave empty to list all records.
- Order by (`order_by`, text): Oracle attribute and direction, for example LastUpdateDate:desc.
- Business unit (`business_unit`, text): Filter to this business unit.

**Outputs**

- `data` (object): Oracle Fusion Cloud ERP response data.

**Example output**

```json
{
  "data": {
    "count": 1,
    "hasMore": false,
    "items": [],
    "limit": 1,
    "offset": 1,
    "totalResults": 1
  }
}
```

### List payables payments

List payables payments. Gets one page; to see more, run it again with the next page it gives.

**Inputs**

- Limit (`limit`, number): Limit. From 1 to 500.
- Offset (`offset`, number): Offset. At least 0.
- Query (`query`, text): Oracle filter expression, for example InvoiceNumber="INV-100". Leave empty to list all records.
- Order by (`order_by`, text): Oracle attribute and direction, for example LastUpdateDate:desc.

**Outputs**

- `data` (object): Oracle Fusion Cloud ERP response data.

**Example output**

```json
{
  "data": {
    "count": 1,
    "hasMore": false,
    "items": [],
    "limit": 1,
    "offset": 1,
    "totalResults": 1
  }
}
```

### List receivables invoices

List receivables invoices. Gets one page; to see more, run it again with the next page it gives.

**Inputs**

- Limit (`limit`, number): Limit. From 1 to 500.
- Offset (`offset`, number): Offset. At least 0.
- Query (`query`, text): Oracle filter expression, for example InvoiceNumber="INV-100". Leave empty to list all records.
- Order by (`order_by`, text): Oracle attribute and direction, for example LastUpdateDate:desc.

**Outputs**

- `data` (object): Oracle Fusion Cloud ERP response data.

**Example output**

```json
{
  "data": {
    "count": 1,
    "hasMore": false,
    "items": [],
    "limit": 1,
    "offset": 1,
    "totalResults": 1
  }
}
```

### List standard receipts

List standard receipts. Gets one page; to see more, run it again with the next page it gives.

**Inputs**

- Limit (`limit`, number): Limit. From 1 to 500.
- Offset (`offset`, number): Offset. At least 0.
- Query (`query`, text): Oracle filter expression, for example InvoiceNumber="INV-100". Leave empty to list all records.
- Order by (`order_by`, text): Oracle attribute and direction, for example LastUpdateDate:desc.

**Outputs**

- `data` (object): Oracle Fusion Cloud ERP response data.

**Example output**

```json
{
  "data": {
    "count": 1,
    "hasMore": false,
    "items": [],
    "limit": 1,
    "offset": 1,
    "totalResults": 1
  }
}
```

### Update payables invoice

Update payables invoice.

**Inputs**

- Payables invoice (`resource_key`, text, required): Opaque key from the resource_key field returned by List payables invoices.
- Terms date (`terms_date`, date): The date used with payment terms to calculate installment along with due date and discount dates. The value can either be provided while creating an invoice or derived based on the Terms Date Basis option from the Supplier Site or from the Manage Invoice Options for the invoicing business unit.
- Description (`description`, text): The statement that describes the invoice.
- Payment terms (`payment_terms`, text): The payment terms used to calculate installments and to calculate due dates, discount dates, and discount amounts for each invoice. The value can either be provided while creating an invoice or populated by default from the Supplier Site or from the Manage Invoice Options for the invoicing business unit.

**Outputs**

- `data` (object): Oracle Fusion Cloud ERP response data.

**Example output**

```json
{
  "data": {
    "BusinessUnit": "example",
    "CreationDate": "example",
    "InvoiceAmount": 1.0,
    "InvoiceCurrency": "example",
    "InvoiceDate": "example",
    "InvoiceId": 1,
    "InvoiceNumber": "example",
    "LastUpdateDate": "example",
    "Supplier": "example",
    "SupplierSite": "example",
    "resource_key": "example"
  }
}
```
