Full expand

Full collapse

Organization

Jump to

• Fields
• Reference Objects
• Business Views
• Other Properties

An organization in supply chain management typically represents a physical facility representing a warehouse, manufacturing plant or maintenance depot. Such facilities are known as inventory organizations. For example, an organization is created for each warehouse in your enterprise. An organization may also represent a less complex version known as an item organization. For example, these are recommended to represent item master organizations. These are needed for item and item attribute setup but aren't used in business transactions.

Label, Plural Label

Organization, Organizations

Qualified Label, Qualified Plural Label

Organization, Organizations

Module

oraScmCoreOrganization

Keys

• $primary: id, effectiveStartDate, effectiveEndDate

• altKey: id

• orgAltKey: id (default)

Base Business Object

• Module: oraHcmHrCoreWorkStructures

• Business Object: Organization

Expand all

Collapse all

Fields

* Field can't be null

• classifications (object-collection)*

  Classifications accessor for the organization.

  Label

  Classification

  Cardinality	Target Object
  One to many	Module: oraHcmHrCoreWorkStructures Business Object: OrganizationClassification

  Additional Mapping Details

  Mapped by relationship: organizationUnit

  Properties

  • inherited
• code (string)

  Code of the organization.

  Label

  Organization Code

  Properties

  • inherited
  • searchable
  • sortable
• createdBy (string)*

  The user who created the record.

  Label

  Created By

  Properties

  • inherited
  • searchable
  • sortable
  • not nullable
• effectiveEndDate (date)*

  Effective end date of the organization.

  Label

  Effective End Date

  Properties

  • inherited
  • searchable
  • sortable
  • not nullable
• effectiveStartDate (date)*

  Effective start date of the organization.

  Label

  Effective Start Date

  Properties

  • inherited
  • searchable
  • sortable
  • not nullable
• id (int64)*

  Unique identifier of the organization.

  Label

  Organization ID

  Properties

  • inherited
  • searchable
  • sortable
  • not nullable
  • overridable
• name (string)*

  Name of the organization used in supply chain management.

  Label

  Name

  Properties

  • inherited
  • translatable
  • not nullable
  • overridable
• organizationConfiguration (object)*

  Object reference to the associated inventory organization parameters for the supply chain organization.

  Label

  Organization Configuration

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

  Additional Mapping Details

  Field in Current Object	Field in Target Object
  id	id

• plantConfiguration (object)*

  Object reference to the associated plant parameters for the supply chain organization.

  Label

  Plant Configuration

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

  Additional Mapping Details

  Field in Current Object	Field in Target Object
  id	organizationId

• timeCreated (date-time)*

  The date and time when the record was created.

  Label

  Creation Date

  Properties

  • inherited
  • searchable
  • sortable
  • not nullable
• timeUpdated (date-time)*

  The date and time when the record was last updated.

  Label

  Last Updated Date

  Properties

  • inherited
  • searchable
  • sortable
  • not nullable
• title (string)

  Title of the organization.

  Label

  Title

  Properties

  • inherited
  • translatable
• updatedBy (string)*

  The user who last updated the record.

  Label

  Last Updated By

  Properties

  • inherited
  • searchable
  • sortable
  • not nullable
• $translations (object-collection)*

  Label

  Translations

  Cardinality	Target Object
  One to many	Module: oraHcmHrCoreWorkStructures Business Object: OrganizationTranslation

  Additional Mapping Details

  Mapped by relationship: organization

  Properties

  • inherited

Expand all

Collapse all

Reference Objects

• actionOccurrence (object)

  Action Occurrence accessor for the organization.

  Label

  Action Occurrence

  Cardinality	Target Object
  One to One	Module: oraHcmHrCoreEmployment Business Object: ActionOccurrence

  Additional Mapping Details

  Field in Current Object	Field in Target Object
  actionOccurrenceId	id

  Properties

  • inherited
• location (object)

  Location accessor for the organization.

  Label

  Location

  Cardinality	Target Object
  One to One	Module: oraHcmHrCoreWorkStructures Business Object: Location

  Additional Mapping Details

  Field in Current Object	Field in Target Object
  locationId	id

  Properties

  • inherited
  • overridable

Expand all

Collapse all

Business Views

** Available for extracting data

• default

  Data Source

  RDBMS

  Expand all

  Collapse all

  Fields

  • id (int64)

    Unique identifier of the organization.

    Label

    Organization ID

    Properties

    • inherited
    • searchable
    • sortable
    • not nullable
    • overridable
  • name (string)

    Name of the organization used in supply chain management.

    Label

    Name

    Properties

    • inherited
    • translatable
    • not nullable
    • overridable

  Expand all

  Collapse all

  Reference Object

  • organizationConfiguration (OrganizationConfiguration)

    Object reference to the associated inventory organization parameters for the supply chain organization.

    Business Object

    OrganizationConfiguration

    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

• inventoryConfiguration

  Gets the organization parameters used by Oracle Fusion Cloud Inventory Management. This includes lot and serial number generation defaults and numerous warehouse behavior settings.

  Data Source

  RDBMS

  Expand all

  Collapse all

  Fields

  • id (int64)

    Unique identifier of the organization.

    Label

    Organization ID

    Properties

    • inherited
    • searchable
    • sortable
    • not nullable
    • overridable
  • name (string)

    Name of the organization used in supply chain management.

    Label

    Name

    Properties

    • inherited
    • translatable
    • not nullable
    • overridable

  Expand all

  Collapse all

  Reference Object

  • organizationConfiguration (OrganizationConfiguration)

    Object reference to the associated inventory organization parameters for the supply chain organization.

    Business Object

    OrganizationConfiguration

    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

    • 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

    • 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

    • 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

    • 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

    • 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

    • 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
    • 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

    • 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
    • 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
    • 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

    • 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
      • customerAccountId (int64)

        Identifier of the customer account.

        Label

        Customer Account 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

    • 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

    • 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

• itemConfiguration

  Gets the organization parameters used by Oracle Fusion Cloud Product Hub. These include the starting revision and the item grouping behavior of each organization.

  Data Source

  RDBMS

  Expand all

  Collapse all

  Fields

  • id (int64)

    Unique identifier of the organization.

    Label

    Organization ID

    Properties

    • inherited
    • searchable
    • sortable
    • not nullable
    • overridable
  • name (string)

    Name of the organization used in supply chain management.

    Label

    Name

    Properties

    • inherited
    • translatable
    • not nullable
    • overridable

  Expand all

  Collapse all

  Reference Object

  • organizationConfiguration (OrganizationConfiguration)

    Object reference to the associated inventory organization parameters for the supply chain organization.

    Business Object

    OrganizationConfiguration

    Expand all

    Collapse all

    Fields

    • 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
    • organizationCode (string)

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

      Label

      Organization Code

      Properties

      • searchable
      • sortable
    • startingRevision (string)

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

      Label

      Starting Revision

    Expand all

    Collapse all

    Reference Object

    • itemDefinitionOrganization (Organization)

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

      Business Object

      Organization

      Expand all

      Collapse all

      Fields

      • effectiveEndDate (date)

        Effective end date of the organization.

        Label

        Effective End Date

        Properties

        • inherited
        • searchable
        • sortable
        • not nullable
      • effectiveStartDate (date)

        Effective start date of the organization.

        Label

        Effective Start Date

        Properties

        • inherited
        • searchable
        • sortable
        • not nullable
      • id (int64)

        Unique identifier of the organization.

        Label

        Organization ID

        Properties

        • inherited
        • searchable
        • sortable
        • not nullable
        • overridable

• lov

  Gets organizations and a small number of fields that are intended for use as a list of options. The list is limited to inventory organizations that the user has access to.

  Data Source

  RDBMS

  Expand all

  Collapse all

  Fields

  • id (int64)

    Unique identifier of the organization.

    Label

    Organization ID

    Properties

    • inherited
    • searchable
    • sortable
    • not nullable
    • overridable
  • name (string)

    Name of the organization used in supply chain management.

    Label

    Name

    Properties

    • inherited
    • translatable
    • not nullable
    • overridable

  Expand all

  Collapse all

  Reference Object

  • organizationConfiguration (OrganizationConfiguration)

    Object reference to the associated inventory organization parameters for the supply chain organization.

    Business Object

    OrganizationConfiguration

    Expand all

    Collapse all

    Fields

    • 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
    • organizationCode (string)

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

      Label

      Organization Code

      Properties

      • searchable
      • sortable

• openLOV

  Gets all organizations and a small number of fields that are intended for use as a list of options. The list returns all organizations.

  Data Source

  RDBMS

  Expand all

  Collapse all

  Fields

  • id (int64)

    Unique identifier of the organization.

    Label

    Organization ID

    Properties

    • inherited
    • searchable
    • sortable
    • not nullable
    • overridable
  • name (string)

    Name of the organization used in supply chain management.

    Label

    Name

    Properties

    • inherited
    • translatable
    • not nullable
    • overridable

  Expand all

  Collapse all

  Reference Object

  • organizationConfiguration (OrganizationConfiguration)

    Object reference to the associated inventory organization parameters for the supply chain organization.

    Business Object

    OrganizationConfiguration

    Expand all

    Collapse all

    Fields

    • 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
    • organizationCode (string)

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

      Label

      Organization Code

      Properties

      • searchable
      • sortable

• organizationDefinitionsReplica

  Gets the high-level organization setup used for reporting. This includes object references to the management business unit, the profit center business unit, and the legal entity.

  Data Source

  Read-optimized data store

  Expand all

  Collapse all

  Fields

  • effectiveEndDate (date)

    Effective end date of the organization.

    Label

    Effective End Date

    Properties

    • inherited
    • searchable
    • sortable
    • not nullable
  • effectiveStartDate (date)

    Effective start date of the organization.

    Label

    Effective Start Date

    Properties

    • inherited
    • searchable
    • sortable
    • not nullable
  • id (int64)

    Unique identifier of the organization.

    Label

    Organization ID

    Properties

    • inherited
    • searchable
    • sortable
    • not nullable
    • overridable
  • name (string)

    Name of the organization used in supply chain management.

    Label

    Name

    Properties

    • inherited
    • translatable
    • not nullable
    • overridable

  Expand all

  Collapse all

  Reference Object

  • organizationConfiguration (OrganizationConfiguration)

    Object reference to the associated inventory organization parameters for the supply chain organization.

    Business Object

    OrganizationConfiguration

    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
    • 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
    • organizationCode (string)

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

      Label

      Organization Code

      Properties

      • searchable
      • sortable

    Expand all

    Collapse all

    Reference Object

    • 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

      • effectiveEndDate (date)

        The end date of the date range within which the business unit is effective.

        Label

        End Date

        Properties

        • inherited
        • searchable
        • sortable
        • not nullable
      • effectiveStartDate (date)

        The start date of the date range within which the business unit is effective.

        Label

        Start Date

        Properties

        • inherited
        • searchable
        • sortable
        • not nullable
      • id (int64)

        The unique identifier of the business unit.

        Label

        Business Unit ID

        Properties

        • inherited
        • searchable
        • sortable
        • not nullable
        • overridable
      • name (string)

        The translated name for the business unit.

        Label

        Business Unit

        Properties

        • inherited
        • translatable
        • not nullable
        • overridable

      Expand all

      Collapse all

      Reference Object

      • information (BusinessUnitInformation)

        A business unit information that contains additional details about the business unit, such as manager, primary ledger, default legal entity, default reference date set, and legal entity option.

        Business Object

        BusinessUnitInformation

        Expand all

        Collapse all

        Fields

        • effectiveEndDate (date)

          Effective end date of the organization information.

          Label

          Effective End Date

          Properties

          • inherited
          • searchable
          • sortable
          • not nullable
        • effectiveStartDate (date)

          Effective start date of the organization information.

          Label

          Effective Start Date

          Properties

          • inherited
          • searchable
          • sortable
          • not nullable
        • id (int64)

          Label

          Organization Unit Classification ID

          Properties

          • inherited
          • searchable
          • sortable
          • not nullable

        Expand all

        Collapse all

        Reference Object

        • primaryLedger (Ledger)

          A ledger represents a record-keeping book used to track financial transactions. It serves as a central repository for all financial activities within an organization, providing a chronological and systematic account of debits, credits, and balances. Ledgers play a crucial role in financial management, budgeting, and maintaining accurate financial records, tracking expenses, revenues, assets, liabilities, and equity.

          Business Object

          Ledger

          Expand all

          Collapse all

          Fields

          • ledgerId (int64)

            The unique identifier of the ledger for which the accounting entry is created.

            Label

            Ledger ID

            Properties

            • searchable
            • sortable
            • not nullable
          • name (string)

            The unique name of the ledger entered by the user.

            Label

            Name

            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

      • effectiveEndDate (date)

        The end date of the date range within which the business unit is effective.

        Label

        End Date

        Properties

        • inherited
        • searchable
        • sortable
        • not nullable
      • effectiveStartDate (date)

        The start date of the date range within which the business unit is effective.

        Label

        Start Date

        Properties

        • inherited
        • searchable
        • sortable
        • not nullable
      • id (int64)

        The unique identifier of the business unit.

        Label

        Business Unit ID

        Properties

        • inherited
        • searchable
        • sortable
        • not nullable
        • overridable

Other Properties

Property	Value
Application Package Name	ora_scm_core_organization
Extensible	No

Back to Top