1. Tables and Views for SCM
  2. INV_CYCLE_COUNT_HEADERS

INV_CYCLE_COUNT_HEADERS

INV_CYCLE_COUNT_HEADERS stores information about cycle count names. . Oracle Inventory uses this information to keep track of all cycle count names defined, to indicate tolerance/approval limits, cycle count calendar and exception set, ABC initialization information, scheduling options, and recount options. . A cycle count name is also a management entity, whose purpose is to be the repository of cycle count requirements for a specific application. A cycle count name is used in performance reports, accuracy reports, and in grouping scheduling requests, count requests, count entries and approvals. . .

Details

  • Schema: FUSION

  • Object owner: INV

  • Object type: TABLE

  • Tablespace: APPS_TS_TX_DATA

Primary Key

Name Columns

INV_CYCLE_COUNT_HEADERS_PK

CYCLE_COUNT_HEADER_ID

Columns

Name Datatype Length Precision Not-null Comments Flexfield-mapping
CYCLE_COUNT_HEADER_ID NUMBER 18 Yes Primary key of the cycle count header.
CYCLE_COUNT_HEADER_NAME VARCHAR2 30 Yes User-visible name of this cycle count
DESCRIPTION VARCHAR2 240 Description of this cycle count
ORGANIZATION_ID NUMBER 18 Yes This identifies the inventory organization.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
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.
ABC_ASSIGNMENT_GROUP_ID NUMBER 18 ABC group from which item-classification was initialized
ABC_INITIALIZATION_STATUS NUMBER 18 Processing status of the item-initialization process
COUNT_BY_CATEGORY_FLAG NUMBER 18 Whether or not Item Category is used for item-classification
AUTOSCHEDULE_ENABLED_FLAG NUMBER 18 Yes Whether or not count-scheduling should be done automatically by Oracle Inventory
SCHEDULE_INTERVAL_TIME VARCHAR2 30 Time interval between two consecutive scheduling runs
WORKDAY_SCHEDULE NUMBER 18 Yes The Schedule associated with the Count
HEADER_LAST_SCHEDULE_DATE DATE Date of last scheduling run for this cycle count
HEADER_NEXT_SCHEDULE_DATE DATE Date that this cycle count should next be scheduled
APPROVAL_REQUIRED NUMBER 18 Yes To indicate whether the Approval is required or not
APPROVAL_OPTION_CODE VARCHAR2 30 Approval required for adjustment transactions
DEFAULT_APPROVER NUMBER 18 This column holds the Identifier for the user/person who is marked as the default approver for the count
OVERRIDE_DEFAULT_APPROVER NUMBER 18 This column indicates that if other users (other than the default approver) can also have access to approve the count sequences
APPROVAL_TOLERANCE_POSITIVE NUMBER Positive percent tolerance, above which an adjustment transaction requires explicit approval
APPROVAL_TOLERANCE_NEGATIVE NUMBER Negative percent tolerance, below which an adjustment transaction requires explicit approval
COST_TOLERANCE_POSITIVE NUMBER Positive currency tolerance, above which an adjustment transaction requires explicit approval
COST_TOLERANCE_NEGATIVE NUMBER Negative currency tolerance, below which an adjustment transaction requires explicit approval
NEXT_USER_COUNT_SEQUENCE NUMBER 18 Next sequence-number for the Count List Report
DAYS_UNTIL_LATE NUMBER 18 Number of days after a count is scheduled that it is considered late
MAXIMUM_AUTO_RECOUNTS NUMBER 18 Maximum number of recounts Oracle Inventory will automatically order
START_DATE DATE Yes Start Date for this Cycle Count
END_DATE DATE This is the end date for this cycle count.
UNSCHEDULED_COUNT_ENTRY NUMBER 18 Whether or not to allow unscheduled counts to be entered
ZERO_COUNT_FLAG NUMBER 18 Whether or not cycle counts should be requested for SKU's with system quantity of zero
ONHAND_VISIBLE_FLAG NUMBER 18 Whether or not to display onhand quantity during count entry
ALLOW_SERIAL_ITEMS NUMBER 18 Yes Flag to indicate whether to indicate Serial Items or not in the Count Scope
SERIAL_COUNT_OPTION VARCHAR2 30 Options for including serial controlled items in the count generation
SERIAL_DETAIL_OPTION NUMBER 18 Detail level for counting serial controlled items
SERIAL_ADJUSTMENT_OPTION VARCHAR2 30 Adjustment options for adjustment in serial controlled items
SERIAL_DISCREPANCY_OPTION NUMBER 18 "Allow/Do not allow" discrepancy while counting serial controlled items
CONTAINER_ADJUSTMENT_OPTION NUMBER 18 Container Adjustment Option - Used by WMS only
CONTAINER_DISCREPANCY_OPTION NUMBER 18 Container Discrepancy Option - Used by WMS only
CONTAINER_ENABLED_FLAG NUMBER 18 Container Option Enabled Flag - Used by WMS only
HIT_MISS_TOLERANCE_POSITIVE NUMBER Positive percent tolerance used for hit/miss analysis
HIT_MISS_TOLERANCE_NEGATIVE NUMBER Negative percent tolerance used for hit/miss analysis
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
JOB_DEFINITION_NAME VARCHAR2 100 Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.
JOB_DEFINITION_PACKAGE VARCHAR2 900 Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.
ATTRIBUTE_CATEGORY VARCHAR2 30 Descriptive Flexfield: structure definition of the user descriptive flexfield. Cycle Count Headers (INV_CYCLE_COUNT_HEADERS)
ATTRIBUTE1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Cycle Count Headers (INV_CYCLE_COUNT_HEADERS)
ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Cycle Count Headers (INV_CYCLE_COUNT_HEADERS)
ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Cycle Count Headers (INV_CYCLE_COUNT_HEADERS)
ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Cycle Count Headers (INV_CYCLE_COUNT_HEADERS)
ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Cycle Count Headers (INV_CYCLE_COUNT_HEADERS)
ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Cycle Count Headers (INV_CYCLE_COUNT_HEADERS)
ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Cycle Count Headers (INV_CYCLE_COUNT_HEADERS)
ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Cycle Count Headers (INV_CYCLE_COUNT_HEADERS)
ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Cycle Count Headers (INV_CYCLE_COUNT_HEADERS)
ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Cycle Count Headers (INV_CYCLE_COUNT_HEADERS)
ATTRIBUTE11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Cycle Count Headers (INV_CYCLE_COUNT_HEADERS)
ATTRIBUTE12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Cycle Count Headers (INV_CYCLE_COUNT_HEADERS)
ATTRIBUTE13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Cycle Count Headers (INV_CYCLE_COUNT_HEADERS)
ATTRIBUTE14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Cycle Count Headers (INV_CYCLE_COUNT_HEADERS)
ATTRIBUTE15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Cycle Count Headers (INV_CYCLE_COUNT_HEADERS)
START_MANUAL_COUNTS_PREFIX VARCHAR2 3 Starting Prefix for a Manual Count

Foreign Keys

Table Foreign Table Foreign Key Column
INV_CYCLE_COUNT_HEADERS inv_abc_assignment_groups ABC_ASSIGNMENT_GROUP_ID
INV_CYCLE_COUNT_HEADERS inv_org_parameters ORGANIZATION_ID
inv_cc_entries_interface inv_cycle_count_headers CYCLE_COUNT_HEADER_ID
inv_cycle_count_entries inv_cycle_count_headers CYCLE_COUNT_HEADER_ID
inv_cycle_count_classes inv_cycle_count_headers CYCLE_COUNT_HEADER_ID
inv_cc_schedule_requests inv_cycle_count_headers CYCLE_COUNT_HEADER_ID
inv_cycle_count_items inv_cycle_count_headers CYCLE_COUNT_HEADER_ID
inv_cc_subinventories inv_cycle_count_headers CYCLE_COUNT_HEADER_ID

Indexes

Index Uniqueness Tablespace Columns
INV_CYCLE_COUNT_HEADERS_N1 Non Unique Default LAST_UPDATE_DATE
INV_CYCLE_COUNT_HEADERS_U1 Unique Default CYCLE_COUNT_HEADER_ID
INV_CYCLE_COUNT_HEADERS_U2 Unique Default ORGANIZATION_ID, CYCLE_COUNT_HEADER_ID