Skip to content
PlaidCloud

Import Fusion Entity

Description

Section titled “Description”

Imports one Oracle Fusion Cloud entity over your Oracle Fusion connection into a project table, calling Fusion’s OData or BI Publisher (BIP) endpoints directly. Pick the connection, the entity type, and any filters; the step pulls matching records and writes them, with no OData query to author.

For a pull too large for a direct call, use Import Fusion Bulk Extract instead.

Configuration

Section titled “Configuration”
Field Required Notes
Fusion Connection Yes The Oracle Fusion connection to read through.
Target Table Yes The project table the results are written to. It is overwritten in full on every run.
Entity Type Yes Which entity to pull. Default gl_balances. One of gl_balances, journal_batches.
Filters No Range filters (ge/le) on date, accounting-period, and numeric balance/amount fields, plus equality filters on discrete fields (ledger, currency). Each entity restricts filters to the fields Oracle Fusion can actually evaluate server side — an unsupported field is rejected, not silently dropped.

Entities and Filterable Fields

Section titled “Entities and Filterable Fields”
Entity Type What it pulls Filterable fields
gl_balances General ledger account balances accounting period range (ge/le), account range, balance amount range (ge/le)
journal_batches Journal batch headers and status date range (ge/le), accounting period range (ge/le)
Section titled “Related”