1. Tables and Views for SCM
  2. INV_CYCLE_COUNT_ENTRIES

INV_CYCLE_COUNT_ENTRIES

INV_CYCLE_COUNT_ENTRIES stores the actual counts of a cycle count. A row in this table without a count is considered to be a count request. Oracle Inventory uses this information to determine and store cycle count adjustments, recounts, and approval requirements. . When a cycle count adjustment is approved, the count status is set to completed and the adjustment amount field is populated. The Cycle Count Approval form then calls a user exit to post an entry in the INV_MATERIAL_TXNS_TEMP, from which the Oracle Inventory Transaction Processor picks it up and does the accounting, costing, and history update. .

Details

  • Schema: FUSION

  • Object owner: INV

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

INV_CC_ENTRIES_PK

CYCLE_COUNT_ENTRY_ID

Columns

Name Datatype Length Precision Not-null Comments Flexfield-mapping Status
CYCLE_COUNT_ENTRY_ID NUMBER 18 Yes Primary key of the cycle count entry. Active
INV_STRIPING_CATEGORY VARCHAR2 40 Segment used to identify the descriptive flexfield application context for Inventory striping attributes
PROJECT_ID NUMBER 18 Identifier of the project used to stripe Inventory transactions
TASK_ID NUMBER 18 Identifier of the task used to stripe Inventory transactions
COUNTRY_OF_ORIGIN_CODE VARCHAR2 2 Code for the country of manufacture used to stripe Inventory transactions
INV_RESERVED_ATTRIBUTE1 VARCHAR2 150 Reserved for future Inventory striping related functionality
INV_RESERVED_ATTRIBUTE2 VARCHAR2 150 Reserved for future Inventory striping related functionality
INV_USER_DEF_ATTRIBUTE1 VARCHAR2 150 Reserved for user-definable Inventory striping information
INV_USER_DEF_ATTRIBUTE2 VARCHAR2 150 Reserved for user-definable Inventory striping information
INV_USER_DEF_ATTRIBUTE3 VARCHAR2 150 Reserved for user-definable Inventory striping information
INV_USER_DEF_ATTRIBUTE4 VARCHAR2 150 Reserved for user-definable Inventory striping information
INV_USER_DEF_ATTRIBUTE5 VARCHAR2 150 Reserved for user-definable Inventory striping information
INV_USER_DEF_ATTRIBUTE6 VARCHAR2 150 Reserved for user-definable Inventory striping information
INV_USER_DEF_ATTRIBUTE7 VARCHAR2 150 Reserved for user-definable Inventory striping information
INV_USER_DEF_ATTRIBUTE8 VARCHAR2 150 Reserved for user-definable Inventory striping information
INV_USER_DEF_ATTRIBUTE9 VARCHAR2 150 Reserved for user-definable Inventory striping information
INV_USER_DEF_ATTRIBUTE10 VARCHAR2 150 Reserved for user-definable Inventory striping information
OWNING_TYPE VARCHAR2 30 The owning type identifies the type of the entity who owns this quantity, in the context of consignment; the lookup type INV_OWNING_TYPES has the valid values. The record is consigned only if OWNING_TYPE is populated.
OWNING_ENTITY_ID NUMBER 18 This identifies the owning entity.
JOB_DEFINITION_PACKAGE VARCHAR2 900 Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. Active
JOB_DEFINITION_NAME VARCHAR2 100 Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. Active
CYCLE_COUNT_HEADER_ID NUMBER 18 Yes Identifies the cycle count header. Active
ORGANIZATION_ID NUMBER 18 Yes This identifies the inventory organization. Active
COUNT_LIST_SEQUENCE NUMBER 18 Sequence number in Count List Report Active
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row. Active
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row. Active
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row. Active
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. Active
INVENTORY_ITEM_ID NUMBER 18 Yes This identifies the inventory item. Active
SUBINVENTORY VARCHAR2 10 Yes This is name of the subinventory. Active
LOCATOR_ID NUMBER 18 This identifies the item locator. Active
REVISION VARCHAR2 18 Revision of item if under revision control. Active
LOT_NUMBER VARCHAR2 80 This number identifies an inventory lot. Active
SERIAL_NUMBER VARCHAR2 80 Serial number to be counted in case of 'ONE SERIAL NUMBER / COUNT' option Active
SERIAL_DETAIL NUMBER 18 Detail level of serial count, 1-Quantity and Serial Numbers,2-Quantity Only Active
ENTRY_STATUS_CODE VARCHAR2 30 This code indicates the current status of count entry. Active
COUNT_DATE DATE This is the date of current count. Active
COUNT_DUE_DATE DATE Date by which this count should be completed. Active
COUNTED_BY_EMPLOYEE_ID NUMBER 18 Identifier of employee who made the current count Active
COUNT_UOM VARCHAR2 3 Unit of measure of the current count Active
COUNT_SECONDARY_UOM VARCHAR2 3 Secondary unit of measure of the current count Active
COUNT_QUANTITY NUMBER This is the count quantity in COUNT_UOM. Active
PRIMARY_UOM_QUANTITY NUMBER Quantity of current count at item's primary unit of measure Active
SECONDARY_UOM_QUANTITY NUMBER Quantity Of the current Count In Secondary Unit Of Measure Of Item Active
SYSTEM_QUANTITY NUMBER System quantity at time of current count Active
SECONDARY_SYSTEM_QTY NUMBER Secondary system quantity at time of current count Active
ADJUSTMENT_QUANTITY NUMBER Quantity of adjustment to bring system quantity in line with count quantity Active
SECONDARY_ADJUSTMENT_QUANTITY NUMBER Secondary quantity of adjustment to bring secondary system quantity in line with secondary count quantity Active
ADJUSTMENT_DATE DATE Date adjustment transaction was posted Active
ADJUSTMENT_AMOUNT NUMBER This is cost of adjustment transaction. Active
ITEM_UNIT_COST NUMBER This is cost of the item per unit. Active
NUMBER_OF_COUNTS NUMBER 18 Number of counts that have been made on this entry Active
APPROVAL_TYPE NUMBER 18 Type of approval given, 1-Automatic,2-Manual,3-Preapproved Active
APPROVAL_DATE DATE Date when adjustment was approved. Active
APPROVER_EMPLOYEE_ID NUMBER 18 Identifier of employee who approved the adjustment Active
TRANSACTION_REASON_ID NUMBER 18 Reason adjustment transaction was performed Active
COMMENTS VARCHAR2 240 Notes pertaining to the current count Active
COUNT_TYPE_CODE VARCHAR2 30 Indicates the type of count performed. Active
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. Active
EXPORT_FLAG NUMBER 18 Flag indicates if this is exported: 1=yes; 2=no. Active
PARENT_LPN_ID NUMBER 18 Parent LPN Identifier of the item. Active
OUTERMOST_LPN_ID NUMBER 18 Outermost LPN Identifier of the item. Active
STANDARD_OPERATION_ID NUMBER 18 This identifies the standard operation . Used by WMS only. Active
TASK_PRIORITY NUMBER 18 This is the task priority. Used by WMS only. Active
ITEM_REVISION_QTY_CONTROL_CODE VARCHAR2 30 Inventory Item Revision quantity control code. Active
ITEM_SERIAL_CONTROL_CODE VARCHAR2 30 Inventory Item Serial Number control code. Active
ITEM_LOT_CONTROL_CODE VARCHAR2 30 Inventory Item Lot Control Code. Active
ATTRIBUTE_CATEGORY VARCHAR2 30 Descriptive Flexfield: structure definition of the user descriptive flexfield. Cycle Count Entries (INV_CYCLE_COUNT_ENTRIES) Active
ATTRIBUTE1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Cycle Count Entries (INV_CYCLE_COUNT_ENTRIES) Active
ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Cycle Count Entries (INV_CYCLE_COUNT_ENTRIES) Active
ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Cycle Count Entries (INV_CYCLE_COUNT_ENTRIES) Active
ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Cycle Count Entries (INV_CYCLE_COUNT_ENTRIES) Active
ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Cycle Count Entries (INV_CYCLE_COUNT_ENTRIES) Active
ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Cycle Count Entries (INV_CYCLE_COUNT_ENTRIES) Active
ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Cycle Count Entries (INV_CYCLE_COUNT_ENTRIES) Active
ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Cycle Count Entries (INV_CYCLE_COUNT_ENTRIES) Active
ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Cycle Count Entries (INV_CYCLE_COUNT_ENTRIES) Active
ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Cycle Count Entries (INV_CYCLE_COUNT_ENTRIES) Active
ATTRIBUTE11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Cycle Count Entries (INV_CYCLE_COUNT_ENTRIES) Active
ATTRIBUTE12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Cycle Count Entries (INV_CYCLE_COUNT_ENTRIES) Active
ATTRIBUTE13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Cycle Count Entries (INV_CYCLE_COUNT_ENTRIES) Active
ATTRIBUTE14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Cycle Count Entries (INV_CYCLE_COUNT_ENTRIES) Active
ATTRIBUTE15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Cycle Count Entries (INV_CYCLE_COUNT_ENTRIES) Active
STANDARD_PACK_UOM_FLAG VARCHAR2 1 Identifier to decide if the Count Uom is a Standard Pack Uom or not. Active
ATTRIBUTE16 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Cycle Count Entries (INV_CYCLE_COUNT_ENTRIES)
ATTRIBUTE17 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Cycle Count Entries (INV_CYCLE_COUNT_ENTRIES)
ATTRIBUTE18 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Cycle Count Entries (INV_CYCLE_COUNT_ENTRIES)
ATTRIBUTE19 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Cycle Count Entries (INV_CYCLE_COUNT_ENTRIES)
ATTRIBUTE20 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Cycle Count Entries (INV_CYCLE_COUNT_ENTRIES)
ATTRIBUTE_NUMBER1 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Cycle Count Entries (INV_CYCLE_COUNT_ENTRIES)
ATTRIBUTE_NUMBER2 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Cycle Count Entries (INV_CYCLE_COUNT_ENTRIES)
ATTRIBUTE_NUMBER3 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Cycle Count Entries (INV_CYCLE_COUNT_ENTRIES)
ATTRIBUTE_NUMBER4 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Cycle Count Entries (INV_CYCLE_COUNT_ENTRIES)
ATTRIBUTE_NUMBER5 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Cycle Count Entries (INV_CYCLE_COUNT_ENTRIES)
ATTRIBUTE_NUMBER6 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Cycle Count Entries (INV_CYCLE_COUNT_ENTRIES)
ATTRIBUTE_NUMBER7 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Cycle Count Entries (INV_CYCLE_COUNT_ENTRIES)
ATTRIBUTE_NUMBER8 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Cycle Count Entries (INV_CYCLE_COUNT_ENTRIES)
ATTRIBUTE_NUMBER9 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Cycle Count Entries (INV_CYCLE_COUNT_ENTRIES)
ATTRIBUTE_NUMBER10 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Cycle Count Entries (INV_CYCLE_COUNT_ENTRIES)
ATTRIBUTE_DATE1 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Cycle Count Entries (INV_CYCLE_COUNT_ENTRIES)
ATTRIBUTE_DATE2 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Cycle Count Entries (INV_CYCLE_COUNT_ENTRIES)
ATTRIBUTE_DATE3 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Cycle Count Entries (INV_CYCLE_COUNT_ENTRIES)
ATTRIBUTE_DATE4 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Cycle Count Entries (INV_CYCLE_COUNT_ENTRIES)
ATTRIBUTE_DATE5 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Cycle Count Entries (INV_CYCLE_COUNT_ENTRIES)
ATTRIBUTE_TIMESTAMP1 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield. Cycle Count Entries (INV_CYCLE_COUNT_ENTRIES)
ATTRIBUTE_TIMESTAMP2 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield. Cycle Count Entries (INV_CYCLE_COUNT_ENTRIES)
ATTRIBUTE_TIMESTAMP3 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield. Cycle Count Entries (INV_CYCLE_COUNT_ENTRIES)
ATTRIBUTE_TIMESTAMP4 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield. Cycle Count Entries (INV_CYCLE_COUNT_ENTRIES)
ATTRIBUTE_TIMESTAMP5 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield. Cycle Count Entries (INV_CYCLE_COUNT_ENTRIES)

Foreign Keys

Table Foreign Table Foreign Key Column
INV_CYCLE_COUNT_ENTRIES inv_transaction_reasons_b TRANSACTION_REASON_ID
INV_CYCLE_COUNT_ENTRIES egp_item_org_associations INVENTORY_ITEM_ID, ORGANIZATION_ID
INV_CYCLE_COUNT_ENTRIES inv_secondary_inventories SUBINVENTORY, ORGANIZATION_ID
INV_CYCLE_COUNT_ENTRIES inv_org_parameters ORGANIZATION_ID
INV_CYCLE_COUNT_ENTRIES inv_cycle_count_headers CYCLE_COUNT_HEADER_ID
INV_CYCLE_COUNT_ENTRIES inv_item_locations LOCATOR_ID
inv_cc_entries_interface inv_cycle_count_entries CYCLE_COUNT_ENTRY_ID
inv_cc_entries_history inv_cycle_count_entries CYCLE_COUNT_ENTRY_ID
inv_cc_sched_count_xrefs inv_cycle_count_entries CYCLE_COUNT_ENTRY_ID
inv_cc_serial_numbers inv_cycle_count_entries CYCLE_COUNT_ENTRY_ID

Indexes

Index Uniqueness Tablespace Columns
INV_CC_ENTRIES_N1 Non Unique FUSION_TS_TX_IDX CYCLE_COUNT_HEADER_ID, ORGANIZATION_ID, INVENTORY_ITEM_ID, SUBINVENTORY, LOCATOR_ID, REVISION, LOT_NUMBER
INV_CC_ENTRIES_N2 Non Unique FUSION_TS_TX_IDX CYCLE_COUNT_HEADER_ID, ORGANIZATION_ID, SUBINVENTORY, COUNT_LIST_SEQUENCE
INV_CC_ENTRIES_N6 Non Unique FUSION_TS_TX_IDX ENTRY_STATUS_CODE, COUNT_DUE_DATE, EXPORT_FLAG
INV_CC_ENTRIES_N7 Non Unique FUSION_TS_TX_IDX ORGANIZATION_ID, STANDARD_OPERATION_ID
INV_CC_ENTRIES_N8 Non Unique FUSION_TS_TX_IDX LAST_UPDATE_DATE
INV_CC_ENTRIES_U1 Unique FUSION_TS_TX_IDX CYCLE_COUNT_ENTRY_ID