Search Results fa_maint_schedule_hdr




Overview
Explore in AI Chat

Overview

The FA_MAINT_SCHEDULE_HDR table is a core data structure within the Oracle E-Business Suite Fixed Assets module (OFA). It functions as the primary repository for header-level information pertaining to maintenance scheduling requests. These requests are integral to the asset maintenance and service management processes, enabling organizations to plan, schedule, and track periodic maintenance activities for their capital assets. The table's existence underscores the integration of asset lifecycle management with preventative maintenance workflows in Oracle EBS. It acts as a parent record, defining the scope and parameters for a maintenance schedule, which is then executed and detailed through related transactional tables and concurrent programs.

Key Information Stored

The table's primary key is the SCHEDULE_ID, a unique system-generated identifier for each maintenance request. Critical foreign key columns define the scope and context of the schedule. The BOOK_TYPE_CODE links to FA_BOOK_CONTROLS, anchoring the request to a specific asset book. Asset selection is defined via FROM_ASSET_NUMBER and TO_ASSET_NUMBER (referencing FA_ADDITIONS_B) for a range, or by CATEGORY_ID (FA_CATEGORIES_B) and LOCATION_ID (FA_LOCATIONS) for a group. The CURRENCY_CODE (FND_CURRENCIES) specifies the monetary context for any cost-related data. A crucial operational column is CONCURRENT_REQUEST_ID, which links to FND_CONCURRENT_REQUESTS, tracking the status and details of the background job that processes the schedule. Additional columns typically include creation and last update dates, request status, schedule frequency, and next scheduled date.

Common Use Cases and Queries

This table is central to generating and analyzing maintenance schedules. A common use case is auditing scheduled maintenance jobs by joining to the concurrent manager table. For example, to find details of a failed schedule request:

  • SELECT fmsh.schedule_id, fmsh.book_type_code, fcr.request_id, fcr.phase_code, fcr.status_code FROM fa_maint_schedule_hdr fmsh, fnd_concurrent_requests fcr WHERE fmsh.concurrent_request_id = fcr.request_id AND fcr.phase_code = 'C' AND fcr.status_code = 'E';

Another key scenario is identifying the assets included in a specific schedule for validation or reporting purposes, requiring joins to FA_ADDITIONS_B using the from and to asset number range. Reporting on scheduled maintenance by asset category or location also relies heavily on this table as the starting point, filtering on CATEGORY_ID or LOCATION_ID before joining to detailed transaction data.

Related Objects

FA_MAINT_SCHEDULE_HDR has defined relationships with several fundamental EBS tables, as per the provided metadata. Key foreign key dependencies include FA_BOOK_CONTROLS (for the book), FA_ADDITIONS_B (for assets), FA_CATEGORIES_B, and FA_LOCATIONS. It links to FND_CURRENCIES for currency and, most operationally, to FND_CONCURRENT_REQUESTS. It is the parent table for any detailed maintenance schedule line tables (though not listed in the excerpt, such as FA_MAINT_SCHEDULE_LINES is a logical child). The table is primarily accessed and populated through the Fixed Assets application's maintenance scheduling forms and the underlying PL/SQL APIs and concurrent programs responsible for generating the actual maintenance work orders or transactions.

  • Table: FA_MAINT_SCHEDULE_HDR 12.2.2

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_MAINT_SCHEDULE_HDR,  object_name:FA_MAINT_SCHEDULE_HDR,  status:VALID,  product: OFA - Assets ,  description: Stores information about maintenance scheduling requests ,  implementation_dba_data: FA.FA_MAINT_SCHEDULE_HDR , 

  • Table: FA_MAINT_SCHEDULE_HDR 12.1.1

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_MAINT_SCHEDULE_HDR,  object_name:FA_MAINT_SCHEDULE_HDR,  status:VALID,  product: OFA - Assets ,  description: Stores information about maintenance scheduling requests ,  implementation_dba_data: FA.FA_MAINT_SCHEDULE_HDR , 

  • Table: FA_LOCATIONS 12.2.2

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_LOCATIONS,  object_name:FA_LOCATIONS,  status:VALID,  product: OFA - Assets ,  description: Location flexfield segment value combinations ,  implementation_dba_data: FA.FA_LOCATIONS , 

  • Table: FA_ADDITIONS_B 12.2.2

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_ADDITIONS_B,  object_name:FA_ADDITIONS_B,  status:VALID,  product: OFA - Assets ,  description: Descriptive information about assets (base MLS table) ,  implementation_dba_data: FA.FA_ADDITIONS_B , 

  • Table: FA_LOCATIONS 12.1.1

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_LOCATIONS,  object_name:FA_LOCATIONS,  status:VALID,  product: OFA - Assets ,  description: Location flexfield segment value combinations ,  implementation_dba_data: FA.FA_LOCATIONS , 

  • Table: FA_ADDITIONS_B 12.1.1

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_ADDITIONS_B,  object_name:FA_ADDITIONS_B,  status:VALID,  product: OFA - Assets ,  description: Descriptive information about assets (base MLS table) ,  implementation_dba_data: FA.FA_ADDITIONS_B , 

  • Table: FA_CATEGORIES_B 12.1.1

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_CATEGORIES_B,  object_name:FA_CATEGORIES_B,  status:VALID,  product: OFA - Assets ,  description: Default financial information for asset categories (base MLS table) ,  implementation_dba_data: FA.FA_CATEGORIES_B , 

  • Table: FA_CATEGORIES_B 12.2.2

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_CATEGORIES_B,  object_name:FA_CATEGORIES_B,  status:VALID,  product: OFA - Assets ,  description: Default financial information for asset categories (base MLS table) ,  implementation_dba_data: FA.FA_CATEGORIES_B , 

  • Table: FA_BOOK_CONTROLS 12.1.1

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_BOOK_CONTROLS,  object_name:FA_BOOK_CONTROLS,  status:VALID,  product: OFA - Assets ,  description: Control information that affects all assets in a depreciation book ,  implementation_dba_data: FA.FA_BOOK_CONTROLS , 

  • Table: FA_BOOK_CONTROLS 12.2.2

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_BOOK_CONTROLS,  object_name:FA_BOOK_CONTROLS,  status:VALID,  product: OFA - Assets ,  description: Control information that affects all assets in a depreciation book ,  implementation_dba_data: FA.FA_BOOK_CONTROLS ,