Search Results csc_prof_checks_b




Overview
Explore in AI Chat

Overview

The CSC_PROF_CHECKS_B table is a core data object within the Oracle E-Business Suite (EBS) Customer Care (CSC) module. It serves as the master repository for profile check definitions, which are fundamental components of the service profiling functionality. Profile checks are configurable rules or conditions used to evaluate service requests, customer accounts, or assets against predefined business criteria. The table's role is to store the structural and control information for each unique check, enabling the system to perform automated assessments that drive service processes, such as entitlement verification, diagnostic routing, and resolution planning. Its "B" suffix indicates it is a base table, primarily holding transactional and seed data that is supplemented by translated descriptive information in its corresponding TL (translation) table.

Key Information Stored

While the provided metadata does not list specific columns, the primary and foreign key relationships define its critical structure. The central column is CHECK_ID, which is the table's primary key and uniquely identifies each profile check definition. Another significant column is SELECT_BLOCK_ID, a foreign key linking the check to a specific profile block defined in CSC_PROF_BLOCKS_B. This relationship suggests that a profile check is often associated with a specific data selection or filtering logic. Other columns in the base table typically store control attributes such as the check's active status, application method, sequencing, creation and last update dates, and the identifier of the last updating user.

Common Use Cases and Queries

This table is central to configuring and executing the service profiling engine. A primary use case involves administrators setting up or modifying the library of checks that the system can apply to service requests. For reporting and analysis, common queries involve listing all active checks or identifying checks associated with a particular service plan. Sample SQL patterns include joining to the translation table to retrieve the check name in a specific language or querying checks linked to a specific profile block.

  • Retrieve active profile checks with descriptions: SELECT b.CHECK_ID, tl.NAME FROM CSC_PROF_CHECKS_B b, CSC_PROF_CHECKS_TL tl WHERE b.CHECK_ID = tl.CHECK_ID AND tl.LANGUAGE = USERENV('LANG') AND b.ENABLED_FLAG = 'Y';
  • Find checks used by a specific service plan: SELECT ph.PLAN_NAME, b.CHECK_ID FROM CSC_PLAN_HEADERS_B ph, CSC_PROF_CHECKS_B b WHERE ph.PROFILE_CHECK_ID = b.CHECK_ID;

Related Objects

The CSC_PROF_CHECKS_B table is a central hub within the profiling schema, with numerous foreign key relationships as documented.

  • CSC_PROF_CHECKS_TL: Stores translated names and descriptions for the check, joined on CHECK_ID.
  • CSC_PROF_BLOCKS_B: Defines the data block a check may use, linked via CSC_PROF_CHECKS_B.SELECT_BLOCK_ID.
  • CSC_PLAN_HEADERS_B: Service plans can reference a specific profile check via CSC_PLAN_HEADERS_B.PROFILE_CHECK_ID.
  • CSC_PROF_CHECK_RATINGS, CSC_PROF_CHECK_RESULTS, CSC_PROF_CHECK_RULES_B, and CSC_PROF_GROUP_CHECKS: These are child tables that store detailed rating logic, execution results, specific rule conditions, and check-group associations, respectively, all linked by the parent CHECK_ID.
  • Table: CSC_PROF_CHECKS_B 12.1.1

    owner:CSC,  object_type:TABLE,  fnd_design_data:CSC.CSC_PROF_CHECKS_B,  object_name:CSC_PROF_CHECKS_B,  status:VALID,  product: CSC - Customer Care ,  description: CSC_PROF_CHECKS_B stores the profile check information ,  implementation_dba_data: CSC.CSC_PROF_CHECKS_B , 

  • Table: CSC_PROF_CHECKS_B 12.2.2

    owner:CSC,  object_type:TABLE,  fnd_design_data:CSC.CSC_PROF_CHECKS_B,  object_name:CSC_PROF_CHECKS_B,  status:VALID,  product: CSC - Customer Care ,  description: CSC_PROF_CHECKS_B stores the profile check information ,  implementation_dba_data: CSC.CSC_PROF_CHECKS_B , 

  • Table: CSC_PROF_CHECKS_TL 12.1.1

    owner:CSC,  object_type:TABLE,  fnd_design_data:CSC.CSC_PROF_CHECKS_TL,  object_name:CSC_PROF_CHECKS_TL,  status:VALID,  product: CSC - Customer Care ,  description: CSC_PROF_CHECKS_TL table stores the translated columns of profile checks stored in CSC_PROF_CHECKS_B table ,  implementation_dba_data: CSC.CSC_PROF_CHECKS_TL , 

  • Table: CSC_PROF_CHECKS_TL 12.2.2

    owner:CSC,  object_type:TABLE,  fnd_design_data:CSC.CSC_PROF_CHECKS_TL,  object_name:CSC_PROF_CHECKS_TL,  status:VALID,  product: CSC - Customer Care ,  description: CSC_PROF_CHECKS_TL table stores the translated columns of profile checks stored in CSC_PROF_CHECKS_B table ,  implementation_dba_data: CSC.CSC_PROF_CHECKS_TL , 

  • View: CSC_PROF_CHECKS_VL 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:CSC.CSC_PROF_CHECKS_VL,  object_name:CSC_PROF_CHECKS_VL,  status:VALID,  product: CSC - Customer Care ,  description: This view is the MLSed view based on CSC_PROF_CHECKS_B and CSC_PROF_CHECKS_TL. This view is used in Customer Profile Setup form- Profile Checks tab. ,  implementation_dba_data: APPS.CSC_PROF_CHECKS_VL , 

  • View: CSC_PROF_CHECKS_VL 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:CSC.CSC_PROF_CHECKS_VL,  object_name:CSC_PROF_CHECKS_VL,  status:VALID,  product: CSC - Customer Care ,  description: This view is the MLSed view based on CSC_PROF_CHECKS_B and CSC_PROF_CHECKS_TL. This view is used in Customer Profile Setup form- Profile Checks tab. ,  implementation_dba_data: APPS.CSC_PROF_CHECKS_VL , 

  • Table: CSC_PROF_CHECK_RATINGS 12.2.2

    owner:CSC,  object_type:TABLE,  fnd_design_data:CSC.CSC_PROF_CHECK_RATINGS,  object_name:CSC_PROF_CHECK_RATINGS,  status:VALID,  product: CSC - Customer Care ,  description: CSC_PROF_CHECK_RATINGS stores the rating and color information ,  implementation_dba_data: CSC.CSC_PROF_CHECK_RATINGS , 

  • Table: CSC_PROF_GROUP_CHECKS 12.1.1

    owner:CSC,  object_type:TABLE,  fnd_design_data:CSC.CSC_PROF_GROUP_CHECKS,  object_name:CSC_PROF_GROUP_CHECKS,  status:VALID,  product: CSC - Customer Care ,  description: Store the relation between profile groups and profile checks. This table stores the Profile checks that are present in a profile group ,  implementation_dba_data: CSC.CSC_PROF_GROUP_CHECKS , 

  • Table: CSC_PROF_CHECK_RULES_B 12.2.2

    owner:CSC,  object_type:TABLE,  fnd_design_data:CSC.CSC_PROF_CHECK_RULES_B,  object_name:CSC_PROF_CHECK_RULES_B,  status:VALID,  product: CSC - Customer Care ,  description: CSC_PROF_CHECK_RULES_B stores the conditions used by the profile check ,  implementation_dba_data: CSC.CSC_PROF_CHECK_RULES_B , 

  • Table: CSC_PROF_BLOCKS_B 12.1.1

    owner:CSC,  object_type:TABLE,  fnd_design_data:CSC.CSC_PROF_BLOCKS_B,  object_name:CSC_PROF_BLOCKS_B,  status:VALID,  product: CSC - Customer Care ,  description: CSC_PROF_BLOCKS_B stores the profile check variable information ,  implementation_dba_data: CSC.CSC_PROF_BLOCKS_B , 

  • Table: CSC_PLAN_HEADERS_B 12.1.1

    owner:CSC,  object_type:TABLE,  fnd_design_data:CSC.CSC_PLAN_HEADERS_B,  object_name:CSC_PLAN_HEADERS_B,  status:VALID,  product: CSC - Customer Care ,  description: CSC_PLAN_HEADERS_B table stores all the plan templates and customized plan templates. ,  implementation_dba_data: CSC.CSC_PLAN_HEADERS_B , 

  • Table: CSC_PROF_CHECK_RATINGS 12.1.1

    owner:CSC,  object_type:TABLE,  fnd_design_data:CSC.CSC_PROF_CHECK_RATINGS,  object_name:CSC_PROF_CHECK_RATINGS,  status:VALID,  product: CSC - Customer Care ,  description: CSC_PROF_CHECK_RATINGS stores the rating and color information ,  implementation_dba_data: CSC.CSC_PROF_CHECK_RATINGS , 

  • Table: CSC_PROF_CHECK_RESULTS 12.1.1

    owner:CSC,  object_type:TABLE,  fnd_design_data:CSC.CSC_PROF_CHECK_RESULTS,  object_name:CSC_PROF_CHECK_RESULTS,  status:VALID,  product: CSC - Customer Care ,  description: CSC_PROF_BLOCK_RESULTS stores the value of the profile checks per party and account ,  implementation_dba_data: CSC.CSC_PROF_CHECK_RESULTS , 

  • Table: CSC_PROF_BLOCKS_B 12.2.2

    owner:CSC,  object_type:TABLE,  fnd_design_data:CSC.CSC_PROF_BLOCKS_B,  object_name:CSC_PROF_BLOCKS_B,  status:VALID,  product: CSC - Customer Care ,  description: CSC_PROF_BLOCKS_B stores the profile check variable information ,  implementation_dba_data: CSC.CSC_PROF_BLOCKS_B , 

  • Table: CSC_PROF_CHECK_RESULTS 12.2.2

    owner:CSC,  object_type:TABLE,  fnd_design_data:CSC.CSC_PROF_CHECK_RESULTS,  object_name:CSC_PROF_CHECK_RESULTS,  status:VALID,  product: CSC - Customer Care ,  description: CSC_PROF_BLOCK_RESULTS stores the value of the profile checks per party and account ,  implementation_dba_data: CSC.CSC_PROF_CHECK_RESULTS , 

  • Table: CSC_PROF_GROUP_CHECKS 12.2.2

    owner:CSC,  object_type:TABLE,  fnd_design_data:CSC.CSC_PROF_GROUP_CHECKS,  object_name:CSC_PROF_GROUP_CHECKS,  status:VALID,  product: CSC - Customer Care ,  description: Store the relation between profile groups and profile checks. This table stores the Profile checks that are present in a profile group ,  implementation_dba_data: CSC.CSC_PROF_GROUP_CHECKS , 

  • Table: CSC_PROF_CHECK_RULES_B 12.1.1

    owner:CSC,  object_type:TABLE,  fnd_design_data:CSC.CSC_PROF_CHECK_RULES_B,  object_name:CSC_PROF_CHECK_RULES_B,  status:VALID,  product: CSC - Customer Care ,  description: CSC_PROF_CHECK_RULES_B stores the conditions used by the profile check ,  implementation_dba_data: CSC.CSC_PROF_CHECK_RULES_B , 

  • Table: CSC_PLAN_HEADERS_B 12.2.2

    owner:CSC,  object_type:TABLE,  fnd_design_data:CSC.CSC_PLAN_HEADERS_B,  object_name:CSC_PLAN_HEADERS_B,  status:VALID,  product: CSC - Customer Care ,  description: CSC_PLAN_HEADERS_B table stores all the plan templates and customized plan templates. ,  implementation_dba_data: CSC.CSC_PLAN_HEADERS_B ,