Search Results the blue lagoon nude




The CS_KB_CTXT_REPO_MAPS_B table is a critical component within Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2, specifically designed to support the Knowledge Base (KB) functionality in the Customer Service (CS) module. This table serves as a repository mapping entity, establishing relationships between knowledge base articles and their associated contexts, categories, or repositories. Its primary purpose is to facilitate efficient content retrieval, categorization, and contextual linking within the Oracle EBS Knowledge Management framework.

Table Structure and Key Columns

The CS_KB_CTXT_REPO_MAPS_B table contains several important columns that define its functionality:
  • MAP_ID: Primary key identifier for each mapping record.
  • CONTEXT_ID: References the context (business or functional area) to which the knowledge article is linked.
  • REPOSITORY_ID: Identifies the repository where the knowledge content is stored.
  • CATEGORY_ID: Associates the article with a specific category within the knowledge base.
  • START_DATE_ACTIVE and END_DATE_ACTIVE: Define the validity period for the mapping.
  • OBJECT_VERSION_NUMBER: Used for optimistic locking and concurrency control.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE: Standard Oracle EBS audit columns.

Functional Role in Oracle EBS

The table plays a pivotal role in knowledge management by:
  • Enabling multi-dimensional categorization of knowledge articles across different contexts and repositories
  • Supporting hierarchical knowledge organization through category mappings
  • Facilitating context-sensitive knowledge delivery based on user roles or business processes
  • Allowing temporal control over knowledge availability through date-effective mappings

Integration Points

CS_KB_CTXT_REPO_MAPS_B integrates with several other Oracle EBS tables:
  • CS_KB_CONTENTS_B: Contains the actual knowledge article content
  • CS_KB_REPOSITORIES_B: Defines knowledge repositories
  • CS_KB_CATEGORIES_B: Maintains category definitions
  • CS_KB_CONTEXTS_B: Stores context definitions for knowledge classification

Technical Considerations

Key technical aspects include:
  • The table follows Oracle EBS standards for table naming (_B suffix indicates base table)
  • It implements standard Oracle EBS audit columns for change tracking
  • Foreign key constraints maintain referential integrity with related knowledge base tables
  • Indexes on frequently queried columns (MAP_ID, CONTEXT_ID, REPOSITORY_ID) optimize performance

Customization and Extension Points

Common extension scenarios include:
  • Creating custom views that join with this table for specialized reporting
  • Developing custom APIs that leverage the mapping relationships
  • Extending the data model through descriptive flexfields if additional attributes are needed

Version-Specific Considerations

Between EBS 12.1.1 and 12.2.2:
  • The fundamental structure remains consistent across versions
  • 12.2.2 may include additional indexes or performance optimizations
  • Integration with Oracle WebLogic Server in 12.2.2 may affect how mappings are cached
The CS_KB_CTXT_REPO_MAPS_B table exemplifies Oracle's approach to knowledge management in EBS, providing a flexible yet structured mechanism for organizing and retrieving enterprise knowledge assets. Its design supports complex knowledge relationships while maintaining the performance and scalability requirements of large EBS implementations.

  • Lookup Type: CS_COLOR_VISUAL_ATTRIBUTES 12.2.2

    product: CS - Service ,  meaning: CS_COLOR_VISUAL_ATTRIBUTES ,  description: Visual attribute names for setting foreground colors for Service Request , 

  • Lookup Type: CS_COLOR_VISUAL_ATTRIBUTES 12.1.1

    product: CS - Service ,  meaning: CS_COLOR_VISUAL_ATTRIBUTES ,  description: Visual attribute names for setting foreground colors for Service Request , 

  • Lookup Type: CS_KB_RTE_FONT_COLOR 12.1.1

    product: CS - Service ,  meaning: Knowledge: Font Color for Rich Text Editor ,  description: Knowledge: Font Color for Rich Text Editor , 

  • Lookup Type: CS_KB_RTE_FONT_COLOR 12.2.2

    product: CS - Service ,  meaning: Knowledge: Font Color for Rich Text Editor ,  description: Knowledge: Font Color for Rich Text Editor , 

  • Lookup Type: CS_LAYOUT_ATTRIBUTES 12.2.2

    product: CS - Service ,  meaning: CS_LAYOUT_ATTRIBUTES ,  description: Configurable Service Request Layout Attributes , 

  • Lookup Type: CS_LAYOUT_ATTRIBUTES 12.1.1

    product: CS - Service ,  meaning: CS_LAYOUT_ATTRIBUTES ,  description: Configurable Service Request Layout Attributes , 

  • Lookup Type: SERVICE_ORDER_BY_OPTION 12.2.2

    product: CS - Service ,  meaning: SERVICE_ORDER_BY_OPTION ,  description: A list of options to order services , 

  • Lookup Type: SERVICE_ORDER_BY_OPTION 12.1.1

    product: CS - Service ,  meaning: SERVICE_ORDER_BY_OPTION ,  description: A list of options to order services , 

  • Lookup Type: CS_MULTI_ORG_RULE 12.1.1

    product: CS - Service ,  meaning: Service Request Multi Org Rule ,  description: Service Request Multi Org Rule , 

  • Lookup Type: CS_MULTI_ORG_RULE 12.2.2

    product: CS - Service ,  meaning: Service Request Multi Org Rule ,  description: Service Request Multi Org Rule , 

  • Concurrent Program: CSXOCIB 12.2.2

    execution_filename: CS_OCInterface_PUB.Populate_InstalledBase ,  product: CS - Service ,  user_name: Installed Base Interface ,  description: Program to get all the relevant orders from the Order Capture queue into the Installed Base. ,  argument_method: Standard ,  enabled: No ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: CSXOCIB 12.1.1

    execution_filename: CS_OCInterface_PUB.Populate_InstalledBase ,  product: CS - Service ,  user_name: Installed Base Interface ,  description: Program to get all the relevant orders from the Order Capture queue into the Installed Base. ,  argument_method: Standard ,  enabled: No ,  execution_method: PL/SQL Stored Procedure , 

  • Table: CS_KB_CTXT_REPO_MAPS_B 12.1.1

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_KB_CTXT_REPO_MAPS_B,  object_name:CS_KB_CTXT_REPO_MAPS_B,  status:VALID,  product: CS - Service ,  description: This table stores the Relationship between a Tab and a Repository. This relationship is translated to a UI tab in the KM Search Module. The mapping order controls how the search framework orders the result tabs when displaying the search re ,  implementation_dba_data: CS.CS_KB_CTXT_REPO_MAPS_B , 

  • Table: CS_KB_CTXT_REPO_MAPS_B 12.2.2

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_KB_CTXT_REPO_MAPS_B,  object_name:CS_KB_CTXT_REPO_MAPS_B,  status:VALID,  product: CS - Service ,  description: This table stores the Relationship between a Tab and a Repository. This relationship is translated to a UI tab in the KM Search Module. The mapping order controls how the search framework orders the result tabs when displaying the search re ,  implementation_dba_data: CS.CS_KB_CTXT_REPO_MAPS_B , 

  • Table: CS_KB_CONTEXTS 12.2.2

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_KB_CONTEXTS,  object_name:CS_KB_CONTEXTS,  status:VALID,  product: CS - Service ,  description: This table stores the context information used in Knowledge Management for the Repository Setup. The definition of a context is defined in the FND Module, Knowledge Management is just reusing the contexts. ,  implementation_dba_data: CS.CS_KB_CONTEXTS , 

  • Table: CS_KB_CONTEXTS 12.1.1

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_KB_CONTEXTS,  object_name:CS_KB_CONTEXTS,  status:VALID,  product: CS - Service ,  description: This table stores the context information used in Knowledge Management for the Repository Setup. The definition of a context is defined in the FND Module, Knowledge Management is just reusing the contexts. ,  implementation_dba_data: CS.CS_KB_CONTEXTS , 

  • Table: CS_KB_REPOSITORIES 12.2.2

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_KB_REPOSITORIES,  object_name:CS_KB_REPOSITORIES,  status:VALID,  product: CS - Service ,  description: This table stores the repository data. A repository is used to perform a search in the search module of Knowledge Management. A repository includes a JRAD region to render the result, a view object to perform the search, and a view object ,  implementation_dba_data: CS.CS_KB_REPOSITORIES , 

  • Table: CS_KB_REPOSITORIES 12.1.1

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_KB_REPOSITORIES,  object_name:CS_KB_REPOSITORIES,  status:VALID,  product: CS - Service ,  description: This table stores the repository data. A repository is used to perform a search in the search module of Knowledge Management. A repository includes a JRAD region to render the result, a view object to perform the search, and a view object ,  implementation_dba_data: CS.CS_KB_REPOSITORIES , 

  • Table: CS_MULTI_ORG_RULES 12.2.2

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_MULTI_ORG_RULES,  object_name:CS_MULTI_ORG_RULES,  status:VALID,  product: CS - Service ,  description: This table defines the Multi Org Rules in CS and the Order in which the rules are to be used. ,  implementation_dba_data: CS.CS_MULTI_ORG_RULES , 

  • Table: CS_MULTI_ORG_RULES 12.1.1

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_MULTI_ORG_RULES,  object_name:CS_MULTI_ORG_RULES,  status:VALID,  product: CS - Service ,  description: This table defines the Multi Org Rules in CS and the Order in which the rules are to be used. ,  implementation_dba_data: CS.CS_MULTI_ORG_RULES , 

  • Table: CS_SR_LINK_TYPES_TL 12.1.1

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_SR_LINK_TYPES_TL,  object_name:CS_SR_LINK_TYPES_TL,  status:VALID,  product: CS - Service ,  description: This table has all the translation attributes for the base link type table, CS_SR_LINK_TYPES_B.It store the name and description of each link type. ,  implementation_dba_data: CS.CS_SR_LINK_TYPES_TL , 

  • Table: CS_SR_LINK_TYPES_TL 12.2.2

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_SR_LINK_TYPES_TL,  object_name:CS_SR_LINK_TYPES_TL,  status:VALID,  product: CS - Service ,  description: This table has all the translation attributes for the base link type table, CS_SR_LINK_TYPES_B.It store the name and description of each link type. ,  implementation_dba_data: CS.CS_SR_LINK_TYPES_TL , 

  • Table: CS_QM_FILTERS 12.2.2

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_QM_FILTERS,  object_name:CS_QM_FILTERS,  status:VALID,  product: CS - Service ,  description: FILTERS are pre-seeded and stores the information of a filter definition, such as the filter name. The combination of FILTER_CODE and FILER_NAME is unique. ,  implementation_dba_data: CS.CS_QM_FILTERS , 

  • Table: CS_QM_FILTERS 12.1.1

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_QM_FILTERS,  object_name:CS_QM_FILTERS,  status:VALID,  product: CS - Service ,  description: FILTERS are pre-seeded and stores the information of a filter definition, such as the filter name. The combination of FILTER_CODE and FILER_NAME is unique. ,  implementation_dba_data: CS.CS_QM_FILTERS , 

  • Lookup Type: CS_PARTYROLE_TYPES 12.2.2

    product: CS - Service ,  meaning: Type List Item in the Define Notification Rules page ,  description: Look up for the Type List Item in the Define Notification Rules page. , 

  • Table: CS_QM_FUNCTION_FILTERS 12.1.1

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_QM_FUNCTION_FILTERS,  object_name:CS_QM_FUNCTION_FILTERS,  status:VALID,  product: CS - Service ,  description: It stores the relationship between functions and filters. The table has a foreign key to both the table CS_QM_FILTERS and FND_FORM_FUNCTIONS. ,  implementation_dba_data: CS.CS_QM_FUNCTION_FILTERS , 

  • Lookup Type: CS_PARTYROLE_TYPES 12.1.1

    product: CS - Service ,  meaning: Type List Item in the Define Notification Rules page ,  description: Look up for the Type List Item in the Define Notification Rules page. , 

  • Lookup Type: CS_SR_TASK_TMPL_LOV_VALUES 12.2.2

    product: CS - Service ,  meaning: CS_SR_TASK_TMPL_LOV_VALUES ,  description: This lookup is used in the Task Template field in the Status and Groups Transition UI , 

  • Table: CS_KB_REPO_PROPERTIES 12.1.1

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_KB_REPO_PROPERTIES,  object_name:CS_KB_REPO_PROPERTIES,  status:VALID,  product: CS - Service ,  description: This table stoes the Properties of a Repository (CS_KB_REPOSITORIES). A Repository Property contains additional information about the Repository. Data stored in this table is in the name-value format. ,  implementation_dba_data: CS.CS_KB_REPO_PROPERTIES , 

  • Table: CS_QM_FUNCTION_FILTERS 12.2.2

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_QM_FUNCTION_FILTERS,  object_name:CS_QM_FUNCTION_FILTERS,  status:VALID,  product: CS - Service ,  description: It stores the relationship between functions and filters. The table has a foreign key to both the table CS_QM_FILTERS and FND_FORM_FUNCTIONS. ,  implementation_dba_data: CS.CS_QM_FUNCTION_FILTERS , 

  • Table: CS_KB_REPO_PROPERTIES 12.2.2

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_KB_REPO_PROPERTIES,  object_name:CS_KB_REPO_PROPERTIES,  status:VALID,  product: CS - Service ,  description: This table stoes the Properties of a Repository (CS_KB_REPOSITORIES). A Repository Property contains additional information about the Repository. Data stored in this table is in the name-value format. ,  implementation_dba_data: CS.CS_KB_REPO_PROPERTIES , 

  • View: CS_SR_UWQ_GROUP_COUNT_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_SR_UWQ_GROUP_COUNT_V,  object_name:CS_SR_UWQ_GROUP_COUNT_V,  status:VALID,  product: CS - Service ,  description: This view is used by the UWQ (Universal Work Queue) to query up the count of Service Requests against the user's groups. ,  implementation_dba_data: APPS.CS_SR_UWQ_GROUP_COUNT_V , 

  • View: CS_SR_UWQ_TEAM_COUNT_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_SR_UWQ_TEAM_COUNT_V,  object_name:CS_SR_UWQ_TEAM_COUNT_V,  status:VALID,  product: CS - Service ,  description: This view is used by the UWQ (Universal Work Queue) to query up the count of Service Requests against the user's teams. ,  implementation_dba_data: APPS.CS_SR_UWQ_TEAM_COUNT_V , 

  • View: CS_SR_UWQ_GROUP_COUNT_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_SR_UWQ_GROUP_COUNT_V,  object_name:CS_SR_UWQ_GROUP_COUNT_V,  status:VALID,  product: CS - Service ,  description: This view is used by the UWQ (Universal Work Queue) to query up the count of Service Requests against the user's groups. ,  implementation_dba_data: APPS.CS_SR_UWQ_GROUP_COUNT_V , 

  • View: CS_SR_UWQ_TEAM_COUNT_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_SR_UWQ_TEAM_COUNT_V,  object_name:CS_SR_UWQ_TEAM_COUNT_V,  status:VALID,  product: CS - Service ,  description: This view is used by the UWQ (Universal Work Queue) to query up the count of Service Requests against the user's teams. ,  implementation_dba_data: APPS.CS_SR_UWQ_TEAM_COUNT_V , 

  • View: CS_SR_UWQ_EMP_COUNT_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_SR_UWQ_EMP_COUNT_V,  object_name:CS_SR_UWQ_EMP_COUNT_V,  status:VALID,  product: CS - Service ,  description: This view is used by the UWQ (Universal Work Queue) to query up the count of Service Requests against the user logged in. ,  implementation_dba_data: APPS.CS_SR_UWQ_EMP_COUNT_V , 

  • View: CS_SR_UWQ_EMP_COUNT_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_SR_UWQ_EMP_COUNT_V,  object_name:CS_SR_UWQ_EMP_COUNT_V,  status:VALID,  product: CS - Service ,  description: This view is used by the UWQ (Universal Work Queue) to query up the count of Service Requests against the user logged in. ,  implementation_dba_data: APPS.CS_SR_UWQ_EMP_COUNT_V , 

  • Table: CS_SR_LINK_TYPES_B 12.1.1

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_SR_LINK_TYPES_B,  object_name:CS_SR_LINK_TYPES_B,  status:VALID,  product: CS - Service ,  description: This table is used to store all the valid relationship Types between service request and service request and between service request and other business objects. The relationship description is stored in the translation table CS_SR_LINK_TY ,  implementation_dba_data: CS.CS_SR_LINK_TYPES_B , 

  • View: CS_SR_KB_SOLUTION_LINKS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_SR_KB_SOLUTION_LINKS_V,  object_name:CS_SR_KB_SOLUTION_LINKS_V,  status:VALID,  product: CS - Service ,  description: This is the base view in the notes section of the workbench tab for Knowledge Base solution notes. ,  implementation_dba_data: APPS.CS_SR_KB_SOLUTION_LINKS_V , 

  • View: CS_SR_PARTY_ADDRESS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_SR_PARTY_ADDRESS_V,  object_name:CS_SR_PARTY_ADDRESS_V,  status:VALID,  product: CS - Service ,  description: This view details the address information of all parties. The address column is a concatenated form of the address from HZ_PARTIES. ,  implementation_dba_data: APPS.CS_SR_PARTY_ADDRESS_V , 

  • Table: CS_SR_LINK_TYPES_B 12.2.2

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_SR_LINK_TYPES_B,  object_name:CS_SR_LINK_TYPES_B,  status:VALID,  product: CS - Service ,  description: This table is used to store all the valid relationship Types between service request and service request and between service request and other business objects. The relationship description is stored in the translation table CS_SR_LINK_TY ,  implementation_dba_data: CS.CS_SR_LINK_TYPES_B , 

  • View: CS_SR_PARTY_ADDRESS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_SR_PARTY_ADDRESS_V,  object_name:CS_SR_PARTY_ADDRESS_V,  status:VALID,  product: CS - Service ,  description: This view details the address information of all parties. The address column is a concatenated form of the address from HZ_PARTIES. ,  implementation_dba_data: APPS.CS_SR_PARTY_ADDRESS_V , 

  • View: CS_SR_KB_SOLUTION_LINKS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_SR_KB_SOLUTION_LINKS_V,  object_name:CS_SR_KB_SOLUTION_LINKS_V,  status:VALID,  product: CS - Service ,  description: This is the base view in the notes section of the workbench tab for Knowledge Base solution notes. ,  implementation_dba_data: APPS.CS_SR_KB_SOLUTION_LINKS_V , 

  • View: CS_SR_UWQ_NODES_VL 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_SR_UWQ_NODES_VL,  object_name:CS_SR_UWQ_NODES_VL,  status:VALID,  product: CS - Service ,  description: The base view for the form CSXNODES. This view shows all the user defined UWQ nodes for Service Request. ,  implementation_dba_data: APPS.CS_SR_UWQ_NODES_VL , 

  • View: CS_SR_UWQ_NODES_VL 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_SR_UWQ_NODES_VL,  object_name:CS_SR_UWQ_NODES_VL,  status:VALID,  product: CS - Service ,  description: The base view for the form CSXNODES. This view shows all the user defined UWQ nodes for Service Request. ,  implementation_dba_data: APPS.CS_SR_UWQ_NODES_VL , 

  • Table: CS_SR_SAVED_SEARCHES_TL 12.2.2

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_SR_SAVED_SEARCHES_TL,  object_name:CS_SR_SAVED_SEARCHES_TL,  status:VALID,  product: CS - Service ,  description: This table is used to store the translated column for the service request saved searches. ,  implementation_dba_data: CS.CS_SR_SAVED_SEARCHES_TL , 

  • Table: CS_SR_SAVED_SEARCHES_TL 12.1.1

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_SR_SAVED_SEARCHES_TL,  object_name:CS_SR_SAVED_SEARCHES_TL,  status:VALID,  product: CS - Service ,  description: This table is used to store the translated column for the service request saved searches. ,  implementation_dba_data: CS.CS_SR_SAVED_SEARCHES_TL , 

  • Table: CS_TRANSACTION_TYPES_TL 12.2.2

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_TRANSACTION_TYPES_TL,  object_name:CS_TRANSACTION_TYPES_TL,  status:VALID,  product: CS - Service ,  description: Table to contain the translated attributes for the CS_TRANSACTION_TYPES_B table. ,  implementation_dba_data: CS.CS_TRANSACTION_TYPES_TL , 

  • Table: CS_TRANSACTION_TYPES_TL 12.1.1

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_TRANSACTION_TYPES_TL,  object_name:CS_TRANSACTION_TYPES_TL,  status:VALID,  product: CS - Service ,  description: Table to contain the translated attributes for the CS_TRANSACTION_TYPES_B table. ,  implementation_dba_data: CS.CS_TRANSACTION_TYPES_TL , 

  • Table: CS_SR_SAVED_BSC_CRITERIA 12.1.1

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_SR_SAVED_BSC_CRITERIA,  object_name:CS_SR_SAVED_BSC_CRITERIA,  status:VALID,  product: CS - Service ,  description: This table is used to store the basic search columns and values in the service request saved searches module. ,  implementation_dba_data: CS.CS_SR_SAVED_BSC_CRITERIA ,