Oracle Fusion · Data dictionary
INV_CYCLE_COUNT_ENTRIES
InventoryUsed in 1 subject areas25 reporting columns
Inventory (INV).
Primary key: not yet catalogued for INV_CYCLE_COUNT_ENTRIES — reference Oracle Tables & Views guide.
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ADJUSTMENT_AMOUNT | ● | Adjustment amount. | |
| ADJUSTMENT_DATE | ● | Adjustment date. | |
| ADJUSTMENT_QUANTITY | ● | Adjustment quantity. | |
| APPROVAL_TYPE | ● | Type of approval. | |
| COUNT_DUE_DATE | ● | Count due date. | |
| COUNT_LIST_SEQUENCE | ● | Count list sequence. | |
| COUNT_QUANTITY | ● | Count quantity. | |
| COUNT_SECONDARY_UOM | ● | Count secondary unit of measure. | |
| COUNT_TYPE_CODE | ● | Code identifying the count type. | |
| COUNT_UOM | ● | Count unit of measure. | |
| CREATION_DATE | ● | Date and time the row was created. | |
| CYCLE_COUNT_ENTRY_ID | ● | Identifier for the cycle count entry. | |
| ENTRY_STATUS_CODE | ● | Code identifying the entry status. | |
| EXPORT_FLAG | ● | Indicator (Y/N) for the export. | |
| ITEM_UNIT_COST | ● | Item unit cost. | |
| LOT_NUMBER | ● | Lot number. | |
| NUMBER_OF_COUNTS | ● | Number of counts. | |
| OWNING_TYPE | ● | Type of owning. | |
| PRIMARY_UOM_QUANTITY | ● | Primary unit of measure quantity. | |
| REVISION | ● | Revision. | |
| SECONDARY_ADJUSTMENT_QUANTITY | ● | Secondary adjustment quantity. | |
| SECONDARY_SYSTEM_QTY | ● | Secondary system quantity. | |
| SECONDARY_UOM_QUANTITY | ● | Secondary unit of measure quantity. | |
| SERIAL_NUMBER | ● | Serial number. | |
| SYSTEM_QUANTITY | ● | System quantity. |
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.
Need the extract + dbt staging for INV_CYCLE_COUNT_ENTRIES?
We ship parameterized SQL, BICC config, and dbt models you own.