Search Results apps_ts_seed




Overview
Explore in AI Chat

Overview

The WSH_CALENDAR_ASSIGNMENTS table is a core data object within the Oracle E-Business Suite Shipping (WSH) module, specifically for versions 12.1.1 and 12.2.2. It functions as the central repository for defining and managing the association of working calendars to various business entities. Its primary role is to enable sophisticated scheduling and capacity planning for shipping, receiving, and carrier operations by dictating the operational days and hours for specific organizations, locations, customers, vendors, or carriers. The table is stored in the APPS_TS_SEED tablespace, indicating it is part of the foundational seed data structure of the application.

Key Information Stored

The table's structure is designed to support flexible assignments through a combination of key identifier and type columns. The primary identifier is the CALENDAR_ASSIGNMENT_ID. Each record links a CALENDAR_CODE (from BOM_CALENDARS) to a specific entity, defining the CALENDAR_TYPE as SHIPPING, RECEIVING, or CARRIER. The ASSOCIATION_TYPE column (e.g., CUSTOMER, VENDOR_SITE, ORGANIZATION) determines which of the subsequent foreign key columns is populated to identify the target entity. Critical foreign key columns include ORGANIZATION_ID, LOCATION_ID, VENDOR_ID, CUSTOMER_ID, and CUSTOMER_SITE_USE_ID. The ENABLED_FLAG controls the active status of the assignment, while FREIGHT_CODE and FREIGHT_ORG_ID provide links to freight-related data.

Common Use Cases and Queries

This table is essential for determining operational schedules in transactional and planning processes. A common use case is validating if a shipment can be planned for a given date by checking the assigned shipping calendar for a specific warehouse (ORGANIZATION_ID) or customer site (CUSTOMER_SITE_USE_ID). For reporting, it is used to analyze calendar coverage across business entities. Sample queries include fetching all active calendar assignments for a specific organization or listing all customer sites assigned a particular shipping calendar.

  • Find active shipping calendar assignments for a specific organization:
    SELECT calendar_code FROM wsh_calendar_assignments WHERE organization_id = :org_id AND calendar_type = 'SHIPPING' AND enabled_flag = 'Y';
  • Identify all entities assigned to a specific calendar for auditing:
    SELECT association_type, organization_id, vendor_id, customer_id FROM wsh_calendar_assignments WHERE calendar_code = :cal_code;

Related Objects

WSH_CALENDAR_ASSIGNMENTS has integral relationships with numerous key EBS tables. The CALENDAR_CODE foreign key references BOM_CALENDARS.BOM_CALENDAR_CODE. Entity identifiers link to foundational tables: ORGANIZATION_ID to HR_ORGANIZATION_UNITS, VENDOR_ID to PO_VENDORS, CUSTOMER_ID to HZ_CUST_ACCOUNTS, and CUSTOMER_SITE_USE_ID to HZ_CUST_SITE_USES_ALL. The FREIGHT_CODE links to ORG_FREIGHT. The table's design, supported by multiple non-unique indexes (N1 through N10) on each foreign key column, optimizes queries filtering on these specific entities. It is a critical dependency for scheduling logic within the Shipping Execution module.

  • TABLE: WSH.WSH_CALENDAR_ASSIGNMENTS 12.2.2

    owner:WSH,  object_type:TABLE,  fnd_design_data:WSH.WSH_CALENDAR_ASSIGNMENTS,  object_name:WSH_CALENDAR_ASSIGNMENTS,  status:VALID, 

  • TABLE: WSH.WSH_CALENDAR_ASSIGNMENTS 12.1.1

    owner:WSH,  object_type:TABLE,  fnd_design_data:WSH.WSH_CALENDAR_ASSIGNMENTS,  object_name:WSH_CALENDAR_ASSIGNMENTS,  status:VALID, 

  • TABLE: HRI.HRI_EDW_EVENT_HRCHY_CMBNS 12.1.1

    owner:HRI,  object_type:TABLE,  fnd_design_data:HRI.HRI_EDW_EVENT_HRCHY_CMBNS,  object_name:HRI_EDW_EVENT_HRCHY_CMBNS,  status:VALID, 

  • TABLE: CZ.CZ_UI_PAGE_ELEMENTS 12.2.2

    owner:CZ,  object_type:TABLE,  fnd_design_data:CZ.CZ_UI_PAGE_ELEMENTS,  object_name:CZ_UI_PAGE_ELEMENTS,  status:VALID, 

  • TABLE: CZ.CZ_RULES 12.2.2

    owner:CZ,  object_type:TABLE,  fnd_design_data:CZ.CZ_RULES,  object_name:CZ_RULES,  status:VALID, 

  • TABLE: CZ.CZ_RULES 12.1.1

    owner:CZ,  object_type:TABLE,  fnd_design_data:CZ.CZ_RULES,  object_name:CZ_RULES,  status:VALID, 

  • TABLE: AMS.AMS_COLUMN_RULES 12.1.1

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_COLUMN_RULES,  object_name:AMS_COLUMN_RULES,  status:VALID, 

  • TABLE: CZ.CZ_UI_PAGE_ELEMENTS 12.1.1

    owner:CZ,  object_type:TABLE,  fnd_design_data:CZ.CZ_UI_PAGE_ELEMENTS,  object_name:CZ_UI_PAGE_ELEMENTS,  status:VALID, 

  • TABLE: XNP.XNP_NUMBER_RANGES 12.2.2

    owner:XNP,  object_type:TABLE,  fnd_design_data:XNP.XNP_NUMBER_RANGES,  object_name:XNP_NUMBER_RANGES,  status:VALID, 

  • TABLE: HR.PQH_ATTRIBUTE_RANGES 12.1.1

    owner:HR,  object_type:TABLE,  fnd_design_data:PQH.PQH_ATTRIBUTE_RANGES,  object_name:PQH_ATTRIBUTE_RANGES,  status:VALID, 

  • TABLE: HR.PQH_ATTRIBUTE_RANGES 12.2.2

    owner:HR,  object_type:TABLE,  fnd_design_data:PQH.PQH_ATTRIBUTE_RANGES,  object_name:PQH_ATTRIBUTE_RANGES,  status:VALID, 

  • TABLE: CZ.CZ_MODEL_REF_EXPLS 12.2.2

    owner:CZ,  object_type:TABLE,  fnd_design_data:CZ.CZ_MODEL_REF_EXPLS,  object_name:CZ_MODEL_REF_EXPLS,  status:VALID, 

  • TABLE: APPLSYS.UMX_REG_SERVICES_B 12.1.1

    owner:APPLSYS,  object_type:TABLE,  fnd_design_data:FND.UMX_REG_SERVICES_B,  object_name:UMX_REG_SERVICES_B,  status:VALID, 

  • TABLE: HR.HR_FORM_ITEMS_B 12.2.2

    owner:HR,  object_type:TABLE,  fnd_design_data:PER.HR_FORM_ITEMS_B,  object_name:HR_FORM_ITEMS_B,  status:VALID, 

  • TABLE: CZ.CZ_MODEL_REF_EXPLS 12.1.1

    owner:CZ,  object_type:TABLE,  fnd_design_data:CZ.CZ_MODEL_REF_EXPLS,  object_name:CZ_MODEL_REF_EXPLS,  status:VALID, 

  • TABLE: APPLSYS.FND_FORM_FUNCTIONS 12.1.1

    owner:APPLSYS,  object_type:TABLE,  fnd_design_data:FND.FND_FORM_FUNCTIONS,  object_name:FND_FORM_FUNCTIONS,  status:VALID, 

  • TABLE: JTF.JTF_LOC_HIERARCHIES_B 12.2.2

    owner:JTF,  object_type:TABLE,  fnd_design_data:JTF.JTF_LOC_HIERARCHIES_B,  object_name:JTF_LOC_HIERARCHIES_B,  status:VALID, 

  • TABLE: CZ.CZ_UI_REFS 12.1.1

    owner:CZ,  object_type:TABLE,  fnd_design_data:CZ.CZ_UI_REFS,  object_name:CZ_UI_REFS,  status:VALID, 

  • TABLE: HR.HR_FORM_ITEMS_TL 12.2.2

    owner:HR,  object_type:TABLE,  fnd_design_data:PER.HR_FORM_ITEMS_TL,  object_name:HR_FORM_ITEMS_TL,  status:VALID, 

  • TABLE: HR.HR_FORM_TEMPLATES_TL 12.2.2

    owner:HR,  object_type:TABLE,  fnd_design_data:PER.HR_FORM_TEMPLATES_TL,  object_name:HR_FORM_TEMPLATES_TL,  status:VALID, 

  • TABLE: HR.HR_FORM_CANVASES_TL 12.2.2

    owner:HR,  object_type:TABLE,  fnd_design_data:PER.HR_FORM_CANVASES_TL,  object_name:HR_FORM_CANVASES_TL,  status:VALID, 

  • TABLE: AMS.AMS_COLUMN_RULES 12.2.2

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_COLUMN_RULES,  object_name:AMS_COLUMN_RULES,  status:VALID, 

  • TABLE: HRI.HRI_EDW_EVENT_HRCHYS 12.1.1

    owner:HRI,  object_type:TABLE,  fnd_design_data:HRI.HRI_EDW_EVENT_HRCHYS,  object_name:HRI_EDW_EVENT_HRCHYS,  status:VALID, 

  • TABLE: HR.PQH_SPECIAL_ATTRIBUTES 12.2.2

    owner:HR,  object_type:TABLE,  fnd_design_data:PQH.PQH_SPECIAL_ATTRIBUTES,  object_name:PQH_SPECIAL_ATTRIBUTES,  status:VALID, 

  • TABLE: HR.HR_FORM_DATA_GROUPS_TL 12.2.2

    owner:HR,  object_type:TABLE,  fnd_design_data:PER.HR_FORM_DATA_GROUPS_TL,  object_name:HR_FORM_DATA_GROUPS_TL,  status:VALID, 

  • TABLE: HR.HR_WINDOW_PROPERTIES_TL 12.2.2

    owner:HR,  object_type:TABLE,  fnd_design_data:PER.HR_WINDOW_PROPERTIES_TL,  object_name:HR_WINDOW_PROPERTIES_TL,  status:VALID, 

  • TABLE: JTF.JTF_LOC_HIERARCHIES_B 12.1.1

    owner:JTF,  object_type:TABLE,  fnd_design_data:JTF.JTF_LOC_HIERARCHIES_B,  object_name:JTF_LOC_HIERARCHIES_B,  status:VALID, 

  • TABLE: HR.GHR_DUTY_STATIONS_F 12.2.2

    owner:HR,  object_type:TABLE,  fnd_design_data:GHR.GHR_DUTY_STATIONS_F,  object_name:GHR_DUTY_STATIONS_F,  status:VALID, 

  • TABLE: XNP.XNP_NUMBER_RANGES 12.1.1

    owner:XNP,  object_type:TABLE,  fnd_design_data:XNP.XNP_NUMBER_RANGES,  object_name:XNP_NUMBER_RANGES,  status:VALID, 

  • TABLE: WSH.WSH_GRANTS 12.1.1

    owner:WSH,  object_type:TABLE,  fnd_design_data:WSH.WSH_GRANTS,  object_name:WSH_GRANTS,  status:VALID, 

  • TABLE: HR.PAY_US_ZIP_CODES 12.2.2

    owner:HR,  object_type:TABLE,  fnd_design_data:PAY.PAY_US_ZIP_CODES,  object_name:PAY_US_ZIP_CODES,  status:VALID, 

  • TABLE: APPLSYS.UMX_REG_SERVICES_B 12.2.2

    owner:APPLSYS,  object_type:TABLE,  fnd_design_data:FND.UMX_REG_SERVICES_B,  object_name:UMX_REG_SERVICES_B,  status:VALID, 

  • TABLE: OSM.AS_INTEREST_TYPES_ALL 12.1.1

    owner:OSM,  object_type:TABLE,  fnd_design_data:AS.AS_INTEREST_TYPES_ALL,  object_name:AS_INTEREST_TYPES_ALL,  status:VALID, 

  • TABLE: OSM.AS_INTEREST_TYPES_ALL 12.2.2

    owner:OSM,  object_type:TABLE,  fnd_design_data:AS.AS_INTEREST_TYPES_ALL,  object_name:AS_INTEREST_TYPES_ALL,  status:VALID, 

  • TABLE: HR.HR_FORM_WINDOWS_TL 12.2.2

    owner:HR,  object_type:TABLE,  fnd_design_data:PER.HR_FORM_WINDOWS_TL,  object_name:HR_FORM_WINDOWS_TL,  status:VALID, 

  • TABLE: JTF.JTF_UM_SUBSCRIPTIONS_B 12.1.1

    owner:JTF,  object_type:TABLE,  fnd_design_data:JTF.JTF_UM_SUBSCRIPTIONS_B,  object_name:JTF_UM_SUBSCRIPTIONS_B,  status:VALID, 

  • TABLE: HR.PQH_TXN_CATEGORY_ATTRIBUTES 12.2.2

    owner:HR,  object_type:TABLE,  fnd_design_data:PQH.PQH_TXN_CATEGORY_ATTRIBUTES,  object_name:PQH_TXN_CATEGORY_ATTRIBUTES,  status:VALID, 

  • TABLE: GMD.GMD_FORMULA_SECURITY 12.1.1

    owner:GMD,  object_type:TABLE,  fnd_design_data:GMD.GMD_FORMULA_SECURITY,  object_name:GMD_FORMULA_SECURITY,  status:VALID, 

  • TABLE: CZ.CZ_UI_REFS 12.2.2

    owner:CZ,  object_type:TABLE,  fnd_design_data:CZ.CZ_UI_REFS,  object_name:CZ_UI_REFS,  status:VALID, 

  • TABLE: APPLSYS.FND_FORM_FUNCTIONS 12.2.2

    owner:APPLSYS,  object_type:TABLE,  fnd_design_data:FND.FND_FORM_FUNCTIONS,  object_name:FND_FORM_FUNCTIONS,  status:VALID, 

  • TABLE: GCS.GCS_XML_FILES 12.1.1

    owner:GCS,  object_type:TABLE,  fnd_design_data:GCS.GCS_XML_FILES,  object_name:GCS_XML_FILES,  status:VALID, 

  • TABLE: XNP.XNP_SP_FILTERS 12.1.1

    owner:XNP,  object_type:TABLE,  fnd_design_data:XNP.XNP_SP_FILTERS,  object_name:XNP_SP_FILTERS,  status:VALID, 

  • TABLE: HR.HR_FORM_DATA_GROUP_ITEMS 12.2.2

    owner:HR,  object_type:TABLE,  fnd_design_data:PER.HR_FORM_DATA_GROUP_ITEMS,  object_name:HR_FORM_DATA_GROUP_ITEMS,  status:VALID, 

  • TABLE: GMD.GMD_FORMULA_SECURITY 12.2.2

    owner:GMD,  object_type:TABLE,  fnd_design_data:GMD.GMD_FORMULA_SECURITY,  object_name:GMD_FORMULA_SECURITY,  status:VALID, 

  • TABLE: HR.GHR_DUTY_STATIONS_F 12.1.1

    owner:HR,  object_type:TABLE,  fnd_design_data:GHR.GHR_DUTY_STATIONS_F,  object_name:GHR_DUTY_STATIONS_F,  status:VALID, 

  • TABLE: HR.HR_TAB_PAGE_PROPERTIES_TL 12.2.2

    owner:HR,  object_type:TABLE,  fnd_design_data:PER.HR_TAB_PAGE_PROPERTIES_TL,  object_name:HR_TAB_PAGE_PROPERTIES_TL,  status:VALID, 

  • TABLE: HR.HR_FORM_TAB_PAGES_TL 12.2.2

    owner:HR,  object_type:TABLE,  fnd_design_data:PER.HR_FORM_TAB_PAGES_TL,  object_name:HR_FORM_TAB_PAGES_TL,  status:VALID, 

  • TABLE: HR.HR_NAVIGATION_NODE_USAGES 12.2.2

    owner:HR,  object_type:TABLE,  fnd_design_data:PER.HR_NAVIGATION_NODE_USAGES,  object_name:HR_NAVIGATION_NODE_USAGES,  status:VALID, 

  • TABLE: APPLSYS.FND_USER 12.2.2

    owner:APPLSYS,  object_type:TABLE,  fnd_design_data:FND.FND_USER,  object_name:FND_USER,  status:VALID, 

  • TABLE: APPLSYS.JDR_ATTRIBUTES 12.2.2

    owner:APPLSYS,  object_type:TABLE,  fnd_design_data:FND.JDR_ATTRIBUTES,  object_name:JDR_ATTRIBUTES,  status:VALID,