Accounting API

Ledger Accounts

Tax Rates

Company Info

Invoices

Customers

Bills

Suppliers

Invoice Items

Payments

Credit Notes

Journals

Journal Entries

Subsidiaries

BalanceSheet

ProfitAndLoss

Purchase Orders

Locations

Departments

Attachments

Tracking Categories

Bill Payments

Expenses

Aged Creditors

Aged Debtors

Bank Feed Accounts

Bank Feed Statements

Quotes

Bank Accounts

Projects

Refunds

Payment Methods

Sales Receipts

Goods Receipts

Companies

Employees

Expense Categories

Expense Reports

Bill Credit Notes

General Ledger Transactions

Oracle Fusion Cloud Financials is Oracle's enterprise cloud ERP suite, providing general ledger, accounts payable, and accounts receivable capabilities for mid-to-large enterprises.

connection

greenfield_gl_setup

receivables_setup

Oracle Fusion Cloud

Testing and production use the same kind of credentials: a connection points at one Fusion pod (Host and Data Center) and its identity domain. Test against a consumer's Additional Test Environment pod, which has its own OAuth application and integration user — there is no Apideck shared Oracle tenant. Caution: journal imports and invoice creates on a production pod create real records (journals arrive Unposted).

Configure OAuth Using the Fusion Applications Identity Domain

Importing Financials Data (FBDI via ERP Integration REST)

Create an Additional Test Environment

Core Financial

Accounts Receivable

Organization

Accounting period

Files attached to this journal entry. Use the attachments endpoints with reference_type=journal-entry and this entry's id where the connector supports it.

critical

The company ID the transaction belongs to

CompanyId

The date and time when the object was created.

Created at (timestamp)

Created by

Indicates the associated currency for an amount of money. Values correspond to [ISO 4217](https://en.wikipedia.org/wiki/ISO_4217).

Currency

UNKNOWN_CURRENCY

Currency Exchange Rate at the time entity was recorded/generated.

Currency Exchange Rate

medium

When custom mappings are configured on the resource, the result is included here.

Display ID

The third-party API ID of original entity

Journal symbol of the entry. For example IND for indirect costs. Where supported, list /accounting/journals to discover available journals and their posting rules. For Exact Online, supply the journal code, not its id.

Journal symbol

Requires a minimum of 2 line items that sum to 0

Memo

Journal entry number

The pass_through property allows passing service-specific, custom data or structured modifications in request body when creating or updating resources.

This is the date on which the journal entry was added. This can be different from the creation date and can also be backdated.

Posted at (timestamp)

A binary value used to detect updates to a object and prevent data conflicts. It is incremented each time an update is made to the object.

Row version

A unique identifier for the source of the journal entry

Source ID

Source Type

Status

Display id

Name

Applicable tax id/code override if tax is not supplied on a line item basis.

Tax Code

Tax inclusive

Deprecated — use line_items[].tax_type for per-line tax applicability. Kept as fallback: applies to all lines that do not set their own tax_type.

Tax Type

Journal entry title

Linked tracking categories

The date and time when the object was last updated.

Updated at (timestamp)

Updated by

Is active

Account Name

Account Number

Account Type

Bank Code

The name of the bank or financial institution

Bank Name

BIC/SWIFT Code

Branch Identifier

Bank State Branch number (Australia/New Zealand)

BSB Number

Country code according to ISO 3166-1 alpha-2.

Country Code

IBAN

Routing Number

Classification

Code

Current balance

Description

The human readable display ID used when displaying the account

Fully Qualified Name

Is header

Reconciliation Date means the last calendar day of each Reconciliation Period.

Last Reconciliation Date

Nominal Code

Opening balance

The human readable display ID used when displaying the parent account

Parent account ID

Account status

Whether the account is a sub account or not.

Is sub account

Sub accounts

Sub Type

Tax rate code

The ID of the object.

Rate

Type

high

The name of the parent tracking category.

Based on the status some functionality is enabled or disabled.

Tracking Category status

Account ID

Parent ID

Category ID

Item code

Department ID

Item ID

The date of opening balance if inventory item is tracked - YYYY-MM-DD.

Inventory date

Location ID

Item name

Description of the unit type the item is sold as, ie: kg, hour.

Unit of measure

Unit price

Item is available for purchase transactions

Item purchased

Quantity

Item will be available on sales transactions

Item sold

Subsidiary ID

Tax schedule ID

If true, transactions for this item are taxable

Item taxable

Item tracked

The unique identifier for the tracking category.

Tracking Category ID

Tracking Category Name

Indicates if accounting by row is used (true) or not (false). Accounting by row means that a separate ledger transaction is created for each row.

Accounting by Row

Balance

Name of the contact person at the address

country code according to ISO 3166-1 alpha-2.

Address field that holds a sublocality, such as a county

Line 1 of the address e.g. number, street, suite, apt #, etc.

Notes

Salutation of the contact person at the address

The address string. Some APIs don't provide structured address data.

edge-case

The channel through which the transaction is processed.

Channel

Company Name

Display Name

Email

The ID of the customer this entity is linked to.

Customer ID

The name of the customer. Deprecated, use display_name instead.

LinkedCustomer

Customer memo

Deposit

Discount Amount

Discount percentage applied to this invoice.

Discount Percent

The invoice due date is the date on which a payment or invoice is scheduled to be received by the seller - YYYY-MM-DD.

Due date

Invoice date

Invoice Sent

language code according to ISO 639-1. For the United States - EN

Invoice Line Item

Invoice number

Payment method used for the transaction, such as cash, credit card, bank transfer, or check

Payment method

A PO Number uniquely identifies a purchase order and is generally defined by the buyer. The buyer will match the PO number in the invoice to the Purchase Order.

Purchase Order number

Optional reference identifier for the transaction.

Oracle Fusion Cloud – Supported Resources

Supported resources