JDBC Driver for Oracle Fusion Cloud Financials

Build 25.0.9434

ComplianceChecklists

Stores procurement compliance checklist details, supporting evaluations or audits of supplier qualifications and practices.

Columns

Name Type Description
ChecklistInitiativeId [KEY] Long System-generated identifier for the compliance checklist. This identifier is stored as an initiative ID and is used to uniquely reference a specific compliance checklist within the system.
Checklist String A unique value that identifies the compliance checklist. This field serves as the primary reference for the checklist in the system.
Title String The title or name given to the compliance checklist. This field helps identify the checklist and provides context for its purpose or subject matter.
StatusCode String A code representing the status of the compliance checklist. This field is used to track the current state of the checklist, such as whether it is 'Pending', 'In Progress', or 'Completed'.
Status String Describes the current status of the compliance checklist. This field provides more detailed information about the checklist’s progress or stage in the compliance process.
ProcurementBUId Long Unique identifier for the procurement business unit where the compliance checklist was created. This value links the checklist to the specific business unit responsible for its creation.
ProcurementBU String The name of the procurement business unit where the compliance checklist was created. This helps identify which part of the organization is responsible for managing and completing the checklist.
ChecklistOwnerId Long Unique identifier for the owner of the compliance checklist. This field is used to link the checklist to the individual or group responsible for overseeing its completion.
ChecklistOwner String The name of the person or entity who owns and is responsible for the compliance checklist. The owner manages the checklist’s creation, updates, and overall progress.
ChecklistTemplateId Long System-generated identifier for the checklist template used to create the compliance checklist. This links the checklist to the template that defines its structure and content.
ChecklistTemplate String The name or identifier of the checklist template used to create the compliance checklist. This field helps track which predefined template was selected for the checklist’s structure.
ChecklistTemplateRevision Int The revision number of the checklist template used. This field helps track changes to the template, ensuring the most up-to-date version is used in the checklist.
ReopenDate Datetime The date and time when the compliance checklist was reopened. This timestamp is recorded when the checklist is revisited after being closed or completed.
ReopenedById Long Unique identifier for the user who reopened the compliance checklist. This links the action of reopening the checklist to the specific individual responsible for it.
ReopenedBy String The name of the user who reopened the compliance checklist. This field provides accountability for who took the action of reopening the checklist.
ReopenReason String The reason given for reopening the compliance checklist. This helps provide context for why the checklist was revisited or modified after its initial closure.
CompletionDate Datetime The date and time when the compliance checklist was marked as complete. This timestamp is recorded when all necessary tasks or steps are finished and the checklist is considered finalized.
CompletedById Long Unique identifier for the user who completed the compliance checklist. This links the completion action to the specific individual responsible for finalizing the checklist.
CompletedBy String The name of the user who completed the compliance checklist. This field provides accountability for the individual who finished the checklist’s tasks or actions.
CancellationDate Datetime The date and time when the compliance checklist was canceled. This timestamp is used when the checklist is deemed no longer necessary or valid and is canceled before completion.
CanceledById Long Unique identifier for the user who canceled the compliance checklist. This links the cancellation action to the specific individual responsible for stopping the checklist.
CanceledBy String The name of the user who canceled the compliance checklist. This field identifies the individual who took the action of halting the checklist process.
CanceledReason String The reason provided for the cancellation of the compliance checklist. This field explains why the checklist was canceled, providing context for its removal from active processes.
CreationDate Datetime The date and time when the compliance checklist was originally created. This timestamp records the creation event and serves as a reference for when the checklist was introduced.
POHeaderId Long System-generated identifier for the purchasing document associated with the compliance checklist. This field links the checklist to the corresponding purchase order header.
PONumber String A unique identifier for the purchasing document associated with the compliance checklist. This number is used to track and link the checklist to its corresponding purchase order.
POStatus String The current status of the purchasing document associated with the compliance checklist. This field reflects the status of the purchase order, such as 'Open', 'Completed', or 'Canceled'.
PurchasingDocumentType String The type of purchasing document associated with the compliance checklist. This field identifies whether the related document is a purchase order, requisition, or other type of procurement document.
Finder String A field used for searching or locating specific compliance checklist records within the system. It may contain search criteria or keywords that help users quickly find the relevant checklist.
EffectiveDate Date This query parameter is used to fetch resources or records that were effective as of the specified start date. It ensures that only valid and relevant data is returned based on the date the query is executed.

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