Views

Views are similar to tables in the way that data is represented; however, views are read-only.

Queries can be executed against a view as if it were a normal table.

CData ADO.NET Provider for Oracle Fusion Cloud Financials Views


Name	Description
AccountCombinationsLOV	Provides a reference of valid General Ledger account combinations, ensuring accurate segment values for financial reporting and ledger analysis.
AccountCombinationsShorthandAliasesLOV	Maintains shorthand alias definitions for quick entry of account combinations, streamlining data input in accounting processes.
AccountingCalendarsLOV	Displays available accounting or commitment calendars, detailing periods and dates for budgeting and transaction alignment.
AccountingPeriodsLOV	Lists period details (for example, open, closed) within a specified accounting calendar, aiding period-based reporting and reconciliation.
AccountingPeriodStatusLOV	Tracks the current status of each accounting period (for example, open, closed) within a calendar, preventing unauthorized postings.
AttributeDerivationConditions	Returns the condition expressions and their validation results used to derive attribute values in Oracle Financials.
AttributeDerivationEntityObjects	Returns the entity objects, identified by lookup type and code, that are available for defining attribute derivation rules in Oracle Financials.
AttributeDerivationMappingSets	Returns the mapping sets used to derive an output attribute value from one or more source inputs in Oracle Financials.
AttributeDerivationMappingSetsFunAdmMappingSetFlavor	Returns the mapping set flavor definitions nested under each attribute derivation mapping set used to derive accounting attribute values.
AttributeDerivationMappingSetsFunAdmMappingSetFlavorFunAdmMappingSetValues	Returns the mapping set values nested within the mapping set flavor of each attribute derivation mapping set used to derive accounting attribute values.
AttributeDerivationMappingSetsFunAdmMappingSetInput	Returns the source input attributes defined for each attribute derivation mapping set in Oracle Financials.
AttributeDerivationRules	Returns the attribute derivation rules that define how target attribute values are derived for subledger accounting entities.
AttributeDerivationSourceAttributes	Returns the source attributes available for deriving accounting attribute values, including their data type, entity, and level details.
AttributeDerivationTargetAttributes	Returns the target attributes that can be assigned to attribute derivation rules for subledger accounting entities.
AttributeDerivationValueSetValues	Returns the values defined within the value sets used to validate derived accounting attribute values.
BankAccountUserRules	Enables configuration of country-specific validations and label changes on bank account fields for streamlined account setup.
BudgetaryControlResults	Shows results of budgetary control checks, helping users identify whether labor schedules or requisitions exceed set budgets.
BudgetaryControlResultsBudgetImpacts	Provides budget impact data associated with labor schedules, including any reductions in available funds due to transactions.
BudgetaryControlResultsBudgetTransactions	Supports internal budget adjustments by displaying validation info on transactions affecting Enterprise Performance Management budgets.
CarriedInterestAgreements	Displays details associated with carried interest agreements.
CarriedInterestAgreementsagreementDFF	Provides access to the descriptive flexfield (DFF) segments defined for carried interest agreements.
CarriedInterestAgreementsstakeholderGroups	Provides access to stakeholder groups defined for a carried interest agreement.
CarriedInterestAgreementsstakeholderGroupsownershipDefinitions	Returns ownership definitions associated with a joint venture. Joint Venture Management uses the ownership definition to calculate the split of costs and revenue among the stakeholders or partners in a joint venture.
CarriedInterestAgreementsstakeholderGroupsownershipDefinitionsownershipPercentages	Displays each stakeholder's percentage of ownership in an ownership definition. The percentages must total 100% for all stakeholders in the ownership definition.
CarriedInterestAgreementsstakeholderGroupsstakeholderGroupDFF	Provides access to the descriptive flexfield (DFF) segments defined for stakeholder groups within a carried interest agreement.
CarriedInterestAgreementsstakeholderGroupsstakeholderPercentages	Displays stakeholder percentages for a stakeholder group.
CarriedInterestAgreementsstakeholderGroupsstakeholderPercentagesstakeholderPercentageDFF	Provides descriptive flexfield (DFF) segment values for stakeholder percentage records within a carried interest agreement.
CarriedInterestAgreementStakeholdersLOV	Returns the list of consenting and nonconsenting stakeholders that can be selected when managing carried interest agreements for a joint venture.
CarriedInterestPenalties	Returns the carried interest penalties defined for joint venture carried interest agreements.
CarriedInterestPenaltiesPenaltyPercentages	Returns the penalty percentages defined for each carried interest penalty in a joint venture, including the account set, project set, and calculation details.
CashBankBranchesLOV	Enables queries on bank branch details, supporting cash management and setup of payment or receipt methods.
CashBanksLOV	Facilitates lookups for bank information, ensuring valid bank references for payment or receipt processing.
ChartOfAccountsLOV	Outlines details of a chart of accounts structure, including segments and hierarchies for robust financial tracking.
CurrencyConversionTypesLOV	Shows available currency conversion types (for example, Corporate, Spot, User), automatically assigning exchange rates to transactions.
CurrencyRates	Retrieves currency exchange rates for specified dates and currency pairs, informing multi-currency postings and reports.
CustomerAccountSitesLOV	Displays customer account site details, linking customers to specific billing or shipping addresses for transaction processing.
DebitAuthorizations	Manages debit authorizations, including creation or updates, allowing users to handle automated debit agreements.
DebitAuthorizationsdebitAuthorizationVersions	Tracks version history of debit authorizations, ensuring an audit trail of any modifications made to authorization terms.
DisbursementPaymentMethodsLOV	Queries valid disbursement payment methods (for example, check, EFT), ensuring payment configuration aligns with organizational rules.
ErpBusinessEvents	Stores or updates status for business events that trigger processes like approvals or notifications in ERP workflows.
Erpintegrations	Automates bulk data import/export with configurable callbacks and error notifications, streamlining integration tasks.
ExpenseAccommodationsPolicies	Defines accommodations-related expense rules, specifying reimbursement rates, limits, or eligibility for lodging costs.
ExpenseAccommodationsPoliciesexpenseAccommodationsPolicyLines	Stores line-level policy details for accommodations expense rules, including thresholds and specific lodging policy items.
ExpenseAirfarePolicies	Defines airfare-related expense rules and eligibility criteria, specifying permitted costs and class restrictions for business travel.
ExpenseAirfarePoliciesexpenseAirfarePolicyLines	Provides detailed line items for airfare policy rules, including maximum limits, exceptions, and additional fare conditions.
ExpenseCashAdvances	Tracks employee cash advances for travel or business-related expenses, capturing key data such as status, requested amounts, and repayment details.
ExpenseCashAdvancesAttachments	Enables document uploads and management (for example, receipts or justifications) for recorded cash advances.
ExpenseCashAdvancesCashAdvanceDff	Offers descriptive flexfields for adding custom attributes to cash advance records, supporting unique organizational needs.
ExpenseConversionRateOptions	Establishes expense-specific conversion rate policies for multiple currencies, ensuring correct reimbursement calculations.
ExpenseConversionRateOptionsconversionRateTolerances	Defines allowable variances in currency conversion rates for certain currencies or business units, supporting exceptions in expense reimbursements.
ExpenseCreditCardTransactions	Captures corporate card transaction data (dates, amounts, merchant info) for automated expense reconciliation and policy checks.
ExpenseDelegations	Allows authorized delegation of expense-related tasks between employees, detailing start/end dates and permissible actions.
ExpenseDffContexts	Houses descriptive flexfield contexts for expenses and reports, enabling tailored data collection for various business use cases.
ExpenseDffSegments	Details individual descriptive flexfield segments linked to expenses, supporting extended data capture and reporting.
ExpenseDistributions	Shows how an expense item’s cost is allocated across multiple accounts or cost centers, ensuring financial accuracy.
ExpenseDistributionsPJCDFF	Captures project-specific descriptive flexfields for expense distributions, integrating project details with expense tracking.
ExpenseEntertainmentPolicies	Establishes company rules for entertainment-related spending, including meal, event, or other hospitality expenses.
ExpenseEntertainmentPoliciesexpenseEntertainmentPolicyLines	Specifies line-level detail within entertainment policies, defining allowable amounts, categories, and exclusions.
ExpenseLocations	Manages standard expense location data (cities, countries, regions) used to categorize and validate expense submissions.
ExpenseMealsPolicies	Defines meal expense guidelines, limits, and other policy details for business trips or events.
ExpenseMealsPoliciesexpenseMealsPolicyLines	Breaks down meal policy rules into line items, detailing per-diem amounts, eligibility, and exceptions.
ExpenseMileagePolicies	Sets reimbursement rules for mileage claims, including distance rates and allowable vehicle types.
ExpenseMileagePoliciesexpenseMileagePolicyLines	Contains line-level specifics for mileage policy, supporting different mileage rates or exceptions based on region or vehicle.
ExpenseMiscPolicies	Covers miscellaneous expense categories that don’t fall under standard policies, detailing eligibility and maximum thresholds.
ExpenseMiscPoliciesexpenseMiscPolicyLines	Describes specific line items under miscellaneous policies, such as office supplies or other uncommon expense types.
ExpenseOrganizationSettings	Holds setup options at the business unit level, configuring how expenses are processed, approved, or reimbursed.
ExpensePerDiemCalculations	Calculates trip-specific per diem amounts for employee expenses, factoring in policy rules and travel duration.
ExpensePerDiemPolicies	Stores the overarching per diem guidelines, including allowable rates and daily caps for travel reimbursements.
ExpensePerDiemPoliciesexpensePerDiemPolLines	Provides a breakdown of per diem policy lines, specifying coverage, meal breakdowns, or location-based rates.
ExpensePerDiemPoliciesexpensePerDiemPolValues	Tracks percentage-based per diem policy values, enabling scaled calculations for partial days or specific travel scenarios.
ExpensePersons	Contains person-centric details (business unit, currency preferences) tied to expense transactions and approvals.
ExpensePreferences	Stores an individual’s default expense settings, such as preferred currency or default cost center, streamlining expense entry.
ExpensePreferredTypes	Lists commonly used expense types for chatbot or quick expense entry, improving user efficiency and consistency.
ExpenseProfileAttributes	Stores extended user-specific expense profile data (for example, employee roles, entitlements), enhancing customization for expense submissions.
ExpenseReportsAttachments	Manages attachments (for example, receipts, authorizations) linked at the expense report level, aiding record-keeping and compliance.
ExpenseReportsExpense	Maintains line-level expense items within a report, capturing essential details like expense type, amount, and project allocations.
ExpenseReportsExpenseAttachments	Enables users to upload documents for individual expense items, reinforcing traceability and validation.
ExpenseReportsExpenseduplicateExpenses	Highlights potential duplicate expenses within a report, flagging lines that share similar attributes for review.
ExpenseReportsExpenseExpenseAttendee	Lists attendees or participants for specific expense items, ensuring accurate reimbursements for group-related expenses.
ExpenseReportsExpenseExpenseDff	Provides descriptive flexfields for additional, organization-specific data on individual expense items.
ExpenseReportsExpenseExpenseDistribution	Shows how costs from a single expense line are allocated across multiple accounts, departments, or cost centers.
ExpenseReportsExpenseExpenseDistributionPJCDFF	Offers project-centric descriptive flexfields for expense item distributions, integrating project cost details.
ExpenseReportsExpenseexpenseErrors	Captures validation errors related to an expense item, allowing users to address issues before final submission.
ExpenseReportsExpenseExpenseItemization	Breaks down a single expense into multiple sub-items (for example, hotel bill itemization), improving transparency and accuracy.
ExpenseReportsExpensematchedExpenses	Identifies expense lines matched with existing records (such as credit card transactions), reducing redundant entries.
ExpenseReportsexpenseNotes	Stores remarks or instructions from approvers or auditors regarding the entire expense report, aiding clarity and resolution.
ExpenseReportsExpensePayment	Details payment-related information (dates, amounts) for reimbursed expense reports, ensuring visibility into disbursement status.
ExpenseReportsExpenseReportDff	Includes custom flexfield data at the expense report header level, aligning the report with unique organizational processes.
ExpenseReportsprocessingDetails	Logs status changes and processing steps (for example, approvals, rejections) for an expense report, providing an audit trail.
ExpensesAttachments	Handles attachments directly tied to individual expenses, enhancing record completeness and verification.
ExpensesduplicateExpenses	Alerts users to expenses that may have been entered multiple times, aiding in cost control and policy enforcement.
ExpenseSetupOptions	Consolidates company-wide expense configurations and preferences, defining processes like workflow routing and policy thresholds.
ExpensesExpenseAttendee	Tracks the individuals associated with an expense, capturing data such as names and roles for cost-sharing analysis.
ExpensesExpenseDff	Holds descriptive flexfield references for an individual expense, enabling custom data collection and categorization.
ExpensesExpenseDistribution	Allocates the cost of an expense across multiple accounts, ensuring precise financial reporting.
ExpensesExpenseDistributionPJCDFF	Captures project-related flexfields for expense distributions, detailing project codes or tasks linked to the expenditure.
ExpensesexpenseErrors	Logs validation or policy errors detected in an expense record, prompting corrective actions prior to submission.
ExpensesExpenseItemization	Allows for subdividing a single expense item into multiple cost components (for example, a multi-day hotel stay), improving clarity.
ExpensesmatchedExpenses	Syncs submitted expenses with matched records (for example, credit card data), preventing duplicates and maintaining consistency.
ExpenseTemplates	Stores a library of standardized expense templates by business unit (for example, travel, relocation), driving efficient expense entry.
ExpenseTemplatesexpenseTypes	Defines the specific expense types and applicable policies within a given expense template, ensuring consistent categorization.
ExpenseTemplatesexpenseTypesitemizedExpenseTypes	Defines itemized expense categories within a template, allowing granular reporting and policy enforcement for expenses with multiple cost components.
ExpenseTemplatesexpenseTypespreferredAgencyLists	Associates preferred travel or service agencies with specific expense types in an expense template, ensuring employees use approved vendors.
ExpenseTemplatesexpenseTypespreferredMerchantLists	Specifies pre-approved merchants for given expense types in a template, streamlining compliance and spend oversight.
ExpenseTemplatesmobileExpenseTypes	Manages expense types specifically enabled for mobile entry, supporting on-the-go expense capture and policy adherence.
ExpenseTypes	Defines and maintains various expense classifications (for example, travel, lodging), guiding users to select the correct cost category.
ExpenseTypesitemizedExpenseTypes	Specifies subcategories for detailed expense entries under a parent expense type, enhancing accuracy and reporting granularity.
ExpenseTypespreferredAgencyLists	Links preferred agency details (for example, travel agencies) to particular expense types, helping users select valid partners.
ExpenseTypespreferredMerchantLists	Catalogs approved merchants for specific expense types, ensuring policy compliance and negotiated rates.
ExternalBankAccounts	Stores external bank account details for payments or reimbursements, supporting account creation, modifications, and usage tracking.
ExternalBankAccountsaccountOwners	Tracks the owners associated with an external bank account, defining authorization and responsibility for transactions.
FedAccountAttributes	Displays the federal account attributes used to manage natural account–level configuration details for federal financial reporting.
FedAccountAttributesfedAccountAttributeLines	Displays the line-level details for federal account attributes, including attribute names, values, and the period range during which each attribute is effective.
FedAgencyLocationCodesLOV	Displays the list of values (LOV) for federal agency location codes (ALC), including their identifiers, names, types, and disbursing classifications.
FedAttributes	Displays the list of federal attributes, including their names, categories, sources, default values, and reporting indicators.
FedAttributesLOV	Displays the list of values (LOV) for federal attributes, including their names, categories, sources, and reporting indicators.
FedAttributeSupplementalRules	Displays details regarding attribute supplemental rule fields.
FedAttributeSupplementalRulesfedAttributeSupplementalRuleLines	Displays the lines of federal attribute supplemental rules, including reporting codes, period ranges, allocation settings, and validation details used to configure rule behavior.
FedAttributeSupplementalRulesfedAttributeSupplementalRuleLinesfedAttributeSupplementalRuleAllocations	The federal attribute supplemental rule allocations enables users to manage supplemental rule allocations.
FedAttributeSupplementalRulesfedAttributeSupplementalRuleLinesfedAttributeSupplementalRuleExceptionMessages	Displays the exception messages defined for federal attribute supplemental rule lines.
FedAttributeSupplementalRulesfedAttributeSupplementalRuleLinesfedAttributeSupplementalRuleFilters	Displays the filters used within federal attribute supplemental rule lines.
FedBETCAdjustmentsLOV	Displays the list of values (LOV) for federal adjustment business event type codes (BETC).
FedBudgetControlTreeLabelsLOV	Displays the list of values (LOV) for budget control tree labels, including label names and identifiers.
FedBudgetControlTreeNodesLOV	Displays the list of values (LOV) for federal budget control tree nodes.
FedBudgetControlTreesLOV	Displays the list of values (LOV) for budget control trees, including their names, codes, and segment information used in federal budget control setups.
FedBudgetControlTreeVersionsLOV	Displays the list of values (LOV) for federal budget control tree versions, including version names, codes, and identifiers used in budget control configuration.
FedBudgetExecutionControls	Manages budget execution rules for federal accounting requirements, ensuring compliance with government financial guidelines.
FedBudgetExecutionControlsfedBudgetControlSegments	Specifies the segment rules within federal budget controls, dictating how funds are tracked and restricted across various accounts.
FedBudgetLevelOperationsLOV	Displays the list of values (LOV) for budget level operations.
FedCTAFBWTAccountDefinitions	Displays details regarding Fund Balance with Treasury (FBWT) account definitions used for Classification Transactions and Accountability (CTA) federal reporting.
FedDATAActBalances	Displays DATA Act balances, including balance identifiers, names, file associations, and audit details used in federal reporting.
FedDATAActBalancesfedDATAActBalanceCalculationTotals	Displays total balance calculations for DATA Act balances, including calculation identifiers, balance names, operators, and valid date ranges.
FedDATAActBalancesfedDATAActBalanceCalculationUSSGLAccounts	Displays United States Standard General Ledger (USSGL) accounts used in DATA Act balance calculations, including account details, balance types, and valid date ranges.
FedDATAActBalancesLOV	Displays the list of values (LOV) for all federal DATA Act balances.
FedDATAActCalculationDateRangesLOV	Displays the list of values (LOV) for federal DATA Act calculation date ranges.
FedDATAActFileCriteria	Displays details associated with the federal DATA Act file criteria for each file type.
FedDATAActFileSequences	Displays details associated with the federal DATA Act file sequence for each file type.
FedFundAttributesLOV	Returns the list of federal fund attribute values that can be used when assigning federal fund attributes in Financials.
FedGTASAccumulationBalances	Returns the federal Governmentwide Treasury Account Symbol Adjusted Trial Balance System (GTAS) accumulation balances maintained in Oracle Financials.
FedIPACTransactionData	Returns the Intra-Governmental Payment and Collection transaction data captured for federal financials processing.
FedLedgerBudgetLevelsLOV	Displays the list of values (LOV) for federal ledger budget levels.
FedLedgerGroupTreesLOV	Displays the list of values (LOV) for federal ledger group trees.
FedLedgerOptionsLOV	Returns the list of federal ledger options that can be selected when configuring federal financial reporting for a ledger.
FedSAMAccountAddressSets	Returns the System for Award Management (SAM) trading partner account address set assignments maintained in Oracle Financials.
FedTransactionTypesLOV	Displays the list of values (LOV) for federal transaction types, including identifiers, budget attributes, ledger details, and classification fields.
FedUSSGLAccountsfedUSSGLAccountAttributes	Defines and manages United States Standard General Ledger (USSGL) account attributes.
FedUSSGLAccountsLOV	Displays the list of values (LOV) for federal United States Standard General Ledger (USSGL) accounts.
FinBusinessUnitsLOV	Lists defined Financials business units, clarifying operational scope (for example, ledger, default currency) for each unit.
Finders	Displays available finder functions and their queryable attributes for different views, aiding in data retrieval and analysis.
FixedAssetCategoriesLOV	Returns the list of fixed asset category key flexfield segment values that can be selected when categorizing assets in Oracle Financials.
FxRevaluationSetups	Displays configuration details for foreign exchange (FX) revaluation, including ledger, currency, and account mappings used to revalue foreign currency balances.
FxTransferSetups	Returns the configuration for foreign exchange (FX) transfer processing, including the ledger, currency, and account mappings used to transfer foreign currency balances.
InstrumentAssignments	Assigns payment instruments (for example, checks, electronic transfers) to specific payees or transactions, ensuring controlled disbursement.
IntercompanyAgreements	Represents the intercompany agreement, which defines the attributes, currency settings, organizations, and process controls used when transferring funds between intercompany organizations.
IntercompanyAgreementsattachments	Displays details about attachments associated with intercompany agreements.
IntercompanyAgreementsintercompanyAgreementDFF	Displays the descriptive flexfield segments (DFF) defined for intercompany agreements.
IntercompanyAgreementsLOV	Displays the list of values (LOV) for intercompany agreements.
IntercompanyAgreementstransferAuthorizationGroups	Represents the transfer authorization group for an intercompany agreement.
IntercompanyAgreementstransferAuthorizationGroupstransferAuthorizationGroupDFF	Displays the descriptive flexfield (DFF) segments defined for transfer authorization groups within an intercompany agreement.
IntercompanyAgreementstransferAuthorizationGroupstransferAuthorizations	Represents the transfer authorizations defined for an intercompany agreement.
IntercompanyAgreementstransferAuthorizationGroupstransferAuthorizationsattachments	Displays details about attachments.
IntercompanyAgreementstransferAuthorizationGroupstransferAuthorizationstransactions	Displays intercompany transactions generated from transfer authorizations.
IntercompanyAgreementstransferAuthorizationGroupstransferAuthorizationstransferAuthorizationDFF	Displays the descriptive flexfield (DFF) segments defined for transfer authorizations within intercompany agreements.
IntercompanyOrganizationsLOV	Provides a list of intercompany organizations, facilitating cross-entity transactions and consolidated financial reporting.
IntercompanyTransactionSourceDocuments	Returns the source documents underlying intercompany transactions, including document, supplier, and transfer authorization details, in Oracle Financials.
IntercompanyTransactionSourceDocumentsAttachments	Returns the attachments associated with each intercompany transaction source document.
IntercompanyTransactionSourceDocumentsIntercompanyTransactionSourceDocumentDFF	Returns the descriptive flexfield attributes defined for intercompany transaction source documents.
IntercompanyTransactionTypesLOV	Displays recognized intercompany transaction types, specifying processing rules and ensuring consistent handling in multi-entity environments.
IntercompanyTransferAuthorizationsLOV	Returns the list of intercompany transfer authorizations that can be selected when processing intercompany transactions.
InterimDocumentsPayables	Holds temporary payables documents pending validation and payment, enabling partial or staged invoice creation.
InvoicesappliedPrepayments	Shows prepayment amounts applied to a given invoice, helping track remaining balances and total obligations.
Invoicesattachments	Stores attachments linked to an invoice header (for example, supporting documents), ensuring transparent record-keeping.
InvoicesavailablePrepayments	Lists prepayments not yet applied to invoices, indicating funds available to offset future payables.
InvoicesinvoiceGdf	Holds global descriptive flexfields at the invoice level, capturing additional region-specific or business-specific attributes.
InvoicesinvoiceInstallmentsinvoiceInstallmentDff	Allows user-defined flexfields for invoice installments, enabling specialized reporting on partial payments or custom categories.
InvoicesinvoiceInstallmentsinvoiceInstallmentGdf	Manages global descriptive flexfields for invoice installments, facilitating regionally unique or enterprise-wide data requirements.
InvoicesinvoiceLinesinvoiceDistributionsinvoiceDistributionDff	Enables custom descriptive flexfields on invoice distributions, allowing organizations to store additional data for reporting or auditing.
InvoicesinvoiceLinesinvoiceDistributionsinvoiceDistributionGdf	Holds global descriptive flexfields for invoice distributions, accommodating region-specific or enterprise-wide fields and validations.
InvoicesinvoiceLinesinvoiceDistributionsinvoiceDistributionProjectDff	Captures project-relevant details in a flexfield format for invoice distributions, integrating cost-tracking with project management.
InvoicesinvoiceLinesinvoiceLineDff	Provides descriptive flexfields at the invoice line level, supporting specialized data collection for each line item.
InvoicesinvoiceLinesinvoiceLineGdf	Contains global descriptive flexfields for invoice lines, ensuring compliance with various regional or organizational requirements.
InvoicesinvoiceLinesinvoiceLineProjectDff	Tracks project details for individual invoice lines in a flexfield format, linking payables data to project cost structures.
JointVentureAccountSetsaccountSetDFF	Displays descriptive flexfield (DFF) segments defined for joint venture account sets.
JointVentureAccountSetsfilterSetFilters	Displays filter sets and their corresponding filters for a project set.
JointVentureAccountSetsfilterSetsfilterSetDFF	Displays the descriptive flexfield (DFF) segments defined for filter sets within a joint venture account set.
JointVentureAccountSetsfilterSetsfiltersfilterValues	Displays filter values defined within a filter for a joint venture account set.
JointVentureAccountSetsLOV	Returns the list of joint venture account sets that can be used when defining ownership and distribution rules.
JointVentureAssignmentRules	Displays ownership definition assignment rules for assigning an ownership definition or direct billed stakeholder to joint venture transactions.
JointVentureDistributions	Returns the stakeholder distributions generated from joint venture transactions, including account, ownership, and amount details, in Oracle Financials.
JointVentureGeneratedDistributions	Returns the distributions generated for joint venture transactions, including the ownership amounts allocated to each stakeholder.
JointVentureGeneratedDistributionsDistributionDFF	Returns the descriptive flexfield attributes defined for each joint venture generated distribution.
JointVentureGeneratedTransactions	Returns the transactions generated by joint venture processing, including source, ownership, overhead, and project details, in Oracle Financials.
JointVentureGeneratedTransactionsTransactionChanges	Returns the change history records for joint venture generated transactions, capturing updates to attributes such as stakeholder, ownership definition, and status.
JointVentureGeneratedTransactionsTransactionDFF	Returns the descriptive flexfield attributes captured for each joint venture generated transaction in Oracle Financials.
JointVentureProjectSets	Returns the project sets defined for joint ventures, which group the projects used to identify and distribute joint venture transactions.
JointVentureProjectSetsFilterSetFilters	Returns the individual filters defined within the filter sets of joint venture project sets, used to identify the projects included in a project set.
JointVentureProjectSetsFilterSets	Returns the filter sets defined for each joint venture project set in Oracle Financials.
JointVentureProjectSetsFilterSetsFilters	Returns the individual filters defined within each filter set of a joint venture project set.
JointVentureProjectSetsFilterSetsFiltersFilterValues	Returns the individual filter values defined within each filter of a joint venture project set filter set in Oracle Financials.
JointVentureProjectSetsFilterSetsFiltersProjectFilterDFF	Returns the descriptive flexfield attributes defined for each filter within a joint venture project set filter set.
JointVentureProjectSetsFilterSetsProjectFilterSetDFF	Returns the descriptive flexfield attributes defined for the filter sets of joint venture project sets.
JointVentureProjectSetsProjectSetDFF	Returns the descriptive flexfield attributes defined for joint venture project sets.
JointVentureTransactions	Returns the transactions processed for joint ventures, including their accounting, ownership, and distribution details.
JointVentureTransactionsTransactionChanges	Returns the change history records for joint venture transactions, capturing updates to attributes such as stakeholder, ownership definition, project, and status.
JournalBatches	Used to view journal batches, update batch completion status and reversal attributes, and delete journal batches.
LedgerBalances	Used to view the balance amount for any account combination or an account that is defined as part of an account group.
LedgersLOV	Offers a lookup of defined ledgers, including primary, secondary, or reporting ledgers, enabling multi-ledger financial tracking.
LegalEntitiesLOV	Lists recognized legal entities, indicating each entity’s legislative compliance and responsibilities in the corporate structure.
LegalJurisdictionsLOV	Provides a reference to legal jurisdictions with specific legal authorities, aiding tax and regulatory compliance.
LegalReportingUnitsLOV	Enumerates legal reporting units, which represent the smallest entities requiring statutory reporting within a business structure.
MemoLinesLOV	Allows retrieval of valid memo lines used in Receivables, defining standardized text or charge descriptions for financial documents.
PartyFiscalClassifications	Captures fiscal classification data for parties (for example, customers, suppliers), determining applicable tax or regulatory treatment.
PartyFiscalClassificationsfiscalClassificationTypeTaxRegimeAssociations	Associates fiscal classification types with relevant tax regimes for correct tax calculation and compliance.
PartyTaxProfiles	Holds tax profile information for a party, including tax registrations and configuration, ensuring proper tax handling and reporting.
PayablesInterfaceInvoices	Returns invoices staged in the Oracle Payables interface tables that are pending validation and import into Payables.
PayablesInterfaceInvoicesAttachments	Returns the file attachments associated with payables interface invoices staged for import in Oracle Financials.
PayablesInterfaceInvoicesInterfaceInvoiceLines	Returns the invoice lines of payables interface invoices staged for import in Oracle Financials.
PayablesInterfaceInvoicesInterfaceInvoiceLinesInterfaceInvoiceLineRejections	Returns the rejection records generated for invoice lines during the payables import process, identifying why individual interface invoice lines could not be imported.
PayablesInterfaceInvoicesInterfaceInvoiceRejections	Returns the import rejections raised for invoices staged in the Oracle Payables interface, explaining why each interface invoice failed to import.
PayablesInterfaceRejectionsLOV	Returns the list of rejection reasons that can occur when invoices are processed through the payables import interface.
PayablesOptions	Centralizes configuration for Payables, such as defaulting rules and processing parameters, shaping invoice and payment workflows.
PayablesPaymentTerms	Defines the rules (for example, net 30, net 60) for paying a supplier, setting installment schedules and discount opportunities.
PayablesPaymentTermspayablesPaymentTermsLines	Specifies the line-level breakdown of each payment term, detailing how installments or discounts are structured across due dates.
PayablesPaymentTermspayablesPaymentTermsSets	Maps payment terms to reference data sets, allowing different business units or legal entities to share or customize terms.
PayablesPaymentTermspayablesPaymentTermsTranslations	Stores multilingual translations of payment terms, facilitating global operations with localized term descriptions.
PayablesTaxReportingEntities	Maintains entities required for tax reporting (for example, 1099 in the U.S.), linking tax obligations to specific organizational segments.
PayablesTaxReportingEntitiespayablesTaxReportingEntityLine	Captures multiple tax reporting lines under a single entity, supporting consolidated or segmented 1099 reporting configurations.
PayeeBankAccountsLOV	Displays valid bank accounts for payees, helping confirm account details during disbursements or refunds.
PaymentsExternalPayees	Defines external payees (for example, suppliers, vendors) for payments, enabling creation and modification of payee records.
PaymentsExternalPayeesexternalPartyPaymentMethods	Lists payment methods (such as check, EFT or ACH) available to a specific external payee, ensuring valid disbursement choices.
PaymentTermsLOV	Provides a quick lookup of defined Receivables payment terms, such as net due days or early payment discount schedules.
PreferredCurrenciesLOV	Enumerates currency preferences used by users or business units, enabling automated conversions and standardized reporting.
ReceiptMethodAssignments	Manages the assignment of receipt methods (for example, cash, check, credit card) to customer accounts or sites, controlling how payments are received.
ReceivablesAdjustments	Allows modification of existing invoices, credit memos, or other transactions, adjusting charges, freight, taxes, or lines.
ReceivablesAdjustmentsreceivablesAdjustmentDFF	Enables custom fields for receivables adjustments, capturing additional business details or classification codes.
ReceivablesBusinessUnitsLOV	Lists valid business units for the Receivables module, identifying each organization’s operational scope and ledger association.
ReceivablesCreditMemosattachments	Enables adding or reviewing attachments linked to credit memos, ensuring supporting documentation for transactions.
ReceivablesCreditMemosnotes	Holds note objects for credit memos, capturing additional instructions, clarifications, or comments.
ReceivablesCreditMemosreceivablesCreditMemoDFF	Enables descriptive flexfields on credit memos, capturing custom data points relevant to an organization’s needs.
ReceivablesCreditMemosreceivablesCreditMemoDistributions	Tracks distribution entries for credit memos, detailing account allocations and supporting ledger postings.
ReceivablesCreditMemosreceivablesCreditMemoDistributionsreceivablesCreditMemoDistributionDFF	Provides descriptive flexfields for credit memo distribution lines, adding specialized data for comprehensive financial tracking.
ReceivablesCreditMemosreceivablesCreditMemoGdf	Houses global descriptive flexfields for credit memos, accommodating region-specific or corporate-wide fields.
ReceivablesCreditMemosreceivablesCreditMemoLines	Represents each line item of a credit memo, specifying product, amounts, and adjustments for the transaction.
ReceivablesCreditMemosreceivablesCreditMemoLinesattachments	Facilitates document attachments at the credit memo line level, ensuring full traceability of line-specific data.
ReceivablesCreditMemosreceivablesCreditMemoLinesreceivablesCreditMemoLineDFF	Enables descriptive flexfields for individual credit memo lines, capturing extended transaction details.
ReceivablesCreditMemosreceivablesCreditMemoLinesreceivablesCreditMemoLineGdf	Holds global descriptive flexfields for credit memo lines, supporting worldwide or business-specific data requirements.
ReceivablesCreditMemosreceivablesCreditMemoLinesreceivablesCreditMemoLineTaxLines	Stores tax line details for credit memo lines, specifying calculated taxes, jurisdictions, and associated rates.
ReceivablesCreditMemosreceivablesCreditMemoLinesreceivablesCreditMemoLineTransactionDFF	Manages descriptive flexfields for credit memo transactions at the line level, enhancing finance data granularity.
ReceivablesCreditMemosreceivablesCreditMemoTransactionDFF	Applies descriptive flexfields at the credit memo transaction level, capturing custom attributes for the entire memo.
ReceivablesCustomerAccountActivities	Consolidates activities for a customer’s accounts, including transactions, receipts, and credit applications within Receivables.
ReceivablesCustomerAccountActivitiescreditMemoApplications	Lists credit memo applications tied to customer account activities, enabling partial or full offset of outstanding transactions.
ReceivablesCustomerAccountActivitiescreditMemoApplicationscreditMemoApplicationDFF	Supports descriptive flexfields for credit memo applications, storing additional data during the application process.
ReceivablesCustomerAccountActivitiescreditMemos	Displays credit memos issued to a customer’s account, including on-account memos and standard credit memos.
ReceivablesCustomerAccountActivitiesstandardReceiptApplications	Lists standard receipt applications for a customer’s account activities, showing how receipts are allocated to open items.
ReceivablesCustomerAccountActivitiesstandardReceiptApplicationsstandardReceiptApplicationDFF	Enables custom descriptive flexfields for standard receipt applications, capturing extra data or references.
ReceivablesCustomerAccountActivitiesstandardReceipts	Shows standard receipts recorded for a customer’s account, reflecting payments received for goods or services.
ReceivablesCustomerAccountActivitiestransactionAdjustments	Details any adjustments (increases or decreases) applied to a customer’s transactions, reflecting corrections or policy updates.
ReceivablesCustomerAccountActivitiestransactionPaymentSchedules	Tracks payment schedules (for example, installments) for a customer’s transactions, ensuring consistent collections and visibility.
ReceivablesCustomerAccountActivitiestransactionsPaidByOtherCustomers	Highlights instances where a different customer remits payment on behalf of the primary customer’s outstanding transactions.
ReceivablesCustomerAccountSiteActivities	Presents activities linked to both the customer account and the specific billing site, providing a unified transaction overview.
ReceivablesCustomerAccountSiteActivitiescreditMemoApplications	Lists credit memo applications for site-level transactions, allowing offsets or adjustments to outstanding amounts at the site.
ReceivablesCustomerAccountSiteActivitiescreditMemoApplicationscreditMemoApplicationDFF	Supports custom descriptive flexfields for credit memo applications at the account site level, capturing specialized data.
ReceivablesCustomerAccountSiteActivitiescreditMemos	Shows credit memos associated with the customer’s site, covering both standard and on-account credits.
ReceivablesCustomerAccountSiteActivitiesstandardReceiptApplications	Tracks standard receipt applications at the site level, mapping applied payments to site-specific invoices or transactions.
ReceivablesCustomerAccountSiteActivitiesstandardReceiptApplicationsstandardReceiptApplicationDFF	Holds custom descriptive flexfields for receipt applications at the account site level, capturing extra data for reporting or integrations.
ReceivablesCustomerAccountSiteActivitiesstandardReceipts	Lists standard receipts managed at the account site, indicating payments received for site-specific transactions.
ReceivablesCustomerAccountSiteActivitiestransactionAdjustments	Tracks adjustments (credits, debits) to site-based transactions, ensuring accurate account records and resolving discrepancies.
ReceivablesCustomerAccountSiteActivitiestransactionPaymentSchedules	Displays scheduled payments for site-level transactions (for example, installment plans), enhancing cash flow planning and visibility.
ReceivablesCustomerAccountSiteActivitiestransactionsPaidByOtherCustomers	Identifies cross-customer payments applied to site-related transactions, aiding reconciliation when a third party settles balances.
ReceivablesInvoicesattachments	Manages the supporting documents attached to a receivables invoice, ensuring compliance and clarity for invoice recipients.
ReceivablesInvoicesnotes	Captures notes or comments linked to an invoice, adding contextual information for collectors, auditors, or customers.
ReceivablesInvoicesreceivablesInvoiceDFF	Enables descriptive flexfields for receivables invoices, storing additional details aligned to business processes.
ReceivablesInvoicesreceivablesInvoiceDistributions	Allocates invoice lines to accounting segments, creating detailed distribution records for financial analysis.
ReceivablesInvoicesreceivablesInvoiceDistributionsreceivablesInvoiceDistributionDFF	Holds custom descriptive flexfields for invoice distributions, aiding specialized reporting or data capture.
ReceivablesInvoicesreceivablesInvoiceGdf	Contains global descriptive flexfields at the invoice level, supporting multi-regional billing and compliance requirements.
ReceivablesInvoicesreceivablesInvoiceInstallments	Details installment-based billing within an invoice, reflecting the portion due amounts and their corresponding dates.
ReceivablesInvoicesreceivablesInvoiceInstallmentsreceivablesInvoiceInstallmentGDF	Leverages global descriptive flexfields for invoice installments, handling cross-border or specialized business needs.
ReceivablesInvoicesreceivablesInvoiceInstallmentsreceivablesInvoiceInstallmentNotes	Stores notes or instructions for specific invoice installments, ensuring clarity around partial payment obligations.
ReceivablesInvoicesreceivablesInvoiceLines	Outlines each item or service included in a receivables invoice, capturing unit price, quantity, and tax details.
ReceivablesInvoicesreceivablesInvoiceLinesattachments	Facilitates attaching supporting files at the line level, clarifying charges or providing proof of delivery.
ReceivablesInvoicesreceivablesInvoiceLinesreceivablesInvoiceLineDFF	Adds descriptive flexfields at the line item level, extending invoice functionality with custom fields.
ReceivablesInvoicesreceivablesInvoiceLinesreceivablesInvoiceLineGdf	Employs global descriptive flexfields for invoice lines, supporting globalized business scenarios and complex data requirements.
ReceivablesInvoicesreceivablesInvoiceLinesreceivablesInvoiceLineTaxLines	Captures tax calculations and jurisdictions for each invoice line, facilitating accurate compliance and tax reporting.
ReceivablesInvoicesreceivablesInvoiceLinesreceivablesInvoiceLineTransactionDFF	Allows custom descriptive flexfields for transaction-level data on invoice lines, providing extended tracking and analysis.
ReceivablesInvoicesreceivablesInvoiceTransactionDFF	Adds descriptive flexfields for the entire invoice transaction, enabling more detailed recordkeeping of billing activities.
RevenueSchedulingRulesLOV	Returns the list of revenue scheduling rules that can be selected to determine how and when revenue is recognized in Oracle Financials.
SourceDocumentLines	Returns the source document lines imported into Oracle Revenue Management, including item, pricing, and satisfaction plan details.
StandardReceiptsattachments	Manages attached documentation (for example, bank slips) for each standard receipt, ensuring proof of payment and audit trails.
StandardReceiptsremittanceReferences	Enables adding references for payments, such as remittance advice numbers, assisting bank reconciliation and inquiries.
StandardReceiptsstandardReceiptDFF	Hosts descriptive flexfields on standard receipts, allowing extra details or tracking codes for internal processes.
StandardReceiptsstandardReceiptGdf	Employs global descriptive flexfields for receipts, meeting international or business-specific data requirements.
SubledgerApplicationsLOV	Returns the list of subledger applications that can be selected when configuring subledger accounting.
TaxAuthorityProfiles	Provides a lookup of tax authority profiles, outlining configuration for various tax authorities and compliance rules.
TaxClassifications	Lists tax classification attributes used for calculating and reporting tax obligations, enabling precise categorization.
TaxExemptions	Manages records of exempted transactions or entities, allowing authorized users to view, add, or modify tax exemption details.
TaxPayerIdentifiers	Stores taxpayer identification data (for example, TIN, VAT ID), facilitating correct tax reporting for businesses or individuals.
ThirdPartyFiscalClassifications	Associates suppliers or customers with fiscal classifications, determining how transactions are taxed or reported.
ThirdPartySiteFiscalClassifications	Manages fiscal classifications at the site level (for example, supplier site), defining local tax or regulatory requirements.
ThirdPartySiteTaxReportingCodeAssociations	Links site-level entities to tax reporting codes, ensuring accurate data capture for compliance and audit needs.
ThirdPartyTaxReportingCodeAssociations	Establishes tax reporting code relationships for third parties, enabling efficient retrieval of tax data across transactions.
TransactionSourcesLOV	Displays recognized Receivables transaction sources (for example, manual, import), guiding consistent transaction entry practices.
TransactionTaxLines	Allows the creation, retrieval, and modification of manual tax lines for a transaction, ensuring accurate tax posting.
TransactionTypesLOV	Presents valid Receivables transaction types (for example, invoice, debit memo) for referencing in billing and revenue processes.
UserDefinedFiscalClassificationsLOV	Returns the list of user-defined fiscal classification values that can be selected when applying tax classifications in Oracle Financials.
ValidateTaxConfigurations	Returns the results of validating tax configuration setup, identifying issues found in the configured tax rules and settings.
ValueSets	Holds value set definitions, ensuring controlled vocabularies and standardized validation for various fields.
ValueSetsvalidationTable	Specifies the underlying validation table for value sets, directing how lookups and data checks occur.
ValueSetsValues	Lists permissible values in a specific value set, enforcing consistency in data entry across modules.
WithholdingTaxLines	Maintains entries for withholding tax computations, supporting creation, retrieval, and updates to withholdings on transactions.
WorkflowUsers	Records details of workflow participants, mapping users to roles or steps in financial approvals and notifications.