Search Results line item display for gl account
The ENI_Tables.html file in Oracle E-Business Suite (EBS) 12.1.1 or 12.2.2 pertains to the Enterprise Navigation Intelligence (ENI) framework, which is a critical component for enhancing user navigation and reporting capabilities within the Oracle EBS environment. ENI provides a structured approach to tracking and analyzing user navigation patterns, enabling organizations to optimize workflows, improve system performance, and enhance user experience. The ENI_Tables.html file typically documents the database tables associated with the ENI framework, detailing their schema, relationships, and functional usage. In Oracle EBS 12.1.1 and 12.2.2, the ENI framework leverages a set of predefined tables to store metadata and transactional data related to user navigation. These tables are integral to the ENI functionality, as they capture details such as user sessions, accessed forms, navigation paths, and performance metrics. Key tables documented in ENI_Tables.html may include: 1. ENI_SESSIONS: This table stores session-level information, including user identifiers, login timestamps, and session durations. It serves as the foundation for analyzing user engagement and system access patterns. 2. ENI_NAVIGATION_PATHS: This table records the sequence of forms and pages accessed by users during a session. It enables the reconstruction of navigation flows, which is valuable for identifying bottlenecks or inefficiencies in user workflows. 3. ENI_FORM_USAGE: This table tracks the frequency and duration of form usage across the EBS application. Organizations can leverage this data to prioritize enhancements or training for underutilized or complex forms. 4. ENI_PERFORMANCE_METRICS: This table captures performance-related data, such as response times for forms and reports. It is instrumental in diagnosing performance issues and optimizing system configurations. 5. ENI_USER_PREFERENCES: This table stores user-specific settings and preferences related to navigation, such as default forms or recently accessed items. It supports personalized user experiences within the EBS environment. The ENI_Tables.html file typically provides a comprehensive schema definition for these tables, including column names, data types, constraints, and indexes. It may also describe foreign key relationships between tables, ensuring data integrity and enabling complex queries for analytical purposes. For example, the ENI_NAVIGATION_PATHS table might reference the ENI_SESSIONS table to associate navigation paths with specific user sessions. In addition to schema details, the file may include usage guidelines, such as recommended query patterns or indexing strategies to optimize performance when extracting ENI data for reporting. This is particularly relevant for organizations implementing custom dashboards or integrating ENI data with external business intelligence tools. The ENI framework in Oracle EBS 12.1.1 and 12.2.2 is designed to be extensible, allowing organizations to customize or augment the default tables to meet specific business requirements. The ENI_Tables.html file serves as a technical reference for developers and administrators tasked with such customizations, ensuring alignment with Oracle's best practices. In summary, the ENI_Tables.html file is a vital resource for understanding the data architecture of the ENI framework in Oracle EBS. By documenting the structure and relationships of ENI-related tables, it enables organizations to harness navigation intelligence for operational improvements, user experience enhancements, and system optimization.
-
Lookup Type: ITEM
12.1.1
product: ENI - Product Intelligence , meaning: Unspecified Item , description: Type for Item not specified ,
-
Concurrent Program: EDW_ITEMS_M
12.1.1
execution_filename: EDW_ITEMS_M_C.Push , product: ENI - Product Intelligence , user_name: EDW_ITEMS_M , description: Item Dimension Collect Program , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
-
Concurrent Program: EDW_BOM_RES_M
12.1.1
execution_filename: EDW_BOM_RES_M_C.PUSH , product: ENI - Product Intelligence , user_name: EDW_BOM_RES_M , description: Resource Dimension Collect Program , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
-
Concurrent Program: ENI_DEN_INIT
12.1.1
execution_filename: ENI_DENORM_HRCHY.LOAD_PRODUCT_HIERARCHY , product: ENI - Product Intelligence , user_name: ENI_DEN_INIT , description: Load of Catalog Hierarchy into Denorm Table , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
-
Concurrent Program: ENI_VSET_CAT
12.1.1
execution_filename: ENI_VALUESET_CATEGORY.ENI_POPULATE_MAIN , product: ENI - Product Intelligence , user_name: ENI_VSET_CAT , description: Create Item Categories from Value Set , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
-
Concurrent Program: EDW_ITEMS_M_T
12.1.1
product: ENI - Product Intelligence , user_name: Load Item Dimension , description: Load Item Dimension , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
-
Concurrent Program: ENI_ITEMS_STAR_PKG
12.1.1
execution_filename: ENI_ITEMS_STAR_PKG.CREATE_STAR_TABLE , product: ENI - Product Intelligence , user_name: ENI_ITEMS_STAR_PKG , description: Update existing items into dimension , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
-
Lookup Type: ITEM_CATALOG
12.1.1
product: ENI - Product Intelligence , meaning: Item Catalog Categories , description: Unassigned Catalog Categories ,
-
Concurrent Program: STAGE20
12.1.1
product: ENI - Product Intelligence , user_name: Request Set Stage Load Item Dimension Hierarchy (20) - Request Set ENI_DBI_SETUP_RS , description: Program that loads the STAR table , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
-
Concurrent Program: Stage 20
12.1.1
product: ENI - Product Intelligence , user_name: Request Set Stage Load Item Dimension Hierarchy (20) - Request Set ENI_DBI_ITM_SETUP , description: Initial load of the STAR table , argument_method: Database fetch , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
-
Concurrent Program: LOAD_DENORMALISED_CATEGORIES
12.1.1
execution_filename: ENI_DENORM_HRCHY.LOAD_OBIEE_HIERARCHY , product: ENI - Product Intelligence , user_name: Denormalisation program for OBIEE , description: Initial Load procedure for OBIEE Denorm table , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
-
Concurrent Program: ENI_DBI_PCO_LOAD_WORKER
12.1.1
execution_filename: ENI_DBI_PCO_LOAD_PKG.part_count_collect_worker , product: ENI - Product Intelligence , user_name: Part Count Collect Worker , description: Worker Program for Part Count Collection , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
-
File: ENI_Tables.html
12.1.1
product: ENI - Product Intelligence , size: 149.432 KBytes , file_type: HTML Report , description: ENI_Tables.html is an html report that documents the table and view definitions for the ENI product. ,
-
Concurrent Program: ENI_DBI_UPDATE_PCO
12.1.1
execution_filename: ENI_DBI_PCO_LOAD_PKG.process_incident_interface_g , product: ENI - Product Intelligence , user_name: Collect Part Count Base Summary , description: Executable for Initial and Incremental Part Count Collections , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
-
Concurrent Program: ENI_DBI_PCO_LOAD
12.1.1
execution_filename: ENI_DBI_PCO_LOAD_PKG.process_incident_interface_g , product: ENI - Product Intelligence , user_name: Collect Part Count Base Summary , description: Executable for Initial and Incremental Part Count Collections , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,