JDBC Driver for Oracle Fusion Cloud Financials

Build 25.0.9434

RequisitionPreferencesrequisitioningOptions

Reflects configured requisitioning BU features, profile options, and active functional opt-ins that shape the user’s requisition interface.

Columns

Name Type Description
RequisitionPreferencesUserPreferenceId [KEY] Long The unique identifier for the requisition preferences associated with requisitioning options. Example: 1001 for User Preference ID 1001.
RequisitioningBUOptionsId [KEY] Long The unique identifier for the requisitioning business unit options associated with the requisition preferences. Example: 2001 for Requisitioning Business Unit Options ID 2001.
RequisitioningBUId Long The unique identifier for the business unit associated with the requisitioning options. Example: 3001 for Requisitioning Business Unit ID 3001.
LineTypeId Long The unique identifier for the line type associated with requisitioning options. Example: 4001 for Line Type ID 4001.
EnableApproverOverrideFlag Bool Indicates whether the approver override feature is enabled. Example: True if approver override is allowed for the requisition.
ShowInternalSupplyAvailableQuantityFlag Bool Indicates whether the internal supply available quantity should be displayed. Example: True if the available quantity of internal supply is visible.
HeaderDffContextCode String The context code for the header descriptive flexfield (DFF), defining how header-level attributes should be captured. Example: 'REQ_HEADER' for requisition header attributes.
LineDffContextCode String The context code for the line DFF, defining how line-level attributes should be captured. Example: 'REQ_LINE' for requisition line attributes.
DistributionDffContextCode String The context code for the distribution DFF, defining how distribution-level attributes should be captured. Example: 'REQ_DIST' for requisition distribution attributes.
FunctionalCurrencyCode String The currency code used in the requisition, typically reflecting the business unit's functional currency. Example: 'USD' for U.S. Dollars.
ChartOfAccountId Long The unique identifier for the chart of accounts associated with the requisitioning options. Example: 5001 for Chart of Account ID 5001.
ShowDFFByDefault String Indicates whether the DFF should be shown by default for requisitioning options. Example: 'Yes' if DFF fields should be displayed by default.
ConversionRateType String The type of conversion rate used in the requisition. Example: 'Spot Rate' for a rate applied to a specific transaction.
ShowAdditionalItemAttributes String Indicates whether additional item attributes should be displayed. Example: 'Yes' if extra attributes like color or size should be shown.
LESystemDate Date The system date for the legal entity (LE), used for date-based validation in the requisition process. Example: '2023-06-01' for the legal entity system date.
InventoryOrganizationSystemDate Date The system date for the inventory organization, used for inventory-related date validations. Example: '2023-06-01' for the inventory organization system date.
PackagingStringOrder String The order in which packaging strings should appear for items in the requisition. Example: '1-2-3' to specify a sequence for packaging.
DisplayPackagingStringOptinFlag Bool Indicates whether the user has opted to display the packaging string. Example: True if the user has opted in to see the packaging string.
RequestedDeliveryDateOffset String The offset from the requested delivery date, used to calculate the expected delivery date. Example: '2 days' to indicate a two-day delay.
ProgressiveWebappOptinFlag Bool Indicates whether the user has opted in to use a progressive web app (PWA) for requisitioning. Example: True if the user opts in for PWA functionality.
InternalMaterialTransfersOptinFlag Bool Indicates whether the user has opted in for internal material transfers. Example: True if the user allows internal material transfers in requisitions.
ExpenseAgreementLinesFromInternalSourcesOptinFlag Bool Indicates whether the user has opted in to include expense agreement lines from internal sources. Example: True if the user permits such lines.
AllowOnetimeAddrFlag Bool Indicates whether one-time delivery addresses are allowed in requisitions. Example: True if one-time addresses can be used for deliveries.
ProjectCostingFeatureOptinFlag Bool Indicates whether the user has opted in to use project costing features in requisitioning. Example: True if project costing features are enabled for the user.
PJCAllowAccountOverride String Indicates whether account overrides are allowed in project costing for requisitions. Example: 'Yes' if account overrides are permitted for project costing.
RequestedDateInLocalTimeOptinFlag Bool Indicates whether the user has opted in to use local time for requested delivery dates. Example: True if the delivery dates should reflect the local time zone.
InvoiceHoldOptinFlag Bool Indicates whether the user has opted in to put invoices on hold in the requisitioning process. Example: True if invoices can be held for review.
CatalogInformationTemplateApplicableFlag Bool Indicates whether catalog information templates are applicable for requisitions. Example: True if templates from the catalog can be used for requisitioning.
SpecialHandlingOptinFlag Bool Indicates whether the user has opted in to handle special requisition requirements. Example: True if special handling flags can be used in requisition requests.
ShopFromPreferredSourceOptinFlag Bool Indicates whether the user has opted to shop from preferred sources for requisitions. Example: True if preferred suppliers are prioritized.
EPPOptinFlag Bool Indicates whether the user has opted in to use the Electronic Purchase Order (EPP) system. Example: True if EPP is enabled for the user.
BpaDescriptionOverrideProfileOptionFlag Bool Indicates whether the user has opted to override the description profile in Blanket Purchase Agreements (BPA). Example: True if the description override is allowed.
MarketplaceOptinFlag Bool Indicates whether the user has opted to participate in the marketplace for requisitioning. Example: True if the marketplace is enabled for the user.
SSPImplementedFlag Bool Indicates whether the Self-Service Procurement (SSP) feature is implemented for the user. Example: True if SSP is implemented.
NextGenSSPSupplierRegistrationOptinFlag Bool Indicates whether the user has opted into the NextGen SSP Supplier Registration. Example: True if the user is enrolled in the NextGen SSP supplier registration program.
Finder String A reference or placeholder used for searching and locating specific requisition preferences records. Example: 'Search by User ID' or 'Search by Business Unit'.
PersonId Long The unique identifier for the person associated with the requisition preferences. Example: 7001 for Person ID 7001.
SysEffectiveDate Date The system effective date, used to determine when the requisition preferences become valid. Example: '2023-06-01' for when the requisition preferences take effect.
UserPreferenceId Long The unique identifier for the user preference record. Example: 8001 for the user's preference ID.
EffectiveDate Date This query parameter is used to fetch resources which are effective as of the specified start date. Example: '2023-06-01' for fetching records that are effective from this date.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434