Oracle Fusion Financials

Oracle Fusion Cloud Financials gives your finance team better data to increase forecasting accuracy, shorten reporting cycles, simplify decision-making, and better manage risk and compliance. Oracle Fusion Cloud Financials is a global financial platform that connects and automates your financial management processes, including payables, receivables, fixed assets, expenses, and reporting, for a clear view into your total financial health. DLH.io is your best option to synchronize your Oracle Fusion Financials data to other target destination systems like Snowflake, Databricks, and the Oracle Data Warehouse.

Setup Instructions

Follow the setup steps guide for configuring your Oracle Fusion Financials connection to enable data to flow into your destination via DLH:

Supported Features

Here are key features supported for this connector.

Sync Feature	Supported	Details
Custom Data and Development	✓	Ability to enhance connector upon request
Historical Re-Load/Load	✓
Incremental/Delta Load	✓	Gets most recent records and changes
Column Selection	✓
Column Hashing	✓
Re-Sync Table/Entity	✓	Select at the table level to reload data history (on next Sync Bridge run)
Custom Queries		Utilizing SQL Data Query Connector
Custom Data
Captures Deleted Rows	✓	On all supported tables
API Sync Bridge Initiation	✓
Priority Scheduling	✓
Private VPC/Link	☂
DLH Data Model Available	-

If you have any questions about these supported features please reach out to our Customer Support team.

Details on Sync Processing

For this connector, we believe the sync processing is straightforward. We've provided a number of details, steps, and other guidance here and in the setup steps guide. Be sure to also check the change log and notes page from time to time for any changes.

Default Datastore/Table Resources via BICC

The default resources below represent the most commonly required tables for this Fusion BICC connector. Although more are available once you have connect to your fusion application, these are the ones DLH automatically selects for synchronization for your target destination data warehouse to help you simplify the initial process.

Table	Module	Why Selected
JournalHeaderExtractPVO	General Ledger	Core GL journal entry headers — required for all financial reporting
JournalLinePVO	General Ledger	Journal line detail — debits, credits, account segments
BookSummaryExtractPVO	Fixed Assets	Asset book summary — depreciation, net book value
LedgerExtractPVO	General Ledger	Ledger definitions — currency, calendar, chart of accounts
SubledgerAllJournalDistributionPVO	Subledger Accounting	Full subledger-to-GL distribution bridge
InvoiceHeaderExtractPVO	Accounts Payable	AP invoice headers — vendor, amount, status
InvoiceLineExtractPVO	Accounts Payable	AP invoice lines — item detail, quantity, price
InvoiceDistributionExtractPVO	Accounts Payable	AP distribution — cost center, account coding
InvoicePaymentExtractPVO	Accounts Payable	Payment records tied to AP invoices
InvoiceHoldExtractPVO	Accounts Payable	Hold reasons and release tracking on AP invoices
InvoiceSelfAssessedTaxDistributionPVO	Tax	Self-assessed tax distributions on AP invoices
DisbursementHeaderExtractPVO	Accounts Payable	Payment disbursement header — check/EFT details
PaidDisbursementSchedulePVO	Accounts Payable	Payment schedule for disbursements
TransactionHeaderExtractPVO	Accounts Receivable	AR transaction headers — invoice, debit memo, credit memo
TransactionLineExtractPVO	Accounts Receivable	AR transaction lines — revenue lines
TransactionHeaderBillsReceivablePVO	Accounts Receivable	Bills receivable transactions
ReceiptApplicationPVO	Accounts Receivable	Cash receipt application against AR transactions
ReceiptApplicationDistributionPVO	Accounts Receivable	Receipt application GL distributions
ReceiptApplicationDistributionRefPVO	Accounts Receivable	Reference distributions for receipt applications
CustomerFinancialProfilePVO	Accounts Receivable	Customer credit and payment terms profile
DetailTaxLineExtractPVO	Tax	Detailed tax lines across AP and AR
LookupValuesTLExtractPVO	Common	Translatable lookup values — codes to descriptions
SupportingReferenceBalanceExtractPVO	Subledger Accounting	Supporting reference balances for subledger reporting
AdjSrcTypeRevAdjDistributionPVO	Revenue	Revenue adjustment source type distributions
SourceDocLinePricingsPVO	Revenue	Source document line pricing for revenue recognition

Schema Information

We talk data for breakfast, lunch, and dinner. So, if you have any questions please send us a note on our Support Portal.

Issue Handling

If any issues occur with the authorization simply return to the sources page in DLH.io, edit the source details and click the Save & Test or Authorize Your Account or Re-Authorize Account button to confirm connectivity. If any issues persist please contact our support team via the DLH.io Support Portal.