Power BI Connector for Oracle Fusion Cloud SCM

Build 25.0.9454

InventoryOrganizationsplantParameters

Manages default parameters for plant-specific manufacturing or maintenance organizations.

Columns

Name Type Description
InventoryOrganizationsOrganizationId [KEY] Long Unique identifier linking this plant parameter entry to a specific inventory organization.
OrganizationId [KEY] Long Unique identifier for the inventory organization, automatically generated upon creation.
ManufacturingCalendarId Long Unique identifier for the manufacturing calendar referenced by the organization. This attribute is required.
DefaultSupplySubinventory String Subinventory used for backflushing operations when no default values are defined.
DefaultSupplyLocator Long Locator used for backflushing operations when no default values are defined. Dependent on DefaultSupplySubinventory.
DefaultCompletionSubinventory String Subinventory used to store completed products if no default subinventory is defined.
DefaultCompletionLocator Long Locator used to store completed products if no default locator is defined. Dependent on DefaultCompletionSubinventory.
StartingOperationSequence Long Default sequence number for the first operation in a new work definition.
OperationSequenceIncrement Long Increment value applied to each new operation added in a work definition.
PhantomOperationInherit String Specifies whether phantom work definitions should charge components, resources, and overhead at the parent work item level.
WorkOrderPrefix String Alphanumeric prefix added to work order names when creating new work orders.
WorkOrderStartingNumber Long Starting numeric value used for generating work order numbers at the plant.
DefaultOvercompletionTolerance Decimal Percentage of assemblies allowed to be overcompleted per job or schedule.
DefaultTransactionMode String Specifies whether the system defaults transaction quantities to required quantities during material or resource transactions.
DefaultTransactionQuantity String Determines default transaction behavior for material and resource transactions within a work order.
QuantityChangeBackflush String Specifies whether quantity changes are allowed during backflushing operations.
DefaultWorkOrderTravelerTemplate String Layout template used when printing work order travelers.
DefaultLabelTemplate String Layout template used when printing labels for manufacturing or work orders.
IncludeComponentYieldFlag Bool Indicates whether decimal quantity rounding is applied. 'True' means no rounding; 'False' means rounding is applied (default: False).
AutoAssociateSerialNumberWorkOrderImportFlag Bool Indicates whether serial numbers are automatically created and associated with jobs. 'True' means enabled; 'False' means disabled (default: True).
BackflushLotSelection String Determines lot selection method during backflushing. Valid values: Manual, FIFO (First In First Out), or FEFO (First Expiration First Out).
StartStopCaptureLevel String Defines how time is captured during operations in the work order. Valid values: Operation Serial or Item Serial.
PurchaseRequisitionCreationTime String Specifies the threshold for creating purchase requisitions for work orders involving supplier operations and outside processing.
MaterialReportingLevel String Determines when material reporting icons appear in the dispatch list.
ForecastHorizon Int Defines the maximum number of days the Maintenance Forecast scheduled process calculates. Must be a positive integer (default: 30 days).
GenerateWorkOrdersHorizon Int Defines the maximum number of days the Generate Work Order scheduled process calculates (default: 7 days).
DefaultPickSlipGroupingRule Long Specifies the default grouping rule for pick slips in manufacturing work orders.
PrintPickSlipsFlag Bool Indicates whether pick slips are printed. 'True' means enabled; 'False' means disabled (default: False).
IncludePullComponentsFlag Bool Indicates whether pull supply type components should be included in picking. 'True' means enabled; 'False' means disabled (default: False).
IssuePushComponentsFlag Bool Indicates whether push components should be issued directly to work orders. 'True' means enabled; 'False' means disabled (default: False).
PrintLabelExternallyFlag Bool Indicates whether labels should be printed using an external system. 'True' means enabled; 'False' means disabled (default: False).
AllowDirectPurchasesForWorkOrdersFlag Bool Indicates whether work orders can access self-service procurement. 'True' means enabled; 'False' means disabled (default: False).
EnableProcessManufacturingFlag Bool Indicates whether the plant supports process manufacturing. 'True' means enabled; 'False' means disabled (default: False).
DefaultWorkMethod String Specifies the default manufacturing method for work definitions. Valid values: Discrete or Process.
ManufacturingCalendarName String Name of the manufacturing calendar referenced by the organization.
EnableIotFlag Bool Indicates whether the plant is synchronized with Oracle Internet of Things Cloud Service. 'True' means enabled; 'False' means disabled (default: False).
ManuallyIssueAssemblyToReworkWorkOrderFlag Bool Indicates whether assemblies must be manually issued for rework. 'True' means enabled; 'False' means disabled (default: False).
AllowNegativeIssueWithoutSerialNumberEntryFlag Bool Indicates whether serial number entry is required when removing parts from a procured finished good. 'True' means not required; 'False' means required (default: False).
AllowReservationsOnWorkOrdersFlag Bool Indicates whether work orders allow reservations on specified materials. 'True' means enabled; 'False' means disabled (default: False).
MaximumSchedulingDurationInMonths Int Defines the maximum allowed scheduling duration in months. Minimum: 3 months, Maximum: 48 months (default: 12 months).
CreatedBy String Username or system entity that created this plant parameter record.
CreationDate Datetime Timestamp indicating when the plant parameter record was initially created.
LastUpdateDate Datetime Timestamp indicating when the plant parameter record was last updated.
LastUpdatedBy String Username or system entity that last modified the plant parameter record.
DefaultLotNumberBehavior String Specifies the defaulting method for lot number population in finished products. Valid values: No Default, Work Order Number (default: No Default).
RestrictLotsDuringReturnsFlag Bool Indicates whether returned lots must be restricted to previously transacted lots. 'True' means restricted; 'False' means not restricted (default: False).
DefaultUndercompletionTolerance Decimal Percentage of assemblies allowed to be undercompleted per job or schedule.
InspectionPlanType String Specifies the default inspection plan for the maintenance facility.
DefaultIncludeInPlanningForBulkSupplyTypeFlag Bool Indicates whether bulk supply-type operation items are included in planning by default. 'True' means included; 'False' means not included (default: True).
DefaultIncludeInPlanningForSupplierSupplyTypeFlag Bool Indicates whether supplier supply-type operation items are included in planning by default. 'True' means included; 'False' means not included (default: True).
EnableRoboticsFlag Bool Indicates whether the plant uses robotic resources. 'True' means enabled; 'False' means disabled (default: False).
DefaultMaterialReviewBoardSubinventory String Specifies the default subinventory for defective or unserviceable components during maintenance.
DefaultMaterialReviewBoardLocator Long Specifies the default locator for defective or unserviceable components during maintenance.
Finder String A system-defined query or lookup used to retrieve plant parameter records.
Status String Current status of the plant parameter entry.

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