JDBC Driver for Oracle Fusion Cloud Financials

Build 25.0.9434

RequisitionPreferencesprojectDFF

Enables descriptive flexfields for project costing within a user’s requisition preferences, linking requisition data to project tasks.

Columns

Name Type Description
RequisitionPreferencesUserPreferenceId [KEY] Long The unique identifier for the requisition preferences associated with the project descriptive flexfield (DFF) record. Example: 1001 for User Preference ID 1001.
UserPreferenceId [KEY] Long The unique identifier for the user's requisition preferences record, linking it to the project DFF. Example: 2001 for the specific user's preferences.
_FLEX_Context String The context for the DFF, used to define the context in which the DFF is applicable. Example: 'Project Details' for the DFF context.
_FLEX_Context_DisplayValue String The display value of the DFF context, providing a user-friendly label for the context. Example: 'Project Information' for the context display name.
Finder String A reference or placeholder used for searching and locating specific project DFF records in the system. Example: 'Search by Context' or 'Search by Project ID'.
PersonId Long The unique identifier for the person associated with the requisition preferences. Example: 3001 for Person ID 3001.
RequisitioningBUId Long The unique identifier for the business unit associated with the requisition preferences related to the project. Example: 4001 for the Requisitioning Business Unit ID.
SysEffectiveDate Date The date from which the requisition preferences for the project DFF are effective. Example: '2023-06-01' for the effective date of the project DFF preferences.
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 effective from this date.

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