ProjectAssets
The project asset resource is used to view project asset and asset assignments, including those from Project Portfolio Management and those imported from third-party applications. Asset Assignment is a child of the Asset.
Columns
| Name | Type | Description |
| ProjectAssetId [KEY] | Long | The unique identifier of a system-generated project asset. This is a mandatory attribute. |
| ProjectId | Long | Identifier of the project to which the asset belongs. You can enter either this attribute, the project name, or the project number while creating an asset. |
| ProjectName | String | Name of the project to which the asset belongs. You can enter either this attribute, the project ID, or the project number while creating an asset. |
| ProjectNumber | String | Number of the project to which the asset belongs. You can enter either this attribute, the project ID, or the project name while creating an asset. |
| ProjectAssetType | String | The identifier that determines when project costs become an asset. This is a mandatory attribute. It can be either ESTIMATED, AS-BUILT, or RETIREMENT_ADJUSTMENT. The default value is ESTIMATED. |
| AssetName | String | Name of the project asset that identifies an asset within a project. This is a mandatory attribute. |
| AssetNumber | String | The project asset number that identifies an asset in a project. This is a mandatory attribute, and can be user-defined or generated by Fixed Assets. You must provide the asset number and FA asset ID in Patch mode to associate the FA asset with the project asset. |
| AssetDescription | String | Description of the project asset that identifies an asset within a project upon transfer to Oracle Assets. This is a mandatory attribute. |
| CapitalEventId | Long | Identifier of the event that's assigned to the project asset. You may enter either this attribute, the event number, or the event name. |
| EventName | String | Name of the event that's assigned to the project asset. You may enter either this attribute, the event number, or the event ID. |
| CapitalEventNumber | Long | Number of the event that's assigned to the project asset. You may enter either this attribute, the event ID, or the event name. |
| EstimatedInServiceDate | Date | The estimated date on which an asset is placed in service. |
| DatePlacedInService | Date | The date on which an asset is placed in service. |
| CapitalizedFlag | Bool | Indicates whether the asset has been interfaced to Oracle Assets. The two options are Y and N. The default value is N. |
| CapitalizedDate | Date | The last date on which nonreversing cost adjustments were interfaced to Oracle Assets. |
| CapitalizedCost | Decimal | The cost amount that has been interfaced to Oracle Assets for capitalization. |
| TotalAssetCost | Decimal | The asset's cost amount, grouped into asset lines. |
| ReverseFlag | Bool | Indicates whether the asset will be reversed in the next Generate Asset Lines run. This is a mandatory attribute. The two options are Y and N. The default value is N. |
| ReversalDate | Date | The last date on which reversing asset lines were created. This is a system-generated date. |
| CapitalHoldFlag | Bool | Indicates whether the generation of new asset lines should be prevented. This is a mandatory attribute. The two options are Y and N. The default value is N. |
| BookTypeCode | String | The corporate book to which the asset is assigned. |
| AssetCategoryId | Long | Identifier of the asset category to which the asset is assigned. You may enter either this attribute, the asset category, or both. |
| AssetKeyIdentifier | Long | Identifier of the key flexfield code combination for the asset. You may enter either this attribute, the asset key, or both. |
| AssetUnits | Decimal | The number of asset units. |
| EstimatedCost | Decimal | The estimated cost of the asset. |
| EstimatedAssetUnits | Decimal | The estimated number of asset units. |
| SourceApplication | String | Identifier of the external project management system from which the project was imported. |
| SourceReference | String | Identifier of the project in the external project management system from which the project was imported. |
| LocationId | Long | Identifier of the location to which the asset is assigned. You may enter either this attribute, the location, or both when assigning a location to the asset. |
| AssignedToPersonId | Long | Identifier of the individual to whom the asset is assigned. You may enter either this attribute, the person name, or person number when assigning an individual to an asset. |
| PersonName | String | Name of the individual to whom the asset is assigned. You may enter either this attribute, the person Id, or person number when assigning an individual to an asset. |
| PersonNumber | String | Number of the individual to whom the asset is assigned. You may enter either this attribute, the person ID, or the person name when assigning an individual to an asset. |
| DepreciateFlag | Bool | Indicates whether the asset should be depreciated in Oracle Assets. The two options are Y and N. The default value is Y. |
| DepreciationExpenseIdentifier | Long | Identifier of the depreciation expense account for the asset. You may enter either this attribute, the depreciation expense account, or both. |
| AmortizeFlag | Bool | Indicates whether cost adjustments should be amortized in Oracle Assets. The two options are Y and N. The default value is N. |
| CostAdjustmentFlag | Bool | Indicates whether asset cost adjustments have been interfaced to Oracle Assets. The two options are Y and N. The default value is N. |
| NewMasterFlag | Bool | Determines whether this cost adjustment will reclassify the asset within Oracle Assets. |
| BusinessUnitId | Long | Identifier of the business unit associated with the project in which the asset has been assigned. This is a mandatory attribute. |
| BusinessUnitName | String | Name of the business unit associated with the project in which the asset has been assigned. |
| FixedAssetsAssetId | Long | Identifier of the asset in Oracle Fixed Assets used for tieback purposes. Users must provide the asset number along with the FA asset ID in PATCH mode if they're trying to associate an Oracle FA asset with the Projects asset. |
| FixedAssetsPeriodName | String | Period into which an asset was posted in Fixed Assets. |
| ParentAssetId | Long | Identifier of the parent asset in which multiple assets can be identified. You may enter a combination of this attribute, the parent asset description, or the parent asset number when associating an asset to a parent asset. |
| ParentAssetDescription | String | Description of the parent asset in which multiple assets can be identified. You may enter a combination of this attribute, the parent asset ID, or the parent asset number when associating an asset to a parent asset. |
| ParentAssetNumber | String | Number of the parent asset in which multiple assets can be identified. You may enter a combination of this attribute, the parent asset ID, or the parent asset description when associating an asset to a parent asset. |
| ManufacturerName | String | The name of the asset manufacturer. |
| ModelNumber | String | The model number of the asset. |
| TagNumber | String | Tag number of the asset. |
| SerialNumber | String | The serial number of the asset. |
| RetirementTargetAssetId | Long | The asset identifier used to capture retirement costs when another asset, or assets retire. You may enter either this attribute, the retirement target asset description, or the retirement target asset number when selecting an asset to capture the retirement costs. |
| RetirementTargetAssetDescription | String | Description of the asset used to capture retirement costs when another asset, or assets, retire. You may enter this attribute, Retirement Target Asset ID, or Retirement Target Asset Number, when selecting an asset to capture the retirement costs. |
| RetirementTargetAssetNumber | String | Number of the asset used to capture the retirement costs when another asset or assets retire. You may enter this attribute, the retirement target asset ID, or the retirement target asset description when selecting an asset to capture the retirement costs. |
| LocationCombination | String | Segment values for location, concatenated using delimiters. |
| AssetKeyCombination | String | Segment values for asset keys, concatenated using a delimiter. |
| AssetCategoryCombination | String | Segment values for asset categories, concatenated using a delimiter. |
| DepreciationExpenseAccountCombination | String | Segment values for depreciation expense accounts, concatenated using delimiters. |
| AssociateFAToPPMAssetFlag | Bool | Indicates whether the asset number recorded exists in Fixed Assets. The two options are Y and N. The default value is N. |
| Finder | String | finder |
| SysEffectiveDate | String | syseffectivedate |