Oracle Fusion Cloud ERP

App · 25 actions

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

Actions

ActionWhat it does
Create payables invoiceCreate a payables invoice and its lines.
Delete payables invoiceDelete an eligible, unvalidated payables invoice.
Get bankGet bank.
Get bank accountGet bank account.
Get bank branchGet bank branch.
Get expense reportGet expense report.
Get invoice lineGet invoice line.
Get journal batchGet journal batch.
Get payables invoiceGet payables invoice.
Get payables paymentGet payables payment.
Get receivables invoiceGet receivables invoice.
Get standard receiptGet standard receipt.
List bank accountsList bank accounts.
List bank branchesList bank branches.
List banksList banks.
List business unitsList business units.
List expense reportsList expense reports.
List invoice linesList invoice lines.
List journal batchesList journal batches.
List ledger balancesList ledger balances.
List payables invoicesList payables invoices.
List payables paymentsList payables payments.
List receivables invoicesList receivables invoices.
List standard receiptsList standard receipts.
Update payables invoiceUpdate payables invoice.

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 numberinvoice_numbertextRequired
The unique number for supplier invoice.
Invoice dateinvoice_datedateRequired
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 dateaccounting_datedateRequired
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 dateterms_datedateRequired
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 amountinvoice_amountnumberRequired
The invoice amount in transaction currency. The value must be provided while creating an invoice.
Invoice currencyinvoice_currencytextRequired
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 currencypayment_currencytextRequired
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 codepayment_method_codetextRequired
The user-entered payment method code that helps to uniquely identify a payment method.
Business unitbusiness_unittextRequired
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.
SuppliersuppliertextRequired
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 sitesupplier_sitetextRequired
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.
Descriptiondescriptiontext
The statement that describes the invoice.
Payment termspayment_termstext
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 linesinvoice_lineslistRequired
Invoice lines.

Outputs

dataobject
Oracle Fusion Cloud ERP response data.
Example output
{
  "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 invoiceresource_keytextRequired
Opaque key from the resource_key field returned by List payables invoices.

Outputs

dataobject
Oracle Fusion Cloud ERP response data.
Example output
{
  "data": {}
}

Get bank

Get bank.

Inputs

bankresource_keytextRequired
Opaque key from the resource_key field returned by List banks.

Outputs

dataobject
Oracle Fusion Cloud ERP response data.
Example output
{
  "data": {
    "BankName": "example",
    "BankPartyId": 1,
    "CreationDate": "example",
    "LastUpdateDate": "example",
    "resource_key": "example"
  }
}

Get bank account

Get bank account.

Inputs

bank accountresource_keytextRequired
Opaque key from the resource_key field returned by List bank accounts.

Outputs

dataobject
Oracle Fusion Cloud ERP response data.
Example output
{
  "data": {
    "BankAccountId": 1,
    "BankAccountName": "example",
    "CreationDate": "example",
    "LastUpdateDate": "example",
    "resource_key": "example"
  }
}

Get bank branch

Get bank branch.

Inputs

bank branchresource_keytextRequired
Opaque key from the resource_key field returned by List bank branches.

Outputs

dataobject
Oracle Fusion Cloud ERP response data.
Example output
{
  "data": {
    "BankBranchName": "example",
    "BranchPartyId": 1,
    "CreationDate": "example",
    "LastUpdateDate": "example",
    "resource_key": "example"
  }
}

Get expense report

Get expense report.

Inputs

expense reportresource_keytextRequired
Opaque key from the resource_key field returned by List expense reports.

Outputs

dataobject
Oracle Fusion Cloud ERP response data.
Example output
{
  "data": {
    "BusinessUnit": "example",
    "CreationDate": "example",
    "ExpenseReportId": 1,
    "ExpenseReportNumber": "example",
    "LastUpdateDate": "example",
    "resource_key": "example"
  }
}

Get invoice line

Get invoice line.

Inputs

Payables invoiceresource_keytextRequired
Opaque key from the resource_key field returned by List payables invoices.
Invoice lineline_keytextRequired
Opaque key from List invoice lines.

Outputs

dataobject
Oracle Fusion Cloud ERP response data.
Example output
{
  "data": {
    "Description": "example",
    "LineAmount": 1.0,
    "LineNumber": 1,
    "LineType": "example",
    "resource_key": "example"
  }
}

Get journal batch

Get journal batch.

Inputs

journal batchresource_keytextRequired
Opaque key from the resource_key field returned by List journal batches.

Outputs

dataobject
Oracle Fusion Cloud ERP response data.
Example output
{
  "data": {
    "CreationDate": "example",
    "JeBatchId": 1,
    "LastUpdateDate": "example",
    "Status": "example",
    "resource_key": "example"
  }
}

Get payables invoice

Get payables invoice.

Inputs

Payables invoiceresource_keytextRequired
Opaque key from the resource_key field returned by List payables invoices.

Outputs

dataobject
Oracle Fusion Cloud ERP response data.
Example output
{
  "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 paymentresource_keytextRequired
Opaque key from the resource_key field returned by List payables payments.

Outputs

dataobject
Oracle Fusion Cloud ERP response data.
Example output
{
  "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 invoiceresource_keytextRequired
Opaque key from the resource_key field returned by List receivables invoices.

Outputs

dataobject
Oracle Fusion Cloud ERP response data.
Example output
{
  "data": {
    "BusinessUnit": "example",
    "CreationDate": "example",
    "CustomerTransactionId": 1,
    "LastUpdateDate": "example",
    "TransactionNumber": "example",
    "resource_key": "example"
  }
}

Get standard receipt

Get standard receipt.

Inputs

standard receiptresource_keytextRequired
Opaque key from the resource_key field returned by List standard receipts.

Outputs

dataobject
Oracle Fusion Cloud ERP response data.
Example output
{
  "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

Limitlimitnumber
Limit.From 1 to 500.
Offsetoffsetnumber
Offset.At least 0.
Queryquerytext
Oracle filter expression, for example InvoiceNumber="INV-100". Leave empty to list all records.
Order byorder_bytext
Oracle attribute and direction, for example LastUpdateDate:desc.

Outputs

dataobject
Oracle Fusion Cloud ERP response data.
Example output
{
  "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

Limitlimitnumber
Limit.From 1 to 500.
Offsetoffsetnumber
Offset.At least 0.
Queryquerytext
Oracle filter expression, for example InvoiceNumber="INV-100". Leave empty to list all records.
Order byorder_bytext
Oracle attribute and direction, for example LastUpdateDate:desc.

Outputs

dataobject
Oracle Fusion Cloud ERP response data.
Example output
{
  "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

Limitlimitnumber
Limit.From 1 to 500.
Offsetoffsetnumber
Offset.At least 0.
Queryquerytext
Oracle filter expression, for example InvoiceNumber="INV-100". Leave empty to list all records.
Order byorder_bytext
Oracle attribute and direction, for example LastUpdateDate:desc.

Outputs

dataobject
Oracle Fusion Cloud ERP response data.
Example output
{
  "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

Limitlimitnumber
Limit.From 1 to 500.
Offsetoffsetnumber
Offset.At least 0.
Queryquerytext
Oracle filter expression, for example InvoiceNumber="INV-100". Leave empty to list all records.
Order byorder_bytext
Oracle attribute and direction, for example LastUpdateDate:desc.

Outputs

dataobject
Oracle Fusion Cloud ERP response data.
Example output
{
  "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

Limitlimitnumber
Limit.From 1 to 500.
Offsetoffsetnumber
Offset.At least 0.
Queryquerytext
Oracle filter expression, for example InvoiceNumber="INV-100". Leave empty to list all records.
Order byorder_bytext
Oracle attribute and direction, for example LastUpdateDate:desc.

Outputs

dataobject
Oracle Fusion Cloud ERP response data.
Example output
{
  "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 invoiceresource_keytextRequired
Opaque key from the resource_key field returned by List payables invoices.
Limitlimitnumber
Limit.From 1 to 500.
Offsetoffsetnumber
Offset.At least 0.

Outputs

dataobject
Oracle Fusion Cloud ERP response data.
Example output
{
  "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

Limitlimitnumber
Limit.From 1 to 500.
Offsetoffsetnumber
Offset.At least 0.
Queryquerytext
Oracle filter expression, for example InvoiceNumber="INV-100". Leave empty to list all records.
Order byorder_bytext
Oracle attribute and direction, for example LastUpdateDate:desc.

Outputs

dataobject
Oracle Fusion Cloud ERP response data.
Example output
{
  "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

Limitlimitnumber
Limit.From 1 to 500.
Offsetoffsetnumber
Offset.At least 0.
Queryquerytext
Oracle filter expression, for example InvoiceNumber="INV-100". Leave empty to list all records.
Order byorder_bytext
Oracle attribute and direction, for example LastUpdateDate:desc.

Outputs

dataobject
Oracle Fusion Cloud ERP response data.
Example output
{
  "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

Limitlimitnumber
Limit.From 1 to 500.
Offsetoffsetnumber
Offset.At least 0.
Queryquerytext
Oracle filter expression, for example InvoiceNumber="INV-100". Leave empty to list all records.
Order byorder_bytext
Oracle attribute and direction, for example LastUpdateDate:desc.
Business unitbusiness_unittext
Filter to this business unit.

Outputs

dataobject
Oracle Fusion Cloud ERP response data.
Example output
{
  "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

Limitlimitnumber
Limit.From 1 to 500.
Offsetoffsetnumber
Offset.At least 0.
Queryquerytext
Oracle filter expression, for example InvoiceNumber="INV-100". Leave empty to list all records.
Order byorder_bytext
Oracle attribute and direction, for example LastUpdateDate:desc.

Outputs

dataobject
Oracle Fusion Cloud ERP response data.
Example output
{
  "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

Limitlimitnumber
Limit.From 1 to 500.
Offsetoffsetnumber
Offset.At least 0.
Queryquerytext
Oracle filter expression, for example InvoiceNumber="INV-100". Leave empty to list all records.
Order byorder_bytext
Oracle attribute and direction, for example LastUpdateDate:desc.

Outputs

dataobject
Oracle Fusion Cloud ERP response data.
Example output
{
  "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

Limitlimitnumber
Limit.From 1 to 500.
Offsetoffsetnumber
Offset.At least 0.
Queryquerytext
Oracle filter expression, for example InvoiceNumber="INV-100". Leave empty to list all records.
Order byorder_bytext
Oracle attribute and direction, for example LastUpdateDate:desc.

Outputs

dataobject
Oracle Fusion Cloud ERP response data.
Example output
{
  "data": {
    "count": 1,
    "hasMore": false,
    "items": [],
    "limit": 1,
    "offset": 1,
    "totalResults": 1
  }
}

Update payables invoice

Update payables invoice.

Inputs

Payables invoiceresource_keytextRequired
Opaque key from the resource_key field returned by List payables invoices.
Terms dateterms_datedate
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.
Descriptiondescriptiontext
The statement that describes the invoice.
Payment termspayment_termstext
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

dataobject
Oracle Fusion Cloud ERP response data.
Example output
{
  "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"
  }
}

On this page