Inventory Organization Parameters

The Inventory Organization Parameters view object manages the defaults and parameters of an organization. A logistic, manufacturing, or asset management application can use this view object to find inventory organization parameters.

Data Store Key : FscmTopModelAM.ScmExtractAM.ScmRcsBiccExtractAM.InvOrgParametersExtractPVO

Primary Keys : OrganizationId

Initial Extract Date : CreationDate

Incremental Extract Date : LastUpdateDate

Attributes

This table provides the list of exposed attributes and their descriptions.

Name	Description
AllocateSerialFlag	Contains one of the following values: true or false. If true, then the application selects each serial number. If false, then the user selects each serial number. The default value is false.
AllowDifferentStatus	Determines whether or not the lot status can change when transferring material that the lot controls.
AllowItemSubstitutionsFlag	Contains one of the following values: true or false. If true, then the warehouse accepts substitute items in place of ordered items. If false, then the warehouse doesn't accept substitute items. The default value is false.
AllowNegOnhandCcTxns	Contains one of the following values: true or false. If true, then allow each transaction that occurs during the cycle count to result in a negative quantity in inventory. If false, then don't allow each transaction that occurs during the cycle count to result in a negative quantity in inventory. The default value is false.
Attribute1	Segment of the user-descriptive flexfield.
Attribute10	Segment of the user-descriptive flexfield.
Attribute11	Segment of the user-descriptive flexfield.
Attribute12	Segment of the user-descriptive flexfield.
Attribute13	Segment of the user-descriptive flexfield.
Attribute14	Segment of the user-descriptive flexfield.
Attribute15	Segment of the user-descriptive flexfield.
Attribute2	Segment of the user-descriptive flexfield.
Attribute3	Segment of the user-descriptive flexfield.
Attribute4	Segment of the user-descriptive flexfield.
Attribute5	Segment of the user-descriptive flexfield.
Attribute6	Segment of the user-descriptive flexfield.
Attribute7	Segment of the user-descriptive flexfield.
Attribute8	Segment of the user-descriptive flexfield.
Attribute9	Segment of the user-descriptive flexfield.
AttributeCategory	Structure definition of the user descriptive flexfield.
AttributeDate1	Segment of the user-descriptive flexfield.
AttributeDate2	Segment of the user-descriptive flexfield.
AttributeDate3	Segment of the user-descriptive flexfield.
AttributeDate4	Segment of the user-descriptive flexfield.
AttributeDate5	Segment of the user-descriptive flexfield.
AttributeNumber1	Segment of the user-descriptive flexfield.
AttributeNumber10	Segment of the user-descriptive flexfield.
AttributeNumber2	Segment of the user-descriptive flexfield.
AttributeNumber3	Segment of the user-descriptive flexfield.
AttributeNumber4	Segment of the user-descriptive flexfield.
AttributeNumber5	Segment of the user-descriptive flexfield.
AttributeNumber6	Segment of the user-descriptive flexfield.
AttributeNumber7	Segment of the user-descriptive flexfield.
AttributeNumber8	Segment of the user-descriptive flexfield.
AttributeNumber9	Segment of the user-descriptive flexfield.
AttributeTimestamp1	Segment of the user-descriptive flexfield.
AttributeTimestamp2	Segment of the user-descriptive flexfield.
AttributeTimestamp3	Segment of the user-descriptive flexfield.
AttributeTimestamp4	Segment of the user-descriptive flexfield.
AttributeTimestamp5	Segment of the user-descriptive flexfield.
AutoDelAllocFlag	Contains one of the following values: true or false. If true, then if the movement request cancels, then cancel the pick. If false, then if the movement request cancels, then don't cancel the pick. The default value is false.
AutoLotAlphaPrefix	Alphanumeric text to add as a prefix to the lot number when creating a lot number.
AutoSerialAlphaPrefix	Alphanumeric text to add as a prefix to the serial number when creating the serial number.
BusinessUnitId	Value that uniquely identifies the management business unit that the organization references. If the organization isn't an item organization and is an inventory organization, then this attribute is required.
CapturePickingException	Contains one of the following values: true or false. If true, then capture the exception for each deviation when picking. If false, then don't capture the exception for each deviation when picking. The default value is true.
ChildLotAlphaPrefix	Prefix to add to the child lot number when creating the child lot number.
ChildLotNumberLength	Value of the total length of the child lot number
ChildLotValidationFlag	Contains one of the following values: true or false. If true, then validate the format of the lot number. If false, then don't validate this format. The default value is false.
ChildLotZeroPaddingFlag	Contains one of the following values: true or false. If true, then pad the child lot number with zeros. If false, then don't pad the child lot number with zeros. The default value is false.
ContractMfgFlag	Contains one of the following values: true or false. If true, then the organization is a contract manufacturing plant, and it also supports warehouse operations. If false, then the organization isn't a contract manufacturing plant, but it does support warehouse operations. The default value is false.
CopyLotAttributeFlag	Contains one of the following values: true or false. If true, then the child lot inherits attributes from the parent. If false, then the child lot doesn't inherit attributes from the parent. The default value is false.
CreateLotUomConversion	Determines whether or not to convert the unit of measure that the lot references.
CreatedBy	User who created the row.
CreationDate	Date and time of the creation of the row.
CustomerAccountNumber	Account number associated with the customer when the warehouse is the destination inventory organization.
DefaultLocatorOrderValue	Default picking order assigned to each locator when creating a work order.
DefaultPickingRuleId	Value that identifies the default picking rule to use when selecting material.
DefaultSubinvOrderValue	Default picking order assigned to each subinventory when creating the work order.
DistributedOrganizationFlag	Contains one of the following values: true or false. If true, then use the organization to provide logistics services, such as warehousing or shipping. If false, then don't use the organization to provide logistics services. The default value is false.
EamEnabledFlag	Contains one of the following values: true or false. If true, then the organization performs maintenance, and it also supports warehouse operations. If false, then the organization doesn't perform maintenance, but it does support warehouse operations. The default value is false.
EnforceLocatorAlisUnqFlag	Contains one of the following values: true or false. If true, then make sure each locator alias is unique across the organization. If false, then don't make sure each locator alias is unique across the organization. The default value is false.
FaBookTypeCode	Value that uniquely identifies the fixed asset book to be associated with the assets defined in this organization.
FifoOrigRcptDateFlag	Contains one of the following values: true or false. If true, then use the original receipt date for on-hand quantity during the transaction. If false, then don't use the original receipt date for on-hand quantity during the transaction. The default value is false.
FillKillMoveOrderFlag	Contains one of the following values: true or false. If true, then allow the request line of a replenishment movement request that's only partially picked to be canceled. If false, then don't allow canceling. The default value is false.
FillKillTransferOrdersFlag	Contains one of the following values: true or false. If true, then cancel the remaining quantities on transfer order lines during pick release, pick confirm, or ship confirm. If false, then don't cancel. The default value is false.
GlobalAttribute1	Segment of the global descriptive flexfield.
GlobalAttribute10	Segment of the global descriptive flexfield.
GlobalAttribute11	Segment of the global descriptive flexfield.
GlobalAttribute12	Segment of the global descriptive flexfield.
GlobalAttribute13	Segment of the global descriptive flexfield.
GlobalAttribute14	Segment of the global descriptive flexfield.
GlobalAttribute15	Segment of the global descriptive flexfield.
GlobalAttribute16	Segment of the global descriptive flexfield.
GlobalAttribute17	Segment of the global descriptive flexfield.
GlobalAttribute18	Segment of the global descriptive flexfield.
GlobalAttribute19	Segment of the global descriptive flexfield.
GlobalAttribute2	Segment of the global descriptive flexfield.
GlobalAttribute20	Segment of the global descriptive flexfield.
GlobalAttribute3	Segment of the global descriptive flexfield.
GlobalAttribute4	Segment of the global descriptive flexfield.
GlobalAttribute5	Segment of the global descriptive flexfield.
GlobalAttribute6	Segment of the global descriptive flexfield.
GlobalAttribute7	Segment of the global descriptive flexfield.
GlobalAttribute8	Segment of the global descriptive flexfield.
GlobalAttribute9	Segment of the global descriptive flexfield.
GlobalAttributeCategory	Structure definition of the global descriptive flexfield.
IntegratedSystemCode	Specifies the integration relationship for the organization that manages material. The default is null. Valid values include Warehouse Management System, Third Party Logistics, or Coexistence Integration.
InternalCustomerFlag	Contains one of the following values: true or false. If true, then the organization is a destination inventory organization, and it has an associated customer and account number. If false, then the organization isn't a destination organization. The default value is false.
InventoryFlag	Contains one of the following values: true or false. If true, then the object is an inventory organization. An inventory application can use the organization. If false, then the object is an item organization. An inventory application can't use the organization. This attribute doesn't have a default value. This attribute must be supplied when creating an organization.
ItemDefinitionOrgId	Value that uniquely identifies the definition organization. The application uses this attribute only when the item grouping code indicates that the organization is a reference organization, which requires that the definition get all item attribute values from another organization.
ItemGroupingCode	Value that specifies how the application assigns items to the organization. Definition organizations specify their attributes for every item assigned to the organization. Reference organizations specify another definition organization, which provides the definition of all attribute values for the items assigned to this reference organization.
JobDefinitionName	Name of the job that created or last updated the row.
JobDefinitionPackage	Package name of the job that created or last updated the row.
Language	Indicates the code of the language into which the contents of the translatable columns are translated.
LastUpdateDate	Date and time of the last update of the row.
LastUpdateLogin	Session login associated to the user who last updated the row.
LastUpdatedBy	User who last updated the row.
LegalEntityId	Value that uniquely identifies the legal entity that the organization references. If the organization isn't an item organization and is an inventory organization, then this attribute is required.
LotNumberGeneration	Control level to use when creating each lot number for the organization.
LotNumberLength	Value of the total length of the lot number.
LotNumberUniqueness	Control level to use that ensures each lot number is unique when creating the lot number.
LotNumberZeroPadding	Contains one of the following values: true or false. If true, then pad the lot number with zeros. If false, then don't pad the lot number with zeros. The default value is false.
LpnPrefix	Prefix to add to the string when creating the packing unit string.
LpnStartingNumber	Smallest number to use as the packing unit number when creating the packing unit.
LpnSuffix	Suffix to add to the string when creating the packing unit string.
MasterOrganizationId	Value that identifies the parent organization or the master organization. This attribute is required.
MfgPlantFlag	Contains one of the following values: true or false. If true, then the organization is a manufacturing plant, and it also supports warehouse operations. If false, then the organization isn't a manufacturing plant but it does support warehouse operations. The default value is false.
MoPickConfirmRequired	Contains one of the following values: true or false. If true, then inventory management requires that you manually confirm each pick. If false, then inventory management doesn't require you to manually confirm each pick. The default value is false.
NegativeInvReceiptCode	Contains one of the following values: true or false. If true, then the organization allows negative balances in inventory. If false, then the organization doesn't allow negative balances in inventory. The default value is true.
ObjectVersionNumber	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
OrganizationCode	User-supplied short code that uniquely identifies the organization. This attribute is required.
OrganizationId	Value that uniquely identifies the item or inventory organization. It's a primary key that the application generates when it creates an item or inventory organization.
OvpkTransferOrdersEnabled	Contains one of the following values: true or false. If true, then inventory management lets you overpick the movement request. If false, then inventory management doesn't let you overpick the movement request. The default value is false.
ParentChildGenerationFlag	Control level to use when creating each child lot number for the organization.
PartyId	Value that identifies the customer when the warehouse is the destination inventory organization.
PickQtyDefaultReasonId	Reason applied for picking quantity exceptions, by default. This attribute is optional.
PickSlipBatchSize	Number of movement request lines that inventory management processes together when it allocates material.
PreFillPickedQty	Contains one of the following values: true or false. If true, then populate each picked quantity when confirming the pick slip. If false, then don't populate each picked quantity when confirming the pick slip. The default value is false.
ProfitCenterBuId	Value that uniquely identifies the business unit that operates as a profit center. The organization references this business unit.
ProjectReferenceEnabled	Contains one of the following values: true or false. If true, then Oracle Project Portfolio Management Cloud integration is enabled on this inventory organization and materials management transactions and manufacturing transactions can gather project details. If false, then project tracking isn't enabled on the organization. The default value is false.
PurchasingByRevision	Contains one of the following values: true or false. If true, then the purchase order or the requisition must include the revision when restocking. If false, then the purchase order or the requisition can include the revision as an option when restocking. The default value is false.
ReplnshMoveOrderGrouping	Threshold to use when grouping movement request lines so that inventory management can replenish inventory.
RequestId	Request ID of the job that created or last updated the row.
RoundReorderQtyFlag	Contains one of the following values: true or false. If true, then round up the reorder quantity to minimize or maximize planning. If false, then don't round up the reorder quantity to minimize or maximize planning. The default value is false.
ScheduleId	Value that uniquely identifies the work day calendar for the organization. This attribute is required.
SerialNumberGeneration	Control level to use when creating each serial number for the organization.
SerialNumberType	Control level to use that ensures each serial number is unique when creating the serial number.
SourceOrganizationId	Value that uniquely identifies the replenishment organization if the source type is Organization.
SourceSubinventory	Value of the replenishment subinventory if the source type is Organization.
SourceType	Source type to use when replenishing an item.
SpecialHndlngOvrpkFlag	Contains one of the following values: true or false. If true, then the warehouse supports overpicking and staging to accommodate material movements requiring special handling. If false, the warehouse won't support special handling. The default value is false.
StartAutoSerialNumber	Smallest number to use as the serial number when creating a serial number.
StartingRevision	Starting revision to use for the new item, by default.
StockLocatorControlCode	Default locator control for subinventories, such as predefined, dynamic, or none.
SupplierId	Value that uniquely identifies the supplier that the contract manufacturing organization references. If ContractManufacturingFlag is true, then SupplierId is required.
SupplierSiteId	Value that uniquely identifies the supplier site that the contract manufacturing organization references. If ContractManufacturingFlag is true, then SupplierId is required.
TimezoneCode	Time zone that the organization uses.
TimezoneId	Value that uniquely identifies the time zone that the organization uses.
TotalLpnLength	Value of the total length of the packing unit string.
TrackCountryOfOriginFlag	Contains one of the following values: true or false. If true, then tracking by country of origin is enabled on this inventory organization and materials management transactions can gather these details. If false, then tracking by country of origin isn't enabled on the organization. The default value is false.
Ucc128SuffixFlag	Contains one of the following values: true or false. If true, then enable GS1-128. If false, then don't enable GS1-128. The default value is false. If you enable GS1-128, then the work order uses the international barcode standard. This standard uses the Code 128 barcode specification to identify data and data formats.
UseCurItemCostFlag	Contains one of the following values: true or false. If true, then the warehouse will default to use the current item cost in the Create Miscellaneous Transaction task. If false, the warehouse will default to not use the current item cost. The default value is false.