JDBC Driver for Oracle Fusion Cloud Financials

Build 25.0.9434

ProcurementAgents

Maintains records of users designated as procurement agents (buyers, supplier managers), defining their responsibilities and privileges.

Columns

Name Type Description
AssignmentId [KEY] Long The unique identifier for the assignment of a procurement agent, linking the agent to their specific role and responsibilities.
Agent String The name of the procurement agent, formatted as Last Name, First Name.
AgentId Long The unique identifier assigned to the procurement agent.
AgentEmail String The email address of the procurement agent for communication purposes.
ProcurementBU String The name of the procurement business unit to which the agent is assigned, indicating where the agent works.
ProcurementBUId Long The unique identifier for the procurement business unit.
Status String The current status of the procurement agent. Valid values include 'Inactive' and 'Active', with 'Active' being the default.
StatusCode String The abbreviated status of the procurement agent. 'Y' indicates active status, while 'N' indicates inactive status. The default is 'Y'.
DefaultRequisitioningBU String The name of the default requisitioning business unit where the agent handles requisitions.
DefaultRequisitioningBUId Long The unique identifier for the default requisitioning business unit associated with the procurement agent.
DefaultPrinter String The default printer assigned to the procurement agent for printing documents.
ManageRequisitionsAllowedFlag Bool Indicates whether the procurement agent is allowed to manage purchase requisitions. 'True' means allowed, 'False' means not allowed. Default is 'False'.
AccessLevelToOtherAgentsRequisitions String The access level for managing requisitions owned by other agents. Possible values are 'None', 'View', and 'Full', with 'None' as the default.
ManageOrdersAllowedFlag Bool Indicates whether the procurement agent is allowed to manage purchase orders. 'True' means allowed, 'False' means not allowed. Default is 'False'.
AccessLevelToOtherAgentsOrders String The access level for managing orders owned by other agents. Valid values include 'None', 'View', and 'Full', with 'None' as the default.
ManageAgreementsAllowedFlag Bool Indicates whether the procurement agent is allowed to manage purchase agreements. 'True' means allowed, 'False' means not allowed. Default is 'False'.
AccessLevelToOtherAgentsAgreements String The access level for managing agreements owned by other agents. Valid values include 'None', 'View', and 'Full', with 'None' as the default.
ManageNegotiationsAllowedFlag Bool Indicates whether the procurement agent is allowed to manage negotiations. 'True' means allowed, 'False' means not allowed. Default is 'False'.
AccessLevelToOtherAgentsNegotiations String The access level for managing negotiations owned by other agents. Valid values include 'None', 'View', and 'Full', with 'None' as the default.
ManageSourcingProgramsAllowedFlag Bool Indicates whether the procurement agent is allowed to manage sourcing programs. 'True' means allowed, 'False' means not allowed. Default is 'False'.
AccessLevelToOtherAgentsSourcingPrograms String The access level for managing sourcing programs owned by other agents. Valid values include 'None', 'View', and 'Full', with 'None' as the default.
ManageCatalogContentAllowedFlag Bool Indicates whether the procurement agent is allowed to manage catalog content. 'True' means allowed, 'False' means not allowed. Default is 'False'.
ManageSuppliersAllowedFlag Bool Indicates whether the procurement agent is allowed to manage suppliers. 'True' means allowed, 'False' means not allowed. Default is 'False'.
ManageQualificationsAllowedFlag Bool Indicates whether the procurement agent is allowed to manage supplier qualifications. 'True' means allowed, 'False' means not allowed. Default is 'False'.
AccessLevelToOtherAgentsQualifications String The access level for managing qualifications owned by other procurement agents. Valid values include 'None', 'View', and 'Full', with 'None' as the default.
ManageAslAllowedFlag Bool Indicates whether the procurement agent is allowed to manage entries on the approved supplier list. 'True' means allowed, 'False' means not allowed. Default is 'False'.
AnalyzeSpendAllowedFlag Bool Indicates whether the procurement agent is allowed to analyze spend data. 'True' means allowed, 'False' means not allowed. Default is 'False'.
AccessLevelToOtherAgentsChecklists String The access level for managing compliance checklists owned by other agents. Valid values include 'None', 'View', and 'Full', with 'None' as the default.
ManageChecklistsAllowedFlag Bool Indicates whether the procurement agent is allowed to manage compliance checklists. 'True' means allowed, 'False' means not allowed. Default is 'False'.
Finder String The finder function or mechanism used to search for or retrieve procurement agent records.

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