Oracle Fusion · Data dictionary
INV_CYCLE_COUNT_HEADERS
InventoryUsed in 3 subject areas23 reporting columns
Inventory (INV), header table, one row per transaction or event (with detail in the paired _LINES table).
Likely primary key: CYCLE_COUNT_HEADER_ID (inferred from Oracle naming conventions, verify against Tables & Views)
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ALLOW_SERIAL_ITEMS | ● | Allow serial items. | |
| APPROVAL_REQUIRED | ● | Approval required. | |
| APPROVAL_TOLERANCE_NEGATIVE | ● | Approval tolerance negative. | |
| APPROVAL_TOLERANCE_POSITIVE | ● | Approval tolerance positive. | |
| AUTOSCHEDULE_ENABLED_FLAG | ● | Indicator (Y/N) for the autoschedule enabled. | |
| COST_TOLERANCE_NEGATIVE | ● | Cost tolerance negative. | |
| COST_TOLERANCE_POSITIVE | ● | Cost tolerance positive. | |
| CYCLE_COUNT_HEADER_ID | PK? | ○ | Identifier for the cycle count header. |
| CYCLE_COUNT_HEADER_NAME | ● | Name of the cycle count header. | |
| DAYS_UNTIL_LATE | ● | Days until late. | |
| DESCRIPTION | ● | Description. | |
| HIT_MISS_TOLERANCE_NEGATIVE | ● | Hit miss tolerance negative. | |
| HIT_MISS_TOLERANCE_POSITIVE | ● | Hit miss tolerance positive. | |
| MAXIMUM_AUTO_RECOUNTS | ● | Maximum auto recounts. | |
| NEXT_USER_COUNT_SEQUENCE | ● | Next user count sequence. | |
| ONHAND_VISIBLE_FLAG | ● | Indicator (Y/N) for the onhand visible. | |
| SCHEDULE_INTERVAL_TIME | ● | Schedule interval time. | |
| SERIAL_ADJUSTMENT_OPTION | ● | Serial adjustment option. | |
| SERIAL_COUNT_OPTION | ● | Serial count option. | |
| SERIAL_DETAIL_OPTION | ● | Serial detail option. | |
| SERIAL_DISCREPANCY_OPTION | ● | Serial discrepancy option. | |
| START_MANUAL_COUNTS_PREFIX | ● | Start manual counts prefix. | |
| UNSCHEDULED_COUNT_ENTRY | ● | Unscheduled count entry. | |
| ZERO_COUNT_FLAG | ● | Indicator (Y/N) for the zero count. |
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.
- Costing - Cost Accounting Real Time
- Inventory - Inventory Cycle Count Real Time
- Inventory - Inventory Transactions Real Time
Need the extract + dbt staging for INV_CYCLE_COUNT_HEADERS?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table