Full expand

Full collapse

OrganizationConfiguration

Jump to

• Fields
• Reference Objects
• Business Views
• Other Properties

The organization configuration defines the high-level input values for a facility, such as a location, time zone, management business unit, and primary ledger. The configuration also specifies the use of the facility in SCM applications, such as indicating if it's used for manufacturing or integrated to other Oracle Fusion Cloud products. The configuration also specifies default values used in Oracle Fusion Cloud Inventory Management and Oracle Product Hub. For example, whether the warehouse accepts substitute items or supports inventory tracking by financial projects.

Label, Plural Label

Organization Configuration, Organization Configurations

Qualified Label, Qualified Plural Label

Organization Configuration, Organization Configurations

Module

oraScmCoreOrganization

Keys

• $primary: id

• organizationCodeAltKey: organizationCode (default)

Expand all

Collapse all

Fields

* Field can't be null

• allowDifferentLotStatusCode (enumeration: AllowDifferentLotStatusCode)

  Determines whether or not the lot status can change when transferring material that the lot controls.

  Label

  Allow Different Lot Status Code

  Type

  • Module: oraScmCoreOrganization

  • Enumeration Type: AllowDifferentLotStatusCode

  Valid Values

  • 1
  • 2
  • 3
• allowNegativeBalancesFlag (boolean)

  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.

  Label

  Allow Negative Balances Flag

• allowNegativeOnhandTransactionsFlag (boolean)

  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.

  Label

  Allow Negative On-hand Transactions Flag

• allowSubstituteItemsFlag (boolean)

  Contains one of the following values: true or false. If true, then the default choice on transactional lines to accept a substitution of the item is true. If false, then the default choice on transactional lines is to not accept a substitute item. The default value is false.

  Label

  Allow Substitute Items Flag

• automaticallyCreateLotUOMConversionCode (enumeration: AutomaticallyCreateLotUOMConversionCode)

  Determines whether or not to convert the unit of measure that the lot references.

  Label

  Automatically Create Lot UOM Conversion Code

  Type

  • Module: oraScmCoreOrganization

  • Enumeration Type: AutomaticallyCreateLotUOMConversionCode

  Valid Values

  • 1
  • 2
  • 3
• automaticallyDeleteAllocationsFlag (boolean)

  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.

  Label

  Automatically Delete Allocations Flag

• capturePickingExceptionsFlag (boolean)

  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.

  Label

  Capture Picking Exceptions Flag

• childLotControlFormatValidationFlag (boolean)

  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.

  Label

  Child Lot Control Format Validation Flag

• childLotControlGenerationCode (enumeration: ChildLotControlGenerationCode)

  Control level to use when creating each child lot number for the organization.

  Label

  Child Lot Control Generation Code

  Type

  • Module: oraScmCoreOrganization

  • Enumeration Type: ChildLotControlGenerationCode

  Valid Values

  • C
  • L
• childLotControlPrefix (string)

  Prefix to add to the child lot number when creating the child lot number.

  Label

  Child Lot Control Prefix

• childLotControlZeroPadSuffixFlag (boolean)

  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.

  Label

  Child Lot Control Zero Pad Suffix Flag

• childLotTotalLength (int32)

  Value of the total length of the child lot number

  Label

  Child Lot Total Length

• contractManufacturingFlag (boolean)

  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.

  Label

  Contract Manufacturing Plant Flag

  Properties

  • searchable
• copyLotAttributesFlag (boolean)

  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.

  Label

  Copy Lot Attributes Flag

• createdBy (string)*

  The user who created the record.

  Label

  Created By

  Properties

  • not readable
  • not nullable
• defaultLocatorOrder (big-decimal)

  Default picking order assigned to each locator when creating a work order.

  Label

  Default Locator Order

• defaultSubinventoryOrder (big-decimal)

  Default picking order assigned to each subinventory when creating the work order.

  Label

  Default Subinventory Order

• distributedOrganizationFlag (boolean)

  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.

  Label

  Distributed Organization Flag

• enableTrackingByCountryOfOriginFlag (boolean)

  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.

  Label

  Enable Tracking by Country of Origin Flag

• enableTrackingByProjectFlag (boolean)

  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.

  Label

  Enable Tracking by Project Flag

  Properties

  • searchable
• fillKillMoveOrderFlag (boolean)

  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.

  Label

  Automatically Delete Picks When Movement Requests Are Canceled Flag

• fillKillSalesOrderFlag (boolean)

  Contains one of the following values: true or false. If true, then automatically cancel the remaining quantities on sales order backorder lines during pick release, pick confirm, or ship confirm. If false, then don't cancel. The default value is false.

  Label

  Automatically cancel sales order backorders

• fillKillTransferOrderFlag (boolean)

  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.

  Label

  Automatically Cancel Transfer Order Backorders Flag

• gs1128Flag (boolean)

  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.

  Label

  GS1-128 Flag

• id (int64)*

  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.

  Label

  ID

  Properties

  • searchable
  • not nullable
• integrateWithWmsFlag (boolean)

  Contains one of the following values: true or false. If true, then the plant is integrated to WMS for manufacturing or maintenance. If false, then the plant isn't integrated. The default value is false.

  Label

  Integrate with WMS Flag

• integratedSystemTypeCode (enumeration: IntegratedSystemTypeCode)

  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.

  Label

  Integrated System Type Code

  Type

  • Module: oraScmCoreOrganization

  • Enumeration Type: IntegratedSystemTypeCode

  Valid Values

  • ORA_RCS_IS_3PL
  • ORA_RCS_IS_INVMGMT
  • ORA_RCS_IS_WMS
• internalCustomerFlag (boolean)

  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.

  Label

  Internal Customer Flag

• inventoryFlag (boolean)*

  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.

  Label

  Inventory Flag

  Properties

  • searchable
  • not nullable
• itemGroupingCode (enumeration: 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.

  Label

  Item Grouping Code

  Type

  • Module: oraScmCoreOrganization

  • Enumeration Type: ItemGroupingCode

  Properties

  • searchable

  Valid Values

  • ORA_RCS_IGB_DFTN
  • ORA_RCS_IGB_RFRC
• kanbanCardPrefix (string)

  Value that defines the prefix to use for generated Kanban cards. The default value is the organization code followed by a dash as the delimiter.

  Label

  Card Prefix

• kanbanCardStartingNumber (int64)

  Value that defines the first number to use for generated Kanban cards. The default value is null and indicates that Kanban isn't in use for the organization.

  Label

  Card Starting Number

• kanbanDocumentSequenceCategoryCode (string)

  Value that identifies the category code for the document sequence.

  Label

  Kanban Document Sequence Category Code

• locatorControlCode (enumeration: LocatorControlCode)

  Default locator control for subinventories, such as predefined, dynamic, or none.

  Label

  Locator Control Code

  Type

  • Module: oraScmCoreOrganization

  • Enumeration Type: LocatorControlCode

  Valid Values

  • 1
  • 2
  • 3
  • 4
• lotControlGenerationCode (enumeration: LotControlGenerationCode)

  Control level to use when creating each lot number for the organization.

  Label

  Lot Control Generation Code

  Type

  • Module: oraScmCoreOrganization

  • Enumeration Type: LotControlGenerationCode

  Valid Values

  • 1
  • 2
  • 3
• lotControlUniquenessCode (enumeration: LotControlUniquenessCode)

  Control level to use that ensures each lot number is unique when creating the lot number.

  Label

  Lot Control Uniqueness Code

  Type

  • Module: oraScmCoreOrganization

  • Enumeration Type: LotControlUniquenessCode

  Valid Values

  • 1
  • 2
• lotGenerationPrefix (string)

  Alphanumeric text to add as a prefix to the lot number when creating a lot number.

  Label

  Lot Generation Prefix

• lotNumberZeroPadSuffixFlag (boolean)

  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.

  Label

  Lot Number Zero Pad Suffix Flag

• lotTotalLength (int32)

  Value of the total length of the lot number.

  Label

  Lot Total Length

• maintenanceEnabledFlag (boolean)

  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.

  Label

  Maintenance Enabled Flag

  Properties

  • searchable
• maintenanceTechnicianWorkbenchEnabledFlag (boolean)

  Contains one of the following values: true or false. If true, the organization appears in the list of values for the organization picker in the maintenance technician workbench, provided the user also has data security access to the organization. If false, the organization won't appear in the organization picker as a choice. The default value is false.

  Label

  Allow maintenance technicians to access work orders in this organization

  Properties

  • searchable
• manufacturingPlantFlag (boolean)

  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.

  Label

  Manufacturing Plant Flag

  Properties

  • searchable
• organizationCode (string)

  User-supplied short code that uniquely identifies the organization. This attribute is required.

  Label

  Organization Code

  Properties

  • searchable
  • sortable
• overpickForSpecialHandlingFlag (boolean)

  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.

  Label

  Overpick for Special Handling Flag

• overpickTransferOrdersFlag (boolean)

  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.

  Label

  Overpick Transfer Orders Flag

• overpickingForWorkOrdersFlag (boolean)
• packingUnitPrefix (string)

  Prefix to add to the string when creating the packing unit string.

  Label

  Packing Unit Prefix

• packingUnitStartingNumber (big-decimal)

  Smallest number to use as the packing unit number when creating the packing unit.

  Label

  Packing Unit Starting Number

• packingUnitSuffix (string)

  Suffix to add to the string when creating the packing unit string.

  Label

  Packing Unit Suffix

• packingUnitTotalLength (int32)

  Value of the total length of the packing unit string.

  Label

  Packing Unit Total Length

• pickConfirmationRequiredFlag (boolean)

  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.

  Label

  Pick Confirmation Required Flag

• pickSlipBatchSize (int54)

  Number of movement request lines that inventory management processes together when it allocates material.

  Label

  Pick Slip Batch Size

• preFillPickedQuantityFlag (boolean)

  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.

  Label

  Prefill Picked Quantity Flag

• purchasingByRevisionFlag (boolean)

  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.

  Label

  Purchasing by Revision Flag

• replenishmentMovementRequestGroupingCode (enumeration: ReplenishmentMovementRequestGroupingCode)

  Threshold to use when grouping movement request lines so that inventory management can replenish inventory.

  Label

  Replenishment Movement Request Grouping Code

  Type

  • Module: oraScmCoreOrganization

  • Enumeration Type: ReplenishmentMovementRequestGroupingCode

  Valid Values

  • 1
  • 2
• requireBarcodeValidationFlag (boolean)
• roundReorderQuantityFlag (boolean)

  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.

  Label

  Round Reorder Quantity Flag

• serialNumberGenerationCode (enumeration: SerialNumberGenerationCode)

  Control level to use when creating each serial number for the organization.

  Label

  Serial Number Generation Code

  Type

  • Module: oraScmCoreOrganization

  • Enumeration Type: SerialNumberGenerationCode

  Valid Values

  • 1
  • 2
  • 3
• serialNumberGenerationPrefix (string)

  Alphanumeric text to add as a prefix to the serial number when creating the serial number.

  Label

  Serial Number Generation Prefix

• serialNumberGenerationUniquenessCode (enumeration: SerialNumberGenerationUniquenessCode)

  Control level to use that ensures each serial number is unique when creating the serial number.

  Label

  Serial Number Generation Uniqueness Code

  Type

  • Module: oraScmCoreOrganization

  • Enumeration Type: SerialNumberGenerationUniquenessCode

  Valid Values

  • 1
  • 2
  • 3
  • 4
• sourceTypeCode (enumeration: SourceTypeCode)

  Source type to use when replenishing an item.

  Label

  Source Type Code

  Type

  • Module: oraScmCoreOrganization

  • Enumeration Type: SourceTypeCode

  Valid Values

  • 1
  • 2
• startingRevision (string)

  Starting revision to use for the new item, by default.

  Label

  Starting Revision

• startingSerialNumber (string)

  Smallest number to use as the serial number when creating a serial number.

  Label

  Starting Serial Number

• systemSelectsSerialNumbersFlag (boolean)

  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.

  Label

  System Selects Serial Numbers Flag

• timeCreated (date-time)*

  The date and time when the record was created.

  Label

  Creation Date

  Properties

  • not readable
  • not nullable
• timeUpdated (date-time)*

  The date and time when the record was last updated.

  Label

  Last Updated Date

  Properties

  • searchable
  • not readable
  • not nullable
• updatedBy (string)*

  The user who last updated the record.

  Label

  Last Updated By

  Properties

  • not readable
  • not nullable
• useCurrentItemCostFlag (boolean)

  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.

  Label

  Use Current Item Cost Flag

• useOriginalReceiptDateFlag (boolean)

  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.

  Label

  Use Original Receipt Date Flag

Expand all

Collapse all

Reference Objects

• customerAccount (object)

  Object reference to the associated account when the warehouse is the destination inventory organization.

  Label

  Customer Account

  Cardinality	Target Object
  One to One	Module: oraErpCoreCustomerAccountSetup Business Object: CustomerAccount

  Additional Mapping Details

  Field in Current Object	Field in Target Object
  customerAccountNumber	accountNumber

• defaultPickingRule (object)

  Object reference to the associated default picking rule.

  Label

  Default Picking Rule

  Cardinality	Target Object
  One to One	Module: oraScmCoreInventorySetup Business Object: PickingRule

  Additional Mapping Details

  Field in Current Object	Field in Target Object
  defaultPickingRuleId	id

• expiredLotQuarantineLocator (object)

  Reference to the associated locator for expired lot quarantine operations within the supply chain organization.

  Label

  Expired Lot Quarantine Locator

  Cardinality	Target Object
  One to One	Module: oraScmCoreInventorySetup Business Object: Locator

  Additional Mapping Details

  Field in Current Object	Field in Target Object
  expiredLotQuarantineLocatorId	id

• expiredLotQuarantineSubinventory (object)

  Reference to the associated subinventory for expired lot quarantine operations within the supply chain organization.

  Label

  Expired Lot Quarantine Subinventory

  Cardinality	Target Object
  One to One	Module: oraScmCoreInventorySetup Business Object: Subinventory

  Additional Mapping Details

  Field in Current Object	Field in Target Object
  expiredLotQuarantineSubinventoryName	name
  id	organizationId

• fixedAssetBookType (object)

  Cardinality	Target Object
  One to One	Module: oraScmCoreCostMgmtSetup Business Object: CostBook

  Additional Mapping Details

  Field in Current Object	Field in Target Object
  fixedAssetBookTypeCode	code

• internalCustomer (object)

  Object reference to the associated customer when the warehouse is the destination inventory organization.

  Label

  Internal Customer

  Cardinality	Target Object
  One to One	Module: oraErpCoreCustomerAccountSetup Business Object: Customer

  Additional Mapping Details

  Field in Current Object	Field in Target Object
  internalCustomerId	id

• itemDefinitionOrganization (object)

  Object reference to the associated item definition organization of the supply chain organization.

  Label

  Item Definition Organization

  Cardinality	Target Object
  One to One	Module: oraScmCoreOrganization Business Object: Organization

  Additional Mapping Details

  Field in Current Object	Field in Target Object
  itemDefinitionOrganizationId	id

• itemMasterOrganization (object)

  Object reference to the associated item master organization of the supply chain organization.

  Label

  Item Master Organization

  Cardinality	Target Object
  One to One	Module: oraScmCoreOrganization Business Object: Organization

  Additional Mapping Details

  Field in Current Object	Field in Target Object
  itemMasterOrganizationId	id

• kanbanDocumentSequence (object)

  Cardinality	Target Object
  One to One	Module: oraCommonAppsInfraObjects Business Object: DocumentSequence

  Additional Mapping Details

  Field in Current Object	Field in Target Object
  kanbanDocumentSequenceId	docSequenceId

• legalEntity (object)

  Object reference to the associated legal entity of the supply chain organization.

  Label

  Legal Entity

  Cardinality	Target Object
  One to One	Module: oraErpCoreStructure Business Object: LegalEntity

  Additional Mapping Details

  Field in Current Object	Field in Target Object
  legalEntityId	legalEntityId

• managementBusinessUnit (object)

  Object reference to the associated management business unit of the supply chain organization.

  Label

  Management Business Unit

  Cardinality	Target Object
  One to One	Module: oraErpCoreStructure Business Object: BusinessUnit

  Additional Mapping Details

  Field in Current Object	Field in Target Object
  managementBusinessUnitId	id

• pickQuantityDefaultReason (object)

  Object reference to the associated default picking rule for quantity exceptions.

  Label

  Quantity Exception Reason

  Cardinality	Target Object
  One to One	Module: oraScmCoreInventorySetup Business Object: TransactionReason

  Additional Mapping Details

  Field in Current Object	Field in Target Object
  pickQuantityDefaultReasonId	id

• profitCenterBusinessUnit (object)

  Object reference to the associated profit center business unit of the supply chain organization.

  Label

  Profit Center Business Unit

  Cardinality	Target Object
  One to One	Module: oraErpCoreStructure Business Object: BusinessUnit

  Additional Mapping Details

  Field in Current Object	Field in Target Object
  profitCenterBusinessUnitId	id

• schedule (object)

  Object reference to the associated schedule of the supply chain organization.

  Label

  Schedule

  Cardinality	Target Object
  One to One	Module: oraScmCoreSchedule Business Object: Schedule

  Additional Mapping Details

  Field in Current Object	Field in Target Object
  scheduleId	id

• sourceOrganization (object)

  Object reference to the associated replenishment organization.

  Label

  Source Organization

  Cardinality	Target Object
  One to One	Module: oraScmCoreOrganization Business Object: Organization

  Additional Mapping Details

  Field in Current Object	Field in Target Object
  sourceOrganizationId	id

• sourceSubinventory (object)

  Object reference to the associated replenishment subinventory.

  Label

  Source Subinventory

  Cardinality	Target Object
  One to One	Module: oraScmCoreInventorySetup Business Object: Subinventory

  Additional Mapping Details

  Field in Current Object	Field in Target Object
  sourceOrganizationId	organizationId
  sourceSubinventoryName	name

• supplier (object)

  Object reference to the associated supplier for the contract manufacturing organization.

  Label

  Supplier

  Cardinality	Target Object
  One to One	Module: oraProcurementCoreSuppliers Business Object: Supplier

  Additional Mapping Details

  Field in Current Object	Field in Target Object
  supplierId	supplierId

• supplierSite (object)

  Object reference to the associated supplier site for the contract manufacturing organization.

  Label

  Supplier Site

  Cardinality	Target Object
  One to One	Module: oraProcurementCoreSuppliers Business Object: SupplierSite

  Additional Mapping Details

  Field in Current Object	Field in Target Object
  supplierSiteId	id

• timezone (object)

  Object reference to the associated time zone of the supply chain organization.

  Label

  Time Zone

  Cardinality	Target Object
  One to One	Module: oraCommonAppsInfraObjects Business Object: Timezone

  Additional Mapping Details

  Field in Current Object	Field in Target Object
  timezoneCode	timezoneCode

Expand all

Collapse all

Business Views

** Available for extracting data

• default

  Data Source

  RDBMS

  Expand all

  Collapse all

  Fields

  • id (int64)

    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.

    Label

    ID

    Properties

    • searchable
    • not nullable
  • organizationCode (string)

    User-supplied short code that uniquely identifies the organization. This attribute is required.

    Label

    Organization Code

    Properties

    • searchable
    • sortable
• organizationParametersExtract**

  Gets the organization parameters used for reporting. This view exposes all fields and object references the organization provides for supply chain application use.

  Label

  Organization Configurations

  Data Source

  Read-optimized data store

  Expand all

  Collapse all

  Fields

  • allowDifferentLotStatusCode (enumeration: AllowDifferentLotStatusCode)

    Determines whether or not the lot status can change when transferring material that the lot controls.

    Label

    Allow Different Lot Status Code

    Type

    • Module: oraScmCoreOrganization

    • Enumeration Type: AllowDifferentLotStatusCode

    Valid Values

    • 1
    • 2
    • 3
  • allowNegativeBalancesFlag (boolean)

    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.

    Label

    Allow Negative Balances Flag

  • allowNegativeOnhandTransactionsFlag (boolean)

    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.

    Label

    Allow Negative On-hand Transactions Flag

  • allowSubstituteItemsFlag (boolean)

    Contains one of the following values: true or false. If true, then the default choice on transactional lines to accept a substitution of the item is true. If false, then the default choice on transactional lines is to not accept a substitute item. The default value is false.

    Label

    Allow Substitute Items Flag

  • automaticallyCreateLotUOMConversionCode (enumeration: AutomaticallyCreateLotUOMConversionCode)

    Determines whether or not to convert the unit of measure that the lot references.

    Label

    Automatically Create Lot UOM Conversion Code

    Type

    • Module: oraScmCoreOrganization

    • Enumeration Type: AutomaticallyCreateLotUOMConversionCode

    Valid Values

    • 1
    • 2
    • 3
  • automaticallyDeleteAllocationsFlag (boolean)

    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.

    Label

    Automatically Delete Allocations Flag

  • capturePickingExceptionsFlag (boolean)

    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.

    Label

    Capture Picking Exceptions Flag

  • childLotControlFormatValidationFlag (boolean)

    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.

    Label

    Child Lot Control Format Validation Flag

  • childLotControlGenerationCode (enumeration: ChildLotControlGenerationCode)

    Control level to use when creating each child lot number for the organization.

    Label

    Child Lot Control Generation Code

    Type

    • Module: oraScmCoreOrganization

    • Enumeration Type: ChildLotControlGenerationCode

    Valid Values

    • C
    • L
  • childLotControlPrefix (string)

    Prefix to add to the child lot number when creating the child lot number.

    Label

    Child Lot Control Prefix

  • childLotControlZeroPadSuffixFlag (boolean)

    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.

    Label

    Child Lot Control Zero Pad Suffix Flag

  • childLotTotalLength (int32)

    Value of the total length of the child lot number

    Label

    Child Lot Total Length

  • contractManufacturingFlag (boolean)

    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.

    Label

    Contract Manufacturing Plant Flag

    Properties

    • searchable
  • copyLotAttributesFlag (boolean)

    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.

    Label

    Copy Lot Attributes Flag

  • createdBy (string)

    The user who created the record.

    Label

    Created By

    Properties

    • not readable
    • not nullable
  • defaultLocatorOrder (big-decimal)

    Default picking order assigned to each locator when creating a work order.

    Label

    Default Locator Order

  • defaultSubinventoryOrder (big-decimal)

    Default picking order assigned to each subinventory when creating the work order.

    Label

    Default Subinventory Order

  • distributedOrganizationFlag (boolean)

    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.

    Label

    Distributed Organization Flag

  • enableTrackingByCountryOfOriginFlag (boolean)

    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.

    Label

    Enable Tracking by Country of Origin Flag

  • enableTrackingByProjectFlag (boolean)

    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.

    Label

    Enable Tracking by Project Flag

    Properties

    • searchable
  • fillKillMoveOrderFlag (boolean)

    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.

    Label

    Automatically Delete Picks When Movement Requests Are Canceled Flag

  • fillKillSalesOrderFlag (boolean)

    Contains one of the following values: true or false. If true, then automatically cancel the remaining quantities on sales order backorder lines during pick release, pick confirm, or ship confirm. If false, then don't cancel. The default value is false.

    Label

    Automatically cancel sales order backorders

  • fillKillTransferOrderFlag (boolean)

    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.

    Label

    Automatically Cancel Transfer Order Backorders Flag

  • gs1128Flag (boolean)

    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.

    Label

    GS1-128 Flag

  • id (int64)

    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.

    Label

    ID

    Properties

    • searchable
    • not nullable
  • integrateWithWmsFlag (boolean)

    Contains one of the following values: true or false. If true, then the plant is integrated to WMS for manufacturing or maintenance. If false, then the plant isn't integrated. The default value is false.

    Label

    Integrate with WMS Flag

  • integratedSystemTypeCode (enumeration: IntegratedSystemTypeCode)

    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.

    Label

    Integrated System Type Code

    Type

    • Module: oraScmCoreOrganization

    • Enumeration Type: IntegratedSystemTypeCode

    Valid Values

    • ORA_RCS_IS_3PL
    • ORA_RCS_IS_INVMGMT
    • ORA_RCS_IS_WMS
  • internalCustomerFlag (boolean)

    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.

    Label

    Internal Customer Flag

  • inventoryFlag (boolean)

    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.

    Label

    Inventory Flag

    Properties

    • searchable
    • not nullable
  • itemGroupingCode (enumeration: 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.

    Label

    Item Grouping Code

    Type

    • Module: oraScmCoreOrganization

    • Enumeration Type: ItemGroupingCode

    Properties

    • searchable

    Valid Values

    • ORA_RCS_IGB_DFTN
    • ORA_RCS_IGB_RFRC
  • kanbanCardPrefix (string)

    Value that defines the prefix to use for generated Kanban cards. The default value is the organization code followed by a dash as the delimiter.

    Label

    Card Prefix

  • kanbanCardStartingNumber (int64)

    Value that defines the first number to use for generated Kanban cards. The default value is null and indicates that Kanban isn't in use for the organization.

    Label

    Card Starting Number

  • kanbanDocumentSequenceCategoryCode (string)

    Value that identifies the category code for the document sequence.

    Label

    Kanban Document Sequence Category Code

  • locatorControlCode (enumeration: LocatorControlCode)

    Default locator control for subinventories, such as predefined, dynamic, or none.

    Label

    Locator Control Code

    Type

    • Module: oraScmCoreOrganization

    • Enumeration Type: LocatorControlCode

    Valid Values

    • 1
    • 2
    • 3
    • 4
  • lotControlGenerationCode (enumeration: LotControlGenerationCode)

    Control level to use when creating each lot number for the organization.

    Label

    Lot Control Generation Code

    Type

    • Module: oraScmCoreOrganization

    • Enumeration Type: LotControlGenerationCode

    Valid Values

    • 1
    • 2
    • 3
  • lotControlUniquenessCode (enumeration: LotControlUniquenessCode)

    Control level to use that ensures each lot number is unique when creating the lot number.

    Label

    Lot Control Uniqueness Code

    Type

    • Module: oraScmCoreOrganization

    • Enumeration Type: LotControlUniquenessCode

    Valid Values

    • 1
    • 2
  • lotGenerationPrefix (string)

    Alphanumeric text to add as a prefix to the lot number when creating a lot number.

    Label

    Lot Generation Prefix

  • lotNumberZeroPadSuffixFlag (boolean)

    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.

    Label

    Lot Number Zero Pad Suffix Flag

  • lotTotalLength (int32)

    Value of the total length of the lot number.

    Label

    Lot Total Length

  • maintenanceEnabledFlag (boolean)

    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.

    Label

    Maintenance Enabled Flag

    Properties

    • searchable
  • maintenanceTechnicianWorkbenchEnabledFlag (boolean)

    Contains one of the following values: true or false. If true, the organization appears in the list of values for the organization picker in the maintenance technician workbench, provided the user also has data security access to the organization. If false, the organization won't appear in the organization picker as a choice. The default value is false.

    Label

    Allow maintenance technicians to access work orders in this organization

    Properties

    • searchable
  • manufacturingPlantFlag (boolean)

    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.

    Label

    Manufacturing Plant Flag

    Properties

    • searchable
  • organizationCode (string)

    User-supplied short code that uniquely identifies the organization. This attribute is required.

    Label

    Organization Code

    Properties

    • searchable
    • sortable
  • overpickForSpecialHandlingFlag (boolean)

    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.

    Label

    Overpick for Special Handling Flag

  • overpickTransferOrdersFlag (boolean)

    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.

    Label

    Overpick Transfer Orders Flag

  • overpickingForWorkOrdersFlag (boolean)
  • packingUnitPrefix (string)

    Prefix to add to the string when creating the packing unit string.

    Label

    Packing Unit Prefix

  • packingUnitStartingNumber (big-decimal)

    Smallest number to use as the packing unit number when creating the packing unit.

    Label

    Packing Unit Starting Number

  • packingUnitSuffix (string)

    Suffix to add to the string when creating the packing unit string.

    Label

    Packing Unit Suffix

  • packingUnitTotalLength (int32)

    Value of the total length of the packing unit string.

    Label

    Packing Unit Total Length

  • pickConfirmationRequiredFlag (boolean)

    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.

    Label

    Pick Confirmation Required Flag

  • pickSlipBatchSize (int54)

    Number of movement request lines that inventory management processes together when it allocates material.

    Label

    Pick Slip Batch Size

  • preFillPickedQuantityFlag (boolean)

    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.

    Label

    Prefill Picked Quantity Flag

  • purchasingByRevisionFlag (boolean)

    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.

    Label

    Purchasing by Revision Flag

  • replenishmentMovementRequestGroupingCode (enumeration: ReplenishmentMovementRequestGroupingCode)

    Threshold to use when grouping movement request lines so that inventory management can replenish inventory.

    Label

    Replenishment Movement Request Grouping Code

    Type

    • Module: oraScmCoreOrganization

    • Enumeration Type: ReplenishmentMovementRequestGroupingCode

    Valid Values

    • 1
    • 2
  • requireBarcodeValidationFlag (boolean)
  • roundReorderQuantityFlag (boolean)

    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.

    Label

    Round Reorder Quantity Flag

  • serialNumberGenerationCode (enumeration: SerialNumberGenerationCode)

    Control level to use when creating each serial number for the organization.

    Label

    Serial Number Generation Code

    Type

    • Module: oraScmCoreOrganization

    • Enumeration Type: SerialNumberGenerationCode

    Valid Values

    • 1
    • 2
    • 3
  • serialNumberGenerationPrefix (string)

    Alphanumeric text to add as a prefix to the serial number when creating the serial number.

    Label

    Serial Number Generation Prefix

  • serialNumberGenerationUniquenessCode (enumeration: SerialNumberGenerationUniquenessCode)

    Control level to use that ensures each serial number is unique when creating the serial number.

    Label

    Serial Number Generation Uniqueness Code

    Type

    • Module: oraScmCoreOrganization

    • Enumeration Type: SerialNumberGenerationUniquenessCode

    Valid Values

    • 1
    • 2
    • 3
    • 4
  • sourceTypeCode (enumeration: SourceTypeCode)

    Source type to use when replenishing an item.

    Label

    Source Type Code

    Type

    • Module: oraScmCoreOrganization

    • Enumeration Type: SourceTypeCode

    Valid Values

    • 1
    • 2
  • startingRevision (string)

    Starting revision to use for the new item, by default.

    Label

    Starting Revision

  • startingSerialNumber (string)

    Smallest number to use as the serial number when creating a serial number.

    Label

    Starting Serial Number

  • systemSelectsSerialNumbersFlag (boolean)

    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.

    Label

    System Selects Serial Numbers Flag

  • timeCreated (date-time)

    The date and time when the record was created.

    Label

    Creation Date

    Properties

    • not readable
    • not nullable
  • timeUpdated (date-time)

    The date and time when the record was last updated.

    Label

    Last Updated Date

    Properties

    • searchable
    • not readable
    • not nullable
  • updatedBy (string)

    The user who last updated the record.

    Label

    Last Updated By

    Properties

    • not readable
    • not nullable
  • useCurrentItemCostFlag (boolean)

    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.

    Label

    Use Current Item Cost Flag

  • useOriginalReceiptDateFlag (boolean)

    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.

    Label

    Use Original Receipt Date Flag

  Expand all

  Collapse all

  Reference Object

  • customerAccount (CustomerAccount)

    Object reference to the associated account when the warehouse is the destination inventory organization.

    Business Object

    CustomerAccount

    Expand all

    Collapse all

    Fields

    • accountNumber (string)

      Customer account number.

      Label

      Account Number

      Properties

      • searchable
      • not nullable

  • defaultPickingRule (PickingRule)

    Object reference to the associated default picking rule.

    Business Object

    PickingRule

    Expand all

    Collapse all

    Fields

    • id (int64)

      Value that uniquely identifies the picking rule.

      Label

      ID

      Properties

      • searchable
      • sortable
      • not nullable

  • expiredLotQuarantineLocator (Locator)

    Reference to the associated locator for expired lot quarantine operations within the supply chain organization.

    Business Object

    Locator

    Expand all

    Collapse all

    Fields

    • id (int64)

      Identifier that uniquely identifies a locator in warehouse.

      Label

      ID

      Properties

      • searchable
      • sortable
      • not nullable

  • expiredLotQuarantineSubinventory (Subinventory)

    Reference to the associated subinventory for expired lot quarantine operations within the supply chain organization.

    Business Object

    Subinventory

    Expand all

    Collapse all

    Fields

    • name (string)

      Value that identifies the subinventory name.

      Label

      Name

      Properties

      • searchable
      • sortable
      • not nullable
    • organizationId (int64)

      Value that uniquely identifies the organization.

      Label

      Organization ID

      Properties

      • searchable
      • sortable
      • not nullable

  • fixedAssetBookType (CostBook)

    Business Object

    CostBook

    Expand all

    Collapse all

    Fields

    • code (string)

      Code that identifies the user-defined cost book. Cost books are associated with ledgers where accounting entries for inventory transactions are posted

      Label

      Cost Book Code

      Properties

      • searchable
      • sortable
      • not nullable

  • internalCustomer (Customer)

    Object reference to the associated customer when the warehouse is the destination inventory organization.

    Business Object

    Customer

    Expand all

    Collapse all

    Fields

    • id (int64)

      The unique identifier of the party.

      Label

      Party ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable
      • overridable

  • itemDefinitionOrganization (Organization)

    Object reference to the associated item definition organization of the supply chain organization.

    Business Object

    Organization

    Expand all

    Collapse all

    Fields

    • id (int64)

      Unique identifier of the organization.

      Label

      Organization ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable
      • overridable

  • itemMasterOrganization (Organization)

    Object reference to the associated item master organization of the supply chain organization.

    Business Object

    Organization

    Expand all

    Collapse all

    Fields

    • id (int64)

      Unique identifier of the organization.

      Label

      Organization ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable
      • overridable

  • kanbanDocumentSequence (DocumentSequence)

    Business Object

    DocumentSequence

    Expand all

    Collapse all

    Fields

    • docSequenceId (int64)

      The unique identifier of the document sequence.

      Label

      Document Sequence ID

      Properties

      • searchable
      • sortable
      • not nullable

  • legalEntity (LegalEntity)

    Object reference to the associated legal entity of the supply chain organization.

    Business Object

    LegalEntity

    Expand all

    Collapse all

    Fields

    • legalEntityId (int64)

      The unique identifier of the legal entity. This is the primary key of the Legal Entities view object.

      Label

      Legal Entity ID

      Properties

      • searchable
      • sortable
      • not nullable

  • managementBusinessUnit (BusinessUnit)

    Object reference to the associated management business unit of the supply chain organization.

    Business Object

    BusinessUnit

    Expand all

    Collapse all

    Fields

    • id (int64)

      The unique identifier of the business unit.

      Label

      Business Unit ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable
      • overridable

  • pickQuantityDefaultReason (TransactionReason)

    Object reference to the associated default picking rule for quantity exceptions.

    Business Object

    TransactionReason

    Expand all

    Collapse all

    Fields

    • id (int64)

      Value that uniquely identifies the transaction reason.

      Label

      ID

      Properties

      • searchable
      • sortable
      • not nullable

  • profitCenterBusinessUnit (BusinessUnit)

    Object reference to the associated profit center business unit of the supply chain organization.

    Business Object

    BusinessUnit

    Expand all

    Collapse all

    Fields

    • id (int64)

      The unique identifier of the business unit.

      Label

      Business Unit ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable
      • overridable

  • schedule (Schedule)

    Object reference to the associated schedule of the supply chain organization.

    Business Object

    Schedule

    Expand all

    Collapse all

    Fields

    • id (int64)

      Value that uniquely identifies the schedule. It's a primary key that the application generates when it creates a schedule. This attribute is required.

      Label

      ID

      Properties

      • creatable
      • searchable
      • sortable
      • not nullable

  • sourceSubinventory (Subinventory)

    Object reference to the associated replenishment subinventory.

    Business Object

    Subinventory

    Expand all

    Collapse all

    Fields

    • name (string)

      Value that identifies the subinventory name.

      Label

      Name

      Properties

      • searchable
      • sortable
      • not nullable
    • organizationId (int64)

      Value that uniquely identifies the organization.

      Label

      Organization ID

      Properties

      • searchable
      • sortable
      • not nullable

  • supplier (Supplier)

    Object reference to the associated supplier for the contract manufacturing organization.

    Business Object

    Supplier

    Expand all

    Collapse all

    Fields

    • supplierId (int64)

      Value that uniquely identifies the supplier.

      Label

      Supplier ID

      Properties

      • searchable
      • sortable
      • not nullable

  • supplierSite (SupplierSite)

    Object reference to the associated supplier site for the contract manufacturing organization.

    Business Object

    SupplierSite

    Expand all

    Collapse all

    Fields

    • id (int64)

      Value that uniquely identifies the supplier site.

      Label

      Supplier Site ID

      Properties

      • searchable
      • sortable
      • not nullable

  • timezone (Timezone)

    Object reference to the associated time zone of the supply chain organization.

    Business Object

    Timezone

    Expand all

    Collapse all

    Fields

    • timezoneCode (string)

      The unique code that identifies the time zone.

      Label

      Time Zone Code

      Properties

      • searchable
      • sortable
      • not nullable

Other Properties

Property	Value
Application Package Name	ora_scm_core_organization
Extensible	Yes

Back to Top