SSIS Components for Oracle Fusion Cloud SCM

Build 26.0.9770

InspectionEventsinspectionEventActions

Tracks actions taken on inspection events, including material status updates, quality issues, and work orders created as a result of the actions.

Columns

Name Type SupportedFinders Description
InspectionEventsIpEventId [KEY] Long The unique identifier for the parent inspection event.
IpEventId [KEY] Long PrimaryKey The unique identifier for the inspection event.
SampleId Decimal The unique identifier for the sample to inspect.
SampleResultId Decimal The unique identifier for the sample inspection result.
ActionTaken String The action taken on the inspection event.
MessageName String The message code returned by the system based on the action.
MaterialStatusLevel String The level of the material status change.
StatusId Long The unique identifier for the new material status based on the action.
StatusCode String The new material status code based on the action.
Notifiers String The list of notification recipients.
IssueId Decimal The unique identifier for the quality issue created by the action.
MessageText String The message details for the action.
SerialNumber String The serial number of the item being inspected.
SampleNumber String The number identifying the sample being inspected for a non-serial item.
IssueNumber String The quality issue number generated by the action.
IssueName String The name of the quality issue created by the action.
IssueDescription String A description of the quality issue created by the action.
AsActionTakenDate Datetime The date and time that the action was executed.
WorkOrderId Long The unique identifier for the work order created by the action.
WorkOrderNumber String The work order number created by the action.
BindAcceptanceQualityLimit String FindInspectionEvents Bind parameter for filtering inspection events by the acceptance quality limit.
BindAssetId Long FindInspectionEvents Bind parameter for filtering inspection events by the unique identifier of the asset.
BindAssetNumber String FindInspectionEvents Bind parameter for filtering inspection events by the asset number.
BindCategoryId Long FindInspectionEvents Bind parameter for filtering inspection events by the unique identifier of the item category.
BindCategorySetId Long FindInspectionEvents Bind parameter for filtering inspection events by the unique identifier of the item category set.
BindDocumentType String FindInspectionEvents Bind parameter for filtering inspection events by the document type.
BindEndDate Datetime FindInspectionEvents Bind parameter for filtering inspection events by the end date of the inspection.
BindEventType String FindInspectionEvents Bind parameter for filtering inspection events by the type of the inspection event.
BindInspectedBy String FindInspectionEvents Bind parameter for filtering inspection events by the user who performed the inspection.
BindInspectionLevelId Long FindInspectionEvents Bind parameter for filtering inspection events by the unique identifier of the inspection level.
BindInspectionLevelName String FindInspectionEvents Bind parameter for filtering inspection events by the name of the inspection level.
BindInspectionName String FindInspectionEvents Bind parameter for filtering inspection events by the name of the inspection.
BindInspectionPlanId Long FindInspectionEvents Bind parameter for filtering inspection events by the unique identifier of the inspection plan.
BindInspectionPlanName String FindInspectionEvents Bind parameter for filtering inspection events by the name of the inspection plan.
BindInspectionStatus String FindInspectionEvents Bind parameter for filtering inspection events by the status of the inspection.
BindInventoryItemId Long FindInspectionEvents Bind parameter for filtering inspection events by the unique identifier of the inventory item.
BindItemNumber String FindInspectionEvents Bind parameter for filtering inspection events by the item number.
BindLotNumber String FindInspectionEvents Bind parameter for filtering inspection events by the lot number.
BindOrganizationCode String FindInspectionEvents Bind parameter for filtering inspection events by the abbreviation that identifies the organization.
BindOrganizationId Long FindInspectionEvents Bind parameter for filtering inspection events by the unique identifier of the organization.
BindOrganizationName String FindInspectionEvents Bind parameter for filtering inspection events by the name of the organization.
BindPrivilege String FindSecuredInspectionEvents Bind parameter for filtering inspection events by the privilege of the user.
BindQuantityRejected String FindInspectionEvents Bind parameter for filtering inspection events by the rejected quantity.
BindReceiptNumber String FindInspectionEvents Bind parameter for filtering inspection events by the receipt number.
BindResourceCode String FindInspectionEvents Bind parameter for filtering inspection events by the abbreviation that identifies the resource.
BindResourceId Long FindInspectionEvents Bind parameter for filtering inspection events by the unique identifier of the resource.
BindSamplingLevelCode String FindInspectionEvents Bind parameter for filtering inspection events by the abbreviation that identifies the sampling level.
BindSamplingPlanType String FindInspectionEvents Bind parameter for filtering inspection events by the type of the sampling plan.
BindSamplingStandardCode String FindInspectionEvents Bind parameter for filtering inspection events by the abbreviation that identifies the sampling standard.
BindSourceOrganizationCode String FindInspectionEvents Bind parameter for filtering inspection events by the abbreviation that identifies the source organization.
BindStartDate Datetime FindInspectionEvents Bind parameter for filtering inspection events by the start date of the inspection.
BindSubinventoryCode String FindInspectionEvents Bind parameter for filtering inspection events by the abbreviation that identifies the subinventory.
BindSupplier String FindInspectionEvents Bind parameter for filtering inspection events by the supplier.
BindWorkAreaId Long FindInspectionEvents Bind parameter for filtering inspection events by the unique identifier of the work area.
BindWorkCenterCode String FindInspectionEvents Bind parameter for filtering inspection events by the abbreviation that identifies the work center.
BindWorkCenterId Long FindInspectionEvents Bind parameter for filtering inspection events by the unique identifier of the work center.
BindWorkOrderId Long FindInspectionEvents Bind parameter for filtering inspection events by the unique identifier of the work order.
BindWorkOrderNumber String FindInspectionEvents Bind parameter for filtering inspection events by the work order number.
Finder String The name of the finder method used to search and filter inspection event action records.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770