Oracle Fusion · Data dictionary
FA_ASSET_INVOICES
Fixed AssetsUsed in 2 subject areas15 reporting columns
Fixed Assets (FA).
Primary key: ASSET_ID, ASSET_INVOICE_ID
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| AP_DISTRIBUTION_LINE_NUMBER | ● | Payables distribution line number. | |
| ASSET_ID | PK | ○ | Identifier for the asset. |
| ASSET_INVOICE_ID | PK | ○ | Identifier for the asset invoice. |
| DATE_EFFECTIVE | ● | Date effective. | |
| DELETED_FLAG | ● | Indicator (Y/N) for the deleted. | |
| DESCRIPTION | ● | Description. | |
| FIXED_ASSETS_COST | ● | Fixed assets cost. | |
| INVOICE_DATE | ● | Invoice date. | |
| INVOICE_LINE_NUMBER | ● | Invoice line number. | |
| INVOICE_NUMBER | ● | Invoice number. | |
| MATERIAL_INDICATOR_FLAG | ● | Indicator (Y/N) for the material indicator. | |
| PAYABLES_BATCH_NAME | ● | Name of the payables batch. | |
| PAYABLES_COST | ● | Payables cost. | |
| PAYABLES_UNITS | ● | Payables units. | |
| PO_NUMBER | ● | Purchase order number. | |
| SPLIT_MERGED_CODE | ● | Code identifying the split merged. | |
| UNREVALUED_COST | ● | Unrevalued cost. |
1 report read from this table
Change a column here and these are the reports that move with it — the blast radius for any change to FA_ASSET_INVOICES.
Where this surfaces in OTBI
The OTBI subject areas that expose this table. You can't join across them in OTBI — the owned conformed model joins them on shared keys.
Need the extract + dbt staging for FA_ASSET_INVOICES?
We ship parameterized SQL, BICC config, and dbt models you own.