Search Results cs_cf_flow_type_pages




Overview
Explore in AI Chat

Overview

The CS_CF_FLOW_TYPE_PAGES table is a core configuration table within the Oracle E-Business Suite Service (CS) module, specifically for the Configurator and Flows functionality. Its primary role is to define the mapping between different service flow types and the user interface pages available for each. This table acts as a master repository that dictates which forms or pages can be accessed during the execution of a specific service flow type, enabling a structured and controlled user navigation experience. It is a foundational object for the runtime rendering of service flows in applications such as Oracle Field Service or Service Contracts, ensuring users are presented with the correct sequence of pages based on the business process.

Key Information Stored

While the provided metadata does not list individual columns, the documented relationships and primary key reveal its critical structure. The central column is the FLOW_TYPE_PAGE_ID, which serves as the unique primary key identifier for each page-to-flow type association. Another crucial column is FUNCTION_NAME, which stores a reference to an Oracle EBS function defined in the FND_FORM_FUNCTIONS table. This function corresponds to the specific form or page (often a JSP or OA Framework page) that will be invoked. The table likely contains additional descriptive and control columns, such as those to indicate the flow type code, a display sequence for the page within the flow, and active status flags, which collectively manage the availability and order of pages.

Common Use Cases and Queries

A primary use case is the administration and customization of service flow user interfaces. Implementers query this table to review or modify the pages assigned to a flow type, such as adding a custom page for a specific service process. A common reporting need is to list all pages available for a given flow type, often joined with its translated descriptions. Troubleshooting user access issues to specific flow pages also involves verifying entries in this table. A typical query pattern would join with the translatable table to fetch user-friendly page names.

  • Sample Query: SELECT ftp.FLOW_TYPE_PAGE_ID, ftp.FUNCTION_NAME, tl.PAGE_NAME FROM CS_CF_FLOW_TYPE_PAGES ftp, CS_CF_FLOW_PAGES_TL tl WHERE ftp.FLOW_TYPE_PAGE_ID = tl.FLOW_TYPE_PAGE_ID AND tl.LANGUAGE = USERENV('LANG') AND <flow_type_condition> ORDER BY ftp.SEQUENCE_NUMBER;

Related Objects

The CS_CF_FLOW_TYPE_PAGES table sits at the center of a key data model for service flows, with documented foreign key relationships to several important tables.

  • References (Outgoing FK): The table references FND_FORM_FUNCTIONS via the FUNCTION_NAME column. This links each flow page entry to the standard Oracle Applications function security and menu system.
  • Referenced By (Incoming FKs): This table is the parent for two critical child tables:
    • CS_CF_FLOW_PAGES_B references it via FLOW_TYPE_PAGE_ID. This is likely the base table holding additional configuration attributes for the flow page.
    • CS_CF_FLOW_PAGES_TL references it via FLOW_TYPE_PAGE_ID. This is the Translation table, storing the user-visible name and description of the page in multiple languages.