1. Tables and Views for Financials
  2. FA_ADJUSTMENTS

FA_ADJUSTMENTS

FA_ADJUSTMENTS stores information that Oracle Assets needs to create journal entries for transactions. The posting program creates journal entries for regular depreciation expense from information in FA_DEPRN_DETAIL. Oracle Assets inserts a row in this table for the debit and credit sides of a financial transaction. All the rows for the same transaction have the same value in the TRANSACTION_HEADER_ID column. . The SOURCE_TYPE_CODE column tells you which program created the adjustment: . {{FB}}ADDITION{{F0}} {{TAB}}Depreciation program . {{FB}}ADJUSTMENT{{F0}} {{TAB}}Expensed or Amortized Adjustment User Exit . {{FB}}CIP ADDITION{{F0}} {{TAB}}Depreciation program . {{FB}}CIP ADJUSTMENT{{F0}} {{TAB}}Expensed or Amortized Adjustment User Exit . {{FB}}CIP RETIREMENT{{F0}} {{TAB}}Gain/loss program . {{FB}}DEPRECIATION{{F0}} {{TAB}}Depreciation program (Retroactive transactions and expensed depreciation adjustments) . {{FB}}RETIREMENT{{F0}} {{TAB}}Gain/loss program . {{FB}}RECLASS{{F0}} {{TAB}}Reclassification user exit . {{FB}}TRANSFER{{F0}} {{TAB}}Transfers form . {{FB}}TAX{{F0}} {{TAB}}Reserve Adjustments form . {{FB}}REVALUATION{{F0}} {{TAB}}Mass revaluation program . . . The ADJUSTMENT_TYPE column tells you which type of account Oracle Assets adjusts. . DEBIT_CREDIT_FLAG is DR if the amount is a debit and CR if the amount is a credit. . ADJUSTMENT_AMOUNT is the amount debited or credited to the account. . ANNUALIZED_ADJUSTMENT is the adjustment amount for a period times the number of periods in a fiscal year. The depreciation program uses it to calculate the depreciation adjustment for an asset when you perform multiple retroactive transactions on the asset. Oracle Assets calculates ADJUSTMENT_PER_PERIOD by dividing the ADJUSTMENT_AMOUNT for a retroactive transaction by the number of periods between the period you entered the transaction and the period that it was effective. For current period transactions, this column is zero. . PERIOD_COUNTER_CREATED IS the period that you entered the adjustment into Oracle Assets. . PERIOD_COUNTER_ADJUSTED is the period to which the adjustment applies. It is the same as PERIOD_COUNTER_CREATED, unless you enter a reserve adjustment, in which case PERIOD_COUNTER_ADJUSTED is the last period of the fiscal year to which the adjustment applies. . CODE_COMBINATION_ID indicates the Accounting Flexfield combination Oracle Assets debits or credits for all transactions except reclassifications and intercompany transfers. This CODE_COMBINATION_ID is generated using the Account Generator, and the posting program does not perform any further processing. . .

Details

  • Schema: FUSION

  • Object owner: FA

  • Object type: TABLE

  • Tablespace: APPS_TS_TX_DATA

Primary Key

Name Columns

FA_ADJUSTMENTS_PK

TRANSACTION_HEADER_ID, ADJUSTMENT_LINE_ID

Columns

Name Datatype Length Precision Not-null Comments
TRANSACTION_HEADER_ID NUMBER 18 Yes Identifier of the asset transaction.
ADJUSTMENT_LINE_ID NUMBER 18 Yes Identifier of the asset accounting line.
SOURCE_TYPE_CODE VARCHAR2 15 Yes Asset transaction type of the accounting line.
ADJUSTMENT_TYPE VARCHAR2 15 Yes The type of account this row affects.
DEBIT_CREDIT_FLAG VARCHAR2 2 Yes Option indicating whether the line is Credit or Debit in the accounting entry for the asset transaction.
CODE_COMBINATION_ID NUMBER 18 Identifier of the account code combination to be used to account the asset transaction line.
BOOK_TYPE_CODE VARCHAR2 30 Yes Unique book identification name.
PERIOD_COUNTER_CREATED NUMBER 18 Yes Identifier of the depreciation period in which the transaction was performed.
PERIOD_COUNTER_ADJUSTED NUMBER 18 Yes Identifier of the depreciation period in which the transaction was effective.
ASSET_ID NUMBER 18 Yes Identifier of the asset number.
DISTRIBUTION_ID NUMBER 18 Yes Identifier of the asset distribution.
ADJUSTMENT_AMOUNT NUMBER Yes Amount of the asset adjustment broken down by the account type and asset distribution.
ANNUALIZED_ADJUSTMENT NUMBER Adjustment amount for a period multiplied by number of periods in fiscal year for retroactive transactions.
SOURCE_DEST_CODE VARCHAR2 15 Indicator of whether this line is on the source or destination side of a transaction.
SOURCE_LINE_ID NUMBER 18 Identifier of the asset source line.
ASSET_INVOICE_ID NUMBER 18 Identifier of the asset invoice.
DEPRN_OVERRIDE_FLAG VARCHAR2 1 Indicator as to whether the depreciation amount for the transaction is overridden or not.
TRACK_MEMBER_FLAG VARCHAR2 1 Option indicating whether the account information is created at the member asset level or at group asset level.
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.
INSERTION_ORDER NUMBER 18 The order of bonus reserve adjustment amount entered for prior period transfer.
COUNTERPARTY_DIST_ID NUMBER 18 Identifier of the counterparty asset distribution for a book transfer transaction.

Foreign Keys

Table Foreign Table Foreign Key Column
FA_ADJUSTMENTS fa_transaction_headers TRANSACTION_HEADER_ID, BOOK_TYPE_CODE
FA_ADJUSTMENTS fa_distribution_history DISTRIBUTION_ID, BOOK_TYPE_CODE
FA_ADJUSTMENTS fa_book_controls BOOK_TYPE_CODE
FA_ADJUSTMENTS fa_additions_b ASSET_ID
FA_ADJUSTMENTS gl_code_combinations CODE_COMBINATION_ID
FA_ADJUSTMENTS fa_asset_invoices SOURCE_LINE_ID
FA_ADJUSTMENTS fa_deprn_periods BOOK_TYPE_CODE, PERIOD_COUNTER_ADJUSTED
FA_ADJUSTMENTS fa_deprn_periods BOOK_TYPE_CODE, PERIOD_COUNTER_CREATED

Indexes

Index Uniqueness Tablespace Columns
FA_ADJUSTMENTS_N1 Non Unique Default DISTRIBUTION_ID, BOOK_TYPE_CODE, PERIOD_COUNTER_CREATED, SOURCE_TYPE_CODE, ADJUSTMENT_TYPE
FA_ADJUSTMENTS_N2 Non Unique Default ASSET_ID, BOOK_TYPE_CODE, PERIOD_COUNTER_CREATED
FA_ADJUSTMENTS_N4 Non Unique Default PERIOD_COUNTER_CREATED, BOOK_TYPE_CODE
FA_ADJUSTMENTS_U1 Unique Default TRANSACTION_HEADER_ID, ADJUSTMENT_LINE_ID