Oracle Fusion · Data dictionary
INV_SECONDARY_LOCATORS
InventoryUsed in 3 subject areas7 reporting columns
Inventory (INV).
Primary key: not yet catalogued for INV_SECONDARY_LOCATORS — reference Oracle Tables & Views guide.
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| COUNT_REQUIRED | ● | Count required. | |
| DEFAULT_COUNT_TYPE_CODE | ● | Code identifying the default count type. | |
| PAR_LEVEL | ● | Par level. | |
| PAR_MAX_QTY | ● | Par max quantity. | |
| PAR_UOM_CODE | ● | Code identifying the par unit of measure. | |
| QTY_COUNT_TOLERANCE | ● | Quantity count tolerance. | |
| SUBINVENTORY_CODE | ● | Code identifying the subinventory. |
Used by reports
No cataloged report reads from this table yet — it's part of the broader Fusion dictionary.
- —
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.
- Inventory - Inventory Balance Real Time
- Inventory - Inventory Transactions Real Time
- Inventory Organization Real Time
Need the extract + dbt staging for INV_SECONDARY_LOCATORS?
We ship parameterized SQL, BICC config, and dbt models you own.