JDBC Driver for Oracle Fusion Cloud Financials

Build 25.0.9434

SupplierInitiatives

Tracks the creation and status of supplier initiatives, which manage supplier assessments or qualification projects.

Columns

Name Type Description
InitiativeId [KEY] Long Unique identifier for the initiative, used to reference and track specific initiatives within the system.
Initiative String The unique number assigned to the initiative, typically used for identification and reference within sourcing and procurement processes.
Title String Title of the initiative as entered by the user, providing a brief summary or label for the initiative.
Description String Detailed description of the initiative, entered by the user, explaining the initiative’s purpose, scope, and objectives.
StatusCode String Abbreviation representing the current status of the initiative. Valid values include those defined in the lookup type POQ_INITIATIVE_STATUS (for example, ACTIVE, INACTIVE, COMPLETED).
Status String Current status of the initiative, providing a high-level summary of its state (for example, 'Active', 'Completed', 'Cancelled').
InitiativeTypeCode String Code that identifies the type of initiative (for example, 'New', 'Renewal', 'Assessment'), with values defined in the lookup type POQ_INITIATIVE_TYPE.
InitiativeType String The type of initiative, indicating whether it’s a new initiative, a renewal, or a different kind of activity.
ProcurementBUId Long Unique identifier for the procurement business unit associated with the initiative, linking the initiative to a specific organizational unit.
ProcurementBU String The name of the procurement business unit responsible for the initiative, providing context for the unit handling the initiative.
InitiativeOwnerId Long Unique identifier for the person or entity responsible for the initiative, linking the initiative to the owner.
InitiativeOwner String The name of the individual or entity that owns and is accountable for the initiative.
InternalNote String Internal notes for the initiative, entered by the user, providing additional context, comments, or instructions regarding the initiative.
QualificationModelId Long Unique identifier for the qualification model associated with the assessment initiative, linking it to a specific qualification model.
QualificationModel String The name of the qualification model used for the assessment, providing context on the criteria and framework for evaluating the initiative.
QualificationModelStatusCode String Code representing the current status of the qualification model, reflecting whether the model is active, inactive, or in another state.
QualificationModelStatus String Descriptive status of the qualification model, indicating its current state (for example, 'Active', 'Inactive', 'Under Review').
QualificationModelRevision Int Revision number of the qualification model, indicating the version of the model in use for the initiative.
AssessmentOwnerId Long Unique identifier for the individual responsible for the assessment, linking the assessment to a specific owner.
AssessmentOwner String The name of the person who owns and oversees the assessment process for the initiative.
AssessmentEvaluationDueDate Date The date by which the assessment for the initiative is due to be evaluated, establishing a deadline for the evaluation process.
ReuseActiveQualificationFlag Bool Flag indicating whether existing active qualifications can be reused for the assessment initiative. If true, valid reusable qualifications will be applied; if false, new qualifications will be created.
LaunchDate Datetime The date and time when the initiative was officially launched, marking the start of the initiative.
InitiativeCompletionDate Datetime The date and time when the initiative was completed, marking the end of the initiative.
InitiativeCancellationDate Datetime The date and time when the initiative was canceled, if applicable, marking the cessation of the initiative.
CanceledById Long Unique identifier for the user who canceled the initiative, providing accountability for the cancellation.
CanceledBy String The name of the user who canceled the initiative, providing visibility into who made the decision to cancel.
CanceledReason String The reason for the cancellation of the initiative, entered by the user, providing context for why the initiative was stopped.
CreationDate Datetime The date and time when the initiative was created, tracking the creation of the initiative in the system.
CreationSourceCode String Code identifying the source from which the initiative was created (for example, 'Internal', 'External'), defined in the lookup type ORA_POQ_CREATION_SOURCE.
CreationSource String Descriptive source for the creation of the initiative, indicating whether it originated internally or externally.
AutoAcceptResponsesFlag Bool Flag indicating whether questionnaire responses should be automatically accepted. If true, responses are automatically accepted; if false, manual approval is required.
AutoPopulateResponsesFlag Bool Flag indicating whether responses from the response repository should be auto-filled in the questionnaire. If true, responses will be populated automatically; if false, they will need to be manually entered.
LastOverdueReminderDate Datetime The date and time when the last overdue reminder notification was sent for an internal response that was overdue.
LastOverdueRmndrDateSup Datetime The date and time when the last overdue reminder notification was sent for an external response that was overdue.
InitiativeSurveyFlag Bool Flag indicating whether the initiative is a survey type. If true, the initiative allows multiple internal responders; if false, it allows only a single responder.
Finder String Search or query reference related to the SupplierInitiatives, potentially used for filtering or looking up past initiatives.

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