[Home] [Help] [Dependency Information]

TABLE: FA.FA_ADJUSTMENTS

Object Details

Object Name:	FA_ADJUSTMENTS
Object Type:	TABLE
Owner:	FA
FND Design Data:	OFA.FA_ADJUSTMENTS
Subobject Name:
Status:	VALID

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.
.
.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FA_ADJUSTMENTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	TRANSACTION_HEADER_ID ADJUSTMENT_LINE_ID
FA_ADJUSTMENTS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DISTRIBUTION_ID BOOK_TYPE_CODE PERIOD_COUNTER_CREATED SOURCE_TYPE_CODE ADJUSTMENT_TYPE
FA_ADJUSTMENTS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ASSET_ID BOOK_TYPE_CODE PERIOD_COUNTER_CREATED
FA_ADJUSTMENTS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	JE_HEADER_ID JE_LINE_NUM
FA_ADJUSTMENTS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PERIOD_COUNTER_CREATED BOOK_TYPE_CODE
FA_ADJUSTMENTS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CODE_COMBINATION_ID BOOK_TYPE_CODE PERIOD_COUNTER_CREATED

Columns

Query Text

Cut, paste (and edit) the following text to query this object:

SELECT TRANSACTION_HEADER_ID
,      SOURCE_TYPE_CODE
,      ADJUSTMENT_TYPE
,      DEBIT_CREDIT_FLAG
,      CODE_COMBINATION_ID
,      BOOK_TYPE_CODE
,      ASSET_ID
,      ADJUSTMENT_AMOUNT
,      DISTRIBUTION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      ANNUALIZED_ADJUSTMENT
,      JE_HEADER_ID
,      JE_LINE_NUM
,      PERIOD_COUNTER_ADJUSTED
,      PERIOD_COUNTER_CREATED
,      ASSET_INVOICE_ID
,      GLOBAL_ATTRIBUTE1
,      GLOBAL_ATTRIBUTE2
,      GLOBAL_ATTRIBUTE3
,      GLOBAL_ATTRIBUTE4
,      GLOBAL_ATTRIBUTE5
,      GLOBAL_ATTRIBUTE6
,      GLOBAL_ATTRIBUTE7
,      GLOBAL_ATTRIBUTE8
,      GLOBAL_ATTRIBUTE9
,      GLOBAL_ATTRIBUTE10
,      GLOBAL_ATTRIBUTE11
,      GLOBAL_ATTRIBUTE12
,      GLOBAL_ATTRIBUTE13
,      GLOBAL_ATTRIBUTE14
,      GLOBAL_ATTRIBUTE15
,      GLOBAL_ATTRIBUTE16
,      GLOBAL_ATTRIBUTE17
,      GLOBAL_ATTRIBUTE18
,      GLOBAL_ATTRIBUTE19
,      GLOBAL_ATTRIBUTE20
,      GLOBAL_ATTRIBUTE_CATEGORY
,      DEPRN_OVERRIDE_FLAG
,      TRACK_MEMBER_FLAG
,      ADJUSTMENT_LINE_ID
,      SOURCE_LINE_ID
,      SOURCE_DEST_CODE
,      INSERTION_ORDER
FROM FA.FA_ADJUSTMENTS;

Dependencies

[top of page]

FA.FA_ADJUSTMENTS does not reference any database object

FA.FA_ADJUSTMENTS is referenced by following:

FA

FA_ADJUSTMENTS#