FA_DISTRIBUTION_HISTORY
FA_DISTRIBUTION_HISTORY contains information about the employee, location, and Accounting Flexfield values you assign to your assets. The depreciation program uses this information to allocate depreciation expense and the Transfers form uses it to maintain an audit trail of asset transfers. . When you initially assign distributions to an asset using the Transfers form, Oracle Assets inserts one row into this table for each distribution. Whenever you transfer, retire, reinstate, or reclassify an asset, Oracle Assets marks the appropriate rows as obsolete and creates new rows that reflect changes in assigned units, employees, general ledger depreciation expense account, or location. . Oracle Assets terminates a row by setting the DATE_INEFFECTIVE and TRANSACTION_HEADER_ID_OUT to the DATE_EFFECTIVE and TRANSACTION_HEADER_ID_IN of the new row. This means you can identify rows affected by the same transaction because they have the same DATE_EFFECTIVE / DATE_INEFFECTIVE and TRANSACTION_HEADER_ID_IN / TRANSACTION_HEADER_ID_OUT pairs. For new rows, TRANSACTION_HEADER_ID_IN is the same as TRANSACTION_HEADER_ID of the row inserted into FA_TRANSACTION_HEADERS for the transaction, and DATE_EFFECTIVE is the system date. . When you perform a full retirement, Oracle Assets updates the asset's current distribution lines with the RETIREMENT_ID from FA_RETIREMENTS so you can easily determine which retirement affected the rows. Oracle Assets stores the number of units retired as a negative number in TRANSACTION_UNITS. The sum of TRANSACTION_UNITS for the retired distribution lines matches the UNITS column in FA_RETIREMENTS, except the signs are opposite. . When you perform a partial unit retirement, Oracle Assets updates only the rows affected by the retirement. For any distribution lines that have units remaining after the retirement, Oracle Assets inserts new rows into this table where UNITS_ASSIGNED is reduced by the units retired, and terminates the old rows. . Partial cost retirements do not affect this table. . If you reinstate a full retirement, Oracle Assets inserts new rows that are the same as those that were active when you retired the asset, except that they have a different DISTRIBUTION_ID, TRANSACTION_HEADER_ID_IN and DATE_EFFECTIVE. If you reinstate a partial unit retirement, Oracle Assets inserts new rows that are the same as those that were active except UNITS_ASSIGNED increases by the units retired and the rows have a new DISTRIBUTION_ID, TRANSACTION_HEADER_ID_IN and DATE_EFFECTIVE. . Oracle Assets terminates the previous rows by setting TRANSACTION_HEADER_ID_OUT to the TRANSACTION_HEADER_ID of the reinstated transaction. . RETIREMENT_ID identifies all the rows affected by a retirement. . TRANSACTION_UNITS is the number of units affected by each retirement, reinstatement, transfer, addition or reclassification transaction. . .
Details
-
Schema: FUSION
-
Object owner: FA
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
FA_DISTRIBUTION_HISTORY_PK |
DISTRIBUTION_ID, BOOK_TYPE_CODE |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| DISTRIBUTION_ID | NUMBER | 18 | Yes | Identifier of the asset distribution. | |
| BOOK_TYPE_CODE | VARCHAR2 | 30 | Yes | Unique book identification name. | |
| ASSET_ID | NUMBER | 18 | Yes | Identifier of the asset number. | |
| UNITS_ASSIGNED | NUMBER | Yes | Number of units assigned to the distribution. | ||
| TRANSACTION_UNITS | NUMBER | Number of units involved in the transaction. Negative value for the row from which the units were transferred away or retired. Positive value for the row to which the units were transferred to or added. | |||
| CODE_COMBINATION_ID | NUMBER | 18 | Yes | Identifier of the account code combination for the depreciation expense account. | |
| LOCATION_ID | NUMBER | 18 | Location flexfield identification number. | ||
| ASSIGNED_TO | NUMBER | 18 | Identifier of the employee to whom the asset is assigned. | ||
| TRANSACTION_HEADER_ID_IN | NUMBER | 18 | Yes | Identifier of the transaction that created the row. | |
| TRANSACTION_HEADER_ID_OUT | NUMBER | 18 | Identifier of the transaction that terminated the row. | ||
| DATE_EFFECTIVE | DATE | Yes | Date when the row became effective. | ||
| DATE_INEFFECTIVE | DATE | Date when the row became inactive. | |||
| RETIREMENT_ID | NUMBER | 18 | Identifier of the asset retirement transaction. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| 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. | |
| INVENTORY_DATE_TAKEN | DATE | User-defined inventory taken date. | |||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| FA_DISTRIBUTION_HISTORY | fa_retirements | RETIREMENT_ID |
| FA_DISTRIBUTION_HISTORY | fa_additions_b | ASSET_ID |
| FA_DISTRIBUTION_HISTORY | fa_locations | LOCATION_ID |
| FA_DISTRIBUTION_HISTORY | fa_transaction_headers | TRANSACTION_HEADER_ID_OUT, BOOK_TYPE_CODE |
| FA_DISTRIBUTION_HISTORY | fa_transaction_headers | TRANSACTION_HEADER_ID_IN, BOOK_TYPE_CODE |
| FA_DISTRIBUTION_HISTORY | fa_book_controls | BOOK_TYPE_CODE |
| FA_DISTRIBUTION_HISTORY | gl_code_combinations | CODE_COMBINATION_ID |
| FA_DISTRIBUTION_HISTORY | per_persons | ASSIGNED_TO |
| fa_deprn_detail_h | fa_distribution_history | DISTRIBUTION_ID, BOOK_TYPE_CODE |
| fa_adjustments | fa_distribution_history | DISTRIBUTION_ID, BOOK_TYPE_CODE |
| fa_mc_deprn_detail | fa_distribution_history | DISTRIBUTION_ID, BOOK_TYPE_CODE |
| fa_deprn_detail | fa_distribution_history | DISTRIBUTION_ID, BOOK_TYPE_CODE |
| fa_mc_deprn_detail_h | fa_distribution_history | DISTRIBUTION_ID, BOOK_TYPE_CODE |
| fa_mc_adjustments | fa_distribution_history | DISTRIBUTION_ID, BOOK_TYPE_CODE |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| FA_DISTRIBUTION_HISTORY_U1 | Unique | DISTRIBUTION_ID, BOOK_TYPE_CODE |
| FA_DISTRIBUTION_HISTORY_N2 | Non Unique | ASSET_ID, BOOK_TYPE_CODE |
| FA_DISTRIBUTION_HISTORY_N7 | Non Unique | ASSIGNED_TO |
| FA_DISTRIBUTION_HISTORY_N4 | Non Unique | RETIREMENT_ID, BOOK_TYPE_CODE |
| FA_DISTRIBUTION_HISTORY_N5 | Non Unique | CODE_COMBINATION_ID |
| FA_DISTRIBUTION_HISTORY_N6 | Non Unique | LOCATION_ID |
| FA_DISTRIBUTION_HISTORY_N3 | Non Unique | TRANSACTION_HEADER_ID_OUT |
| FA_DISTRIBUTION_HISTORY_N1 | Non Unique | TRANSACTION_HEADER_ID_IN |