Search Results roster for global process_peak_oct_nov_dec_2022.xlsx

The AST_CGI_SWITCHES table in Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 is a configuration table that plays a critical role in the Advanced Supply Chain Planning (ASCP) module. This table stores system-level switches that control the behavior of various functionalities within the ASCP application, particularly those related to the Concurrent Processing Interface (CGI) used for planning engine operations. Below is a detailed breakdown of its structure, purpose, and significance in Oracle EBS.

1. Purpose of AST_CGI_SWITCHES

The primary purpose of the AST_CGI_SWITCHES table is to store configuration flags that determine how the ASCP engine processes planning data. These switches act as toggles for enabling or disabling specific features, optimizing performance, or altering default behaviors during planning runs. The table is essential for administrators and implementers who need to fine-tune ASCP operations without modifying the core application code.

2. Key Columns and Structure

The table typically contains the following key columns:

SWITCH_NAME: A unique identifier for the switch (e.g., ENABLE_DEBUG_MODE, USE_PARALLEL_PROCESSING).
SWITCH_VALUE: A boolean or text value (e.g., Y/N, TRUE/FALSE) that activates or deactivates the switch.
DESCRIPTION: A brief explanation of the switch's purpose.
LAST_UPDATE_DATE and LAST_UPDATED_BY: Audit columns tracking modifications.

3. Common Switches and Their Functions

Some of the frequently used switches in AST_CGI_SWITCHES include:

ENABLE_DEBUG_MODE: When set to Y, generates detailed logs for troubleshooting planning engine issues.
OPTIMIZE_MRP_CALCULATIONS: Improves performance by optimizing Material Requirements Planning (MRP) calculations.
ALLOW_PLAN_OVERWRITE: Controls whether existing plans can be overwritten during a new planning run.
USE_INCREMENTAL_REFRESH: Enables incremental data refreshes instead of full reloads, reducing processing time.

4. Integration with ASCP Engine

The ASCP engine references AST_CGI_SWITCHES during initialization and execution. For example:

During a planning run, the engine checks USE_PARALLEL_PROCESSING to determine if tasks should be distributed across multiple CPUs.
Debug-related switches influence log verbosity, aiding in root cause analysis for failed runs.

5. Administration and Best Practices

To modify switches, administrators typically use Oracle's backend SQL scripts or custom front-end utilities. Key best practices include:

Documenting changes to avoid unintended side effects.
Testing switches in a non-production environment before deployment.
Monitoring performance impacts after enabling resource-intensive switches like parallel processing.

6. Impact on Upgrades (12.1.1 to 12.2.2)

In Oracle EBS 12.2.2, the table retains its structure but may include additional switches to support new ASCP features. During upgrades, custom switch settings should be reviewed and validated to ensure compatibility with the updated planning engine logic.

7. Conclusion

The AST_CGI_SWITCHES table is a pivotal component in Oracle ASCP, offering granular control over planning operations. Proper configuration of these switches can significantly enhance performance, debugging, and functionality. Administrators must exercise caution when modifying values, as incorrect settings may disrupt planning workflows or degrade system efficiency.

Lookup Type: AST_HGRID_EVENT_ROSTER 12.1.1
product: AST - TeleSales , meaning: OTS: Event Registration Roster HGrid Columns , description: HGrid Columns for Event Registration Roster ,
Lookup Type: AST_HGRID_EVENT_ROSTER 12.2.2
product: AST - TeleSales , meaning: OTS: Event Registration Roster HGrid Columns , description: HGrid Columns for Event Registration Roster ,
Lookup Type: AST_SCALING_FACTOR 12.1.1
product: AST - TeleSales , meaning: OTS: Amount Scaling Factor , description: Amount scaling factor for displaying amounts ,
Lookup Type: AST_SCALING_FACTOR 12.2.2
product: AST - TeleSales , meaning: OTS: Amount Scaling Factor , description: Amount scaling factor for displaying amounts ,
Lookup Type: AST_CUTSK_QUERY_TYPE 12.2.2
product: AST - TeleSales , meaning: Query Type Values for Task Tab , description: Query Type Values for Task Tab ,
Lookup Type: AST_UWQ_LABELS 12.1.1
product: AST - TeleSales , meaning: Labels Used by UWQ TeleSales Extensions , description: These labels are passed to UWQ for various reasons related to extending UWQ to see TeleSales items as work types. ,
Lookup Type: AST_CUTSK_QUERY_TYPE 12.1.1
product: AST - TeleSales , meaning: Query Type Values for Task Tab , description: Query Type Values for Task Tab ,
Lookup Type: AST_UWQ_LABELS 12.2.2
product: AST - TeleSales , meaning: Labels Used by UWQ TeleSales Extensions , description: These labels are passed to UWQ for various reasons related to extending UWQ to see TeleSales items as work types. ,
Lookup Type: AST_CUORD_FILTER_BY 12.1.1
product: AST - TeleSales , meaning: Filter By Values for Order Tab , description: Filter By values for the Order Tab ,
Lookup Type: AST_CUORD_FILTER_BY 12.2.2
product: AST - TeleSales , meaning: Filter By Values for Order Tab , description: Filter By values for the Order Tab ,
Table: AST_CGI_SWITCHES 12.1.1
owner:AST, object_type:TABLE, fnd_design_data:AST.AST_CGI_SWITCHES, object_name:AST_CGI_SWITCHES, status:VALID, product: AST - TeleSales , description: Metadata for query string switches , implementation_dba_data: AST.AST_CGI_SWITCHES ,
Table: AST_QUERY_STRINGS 12.1.1
owner:AST, object_type:TABLE, fnd_design_data:AST.AST_QUERY_STRINGS, object_name:AST_QUERY_STRINGS, status:VALID, product: AST - TeleSales , description: CGI query string for a site , implementation_dba_data: AST.AST_QUERY_STRINGS ,
Table: AST_CGI_SWITCHES 12.2.2
owner:AST, object_type:TABLE, fnd_design_data:AST.AST_CGI_SWITCHES, object_name:AST_CGI_SWITCHES, status:VALID, product: AST - TeleSales , description: Metadata for query string switches , implementation_dba_data: AST.AST_CGI_SWITCHES ,
Table: AST_QUERY_STRINGS 12.2.2
owner:AST, object_type:TABLE, fnd_design_data:AST.AST_QUERY_STRINGS, object_name:AST_QUERY_STRINGS, status:VALID, product: AST - TeleSales , description: CGI query string for a site , implementation_dba_data: AST.AST_QUERY_STRINGS ,
Table: AST_SWITCH_DATA 12.2.2
owner:AST, object_type:TABLE, fnd_design_data:AST.AST_SWITCH_DATA, object_name:AST_SWITCH_DATA, status:VALID, product: AST - TeleSales , description: Metadata for all data on a CGI switch , implementation_dba_data: AST.AST_SWITCH_DATA ,
Table: AST_SWITCH_DATA 12.1.1
owner:AST, object_type:TABLE, fnd_design_data:AST.AST_SWITCH_DATA, object_name:AST_SWITCH_DATA, status:VALID, product: AST - TeleSales , description: Metadata for all data on a CGI switch , implementation_dba_data: AST.AST_SWITCH_DATA ,
Lookup Type: AST_TASK_DATE_TYPE 12.1.1
product: AST - TeleSales , meaning: AST_TASK_DATE_TYPE , description: OTS: Date Type values for AST_DEFAULT_TASK_DATE_TYPE profile ,
Lookup Type: AST_TASK_DATE_TYPE 12.2.2
product: AST - TeleSales , meaning: AST_TASK_DATE_TYPE , description: OTS: Date Type values for AST_DEFAULT_TASK_DATE_TYPE profile ,
Table: AST_RS_CAMPAIGNS 12.1.1
owner:AST, object_type:TABLE, fnd_design_data:AST.AST_RS_CAMPAIGNS, object_name:AST_RS_CAMPAIGNS, status:VALID, product: AST - TeleSales , description: Used for assigning Campaigns to Resources , implementation_dba_data: AST.AST_RS_CAMPAIGNS ,
Lookup Type: AST_LEAD_QUAL_STATUS 12.2.2
product: AST - TeleSales , meaning: AST_LEAD_QUAL_STATUS , description: Status list for Lead ,
File: AST_Tables.html 12.1.1
product: AST - TeleSales , size: 1.724 MBytes , file_type: HTML Report , description: AST_Tables.html is an html report that documents the table and view definitions for the AST product. ,
Table: AST_RS_CAMPAIGNS 12.2.2
owner:AST, object_type:TABLE, fnd_design_data:AST.AST_RS_CAMPAIGNS, object_name:AST_RS_CAMPAIGNS, status:VALID, product: AST - TeleSales , description: Used for assigning Campaigns to Resources , implementation_dba_data: AST.AST_RS_CAMPAIGNS ,
Lookup Type: AST_LEAD_QUAL_STATUS 12.1.1
product: AST - TeleSales , meaning: AST_LEAD_QUAL_STATUS , description: Status list for Lead ,
File: AST_Tables.html 12.2.2
product: AST - TeleSales , size: 1.72 MBytes , file_type: HTML Report , description: AST_Tables.html is an html report that documents the table and view definitions for the AST product. ,
Lookup Type: AST_SEARCH_TAB 12.2.2
product: AST - TeleSales , meaning: AST_SEARCH_TAB , description: Tab list for Universal Search ,
Lookup Type: AST_SEARCH_TAB 12.1.1
product: AST - TeleSales , meaning: AST_SEARCH_TAB , description: Tab list for Universal Search ,
Table: AST_GRP_CAMPAIGNS 12.1.1
owner:AST, object_type:TABLE, fnd_design_data:AST.AST_GRP_CAMPAIGNS, object_name:AST_GRP_CAMPAIGNS, status:VALID, product: AST - TeleSales , description: This table stores the information for the mapping of resource groups to campaigns , implementation_dba_data: AST.AST_GRP_CAMPAIGNS ,
Table: AST_GRP_CAMPAIGNS 12.2.2
owner:AST, object_type:TABLE, fnd_design_data:AST.AST_GRP_CAMPAIGNS, object_name:AST_GRP_CAMPAIGNS, status:VALID, product: AST - TeleSales , description: This table stores the information for the mapping of resource groups to campaigns , implementation_dba_data: AST.AST_GRP_CAMPAIGNS ,
Lookup Type: AST_HGRID_EVENT_RECAP 12.2.2
product: AST - TeleSales , meaning: OTS: Event Registration Review HGrid Columns , description: HGrid columns for Event Registration Review ,
Lookup Type: AST_HGRID_EVENT_RECAP 12.1.1
product: AST - TeleSales , meaning: OTS: Event Registration Review HGrid Columns , description: HGrid columns for Event Registration Review ,
View: AST_ACCOUNT_PARTIES_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:AST.AST_ACCOUNT_PARTIES_V, object_name:AST_ACCOUNT_PARTIES_V, status:VALID, product: AST - TeleSales , description: AST_ACCOUNT_PARTIES_V retrieves limited party details for a customer account. , implementation_dba_data: APPS.AST_ACCOUNT_PARTIES_V ,
View: AST_SUSPENSION_ACTIVITY_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:AST.AST_SUSPENSION_ACTIVITY_V, object_name:AST_SUSPENSION_ACTIVITY_V, status:VALID, product: AST - TeleSales , description: AST_SUSPENSION_ACTIVITY_V retrieves suspension activity for a customer account. , implementation_dba_data: APPS.AST_SUSPENSION_ACTIVITY_V ,
View: AST_ACCOUNT_PARTIES_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:AST.AST_ACCOUNT_PARTIES_V, object_name:AST_ACCOUNT_PARTIES_V, status:VALID, product: AST - TeleSales , description: AST_ACCOUNT_PARTIES_V retrieves limited party details for a customer account. , implementation_dba_data: APPS.AST_ACCOUNT_PARTIES_V ,
View: AST_SUSPENSION_ACTIVITY_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:AST.AST_SUSPENSION_ACTIVITY_V, object_name:AST_SUSPENSION_ACTIVITY_V, status:VALID, product: AST - TeleSales , description: AST_SUSPENSION_ACTIVITY_V retrieves suspension activity for a customer account. , implementation_dba_data: APPS.AST_SUSPENSION_ACTIVITY_V ,
Lookup Type: AST_EBC_TAB_LABEL 12.2.2
product: AST - TeleSales , meaning: OTS:eBusiness Center Tab Labels , description: OTS:Labels for the various tabs in eBusiness Center ,
Lookup Type: AST_EBC_TAB_LABEL 12.1.1
product: AST - TeleSales , meaning: OTS:eBusiness Center Tab Labels , description: OTS:Labels for the various tabs in eBusiness Center ,
View: AST_BILLING_PREFERENCES_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:AST.AST_BILLING_PREFERENCES_V, object_name:AST_BILLING_PREFERENCES_V, status:VALID, product: AST - TeleSales , description: AST_BILLING_PREFERENCES_V retrieves billing preferences for a customer account. , implementation_dba_data: APPS.AST_BILLING_PREFERENCES_V ,
View: AST_BILLING_PREFERENCES_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:AST.AST_BILLING_PREFERENCES_V, object_name:AST_BILLING_PREFERENCES_V, status:VALID, product: AST - TeleSales , description: AST_BILLING_PREFERENCES_V retrieves billing preferences for a customer account. , implementation_dba_data: APPS.AST_BILLING_PREFERENCES_V ,
View: AST_ACCT_RELATIONSHIP_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:AST.AST_ACCT_RELATIONSHIP_V, object_name:AST_ACCT_RELATIONSHIP_V, status:VALID, product: AST - TeleSales , description: AST_ACCT_RELATIONSHIP_V retrieves related accounts for a customer account. , implementation_dba_data: APPS.AST_ACCT_RELATIONSHIP_V ,
View: AST_ACCT_RELATIONSHIP_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:AST.AST_ACCT_RELATIONSHIP_V, object_name:AST_ACCT_RELATIONSHIP_V, status:VALID, product: AST - TeleSales , description: AST_ACCT_RELATIONSHIP_V retrieves related accounts for a customer account. , implementation_dba_data: APPS.AST_ACCT_RELATIONSHIP_V ,
View: AST_QUOTES_UWQ_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:AST.AST_QUOTES_UWQ_V, object_name:AST_QUOTES_UWQ_V, status:VALID, product: AST - TeleSales , description: View for Quotes Node on UWQ. , implementation_dba_data: APPS.AST_QUOTES_UWQ_V ,
View: AST_QUOTES_UWQ_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:AST.AST_QUOTES_UWQ_V, object_name:AST_QUOTES_UWQ_V, status:VALID, product: AST - TeleSales , description: View for Quotes Node on UWQ. , implementation_dba_data: APPS.AST_QUOTES_UWQ_V ,