1. Tables and Views for Financials
  2. FA_MASS_TRX_DETAILS

FA_MASS_TRX_DETAILS

FA_MASS_TRX_DETAILS contains the new transaction details for mass transaction requests. Oracle Fusion Assets uses this information when determining the new transaction details for each of the candidate assets selected based on the criteria in the FA_MASS_TRANSACTIONS table.

Details

  • Schema: FUSION

  • Object owner: FA

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Columns

Name Datatype Length Precision Not-null Comments Status
MASS_TRANSACTION_ID NUMBER 18 Yes Identifier of the mass transaction. Active
METHOD_ID NUMBER 18 Identifier of the depreciation method to be assigned to candidate assets. Active
FLAT_RATE_ID NUMBER 18 Identifier of the flat rate record to be assigned to candidate assets. Active
PRODUCTION_CAPACITY NUMBER Total production capacity to be assigned to candidate assets depreciating under a units of production depreciation method. Active
UNIT_OF_MEASURE VARCHAR2 25 Unit of measure to be assigned to candidate assets depreciating under a units of production depreciation method. Active
CONVENTION_TYPE_ID NUMBER 18 Identifier of the depreciation prorate convention to be assigned to candidate assets. Active
BONUS_RULE_ID NUMBER 18 Identifier of the depreciation bonus rule to be assigned to candidate assets. Active
CEILING_TYPE_ID NUMBER Identifier of the depreciation ceiling to be assigned to candidate assets. Active
CASH_GENERATING_UNIT_ID NUMBER Identifier of the cash generating unit to be assigned to candidate assets. Active
GROUP_ASSOCIATION VARCHAR2 30 Group asset association option for selected candidate assets. Association is limited to standalone or member asset type. Active
GROUP_ASSET_ID NUMBER 18 Identifier of the group asset to be assigned to candidate assets. Active
DATE_PLACED_IN_SERVICE DATE Date to be assigned as the new date placed in service to candidate assets. Active
SALVAGE_TYPE VARCHAR2 30 Salvage type to be assigned to candidate assets. Active
SALVAGE_PERCENT NUMBER Salvage value percentage to be assigned to candidate assets. Active
SALVAGE_VALUE NUMBER Salvage value amount to be assigned to candidate assets. Active
DEPRN_LIMIT_TYPE VARCHAR2 30 Depreciation limit type to be assigned to candidate assets. Active
DEPRN_LIMIT_PERCENT NUMBER Depreciation limit percentage to be assigned to candidate assets. Active
DEPRN_LIMIT_AMOUNT NUMBER Depreciation limit amount to be assigned to candidate assets. Active
DISTRIBUTION_SET_ID NUMBER 18 Identifier of the distribution set to be applied to candidate assets. Active
ASSIGNED_TO NUMBER 18 Identifier of the person to be applied as the custodian of candidate assets. Active
PROCEEDS_OF_SALE NUMBER Total proceeds from the sale of all assets in the batch to be allocated to the candidate assets during retirement. Active
COST_OF_REMOVAL NUMBER Total cost of removing all the assets in the batch to be allocated to the candidate assets during retirement. Active
RETIREMENT_TYPE_CODE VARCHAR2 30 Retirement type to be assigned to the candidate assets during retirement. Active
RETIREMENT_CONVENTION_TYPE_ID NUMBER 18 Identifier of the prorate convention to be assigned to the candidate assets during retirement. Active
SOLD_TO VARCHAR2 30 Name of the party to whom all the assets were sold, which will be assigned to the candidate assets during retirement. Active
REFERENCE_NUM VARCHAR2 15 Internal reference number to be assigned to the candidate assets during retirement. Active
UNITS_TO_RETIRE NUMBER 18 Total number of units to retire. Used in performing unit-based retirements of the candidate assets up to this limit. Active
RET_ATTRIBUTE1 VARCHAR2 150 Descriptive Flexfield:??segment of the user descriptive flexfield. Active
RET_ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield:??segment of the user descriptive flexfield. Active
RET_ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield:??segment of the user descriptive flexfield. Active
RET_ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield:??segment of the user descriptive flexfield. Active
RET_ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield:??segment of the user descriptive flexfield. Active
RET_ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield:??segment of the user descriptive flexfield. Active
RET_ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield:??segment of the user descriptive flexfield. Active
RET_ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield:??segment of the user descriptive flexfield. Active
RET_ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield:??segment of the user descriptive flexfield. Active
RET_ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield:??segment of the user descriptive flexfield. Active
RET_ATTRIBUTE11 VARCHAR2 150 Descriptive Flexfield:??segment of the user descriptive flexfield. Active
RET_ATTRIBUTE12 VARCHAR2 150 Descriptive Flexfield:??segment of the user descriptive flexfield. Active
RET_ATTRIBUTE13 VARCHAR2 150 Descriptive Flexfield:??segment of the user descriptive flexfield. Active
RET_ATTRIBUTE14 VARCHAR2 150 Descriptive Flexfield:??segment of the user descriptive flexfield. Active
RET_ATTRIBUTE15 VARCHAR2 150 Descriptive Flexfield:??segment of the user descriptive flexfield. Active
RET_ATTRIBUTE_NUMBER1 NUMBER Descriptive Flexfield:??segment of the user descriptive flexfield. Active
RET_ATTRIBUTE_NUMBER2 NUMBER Descriptive Flexfield:??segment of the user descriptive flexfield. Active
RET_ATTRIBUTE_NUMBER3 NUMBER Descriptive Flexfield:??segment of the user descriptive flexfield. Active
RET_ATTRIBUTE_NUMBER4 NUMBER Descriptive Flexfield:??segment of the user descriptive flexfield. Active
RET_ATTRIBUTE_NUMBER5 NUMBER Descriptive Flexfield:??segment of the user descriptive flexfield. Active
RET_ATTRIBUTE_DATE1 DATE Descriptive Flexfield:??segment of the user descriptive flexfield. Active
RET_ATTRIBUTE_DATE2 DATE Descriptive Flexfield:??segment of the user descriptive flexfield. Active
RET_ATTRIBUTE_DATE3 DATE Descriptive Flexfield:??segment of the user descriptive flexfield. Active
RET_ATTRIBUTE_DATE4 DATE Descriptive Flexfield:??segment of the user descriptive flexfield. Active
RET_ATTRIBUTE_DATE5 DATE Descriptive Flexfield:??segment of the user descriptive flexfield. Active
RET_ATTRIBUTE_CATEGORY_CODE VARCHAR2 30 Descriptive Flexfield: structure definition of the user descriptive flexfield. Active
INHERIT_DEF_RULES_FLAG VARCHAR2 1 Option indicating whether assets undergoing a change in category should inherit the depreciation rules of the new category or not. Active
COPY_CATEGORY_DFF_FLAG VARCHAR2 1 Option indicating whether to copy the descriptive flexfield information to the new category or not. Active
DEST_BOOK_TYPE_CODE VARCHAR2 30 Unique destination book identification name.
CREATE_NEW_ASSET_FLAG VARCHAR2 1 Indicates whether the destination asset number is the same as the source.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row. Active
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row. Active
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row. Active
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. Active
CATEGORY_FLEX_FILTER XMLTYPE Key Flexfield: filter criteria for the asset category key flexfield in xml format
LOCATION_FLEX_FILTER XMLTYPE Key Flexfield: filter criteria for the asset location key flexfield in xml format
DEPRN_EXPENSE_FLEX_FILTER XMLTYPE Key Flexfield: filter criteria for the general ledger accounting key flexfield in xml format
REVAL_METHOD VARCHAR2 30 Stores the method used for revaluation.
REVAL_FULLY_RSVD_FLAG VARCHAR2 1 Allows fully reserved asset revaluation.
LIFE_EXTENSION_FACTOR NUMBER Stores the value of the life extension factor entered by the user. Used to default life extension factor for all assets in a batch.
LIFE_EXTENSION_CEILING NUMBER Stores the value of the life extension ceiling entered by the user. Used to default life extension ceiling for all assets in a batch.
PERIOD_END_REVAL_FLAG VARCHAR2 1 Stores the value of the include current period depreciation option entered by the user. Used to default the value of the include current period depreciation option for all assets in a batch.
REVAL_VALUE_TYPE VARCHAR2 30 Stores the value type used for revaluation.
LINKED_FLAG VARCHAR2 1 Allows revaluation to be linked to prior impairment transactions.
REVAL_PERCENTAGE NUMBER Stores the revaluation percentage value.
MAX_FULLY_RSVD_REVALS NUMBER 18 Stores the default value of the maximum number of revaluations allowed on a fully reserved asset.
EXTENDED_DEPRN_FLAG VARCHAR2 1 Indicates whether the asset depreciation needs to be extended.
PERIOD_COUNTER_EXTENDED NUMBER 18 Extended depreciation start period identifier.
BK_GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 30 Global Descriptive Flexfield: structure definition of the global descriptive flexfield.
BK_GLOBAL_ATTRIBUTE1 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
BK_GLOBAL_ATTRIBUTE2 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
BK_GLOBAL_ATTRIBUTE3 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
BK_GLOBAL_ATTRIBUTE4 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
BK_GLOBAL_ATTRIBUTE5 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
BK_GLOBAL_ATTRIBUTE6 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
BK_GLOBAL_ATTRIBUTE7 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
BK_GLOBAL_ATTRIBUTE8 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
BK_GLOBAL_ATTRIBUTE9 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
BK_GLOBAL_ATTRIBUTE10 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
BK_GLOBAL_ATTRIBUTE11 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
BK_GLOBAL_ATTRIBUTE12 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
BK_GLOBAL_ATTRIBUTE13 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
BK_GLOBAL_ATTRIBUTE14 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
BK_GLOBAL_ATTRIBUTE15 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
BK_GLOBAL_ATTRIBUTE16 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
BK_GLOBAL_ATTRIBUTE17 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
BK_GLOBAL_ATTRIBUTE18 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
BK_GLOBAL_ATTRIBUTE19 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
BK_GLOBAL_ATTRIBUTE20 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
BK_GLOBAL_ATTRIBUTE_NUMBER1 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
BK_GLOBAL_ATTRIBUTE_NUMBER2 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
BK_GLOBAL_ATTRIBUTE_NUMBER3 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
BK_GLOBAL_ATTRIBUTE_NUMBER4 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
BK_GLOBAL_ATTRIBUTE_NUMBER5 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
BK_GLOBAL_ATTRIBUTE_DATE1 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
BK_GLOBAL_ATTRIBUTE_DATE2 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
BK_GLOBAL_ATTRIBUTE_DATE3 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
BK_GLOBAL_ATTRIBUTE_DATE4 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
BK_GLOBAL_ATTRIBUTE_DATE5 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
UNPLAN_EXPENSE_ACCOUNT_CCID NUMBER 18 The account code combination identifier used to account the unplanned depreciation expense.
GLOBAL_ATTRIBUTE_NUMBER6 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER7 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER8 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER9 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER10 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
UPDATE_LAST_USED_INDEX_FLAG VARCHAR2 1 Specifies whether the value of the last used price index will be updated to a new value as of the revaluation date.

Foreign Keys

Table Foreign Table Foreign Key Column
FA_MASS_TRX_DETAILS gl_code_combinations UNPLAN_EXPENSE_ACCOUNT_CCID

Indexes

Index Uniqueness Tablespace Columns
FA_MASS_TRX_DETAILS_U1 Unique Default MASS_TRANSACTION_ID