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 |