JDBC Driver for Oracle Financials Cloud

Build 22.0.8462

Views

Views are composed of columns and pseudo columns. Views are similar to tables in the way that data is represented; however, views do not support updates. Entities that are represented as views are typically read-only entities. Often, a stored procedure is available to update the data if such functionality is applicable to the data source.

Queries can be executed against a view as if it were a normal table, and the data that comes back is similar in that regard.

Dynamic views, such as queries exposed as views, and views for looking up specific combinations of project_team work items are supported.

CData JDBC Driver for Oracle Financials Cloud Views

Name Description
AccountCombinationsLOV AccountCombinationsLOV
AccountingPeriodsLOV AccountingPeriodsLOV
AccountingPeriodStatusLOV AccountingPeriodStatusLOV
BankAccountUserRules BankAccountUserRules
BudgetaryControlBudgetTransactions BudgetaryControlBudgetTransactions
BudgetaryControlResults BudgetaryControlResults
BudgetaryControlResultsBudgetImpacts BudgetaryControlResultsBudgetImpacts
BudgetaryControlResultsBudgetTransactions BudgetaryControlResultsBudgetTransactions
CashExternalTransactions CashExternalTransactions
CashExternalTransactionsattachments CashExternalTransactionsattachments
CashExternalTransactionscashExternalTransactionDFF CashExternalTransactionscashExternalTransactionDFF
CurrencyConversionTypesLOV CurrencyConversionTypesLOV
CurrencyRates CurrencyRates
CustomerAccountSitesLOV CustomerAccountSitesLOV
DataAccessSetLedgersLOV DataAccessSetLedgersLOV
DataAccessSetsLOV DataAccessSetsLOV
DebitAuthorizations DebitAuthorizations
DebitAuthorizationsdebitAuthorizationVersions DebitAuthorizationsdebitAuthorizationVersions
DisbursementPaymentMethodsLOV DisbursementPaymentMethodsLOV
ErpBusinessEvents ErpBusinessEvents
Erpintegrations Erpintegrations
ExternalBankAccounts ExternalBankAccounts
ExternalBankAccountsaccountOwners ExternalBankAccountsaccountOwners
FinBusinessUnitsLOV FinBusinessUnitsLOV
FixedAssetBooksLOV FixedAssetBooksLOV
InputTaxClassificationsLOV InputTaxClassificationsLOV
InstrumentAssignments InstrumentAssignments
IntercompanyOrganizationsLOV IntercompanyOrganizationsLOV
IntercompanyTransactionTypesLOV IntercompanyTransactionTypesLOV
InvoiceApprovalsAndNotificationsHistory InvoiceApprovalsAndNotificationsHistory
InvoiceHolds InvoiceHolds
InvoiceHoldsinvoiceHoldDff InvoiceHoldsinvoiceHoldDff
Invoices Invoices
InvoicesappliedPrepayments InvoicesappliedPrepayments
Invoicesattachments Invoicesattachments
InvoicesavailablePrepayments InvoicesavailablePrepayments
InvoicesinvoiceDff InvoicesinvoiceDff
InvoicesinvoiceGdf InvoicesinvoiceGdf
InvoicesinvoiceInstallments InvoicesinvoiceInstallments
InvoicesinvoiceInstallmentsinvoiceInstallmentDff InvoicesinvoiceInstallmentsinvoiceInstallmentDff
InvoicesinvoiceInstallmentsinvoiceInstallmentGdf InvoicesinvoiceInstallmentsinvoiceInstallmentGdf
InvoicesinvoiceLines InvoicesinvoiceLines
InvoicesinvoiceLinesinvoiceDistributions InvoicesinvoiceLinesinvoiceDistributions
InvoicesinvoiceLinesinvoiceDistributionsinvoiceDistributionDff InvoicesinvoiceLinesinvoiceDistributionsinvoiceDistributionDff
InvoicesinvoiceLinesinvoiceDistributionsinvoiceDistributionGdf InvoicesinvoiceLinesinvoiceDistributionsinvoiceDistributionGdf
InvoicesinvoiceLinesinvoiceDistributionsinvoiceDistributionProjectDff InvoicesinvoiceLinesinvoiceDistributionsinvoiceDistributionProjectDff
InvoicesinvoiceLinesinvoiceLineDff InvoicesinvoiceLinesinvoiceLineDff
InvoicesinvoiceLinesinvoiceLineGdf InvoicesinvoiceLinesinvoiceLineGdf
InvoicesinvoiceLinesinvoiceLineProjectDff InvoicesinvoiceLinesinvoiceLineProjectDff
JournalBatches JournalBatches
JournalBatchesbatchAttachment JournalBatchesbatchAttachment
JournalBatchesjournalActionLogs JournalBatchesjournalActionLogs
JournalBatchesjournalBatchDFF JournalBatchesjournalBatchDFF
JournalBatchesjournalErrors JournalBatchesjournalErrors
JournalBatchesjournalHeaders JournalBatchesjournalHeaders
JournalBatchesjournalHeadersjournalAttachment JournalBatchesjournalHeadersjournalAttachment
JournalBatchesjournalHeadersjournalDFF JournalBatchesjournalHeadersjournalDFF
JournalBatchesjournalHeadersjournalGDF JournalBatchesjournalHeadersjournalGDF
JournalBatchesjournalHeadersjournalLines JournalBatchesjournalHeadersjournalLines
JournalBatchesjournalHeadersjournalLinescapturedInformationDFF JournalBatchesjournalHeadersjournalLinescapturedInformationDFF
JournalBatchesjournalHeadersjournalLinesjournalLineDFF JournalBatchesjournalHeadersjournalLinesjournalLineDFF
JournalBatchesjournalHeadersjournalLinesjournalLineGDF JournalBatchesjournalHeadersjournalLinesjournalLineGDF
JournalCategoriesLOV JournalCategoriesLOV
JournalSourcesLOV JournalSourcesLOV
LedgerBalances LedgerBalances
LedgersLOV LedgersLOV
LegalEntitiesLOV LegalEntitiesLOV
MemoLinesLOV MemoLinesLOV
PartyFiscalClassifications PartyFiscalClassifications
PartyFiscalClassificationsfiscalClassificationTypeTaxRegimeAssociations PartyFiscalClassificationsfiscalClassificationTypeTaxRegimeAssociations
PartyTaxProfiles PartyTaxProfiles
PayablesAndProcurementOptions PayablesAndProcurementOptions
PayablesCalendarTypes PayablesCalendarTypes
PayablesCalendarTypespayablesCalendarPeriods PayablesCalendarTypespayablesCalendarPeriods
PayablesDistributionSets PayablesDistributionSets
PayablesDistributionSetsLOV PayablesDistributionSetsLOV
PayablesDistributionSetspayablesDistributionSetsLines PayablesDistributionSetspayablesDistributionSetsLines
PayablesIncomeTaxRegions PayablesIncomeTaxRegions
PayablesIncomeTaxTypes PayablesIncomeTaxTypes
PayablesInvoiceHolds PayablesInvoiceHolds
PayablesInvoiceHoldsLOV PayablesInvoiceHoldsLOV
PayablesOptions PayablesOptions
PayablesPayments PayablesPayments
PayablesPaymentspaymentDff PayablesPaymentspaymentDff
PayablesPaymentspaymentGdf PayablesPaymentspaymentGdf
PayablesPaymentsrelatedInvoices PayablesPaymentsrelatedInvoices
PayablesPaymentsrelatedInvoicesrelatedInvoiceGdf PayablesPaymentsrelatedInvoicesrelatedInvoiceGdf
PayablesPaymentTerms PayablesPaymentTerms
PayablesPaymentTermsLOV PayablesPaymentTermsLOV
PayablesPaymentTermspayablesPaymentTermsLines PayablesPaymentTermspayablesPaymentTermsLines
PayablesPaymentTermspayablesPaymentTermsSets PayablesPaymentTermspayablesPaymentTermsSets
PayablesPaymentTermspayablesPaymentTermsTranslations PayablesPaymentTermspayablesPaymentTermsTranslations
PayablesTaxReportingEntities PayablesTaxReportingEntities
PayablesTaxReportingEntitiespayablesTaxReportingEntityLine PayablesTaxReportingEntitiespayablesTaxReportingEntityLine
PayeeBankAccountsLOV PayeeBankAccountsLOV
PaymentCodesLOV PaymentCodesLOV
PaymentProcessRequests PaymentProcessRequests
PaymentsExternalPayees PaymentsExternalPayees
PaymentsExternalPayeesexternalPartyPaymentMethods PaymentsExternalPayeesexternalPartyPaymentMethods
PaymentTermsLOV PaymentTermsLOV
PreferredCurrenciesLOV PreferredCurrenciesLOV
PurchaseToPayLegalEntitiesLOV PurchaseToPayLegalEntitiesLOV
ReceiptMethodAssignments ReceiptMethodAssignments
ReceiptMethods ReceiptMethods
ReceiptMethodsreceiptMethodDFF ReceiptMethodsreceiptMethodDFF
ReceivablesAdjustments ReceivablesAdjustments
ReceivablesAdjustmentsreceivablesAdjustmentDFF ReceivablesAdjustmentsreceivablesAdjustmentDFF
ReceivablesBusinessUnitsLOV ReceivablesBusinessUnitsLOV
ReceivablesCreditMemos ReceivablesCreditMemos
ReceivablesCreditMemosattachments ReceivablesCreditMemosattachments
ReceivablesCreditMemosnotes ReceivablesCreditMemosnotes
ReceivablesCreditMemosreceivablesCreditMemoDFF ReceivablesCreditMemosreceivablesCreditMemoDFF
ReceivablesCreditMemosreceivablesCreditMemoDistributions ReceivablesCreditMemosreceivablesCreditMemoDistributions
ReceivablesCreditMemosreceivablesCreditMemoDistributionsreceivablesCreditMemoDistributionDFF ReceivablesCreditMemosreceivablesCreditMemoDistributionsreceivablesCreditMemoDistributionDFF
ReceivablesCreditMemosreceivablesCreditMemoGdf ReceivablesCreditMemosreceivablesCreditMemoGdf
ReceivablesCreditMemosreceivablesCreditMemoLines ReceivablesCreditMemosreceivablesCreditMemoLines
ReceivablesCreditMemosreceivablesCreditMemoLinesattachments ReceivablesCreditMemosreceivablesCreditMemoLinesattachments
ReceivablesCreditMemosreceivablesCreditMemoLinesreceivablesCreditMemoLineDFF ReceivablesCreditMemosreceivablesCreditMemoLinesreceivablesCreditMemoLineDFF
ReceivablesCreditMemosreceivablesCreditMemoLinesreceivablesCreditMemoLineGdf ReceivablesCreditMemosreceivablesCreditMemoLinesreceivablesCreditMemoLineGdf
ReceivablesCreditMemosreceivablesCreditMemoLinesreceivablesCreditMemoLineTaxLines ReceivablesCreditMemosreceivablesCreditMemoLinesreceivablesCreditMemoLineTaxLines
ReceivablesCreditMemosreceivablesCreditMemoLinesreceivablesCreditMemoLineTransactionDFF ReceivablesCreditMemosreceivablesCreditMemoLinesreceivablesCreditMemoLineTransactionDFF
ReceivablesCreditMemosreceivablesCreditMemoTransactionDFF ReceivablesCreditMemosreceivablesCreditMemoTransactionDFF
ReceivablesCustomerAccountActivities ReceivablesCustomerAccountActivities
ReceivablesCustomerAccountActivitiescreditMemoApplications ReceivablesCustomerAccountActivitiescreditMemoApplications
ReceivablesCustomerAccountActivitiescreditMemoApplicationscreditMemoApplicationDFF ReceivablesCustomerAccountActivitiescreditMemoApplicationscreditMemoApplicationDFF
ReceivablesCustomerAccountActivitiescreditMemos ReceivablesCustomerAccountActivitiescreditMemos
ReceivablesCustomerAccountActivitiesstandardReceiptApplications ReceivablesCustomerAccountActivitiesstandardReceiptApplications
ReceivablesCustomerAccountActivitiesstandardReceiptApplicationsstandardReceiptApplicationDFF ReceivablesCustomerAccountActivitiesstandardReceiptApplicationsstandardReceiptApplicationDFF
ReceivablesCustomerAccountActivitiesstandardReceipts ReceivablesCustomerAccountActivitiesstandardReceipts
ReceivablesCustomerAccountActivitiestransactionAdjustments ReceivablesCustomerAccountActivitiestransactionAdjustments
ReceivablesCustomerAccountActivitiestransactionPaymentSchedules ReceivablesCustomerAccountActivitiestransactionPaymentSchedules
ReceivablesCustomerAccountActivitiestransactionsPaidByOtherCustomers ReceivablesCustomerAccountActivitiestransactionsPaidByOtherCustomers
ReceivablesCustomerAccountSiteActivities ReceivablesCustomerAccountSiteActivities
ReceivablesCustomerAccountSiteActivitiescreditMemoApplications ReceivablesCustomerAccountSiteActivitiescreditMemoApplications
ReceivablesCustomerAccountSiteActivitiescreditMemoApplicationscreditMemoApplicationDFF ReceivablesCustomerAccountSiteActivitiescreditMemoApplicationscreditMemoApplicationDFF
ReceivablesCustomerAccountSiteActivitiescreditMemos ReceivablesCustomerAccountSiteActivitiescreditMemos
ReceivablesCustomerAccountSiteActivitiesstandardReceiptApplications ReceivablesCustomerAccountSiteActivitiesstandardReceiptApplications
ReceivablesCustomerAccountSiteActivitiesstandardReceiptApplicationsstandardReceiptApplicationDFF ReceivablesCustomerAccountSiteActivitiesstandardReceiptApplicationsstandardReceiptApplicationDFF
ReceivablesCustomerAccountSiteActivitiesstandardReceipts ReceivablesCustomerAccountSiteActivitiesstandardReceipts
ReceivablesCustomerAccountSiteActivitiestransactionAdjustments ReceivablesCustomerAccountSiteActivitiestransactionAdjustments
ReceivablesCustomerAccountSiteActivitiestransactionPaymentSchedules ReceivablesCustomerAccountSiteActivitiestransactionPaymentSchedules
ReceivablesCustomerAccountSiteActivitiestransactionsPaidByOtherCustomers ReceivablesCustomerAccountSiteActivitiestransactionsPaidByOtherCustomers
ReceivablesInvoices ReceivablesInvoices
ReceivablesInvoicesattachments ReceivablesInvoicesattachments
ReceivablesInvoicesnotes ReceivablesInvoicesnotes
ReceivablesInvoicesreceivablesInvoiceDFF ReceivablesInvoicesreceivablesInvoiceDFF
ReceivablesInvoicesreceivablesInvoiceDistributions ReceivablesInvoicesreceivablesInvoiceDistributions
ReceivablesInvoicesreceivablesInvoiceDistributionsreceivablesInvoiceDistributionDFF ReceivablesInvoicesreceivablesInvoiceDistributionsreceivablesInvoiceDistributionDFF
ReceivablesInvoicesreceivablesInvoiceGdf ReceivablesInvoicesreceivablesInvoiceGdf
ReceivablesInvoicesreceivablesInvoiceInstallments ReceivablesInvoicesreceivablesInvoiceInstallments
ReceivablesInvoicesreceivablesInvoiceInstallmentsreceivablesInvoiceInstallmentGDF ReceivablesInvoicesreceivablesInvoiceInstallmentsreceivablesInvoiceInstallmentGDF
ReceivablesInvoicesreceivablesInvoiceInstallmentsreceivablesInvoiceInstallmentNotes ReceivablesInvoicesreceivablesInvoiceInstallmentsreceivablesInvoiceInstallmentNotes
ReceivablesInvoicesreceivablesInvoiceLines ReceivablesInvoicesreceivablesInvoiceLines
ReceivablesInvoicesreceivablesInvoiceLinesattachments ReceivablesInvoicesreceivablesInvoiceLinesattachments
ReceivablesInvoicesreceivablesInvoiceLinesreceivablesInvoiceLineDFF ReceivablesInvoicesreceivablesInvoiceLinesreceivablesInvoiceLineDFF
ReceivablesInvoicesreceivablesInvoiceLinesreceivablesInvoiceLineGdf ReceivablesInvoicesreceivablesInvoiceLinesreceivablesInvoiceLineGdf
ReceivablesInvoicesreceivablesInvoiceLinesreceivablesInvoiceLineTaxLines ReceivablesInvoicesreceivablesInvoiceLinesreceivablesInvoiceLineTaxLines
ReceivablesInvoicesreceivablesInvoiceLinesreceivablesInvoiceLineTransactionDFF ReceivablesInvoicesreceivablesInvoiceLinesreceivablesInvoiceLineTransactionDFF
ReceivablesInvoicesreceivablesInvoiceTransactionDFF ReceivablesInvoicesreceivablesInvoiceTransactionDFF
SalespersonReferenceAccounts SalespersonReferenceAccounts
StandardReceipts StandardReceipts
StandardReceiptsattachments StandardReceiptsattachments
StandardReceiptsremittanceReferences StandardReceiptsremittanceReferences
StandardReceiptsstandardReceiptDFF StandardReceiptsstandardReceiptDFF
StandardReceiptsstandardReceiptGdf StandardReceiptsstandardReceiptGdf
TaxAuthorityProfiles TaxAuthorityProfiles
TaxClassifications TaxClassifications
TaxExemptions TaxExemptions
TaxIntendedUsesLOV TaxIntendedUsesLOV
TaxPayerIdentifiers TaxPayerIdentifiers
TaxRegistrations TaxRegistrations
ThirdPartyFiscalClassifications ThirdPartyFiscalClassifications
ThirdPartySiteFiscalClassifications ThirdPartySiteFiscalClassifications
ThirdPartySiteTaxReportingCodeAssociations ThirdPartySiteTaxReportingCodeAssociations
ThirdPartyTaxReportingCodeAssociations ThirdPartyTaxReportingCodeAssociations
TransactionSourcesLOV TransactionSourcesLOV
TransactionTaxLines TransactionTaxLines
TransactionTypesLOV TransactionTypesLOV
WithholdingTaxGroupsLOV WithholdingTaxGroupsLOV
WithholdingTaxLines WithholdingTaxLines
WorkflowUsers WorkflowUsers

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462