InstalledBaseAssets
Manages customer-owned and maintainable assets, including lifecycle and operational data.
Columns
| Name | Type | Description |
| ActiveEndDate | Datetime | The date when the asset becomes inactive. For maintenance assets, the asset’s active end date must be a future date. For customer assets, this date must be in the past and not earlier than the customer’s active start date. When the asset end date is provided, other asset attributes cannot be updated. |
| AssetId [KEY] | Long | A unique identifier automatically assigned to each asset when created by the application. This value is read-only. |
| AssetNumber | String | An optional identifier for the asset. If not provided, the application uses the AssetId as the asset number. |
| BOMExplosionFlag | Bool | Determines whether to create component assets. If true, it creates child items by expanding the bill of materials for the asset. The default value is false. |
| CompetitorAssetFlag | Bool | Indicates if the asset represents a competitor’s asset. If true, it is a competitor’s asset; otherwise, it is not. The default value is false. |
| CurrentLocationContextCode | String | Abbreviation that identifies the location context where the asset resides. A valid list of values is defined in the lookup type 'ORA_CSE_CURRENT_LOC_CONTEXT'. This attribute is required when creating the asset. |
| CurrentLocationId | Long | A unique identifier for the location where the asset is currently placed. This value is required if the CurrentLocationContextCode is set to 'ORA_EXTERNAL_LOCATION' or 'ORA_INTERNAL_LOCATION'. |
| CustomerAccountId | Long | A unique identifier for the customer account to which the asset is billed. |
| CustomerAccountSiteId | Long | A unique identifier for the customer account site associated with the asset. This site must be part of the customer account. |
| CustomerAccountSiteUseId | Long | A unique identifier for the usage of the customer account site associated with the asset. This value must be part of the customer account site. |
| CustomerAssetEndDate | Datetime | The date and time when the customer asset becomes inactive. Once this value is set, other asset attributes cannot be updated. |
| CustomerAssetStartDate | Datetime | The date and time when the customer asset becomes active. This value is determined by the shipment date and is read-only. |
| CustomerBillingPartyId | Long | A unique identifier for the customer party responsible for billing for the asset. This value is read-only. |
| CustomerBillingPartySiteId | Long | A unique identifier for the billing party site associated with the customer. This value is read-only. |
| CustomerId | Long | A unique identifier for the customer party that currently owns or uses the asset. This is required for creating a customer asset. |
| CustomerSiteId | Long | A unique identifier for the customer site where the asset resides. This value is required when the 'CurrentLocationContextCode' is set to 'ORA_CUSTOMER'. |
| CustomerSitePartyId | Long | A unique identifier for the customer site party where the asset is located. |
| Description | String | A description of the asset, used to provide details on its features or characteristics. |
| DfltWoSubTypeCode | String | Abbreviation identifying the work order sub-type. This value is selected from the 'ORA_MNT_WO_SUB_TYPE' lookup and is used when creating work orders for the asset. |
| DfltWoTypeCode | String | Abbreviation identifying the work order type. This value is selected from the 'ORA_MNT_WO_TYPE' lookup and is used when creating work orders for the asset. |
| FulfillLineId | Long | A unique identifier for the fulfillment line associated with the asset in the installed base. |
| InServiceDate | Date | The date when the asset was placed in service by the organization. The in-service date must occur after the installation date. |
| InstalledDate | Date | The date when the asset was installed. The installed date must occur after the shipment date and before the in-service date. |
| LocatorId | Long | A unique identifier for the locator where the asset is placed in the installed base. |
| IotEnabledFlag | Bool | Indicates whether the asset is synchronized with the Internet of Things (IoT) application. If true, the asset will be synchronized. The default value is true. |
| ItemId | Long | The unique identifier for the item associated with the asset. This is required when 'ItemRequiredFlag' is true. For customer assets, the item must have 'Enable Asset Tracking' set to 'Customer Asset' or 'Full Lifecycle'. For enterprise assets, it must be set to 'Full Lifecycle'. |
| OperatingOrganizationId | Long | The unique identifier for the organization that operates or creates the asset. This is required for creating an enterprise asset. If not provided, the application uses the item master organization. |
| ItemRevision | String | The revision number for the item associated with the asset. |
| LocationOrganizationId | Long | The unique identifier for the organization where the asset is located. This is required when 'CurrentLocationContextCode' is set to 'ORA_WORK CENTER'. |
| LotNumber | String | The lot number identifying the inventory lot for the item associated with the asset. This is applicable when the item is lot-controlled. |
| MaintainableFlag | Bool | Indicates whether the asset is eligible for maintenance activities, such as work orders. If true, the asset can be maintained. The default value is true. |
| NewWoAllowedFlag | Bool | Indicates whether the application can create a work order for the asset. If true, a work order can be created; otherwise, it cannot. The default value is true. |
| PurchaseDate | Date | The date when the customer purchased the asset. It must occur before the registration date. |
| Quantity | Decimal | The quantity for the asset, which is required for the item. If the item is serial controlled, the quantity cannot exceed one. |
| RegistrationDate | Date | The date and time when the customer registered the asset. |
| SalesOrderId | Long | The unique identifier for the sales order used to order the asset. |
| SalesOrderLineId | Long | The unique identifier for the line item on the sales order used to order the asset. |
| SalesOrderLineNumber | String | The unique number identifying the line item on the sales order used to order the asset. |
| SalesOrderNumber | String | The number identifying the sales order used to order the asset. |
| SalesOrderSourceSystem | String | The name of the external application from which the sales order originated. If the source system is internal, it identifies an Oracle Fusion application. |
| SalesOrderSourceSystemType | String | Describes whether the sales order originated from an internal or external application. This is read-only. |
| SerialNumber | String | A unique serial number for the asset when the item is serial-controlled. The serial number must be created in the inventory if it does not already exist. |
| ShipmentDate | Datetime | The date when the asset was shipped to the customer. This is optional, and if not provided, the application uses the current date. |
| SoldByBusinessUnitId | Long | The unique identifier for the business unit that sold the asset. This is optional. |
| SplitFromAssetId | Long | The unique identifier for the asset from which this asset was split during partial returns. |
| SubinventoryCode | String | The subinventory code where the asset is stored or located. |
| UOMCode | String | The unit of measure code for the asset. It must match the unit of measure used for the item. |
| UpdateContractFlag | Bool | Indicates whether changes to the asset should be communicated to the enterprise contract application. If true, changes are sent to the contract system. The default is true. |
| WorkCenterId | Long | The unique identifier for the work center where the asset is located. |
| WorkCenterName | String | The name of the work center where the asset resides. |
| CustomerSitePartyName | String | The name of the customer site party where the asset is located. |
| CustomerSiteName | String | The name of the customer site where the asset resides. |
| CustomerAccountName | String | The name of the customer account to which the asset is billed. |
| CustomerAccountSiteName | String | The name of the customer account site associated with the asset. |
| OperatingOrganizationCode | String | The abbreviation for the organization that creates or operates the asset. It is used to create either customer or enterprise assets. |
| ManageAssetPrivilege | String | Indicates the level of responsibility for managing the asset. C stands for customer asset responsibility, M for enterprise asset responsibility, and MC for super-user responsibility. |
| ItemNumber | String | The unique item number for the asset. This is required when 'ItemRequiredFlag' is true and must correspond to an item with asset tracking enabled. |
| CustomerName | String | The name of the customer who owns or uses the asset. This is read-only. |
| CustomerNumber | String | A unique identifier for the customer associated with the asset. You can provide either 'CustomerId' or 'CustomerNumber'. |
| ItemRequiredFlag | Bool | Indicates whether an item is required to create the asset. If true, the item is required. The default is false. |
| Country | String | The country where the asset is located if 'CurrentLocationContextCode' is set to 'ORA_EXTERNAL_LOCATION'. |
| City | String | The city where the asset is located if 'CurrentLocationContextCode' is set to 'ORA_EXTERNAL_LOCATION'. |
| PostalCode | String | The postal code for the location where the asset resides, required if 'CurrentLocationContextCode' is 'ORA_EXTERNAL_LOCATION'. |
| State | String | The state where the asset is located if 'CurrentLocationContextCode' is set to 'ORA_EXTERNAL_LOCATION'. |
| Address1 | String | The first line of the address for the asset’s location, required if 'CurrentLocationContextCode' is 'ORA_EXTERNAL_LOCATION'. |
| Address2 | String | The second line of the address for the asset’s location, if applicable. |
| Address3 | String | The third line of the address for the asset’s location, if applicable. |
| Address4 | String | The fourth line of the address for the asset’s location, if applicable. |
| Province | String | The province where the asset resides if CurrentLocationContextCode is set to 'ORA_EXTERNAL_LOCATION'. |
| County | String | The county where the asset is located if CurrentLocationContextCode is set to 'ORA_EXTERNAL_LOCATION'. |
| CurrentLocationContext | String | The context in which the asset’s current location is identified. |
| LocatorName | String | The name of the locator where the asset is stored. |
| CurrentLocationName | String | The name of the current location of the asset. |
| ContactId | Long | The unique identifier for the asset contact. You can use the contact identifier, number, or name to link a contact to the asset. |
| ContactName | String | The name of the asset’s contact person. This is the concatenation of the first, middle, and last names, as defined in the customer data model. |
| ContactNumber | String | The contact number for the asset's person. This can be used to create or update the asset's contact information. |
| ParentAssetId | Long | The unique identifier for the parent asset to which this asset is related. |
| StructureActionCode | String | Indicates the action for the asset relationship, such as adding or removing the asset from a parent asset. |
| WorkCenterCode | String | The code identifying the work center where the asset is located, when 'CurrentLocationContextCode' is 'ORA_WORK CENTER'. |
| CustomerAccountNumber | String | The number that identifies the customer account to which the asset is billed. |
| CustomerAccountSiteNumber | String | The unique number identifying the site of the customer account where the asset is located. |
| SoldByBusinessUnitName | String | The name of the business unit that sold the asset. |
| LocationOrganizationCode | String | The organization code identifying the location where the asset is stored, used when the 'CurrentLocationContextCode' is set to 'ORA_WORK CENTER'. |
| CustomerSiteNumber | String | The unique number identifying the customer site where the asset resides. |
| CustomerSitePartyNumber | String | The unique number identifying the customer site party for the asset. |
| CustomerAccountSiteUseCode | String | The code identifying the usage of the customer account site for the asset. |
| ItemCustomerSelfServiceFlag | Bool | Indicates whether the item is available for self-service by the customer. |
| ItemServiceRequestEnabledCode | String | Indicates whether service requests are enabled for the item associated with the asset. |
| ItemDescription | String | The description of the item associated with the asset. |
| ItemLongDescription | String | The detailed description of the item associated with the asset. |
| SecondaryQuantity | Decimal | The secondary quantity for dual-unit-of-measure items, which overrides the default quantity if required. |
| SecondaryUOMCode | String | The code for the secondary unit of measure associated with the asset, used for dual-UOM items. |
| CustomerPartyType | String | Indicates whether the customer is an organization or an individual party. |
| ReturnSourceOrderNumber | String | The reference number for the return source sales order when processing returns. |
| ReturnOrderNumber | String | The unique identifier for the return sales order number. |
| ReturnOrderFulfillLineId | Long | The unique identifier for the return order fulfillment line. |
| ReturnOrderId | Long | The unique identifier for the return order. |
| ReturnOrderLineId | Long | The unique identifier for the return order line. |
| OperatingOrganizationName | String | The name of the organization responsible for operating or managing the asset. |
| CurrentLocationNameFormatted | String | The formatted name of the asset’s current location. |
| Finder | String | Finder for 'InstalledBaseAssets'. |