1. Tables and Views for SCM
  2. INV_CC_ENTRIES_INTERFACE

INV_CC_ENTRIES_INTERFACE

The INV_CC_ENTRIES_INTERFACE table serves as the interface between users and Oracle Inventory's Enter/Approve Cycle Count Request functionality. Users populate the interface table, and a PL/SQL concurrent program, launched by the user, processes the information in this table, inserts/updates the INV_CYCLE_COUNT_ENTRIES table, and spawns adjustment material transactions, if necessary.

Details

  • Schema: FUSION

  • Object owner: INV

  • Object type: TABLE

  • Tablespace: INTERFACE

Primary Key

Name Columns

INV_CC_ENTRIES_INTERFACE_PK

CC_ENTRY_INTERFACE_ID

Columns

Name Datatype Length Precision Not-null Comments Status
CC_ENTRY_INTERFACE_ID NUMBER 18 Yes Primary key of the cycle count interface entry. Active
JOB_DEFINITION_NAME VARCHAR2 100 Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. Active
JOB_DEFINITION_PACKAGE VARCHAR2 900 Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. Active
ORGANIZATION_ID NUMBER 18 This identifies the inventory organization. Active
ORGANIZATION_CODE VARCHAR2 18 This code indicates the inventory organization.
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
CC_ENTRY_INTERFACE_GROUP_ID NUMBER 18 Identifier used to group interface records into a set Active
CYCLE_COUNT_ENTRY_ID NUMBER 18 If this data record was exported, the unambiguous primary key is referenced in this column. Active
ACTION_CODE NUMBER 18 Yes Action code identifying which user actions/APIs to perform for the current record Active
CYCLE_COUNT_HEADER_ID NUMBER 18 Identifies the cycle count header. Active
CYCLE_COUNT_HEADER_NAME VARCHAR2 30 User visible name of this cycle count. The identifier by which each entry in the interface table is tied to a particular cycle count. Active
COUNT_LIST_SEQUENCE NUMBER 18 Input which identifies a particular open count request for the specified cycle count. If a corresponding open count request is found that matches the specified count sequence, then the item and SKU information is defaulted from the INV_CYCLE_COUNT_ENTRIES table. Otherwise the count request in the interface table is treated as an unscheduled count and the count sequence is inserted into the table along with the rest of the count request information. In this case, the item and SKU information is required. Active
INVENTORY_ITEM_ID NUMBER 18 Unique identifier of the inventory item Active
ITEM_SEGMENT1 VARCHAR2 40 This is an item flexfield segment. Active
ITEM_SEGMENT2 VARCHAR2 40 This is an item flexfield segment. Active
ITEM_SEGMENT3 VARCHAR2 40 This is an item flexfield segment. Active
ITEM_SEGMENT4 VARCHAR2 40 This is an item flexfield segment. Active
ITEM_SEGMENT5 VARCHAR2 40 This is an item flexfield segment. Active
ITEM_SEGMENT6 VARCHAR2 40 This is an item flexfield segment. Active
ITEM_SEGMENT7 VARCHAR2 40 This is an item flexfield segment. Active
ITEM_SEGMENT8 VARCHAR2 40 This is an item flexfield segment. Active
ITEM_SEGMENT9 VARCHAR2 40 This is an item flexfield segment. Active
ITEM_SEGMENT10 VARCHAR2 40 This is an item flexfield segment. Active
ITEM_SEGMENT11 VARCHAR2 40 This is an item flexfield segment. Active
ITEM_SEGMENT12 VARCHAR2 40 This is an item flexfield segment. Active
ITEM_SEGMENT13 VARCHAR2 40 This is an item flexfield segment. Active
ITEM_SEGMENT14 VARCHAR2 40 This is an item flexfield segment. Active
ITEM_SEGMENT15 VARCHAR2 40 This is an item flexfield segment. Active
ITEM_SEGMENT16 VARCHAR2 40 This is an item flexfield segment. Active
ITEM_SEGMENT17 VARCHAR2 40 This is an item flexfield segment. Active
ITEM_SEGMENT18 VARCHAR2 40 This is an item flexfield segment. Active
ITEM_SEGMENT19 VARCHAR2 40 This is an item flexfield segment. Active
ITEM_SEGMENT20 VARCHAR2 40 This is an item flexfield segment. Active
REVISION VARCHAR2 18 Revision of item if under revision control Active
SUBINVENTORY VARCHAR2 10 This is name of the subinventory. Active
LOCATOR_ID NUMBER 18 Unique identifier of the locator Active
LOCATOR_SEGMENT1 VARCHAR2 40 This is a locator flexfield segment. Active
LOCATOR_SEGMENT2 VARCHAR2 40 This is a locator flexfield segment. Active
LOCATOR_SEGMENT3 VARCHAR2 40 This is a locator flexfield segment. Active
LOCATOR_SEGMENT4 VARCHAR2 40 This is a locator flexfield segment. Active
LOCATOR_SEGMENT5 VARCHAR2 40 This is a locator flexfield segment. Active
LOCATOR_SEGMENT6 VARCHAR2 40 This is a locator flexfield segment. Active
LOCATOR_SEGMENT7 VARCHAR2 40 This is a locator flexfield segment. Active
LOCATOR_SEGMENT8 VARCHAR2 40 This is a locator flexfield segment. Active
LOCATOR_SEGMENT9 VARCHAR2 40 This is a locator flexfield segment. Active
LOCATOR_SEGMENT10 VARCHAR2 40 This is a locator flexfield segment. Active
LOCATOR_SEGMENT11 VARCHAR2 40 This is a locator flexfield segment. Active
LOCATOR_SEGMENT12 VARCHAR2 40 This is a locator flexfield segment. Active
LOCATOR_SEGMENT13 VARCHAR2 40 This is a locator flexfield segment. Active
LOCATOR_SEGMENT14 VARCHAR2 40 This is a locator flexfield segment. Active
LOCATOR_SEGMENT15 VARCHAR2 40 This is a locator flexfield segment. Active
LOCATOR_SEGMENT16 VARCHAR2 40 This is a locator flexfield segment. Active
LOCATOR_SEGMENT17 VARCHAR2 40 This is a locator flexfield segment. Active
LOCATOR_SEGMENT18 VARCHAR2 40 This is a locator flexfield segment. Active
LOCATOR_SEGMENT19 VARCHAR2 40 This is a locator flexfield segment. Active
LOCATOR_SEGMENT20 VARCHAR2 40 This is a locator flexfield segment. Active
LOT_NUMBER VARCHAR2 80 Lot number if item is under lot control Active
SERIAL_NUMBER VARCHAR2 80 Serial number if item is under serial control Active
PRIMARY_UOM_QUANTITY NUMBER Quantity of count at items primary unit of measure Active
COUNT_UOM VARCHAR2 3 Unit of measure of count quantity. Active
COUNT_UNIT_OF_MEASURE VARCHAR2 25 Unit of measure of the current count. Active
COUNT_QUANTITY NUMBER This is the count quantity in COUNT_UOM. Active
COUNT_DATE DATE Count date for current count request. This date is also used as the transaction date and approval date should an adjustment transaction be necessary. If this date is NULL, sysdate is defaulted for the count date Active
EMPLOYEE_ID NUMBER 18 This column identifies the employee. Active
EMPLOYEE_FULL_NAME VARCHAR2 240 Employee who performed the current count request/approval action Active
COMMENTS VARCHAR2 240 Reference for current count request. Also used as the transaction reference should an adjustment transaction be required Active
TRANSACTION_REASON_ID NUMBER 18 This identifies the transaction reason. Active
TRANSACTION_REASON VARCHAR2 30 Reason for the current row's cycle count entry as well as any necessary inventory adjustment transaction Active
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. Active
LOCK_FLAG NUMBER 18 Lock Flag, 1 - LOCK, 2 - UNLOCK Active
PROCESS_FLAG NUMBER 18 Process Flag, 1 - READY, 2 - NOT READY Active
PROCESS_MODE NUMBER 18 Process Mode, 1 - Online, 2 - Concurrent, 3 - Background Active
VALID_FLAG NUMBER 18 Valid Flag, 1 - VALID, 2 - INVALID Active
DELETE_FLAG NUMBER 18 Flag indicates if the record is to be deleted: 1=yes, 2=no. Active
STATUS_FLAG NUMBER 18 Statu Flag, 0-successful completed, 1-successful completed with warnings,2- processed with errors, 3 marked for recounting, 4 marked for reprocessing Active
ERROR_FLAG NUMBER 18 Error Flag, 1 - YES an error occurs, 2 - NO errors, NULL - not processed Active
ATTRIBUTE_CATEGORY VARCHAR2 30 Descriptive Flexfield: structure definition of the user descriptive flexfield. Active
ATTRIBUTE1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
SYSTEM_QUANTITY NUMBER System quantity. This information will be inserted, if this row is exported. Active
PARENT_LPN_ID NUMBER 18 Parent LPN ID - Used by WMS only Active
OUTERMOST_LPN_ID NUMBER 18 Outermost LPN ID - Used by WMS only Active
PARENT_LPN VARCHAR2 30 This is the parent lot number. Used by WMS only. Active
SECONDARY_COUNT_QUANTITY NUMBER This is the secondary count quantity. Active
SECONDARY_SYSTEM_QUANTITY NUMBER This is the secondary system quantity. Active
SECONDARY_UNIT_OF_MEASURE VARCHAR2 25 Secondary Unit of Measure Meaning Active
SECONDARY_UOM VARCHAR2 3 Unit of measure for secondary quantity. 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
ITEM_NUMBER VARCHAR2 300 Item Number (ITem KFF replacement for Fusion V1.0) Active
ATTRIBUTE16 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE17 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE18 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE19 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE20 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER1 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER2 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER3 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER4 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER5 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER6 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER7 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER8 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER9 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER10 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE1 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE2 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE3 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE4 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE5 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP1 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP2 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP3 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP4 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP5 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
LOAD_REQUEST_ID NUMBER 18 Used by Enterpraise Service Scheduler. Indicates the requset ID of the interface job that created the row.
OWNING_TYPE VARCHAR2 30 The column which stores the information if the material is consigned or not. 1- Consigned Material; 2- Own Material
OWNING_ENTITY_ID NUMBER 18 The Identifier for the Owning Entity Id. This would be populated for the consigned material with the vendor site id which holds the ownership for the material. For the own material it can be populated to the owning organization id.This maps to the OWNING_ENTITY_ID column INV_CYCLE_COUNT_ENTRIES table.
OWNING_ENTITY_CODE VARCHAR2 240 The column holds the value for the Owning Entity Code. This would be populated for the consigned material with the vendor site code which holds the ownership for the material. For the own material it can be populated to the owning organization code.
PRC_BU_NAME VARCHAR2 240 The column will hold the Procurement Business Unit Name in case the material in question is consigned. This column is required for deriving the Owning Entity for the consigned material.
VENDOR_NAME VARCHAR2 240 Vendor Name in case the material is consigned.
VENDOR_NUMBER VARCHAR2 30 Vendor Name in case the material is consigned.
CONSIGNMENT_AGREEMENT_NUM VARCHAR2 30 This column holds the cosnignment agreement number for the consigned material. Mostly to be populated if the the Vendor Name, Vendor Number, Procurement Business Unit, Vendor Site Code is insufficient to derive the Vendor Site Id (Owning Entity Id).
LOCATOR_NAME VARCHAR2 2000 This columns holds the concatenated segments for the locator flexfields. If the user does not wish to give the indidual segment values in the LOCATOR_SEGMENT1..LOCATOR_SEGMENT20 columns he can also provide the concatenated segments for the locator flexfield in this column.
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
INV_PROJECT VARCHAR2 25 Identifier of the project name used to stripe inventory transactions
TASK_ID NUMBER 18 Identifier of the task used to stripe inventory transactions
INV_TASK VARCHAR2 100 Identifier of the task name used to stripe inventory transactions
COUNTRY_OF_ORIGIN_CODE VARCHAR2 2 Code for the country of manufacture used to stripe inventory transactions
COUNTRY_OF_ORIGIN_NAME VARCHAR2 80 Name 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

Foreign Keys

Table Foreign Table Foreign Key Column
INV_CC_ENTRIES_INTERFACE inv_cycle_count_entries CYCLE_COUNT_ENTRY_ID
INV_CC_ENTRIES_INTERFACE inv_cycle_count_headers CYCLE_COUNT_HEADER_ID
INV_CC_ENTRIES_INTERFACE inv_item_locations LOCATOR_ID
INV_CC_ENTRIES_INTERFACE inv_lot_numbers INVENTORY_ITEM_ID, ORGANIZATION_ID, LOT_NUMBER
INV_CC_ENTRIES_INTERFACE inv_org_parameters ORGANIZATION_ID
INV_CC_ENTRIES_INTERFACE inv_secondary_inventories SUBINVENTORY, ORGANIZATION_ID
INV_CC_ENTRIES_INTERFACE egp_item_org_associations INVENTORY_ITEM_ID, ORGANIZATION_ID
INV_CC_ENTRIES_INTERFACE inv_transaction_reasons_b TRANSACTION_REASON_ID
inv_cc_interface_errors inv_cc_entries_interface CC_ENTRY_INTERFACE_ID

Indexes

Index Uniqueness Tablespace Columns Status
INV_CC_ENTRIES_INTRFC_N1 Non Unique FUSION_TS_TX_IDX ACTION_CODE, CYCLE_COUNT_HEADER_ID
INV_CC_ENTRIES_INTRFC_N2 Non Unique FUSION_TS_TX_IDX ORGANIZATION_ID, INVENTORY_ITEM_ID, LOCATOR_ID
INV_CC_ENTRIES_INTRFC_N3 Non Unique FUSION_TS_TX_IDX CYCLE_COUNT_HEADER_ID
INV_CC_ENTRIES_INTRFC_N4 Non Unique FUSION_TS_TX_IDX ORGANIZATION_CODE, CYCLE_COUNT_HEADER_NAME, STATUS_FLAG
INV_CC_ENTRIES_INTRFC_U1 Unique FUSION_TS_TX_IDX CC_ENTRY_INTERFACE_ID Active