Search Results csc_prof_table_columns_b




Overview
Explore in AI Chat

Overview

The table CSC_PROF_TABLE_COLUMNS_B is a core data repository within the Oracle E-Business Suite Customer Care (CSC) module, specifically for versions 12.1.1 and 12.2.2. It functions as the base table for defining and storing the metadata required for drilldown functionality associated with profile variables. Profile variables are key data points used throughout the Customer Care application. This table's primary role is to configure the dynamic navigation from a displayed profile variable value to a more detailed transactional form, thereby enabling deeper data investigation and user workflow.

Key Information Stored

The table stores the technical mapping details that link a profile variable to its corresponding drilldown destination. While the full column list is not detailed in the provided metadata, the description and relationships indicate it holds critical identifiers. The central piece of data is the BLOCK_ID, a foreign key linking the drilldown definition to its parent profile block in the CSC_PROF_BLOCKS_B table. Crucially, the table stores the names of the database TABLE and COLUMN that contain the data to be queried for the drilldown. Furthermore, it stores an OBJECT_CODE, which is used to resolve and launch the specific Oracle EBS form function (e.g., a specific transaction form) that will display the detailed data, completing the end-to-end drilldown navigation path.

Common Use Cases and Queries

The primary use case is the administration and configuration of profile drilldowns. System administrators or implementers query and maintain this table to define or troubleshoot how users navigate from summary profile data to underlying transactions. A common diagnostic query would join this table to its parent block table to understand the full drilldown setup for a given profile area. For example:

  • Identifying all configured drilldowns: SELECT c.table_name, c.column_name, c.object_code, b.block_name FROM csc_prof_table_columns_b c, csc_prof_blocks_b b WHERE c.block_id = b.block_id;
  • Troubleshooting a non-functional drilldown by verifying the object_code maps to a valid form function or by checking the referenced table and column names for accuracy.

Direct reporting from this table is rare; it is primarily a configuration object queried for setup and support purposes.

Related Objects

CSC_PROF_TABLE_COLUMNS_B has a direct and documented foreign key relationship within the CSC schema, as per the provided metadata. The key relationship is:

  • CSC_PROF_BLOCKS_B: This table is the parent, containing the definition of profile blocks. The relationship is enforced through the foreign key column CSC_PROF_TABLE_COLUMNS_B.BLOCK_ID, which references the CSC_PROF_BLOCKS_B table. Any drilldown column definition must be associated with a valid profile block. This table is likely referenced by various views or APIs within the Customer Care module that render profile checklists and execute the drilldown functionality, though those specific objects are not listed in the provided excerpt.