Analytics Catalog/Data dictionary/INV_CYCLE_COUNT_ENTRIES
Explore the catalogReportsModulesEnterprise modelOTBI subject areasBICC PVOs
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

ColumnKeyIn reportsDescription (inferred)
ADJUSTMENT_AMOUNTAdjustment amount.
ADJUSTMENT_DATEAdjustment date.
ADJUSTMENT_QUANTITYAdjustment quantity.
APPROVAL_TYPEType of approval.
COUNT_DUE_DATECount due date.
COUNT_LIST_SEQUENCECount list sequence.
COUNT_QUANTITYCount quantity.
COUNT_SECONDARY_UOMCount secondary unit of measure.
COUNT_TYPE_CODECode identifying the count type.
COUNT_UOMCount unit of measure.
CREATION_DATEDate and time the row was created.
CYCLE_COUNT_ENTRY_IDIdentifier for the cycle count entry.
ENTRY_STATUS_CODECode identifying the entry status.
EXPORT_FLAGIndicator (Y/N) for the export.
ITEM_UNIT_COSTItem unit cost.
LOT_NUMBERLot number.
NUMBER_OF_COUNTSNumber of counts.
OWNING_TYPEType of owning.
PRIMARY_UOM_QUANTITYPrimary unit of measure quantity.
REVISIONRevision.
SECONDARY_ADJUSTMENT_QUANTITYSecondary adjustment quantity.
SECONDARY_SYSTEM_QTYSecondary system quantity.
SECONDARY_UOM_QUANTITYSecondary unit of measure quantity.
SERIAL_NUMBERSerial number.
SYSTEM_QUANTITYSystem 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.
Talk to us