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.
Problems that run through this table