Search Results bsc_user_info_pk

Overview

The BSC_USER_INFO table is a data object within the Oracle E-Business Suite (EBS) Balanced Scorecard (BSC) module, which is designated as obsolete. Its primary role was to store connection-related information for users of the Balanced Scorecard functionality. This table served as a supporting entity, linking user-specific connection details to the core user definitions maintained in the BSC_USERS table. As the module is obsolete, this table and its associated data are no longer actively implemented or maintained in standard EBS 12.1.1 or 12.2.2 databases, as explicitly noted in the provided metadata.

Key Information Stored

Based on the documented structure, the table's primary purpose is to hold connection metadata. The key column is the SID (System ID), which serves as the table's primary key (BSC_USER_INFO_PK). The most significant data relationship is established through the USER_ID column, which is a foreign key referencing the BSC_USERS table. This design indicates that for each user record in BSC_USERS, there could be associated connection information records in BSC_USER_INFO. The specific nature of the "connection information" (e.g., session details, login timestamps, or connection parameters) is not detailed in the provided excerpt, but the structure centers on this user-linkage.

Common Use Cases and Queries

In an active BSC environment, this table would have been queried to retrieve or audit user connection data. Common operational and reporting scenarios would have included identifying active user sessions or joining to the user master table for detailed connection reports. A typical query pattern would involve joining to the BSC_USERS table to get user names or other attributes.

SELECT u.USER_NAME, i.*
FROM BSC_USER_INFO i,
     BSC_USERS u
WHERE i.USER_ID = u.USER_ID;

Given the module's obsolete status, current use cases are largely limited to historical data analysis, data migration projects, or cleanup activities for organizations that previously used the Balanced Scorecard module.

Related Objects

The table has a direct and singular documented foreign key relationship, as per the provided metadata. The related objects are:

• Primary Key Constraint: BSC_USER_INFO_PK on the SID column.
• Foreign Key Relationship (This table references): The BSC_USER_INFO.USER_ID column is a foreign key that references the BSC_USERS table. This is the primary relationship, ensuring that connection information is associated with a valid, defined user within the obsolete Balanced Scorecard system.