Oracle Fusion Cloud Financials Reader

Note

This adapter is in preview and is available on Striim Developer only. See Striim Developer for more information.

Striim’s Oracle Fusion Cloud Financials Reader allows users to seamlessly connect and interact with Oracle Fusion Cloud Financials without the need for complex ETL (extract, transform, load) processes, enabling smooth data transfer in real time. It enables you to pull data from Oracle Fusion Financials for custom reporting without needing extensive database knowledge, simplifying reporting and analytics workflows.

Feature summary

Feature		Supported?	Notes
Objects	Standard objects	✓
Objects	Custom objects	✓
Authentication	Basic authentication	✓	Username and password
	OAuth authentication		Manual configuration based
	Custom authentication methods		Not all methods may be supported
Operations	Automated mode	✓
	Initial load	✓
	Pull-based incremental load	✓
	Push-based incremental load
	Automated pipeline
Governance	Connection profile
	Sherlock AI
	Sentinel AI
Schema handling	Initial schema creation	✓	Works with supported targets
Schema handling	Schema evolution
Setup	Wizard template
	Flow Designer	✓
	Striim TQL	✓
Runtime	Resilience/recovery	✓
	Parallel execution
	Metrics	✓	Standard metrics

Supported authentication method

The Oracle Financial Cloud Reader supports basic authentication using username and password.

Supported objects

The following are the supported objects for reading from Oracle Financial Cloud:

Financial data model

AccountCombinationsLOV
AccountCombinationsShorthandAliasesLOV
AccountingCalendarsLOV
AccountingPeriodsLOV
AccountingPeriodStatusLOV
Accounts
Accounting
Accounts
Accounting
BankAccountUserRules
BudgetaryControlResults
BudgetaryControlResultsBudgetImpacts
BudgetaryControlResultsBudgetTransactions
CashBankBranchesLOV
CashBanksLOV
ChartOfAccountsLOV
CurrencyConversionTypesLOV
CurrencyRates
CustomerAccountSitesLOV
DebitAuthorizations
DebitAuthorizationsdebitAuthorizationVersions
DisbursementPaymentMethodsLOV
ErpBusinessEvents
Erpintegrations
ExpenseAccommodationsPolicies
ExpenseAccommodationsPoliciesexpenseAccommodationsPolicyLines
ExpenseAirfarePolicies
ExpenseAirfarePoliciesexpenseAirfarePolicyLines
ExpenseCashAdvances
ExpenseCashAdvancesAttachments
ExpenseCashAdvancesCashAdvanceDff
ExpenseConversionRateOptions
ExpenseConversionRateOptionsconversionRateTolerances
ExpenseCreditCardTransactions
ExpenseDelegations
ExpenseDffContexts
ExpenseDffSegments
ExpenseDistributions
ExpenseDistributionsPJCDFF
ExpenseEntertainmentPolicies
ExpenseEntertainmentPoliciesexpenseEntertainmentPolicyLines
ExpenseLocations
ExpenseMealsPolicies
ExpenseMealsPoliciesexpenseMealsPolicyLines
ExpenseMileagePolicies
ExpenseMileagePoliciesexpenseMileagePolicyLines
ExpenseMiscPolicies
ExpenseMiscPoliciesexpenseMiscPolicyLines
ExpenseOrganizationSettings
ExpensePerDiemCalculations
ExpensePerDiemPolicies
ExpensePerDiemPoliciesexpensePerDiemPolLines
ExpensePerDiemPoliciesexpensePerDiemPolValues
ExpensePersons
ExpensePreferences
ExpensePreferredTypes
ExpenseProfileAttributes
ExpenseReportsAttachments
ExpenseReportsExpense
ExpenseReportsExpenseAttachments
ExpenseReportsExpenseduplicateExpenses
ExpenseReportsExpenseExpenseAttendee
ExpenseReportsExpenseExpenseDff
ExpenseReportsExpenseExpenseDistribution
ExpenseReportsExpenseExpenseDistributionPJCDFF
ExpenseReportsExpenseexpenseErrors
ExpenseReportsExpenseExpenseItemization
ExpenseReportsExpensematchedExpenses
ExpenseReportsexpenseNotes
ExpenseReportsExpensePayment
ExpenseReportsExpenseReportDff
ExpenseReportsprocessingDetails
ExpensesAttachments
ExpensesduplicateExpenses
ExpenseSetupOptions
ExpensesExpenseAttendee
ExpensesExpenseDff
ExpensesExpenseDistribution
ExpensesExpenseDistributionPJCDFF
ExpensesexpenseErrors
ExpensesExpenseItemization
ExpensesmatchedExpenses
ExpenseTemplates
ExpenseTemplatesexpenseTypes
ExpenseTemplatesexpenseTypesitemizedExpenseTypes
ExpenseTemplatesexpenseTypespreferredAgencyLists
ExpenseTemplatesexpenseTypespreferredMerchantLists
ExpenseTemplatesmobileExpenseTypes
ExpenseTypes
ExpenseTypesitemizedExpenseTypes
ExpenseTypespreferredAgencyLists
ExpenseTypespreferredMerchantLists
ExternalBankAccounts
ExternalBankAccountsaccountOwners
FedBudgetExecutionControls
FedBudgetExecutionControlsfedBudgetControlSegments
FinBusinessUnitsLOV
Finders
InstrumentAssignments
IntercompanyOrganizationsLOV
IntercompanyTransactionTypesLOV
InterimDocumentsPayables
InvoicesappliedPrepayments
Invoicesattachments
InvoicesavailablePrepayments
InvoicesinvoiceGdf
InvoicesinvoiceInstallmentsinvoiceInstallmentDff
InvoicesinvoiceInstallmentsinvoiceInstallmentGdf
InvoicesinvoiceLinesinvoiceDistributionsinvoiceDistributionDff
InvoicesinvoiceLinesinvoiceDistributionsinvoiceDistributionGdf
InvoicesinvoiceLinesinvoiceDistributionsinvoiceDistributionProjectDff
InvoicesinvoiceLinesinvoiceLineDff
InvoicesinvoiceLinesinvoiceLineGdf
InvoicesinvoiceLinesinvoiceLineProjectDff
LedgersLOV
LegalEntitiesLOV
LegalJurisdictionsLOV
LegalReportingUnitsLOV
MemoLinesLOV
PartyFiscalClassifications
PartyFiscalClassificationsfiscalClassificationTypeTaxRegimeAssociations
PartyTaxProfiles
PayablesOptions
PayablesPaymentTerms
PayablesPaymentTermspayablesPaymentTermsLines
PayablesPaymentTermspayablesPaymentTermsSets
PayablesPaymentTermspayablesPaymentTermsTranslations
PayablesTaxReportingEntities
PayablesTaxReportingEntitiespayablesTaxReportingEntityLine
PayeeBankAccountsLOV
PaymentsExternalPayees
PaymentsExternalPayeesexternalPartyPaymentMethods
PaymentTermsLOV
PreferredCurrenciesLOV
ReceiptMethodAssignments
ReceivablesAdjustments
ReceivablesAdjustmentsreceivablesAdjustmentDFF
ReceivablesBusinessUnitsLOV
ReceivablesCreditMemosattachments
ReceivablesCreditMemosnotes
ReceivablesCreditMemosreceivablesCreditMemoDFF
ReceivablesCreditMemosreceivablesCreditMemoDistributions
ReceivablesCreditMemosreceivablesCreditMemoDistributionsreceivablesCreditMemoDistributionDFF
ReceivablesCreditMemosreceivablesCreditMemoGdf
ReceivablesCreditMemosreceivablesCreditMemoLines
ReceivablesCreditMemosreceivablesCreditMemoLinesattachments
ReceivablesCreditMemosreceivablesCreditMemoLinesreceivablesCreditMemoLineDFF
ReceivablesCreditMemosreceivablesCreditMemoLinesreceivablesCreditMemoLineGdf
ReceivablesCreditMemosreceivablesCreditMemoLinesreceivablesCreditMemoLineTaxLines
ReceivablesCreditMemosreceivablesCreditMemoLinesreceivablesCreditMemoLineTransactionDFF
ReceivablesCreditMemosreceivablesCreditMemoTransactionDFF
ReceivablesCustomerAccountActivities
ReceivablesCustomerAccountActivitiescreditMemoApplications
ReceivablesCustomerAccountActivitiescreditMemoApplicationscreditMemoApplicationDFF
ReceivablesCustomerAccountActivitiescreditMemos
ReceivablesCustomerAccountActivitiesstandardReceiptApplications
ReceivablesCustomerAccountActivitiesstandardReceiptApplicationsstandardReceiptApplicationDFF
ReceivablesCustomerAccountActivitiesstandardReceipts
ReceivablesCustomerAccountActivitiestransactionAdjustments
ReceivablesCustomerAccountActivitiestransactionPaymentSchedules
ReceivablesCustomerAccountActivitiestransactionsPaidByOtherCustomers
ReceivablesCustomerAccountSiteActivities
ReceivablesCustomerAccountSiteActivitiescreditMemoApplications
ReceivablesCustomerAccountSiteActivitiescreditMemoApplicationscreditMemoApplicationDFF
ReceivablesCustomerAccountSiteActivitiescreditMemos
ReceivablesCustomerAccountSiteActivitiesstandardReceiptApplications
ReceivablesCustomerAccountSiteActivitiesstandardReceiptApplicationsstandardReceiptApplicationDFF
ReceivablesCustomerAccountSiteActivitiesstandardReceipts
ReceivablesCustomerAccountSiteActivitiestransactionAdjustments
ReceivablesCustomerAccountSiteActivitiestransactionPaymentSchedules
ReceivablesCustomerAccountSiteActivitiestransactionsPaidByOtherCustomers
ReceivablesInvoicesattachments
ReceivablesInvoicesnotes
ReceivablesInvoicesreceivablesInvoiceDFF
ReceivablesInvoicesreceivablesInvoiceDistributions
ReceivablesInvoicesreceivablesInvoiceDistributionsreceivablesInvoiceDistributionDFF
ReceivablesInvoicesreceivablesInvoiceGdf
ReceivablesInvoicesreceivablesInvoiceInstallments
ReceivablesInvoicesreceivablesInvoiceInstallmentsreceivablesInvoiceInstallmentGDF
ReceivablesInvoicesreceivablesInvoiceInstallmentsreceivablesInvoiceInstallmentNotes
ReceivablesInvoicesreceivablesInvoiceLines
ReceivablesInvoicesreceivablesInvoiceLinesattachments
ReceivablesInvoicesreceivablesInvoiceLinesreceivablesInvoiceLineDFF
ReceivablesInvoicesreceivablesInvoiceLinesreceivablesInvoiceLineGdf
ReceivablesInvoicesreceivablesInvoiceLinesreceivablesInvoiceLineTaxLines
ReceivablesInvoicesreceivablesInvoiceLinesreceivablesInvoiceLineTransactionDFF
ReceivablesInvoicesreceivablesInvoiceTransactionDFF
StandardReceiptsattachments
StandardReceiptsremittanceReferences
StandardReceiptsstandardReceiptDFF
StandardReceiptsstandardReceiptGdf
TaxAuthorityProfiles
TaxClassifications
TaxExemptions
TaxPayerIdentifiers
ThirdPartyFiscalClassifications
ThirdPartySiteFiscalClassifications
ThirdPartySiteTaxReportingCodeAssociations
ThirdPartyTaxReportingCodeAssociations
TransactionSourcesLOV
TransactionTaxLines
TransactionTypesLOV
ValueSets
ValueSetsvalidationTable
ValueSetsValues
WithholdingTaxLines
WorkflowUsers

Procurement data model

ApprovedSupplierListSourceDocuments
ApprovedSupplierListSourceDocumentsDFF
CatalogCategoryHierarchyNodes
ComplianceChecklists
ComplianceChecklistTemplates
ContentZones
ContentZonescatalogAssignments
ContentZonespublicShoppingListAssignments
ContentZonessecurityAssignments
ContentZonessmartFormAssignments
DraftPurchaseOrders
DraftPurchaseOrdersattachments
DraftPurchaseOrdersDFF
DraftPurchaseOrdersglobalDFFs
DraftPurchaseOrderslines
DraftPurchaseOrderslinesattachments
DraftPurchaseOrderslinesDFF
DraftPurchaseOrderslinesschedules
DraftPurchaseOrderslinesschedulesattachments
DraftPurchaseOrderslinesschedulesDFF
DraftPurchaseOrderslinesschedulesdistributions
DraftPurchaseOrderslinesschedulesglobalDFFs
DraftPurchaseOrderssummaryAttributes
DraftSupplierNegotiationResponses
DraftSupplierNegotiationResponsesattachments
DraftSupplierNegotiationResponseslines
DraftSupplierNegotiationResponseslinesattachments
DraftSupplierNegotiationResponseslinescostFactors
DraftSupplierNegotiationResponseslineslineAttributeGroups
DraftSupplierNegotiationResponseslineslineAttributeGroupslineAttributes
DraftSupplierNegotiationResponseslinespriceBreaks
DraftSupplierNegotiationResponseslinespriceTiers
DraftSupplierNegotiationResponsessections
DraftSupplierNegotiationResponsessectionsrequirements
DraftSupplierNegotiationResponsessectionsrequirementsattachments
DraftSupplierNegotiationResponsessectionsrequirementsresponseValues
Finders
FlexFndDffDescriptiveFlexfieldContexts
FlexFndPvsCharacterIdCharacterValues
PersonalShoppingLists
PersonalShoppingListslines
ProcurementAgents
ProcurementApprovedSupplierListEntries
ProcurementApprovedSupplierListEntriesDFF
ProcurementPersonsLOV
PublicShoppingListLines
PublicShoppingLists
PunchoutConnections
PurchaseAgreementImportRequests
PurchaseAgreementImportRequestsbusinessUnitAccess
PurchaseAgreementImportRequestslines
PurchaseAgreementImportRequestslinesitemAttributes
PurchaseAgreementImportRequestslinespriceBreaks
PurchaseAgreementImportRequestslinestranslationItemAttributes
PurchaseAgreementLines
PurchaseAgreementLinesitemAttributes
PurchaseAgreementLinespriceBreaks
PurchaseAgreements
PurchaseAgreementsbusinessUnitAccess
PurchaseAgreementslines
PurchaseAgreementslinesitemAttributes
PurchaseAgreementslinespriceBreaks
PurchaseAgreementsnotificationControls
PurchaseOrders
PurchaseOrdersattachments
PurchaseOrderSchedules
PurchaseOrdersDFF
PurchaseOrdersglobalDFFs
PurchaseOrderslines
PurchaseOrderslinesattachments
PurchaseOrderslinesDFF
PurchaseOrderslinesschedules
PurchaseOrderslinesschedulesattachments
PurchaseOrderslessnesschedulesDFF
PurchaseOrderslinesschedulesdistributions
PurchaseOrderslinesschedulesglobalDFFs
PurchaseOrdersLOV
PurchaseRequisitions
PurchaseRequisitionsattachments
PurchaseRequisitionsDFF
PurchaseRequisitionslines
PurchaseRequisitionslinesattachments
PurchaseRequisitionslinesDFF
PurchaseRequisitionslinesdistributions
PurchaseRequisitionslinesdistributionsDFF
PurchaseRequisitionslinesdistributionsprojectDFF
PurchaseRequisitionslinesinformationTemplates
PurchaseRequisitionslinesinformationTemplatesinformationTemplateDFF
PurchaseRequisitionslinesspecialHandlingDFF
PurchaseRequisitionsspecialHandlingDFF
PurchaseRequisitionssummaryAttributes
PurchasingDocumentImportErrors
PurchasingNews
QuestionnaireResponses
QuestionnaireResponsesquestionnaireAttachments
QuestionnaireResponsesquestionnaireResponseSections
QuestionnaireResponsesquestionnaireResponseSectionsquestionnaireResponseDetails
QuestionnaireResponsesquestionnaireResponseSectionsquestionnaireResponseDetailsquestionAttachments
QuestionnaireResponsesquestionnaireResponseSectionsquestionnaireResponseDetailsquestionnaireResponseValues
RecentRequisitions
RequisitionOneTimeLocations
RequisitionPreferences
RequisitionPreferencesfavoriteChargeAccounts
RequisitionPreferencesprojectDFF
RequisitionPreferencespurchasingNews
RequisitionPreferencesrequisitioningOptions
RequisitionProcessingRequests
RequisitionProcessingRequestslines
RequisitionProductDetails
RequisitionProductDetailspriceBreaks
ShoppingCatalogSmartFormDetails
ShoppingCatalogSmartFormDetailsagreementRequisitionBUAssignments
ShoppingCatalogSmartFormDetailsattachments
ShoppingCatalogSmartFormDetailsinformationTemplateAssignments
ShoppingLists
ShoppingSearches
ShoppingSearchesbrandFilters
ShoppingSearchesresultItems
ShoppingSearchesresultPunchoutCatalogs
StandardLookupsLOV
SupplierEligibilities
SupplierInitiatives
SupplierInitiativesattachments
SupplierInitiativesDFF
SupplierInitiativesevaluationTeamMembers
SupplierInitiativesqualificationAreas
SupplierInitiativessuppliers
SupplierNegotiationResponses
SupplierNegotiationResponsesattachments
SupplierNegotiationResponseslines
SupplierNegotiationResponseslinesattachments
SupplierNegotiationResponseslinescostFactors
SupplierNegotiationResponseslineslineAttributeGroups
SupplierNegotiationResponseslineslineAttributeGroupslineAttributes
SupplierNegotiationResponseslinespriceBreaks
SupplierNegotiationResponseslinespriceTiers
SupplierNegotiationResponsessections
SupplierNegotiationResponsessectionsrequirements
SupplierNegotiationResponsessectionsrequirementsattachments
SupplierNegotiationResponsessectionsrequirementsresponseValues
SupplierNegotiations
SupplierNegotiationsabstracts
SupplierNegotiationsabstractsDFF
SupplierNegotiationsattachments
SupplierNegotiationscollaborationTeamMembers
SupplierNegotiationsDFF
SupplierNegotiationslines
SupplierNegotiationslinesattachments
SupplierNegotiationslinescostFactors
SupplierNegotiationslinesDFF
SupplierNegotiationslineslineAttributeGroups
SupplierNegotiationslineslineAttributeGroupslineAttributes
SupplierNegotiationslinesnegotiationLineRecommendedSuppliers
SupplierNegotiationslinespriceBreaks
SupplierNegotiationslinespriceTiers
SupplierNegotiationsnegotiationActivities
SupplierNegotiationsnegotiationRecommendedSuppliers
SupplierNegotiationsresponseCurrencies
SupplierNegotiationsscoringTeams
SupplierNegotiationsscoringTeamsscoringTeamMembers
SupplierNegotiationssections
SupplierNegotiationssectionsrequirements
SupplierNegotiationssectionsrequirementsacceptableResponseScoreValues
SupplierNegotiationssectionsrequirementsattachments
SupplierNegotiationssupplierDFF
SupplierNegotiationssuppliers
SupplierNegotiationssupplierssupplierLineAccessRestrictions
SupplierQualificationAreas
SupplierQualificationAreasattachments
SupplierQualificationAreasbusinessUnits
SupplierQualificationAreasoutcomes
SupplierQualificationAreasquestions
SupplierQualificationQuestionResponses
SupplierQualificationQuestionResponsesvalues
SupplierQualificationQuestionResponsesvaluesattachments
SupplierQualificationQuestions
SupplierQualificationQuestionsacceptableResponses
SupplierQualificationQuestionsacceptableResponsesbranches
SupplierQualificationQuestionsattachments
SupplierQualificationQuestionsscores
SupplierRegistrationAddressGeographies
SupplierRegistrationAddressStyleFormats
SupplierRegistrationAddressStyleFormatsAddressStyleFormatLayout
SupplierRegistrationBankBranchesLOV
SupplierRegistrationBanksLOV
SupplierRegistrationCertifyingAgenciesLOV
SupplierRegistrationConfigurations
SupplierRegistrationOptions
SupplierRegistrationPhoneCountryCodes
SupplierRegistrationProductsAndServicesLOV
SupplierRegistrationProductsAndServicesLOVchildCategories
SupplierRegistrationQuestionnaireResponses
SupplierRegistrationQuestionnaireResponsesquestionnaireAttachments
SupplierRegistrationQuestionnaireResponsesquestionnaireResponseSections
SupplierRegistrationQuestionnaireResponsesquestionnaireResponseSectionsquestionnaireResponses
SupplierRegistrationQuestionnaireResponsesquestionnaireResponseSectionsquestionnaireResponsesquestionAttachments
SupplierRegistrationQuestionnaireResponsesquestionnaireResponseSectionsquestionnaireResponsesquestionnaireResponseValues
SupplierRegistrationRequests
SupplierRegistrationRequestsaddresses
SupplierRegistrationRequestsaddressesaddressContacts
SupplierRegistrationRequestsaddressesDFF
SupplierRegistrationRequestsattachments
SupplierRegistrationRequestsbankAccounts
SupplierRegistrationRequestsbankAccountsattachments
SupplierRegistrationRequestsbusinessClassifications
SupplierRegistrationRequestsbusinessClassificationsattachments
SupplierRegistrationRequestscontacts
SupplierRegistrationRequestscontactsDFF
SupplierRegistrationRequestscontactsroles
SupplierRegistrationRequestsDFF
SupplierRegistrationRequestsproductsAndServices
SupplierRegistrationRolesLOV
Suppliers
Suppliersaddresses
SuppliersaddressesDFF
Suppliersattachments
SuppliersbusinessClassifications
SuppliersbusinessClassificationsattachments
Supplierscontacts
Supplierscontactsaddresses
SupplierscontactsDFF
SuppliersDFF
SuppliersglobalDFF
SuppliersproductsAndServices
Supplierssites
Supplierssitesassignments
Supplierssitesattachments
SupplierssitesDFF
SupplierssitesglobalDFF
SupplierssitesthirdPartyPaymentRelationships
ValueSets
ValueSetsvalidationTable
ValueSetsValues
WorkConfirmations
WorkConfirmationsattachments
WorkConfirmationsdocumentActions
WorkConfirmationslines

Oracle Financial Cloud Reader properties

Property	Type	Default value	Notes
URL	String		URL of the Oracle Cloud Service. For example, https://servername.fa.us2.oraclecloud.com.
Username	String		The username of the Oracle account.
Password	Password		The password of the Oracle account.
Connection pool size	Integer	20	Specifies the maximum number of active connections.
Exclude tables	String		A list of tables excluded from read operations. Typically used to create a list of exceptions when the Tables property includes wildcards. Misconfiguration of the Tables and Exclude Tables properties can cause "Invalid table names" errors.
Incremental load marker	String		The incremental load marker is a unique incremental column in each object used for incremental load. When no marker is specified, tables are resynced at each polling interval. Specify the name of the column that contains the start position value. This column must meet the following criteria: It should have an integer or timestamp data type (for example, a creation timestamp or an employee ID). The values must be unique and continuously increasing to ensure proper incremental reading.
Migrate schema	Boolean	False	Only available in Initial Load or Automated mode. Set to `True` to enable initial schema migration, which propagates the object schema from the source to the target.
Mode	Select list: Automated mode Initial load Incremental load	Automated	Automated mode applies incremental updates to objects that support incremental load and performs full resyncs for objects that do not support incremental load.
Polling interval	Integer	5m	Specifies an interval as an integer followed by a unit. Supported units are days (`d`), hours (`h`), minutes (`m`), or seconds (`s`). The reader polls the source at the specified interval.
Start Position	String	%=-1	Value of the incremental load marker that defines the initial reading position.
Tables	String		A semicolon-delimited (;) list of objects to read from the source. Supports the `%` wildcard. Misconfiguration of the Tables and Exclude Tables properties can cause "Invalid table names" errors. Do not modify this property when recovery is enabled for the application.
Thread pool count	Integer	10	The number of parallel running threads. The default value of zero specifies single-threaded operation. When the value of the thread pool counter is higher than the connection pool size, large data ingestion operations can cause the app to halt. Since best performance is achieved when using one thread for each table being synced, increasing the size of the connection pool to match the number of threads in use is a performance best practice.