Search Results rules




The AR_BPA_RULES_TL table in Oracle E-Business Suite (EBS) 12.1.1 or 12.2.2 is a critical component of the Accounts Receivable (AR) module, specifically tied to the Business Process Automation (BPA) framework. This table stores translated descriptions and names of BPA rules, enabling multilingual support for rule definitions across different locales. Below is a detailed breakdown of its structure, purpose, and functional significance.

Table Overview

AR_BPA_RULES_TL is a child table of AR_BPA_RULES_B, which holds the base data for BPA rules. The "_TL" suffix denotes its role as a translation table, adhering to Oracle's multilingual architecture. It stores language-specific attributes of BPA rules, ensuring that rule descriptions and names are displayed correctly in the user's preferred language.

Key Columns

  • RULE_ID: Foreign key linking to AR_BPA_RULES_B.RULE_ID, ensuring referential integrity.
  • LANGUAGE: Stores the ISO language code (e.g., 'US' for English, 'FR' for French).
  • SOURCE_LANG: Indicates the source language of the original record, used for synchronization during translations.
  • RULE_NAME: The translated name of the BPA rule, displayed in the UI.
  • DESCRIPTION: A detailed explanation of the rule's purpose, translated for end-users.

Functional Role

BPA rules automate AR processes like invoice validation, dunning, and payment application. The AR_BPA_RULES_TL table ensures these rules are accessible globally by storing localized text. For example, a French user sees rule names and descriptions in French, while a German user sees them in German. This is critical for multinational deployments of Oracle EBS.

Integration with BPA Framework

The table is queried by the Oracle Forms and Oracle Application Framework (OAF) interfaces when rendering rule definitions. During rule execution, the system references AR_BPA_RULES_B for logic but uses AR_BPA_RULES_TL for user-facing text. This separation ensures performance efficiency while maintaining multilingual flexibility.

Technical Considerations

  • Indexing: Typically indexed on RULE_ID and LANGUAGE for fast joins with the base table.
  • Seed Data: Oracle provides seed data for predefined rules, but custom rules require manual translation entries.
  • Upgrades: During EBS upgrades, this table is preserved but may require additional translations for new features.

Customization Impact

Modifications to BPA rules (e.g., adding custom validations) necessitate updates to both AR_BPA_RULES_B and AR_BPA_RULES_TL. Failure to update the TL table results in missing or untranslated text in non-base languages.

Example Use Case

A company operating in the U.S. and Spain configures a BPA rule to validate invoice amounts. The base rule is created in English, and a Spanish translation is added to AR_BPA_RULES_TL with LANGUAGE = 'ES'. Spanish users now see the rule name and description in their local language.

Conclusion

AR_BPA_RULES_TL is a vital element of Oracle EBS's AR module, enabling multilingual BPA rule management. Its proper maintenance ensures seamless automation of receivables processes across global enterprises, aligning with Oracle's design principles of scalability and localization.

  • Lookup Type: HZ_DL_DSS_RULES 12.1.1

    product: AR - Receivables ,  meaning: DSS Rules for Data Librarians ,  description: Data Sharing and Security Rules for Data Librarians , 

  • Lookup Type: HZ_DL_DSS_RULES 12.2.2

    product: AR - Receivables ,  meaning: DSS Rules for Data Librarians ,  description: Data Sharing and Security Rules for Data Librarians , 

  • Concurrent Program: ARHDQCMAL 12.1.1

    execution_filename: HZ_MATCH_RULE_COMPILE.compile_all_rules ,  product: AR - Receivables ,  user_name: DQM Compile All Rules ,  description: Compile All DQM Match Rules ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: ARHDQCMAL 12.2.2

    execution_filename: HZ_MATCH_RULE_COMPILE.compile_all_rules ,  product: AR - Receivables ,  user_name: DQM Compile All Rules ,  description: Compile All DQM Match Rules ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: RAXARL 12.1.1

    execution_filename: RAXARL ,  product: AR - Receivables ,  user_name: RAXARL ,  description: Accounting Rules Report ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: ARXPAR 12.2.2

    execution_filename: ARXPAR ,  product: AR - Receivables ,  user_name: ARXPAR ,  description: Payment Application Rules Listing Report ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: RAXARL 12.2.2

    execution_filename: RAXARL ,  product: AR - Receivables ,  user_name: RAXARL ,  description: Accounting Rules Report ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: ARXGRL 12.1.1

    execution_filename: ARXGRL ,  product: AR - Receivables ,  user_name: ARXGRL ,  description: Ordering and Grouping Rules Listing ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: ARXGRL 12.2.2

    execution_filename: ARXGRL ,  product: AR - Receivables ,  user_name: ARXGRL ,  description: Ordering and Grouping Rules Listing ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: ARXPAR 12.1.1

    execution_filename: ARXPAR ,  product: AR - Receivables ,  user_name: ARXPAR ,  description: Payment Application Rules Listing Report ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: ARXPAR_XML 12.2.2

    product: AR - Receivables ,  user_name: AutoCash Rules (XML) ,  description: AutoCash Rules Report ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Java Concurrent Program , 

  • Concurrent Program: RAXARL_XML 12.2.2

    product: AR - Receivables ,  user_name: Accounting Rules Listing Report (XML) ,  description: Accounting Rules Report ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Java Concurrent Program , 

  • Concurrent Program: ARXPAR_XML 12.1.1

    product: AR - Receivables ,  user_name: AutoCash Rules (XML) - Not Supported: Reserved For Future Use ,  description: AutoCash Rules Report ,  argument_method: Standard ,  enabled: No ,  execution_method: Java Concurrent Program , 

  • Concurrent Program: ARXGRL_XML 12.2.2

    product: AR - Receivables ,  user_name: Ordering and Grouping Rules Listing (XML) ,  description: Ordering and Grouping Rules Listing Report ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Java Concurrent Program , 

  • Concurrent Program: RAXARL_XML 12.1.1

    product: AR - Receivables ,  user_name: Accounting Rules Listing Report (XML) - Not Supported: Reserved For Future Use ,  description: Accounting Rules Report ,  argument_method: Standard ,  enabled: No ,  execution_method: Java Concurrent Program , 

  • Concurrent Program: ARXGRL_XML 12.1.1

    product: AR - Receivables ,  user_name: Ordering and Grouping Rules Listing (XML) - Not Supported: Reserved For Future Use ,  description: Ordering and Grouping Rules Listing Report ,  argument_method: Standard ,  enabled: No ,  execution_method: Java Concurrent Program , 

  • Table: AR_BPA_RULES_TL 12.1.1

    owner:AR,  object_type:TABLE,  fnd_design_data:AR.AR_BPA_RULES_TL,  object_name:AR_BPA_RULES_TL,  status:VALID,  product: AR - Receivables ,  description: The AR_BPA_RULES_TL table provides multilingual support (MLS) for assignment rules defined in Bill Presentment Architecture. Data in this table is maintained in the Assignment Rules page. Each row includes the rule name and description. MLS ,  implementation_dba_data: AR.AR_BPA_RULES_TL , 

  • Table: AR_BPA_RULES_TL 12.2.2

    owner:AR,  object_type:TABLE,  fnd_design_data:AR.AR_BPA_RULES_TL,  object_name:AR_BPA_RULES_TL,  status:VALID,  product: AR - Receivables ,  description: The AR_BPA_RULES_TL table provides multilingual support (MLS) for assignment rules defined in Bill Presentment Architecture. Data in this table is maintained in the Assignment Rules page. Each row includes the rule name and description. MLS ,  implementation_dba_data: AR.AR_BPA_RULES_TL , 

  • Table: HZ_MATCH_RULES_B 12.1.1

    owner:AR,  object_type:TABLE,  fnd_design_data:AR.HZ_MATCH_RULES_B,  object_name:HZ_MATCH_RULES_B,  status:VALID,  product: AR - Receivables ,  description: Stores information about match rules. ,  implementation_dba_data: AR.HZ_MATCH_RULES_B , 

  • Table: HZ_MATCH_RULES_B 12.2.2

    owner:AR,  object_type:TABLE,  fnd_design_data:AR.HZ_MATCH_RULES_B,  object_name:HZ_MATCH_RULES_B,  status:VALID,  product: AR - Receivables ,  description: Stores information about match rules. ,  implementation_dba_data: AR.HZ_MATCH_RULES_B , 

  • Table: AR_APP_RULES 12.1.1

    owner:AR,  object_type:TABLE,  fnd_design_data:AR.AR_APP_RULES,  object_name:AR_APP_RULES,  status:VALID,  product: AR - Receivables ,  description: Application Rules ,  implementation_dba_data: AR.AR_APP_RULES , 

  • Table: AR_APP_RULES 12.2.2

    owner:AR,  object_type:TABLE,  fnd_design_data:AR.AR_APP_RULES,  object_name:AR_APP_RULES,  status:VALID,  product: AR - Receivables ,  description: Application Rules ,  implementation_dba_data: AR.AR_APP_RULES , 

  • Table: HZ_MATCH_RULES_TL 12.1.1

    owner:AR,  object_type:TABLE,  fnd_design_data:AR.HZ_MATCH_RULES_TL,  object_name:HZ_MATCH_RULES_TL,  status:VALID,  product: AR - Receivables ,  description: Stores translated information about match rules. ,  implementation_dba_data: AR.HZ_MATCH_RULES_TL , 

  • Table: AR_APP_RULE_DETAILS 12.1.1

    owner:AR,  object_type:TABLE,  fnd_design_data:AR.AR_APP_RULE_DETAILS,  object_name:AR_APP_RULE_DETAILS,  status:VALID,  product: AR - Receivables ,  description: Detailed information about individual application rules ,  implementation_dba_data: AR.AR_APP_RULE_DETAILS , 

  • Table: RA_RULE_SCHEDULES 12.2.2

    owner:AR,  object_type:TABLE,  fnd_design_data:AR.RA_RULE_SCHEDULES,  object_name:RA_RULE_SCHEDULES,  status:VALID,  product: AR - Receivables ,  description: Accounting schedules for invoices with rules ,  implementation_dba_data: AR.RA_RULE_SCHEDULES , 

  • Table: HZ_MATCH_RULES_TL 12.2.2

    owner:AR,  object_type:TABLE,  fnd_design_data:AR.HZ_MATCH_RULES_TL,  object_name:HZ_MATCH_RULES_TL,  status:VALID,  product: AR - Receivables ,  description: Stores translated information about match rules. ,  implementation_dba_data: AR.HZ_MATCH_RULES_TL , 

  • Table: RA_RULE_SCHEDULES 12.1.1

    owner:AR,  object_type:TABLE,  fnd_design_data:AR.RA_RULE_SCHEDULES,  object_name:RA_RULE_SCHEDULES,  status:VALID,  product: AR - Receivables ,  description: Accounting schedules for invoices with rules ,  implementation_dba_data: AR.RA_RULE_SCHEDULES , 

  • Table: AR_APP_RULE_DETAILS 12.2.2

    owner:AR,  object_type:TABLE,  fnd_design_data:AR.AR_APP_RULE_DETAILS,  object_name:AR_APP_RULE_DETAILS,  status:VALID,  product: AR - Receivables ,  description: Detailed information about individual application rules ,  implementation_dba_data: AR.AR_APP_RULE_DETAILS , 

  • Table: HZ_MATCH_RULE_CONDITIONS 12.1.1

    owner:AR,  object_type:TABLE,  fnd_design_data:AR.HZ_MATCH_RULE_CONDITIONS,  object_name:HZ_MATCH_RULE_CONDITIONS,  status:VALID,  product: AR - Receivables ,  description: Stores information conditions and match rules in match rule sets ,  implementation_dba_data: AR.HZ_MATCH_RULE_CONDITIONS , 

  • Table: HZ_MATCH_RULE_CONDITIONS 12.2.2

    owner:AR,  object_type:TABLE,  fnd_design_data:AR.HZ_MATCH_RULE_CONDITIONS,  object_name:HZ_MATCH_RULE_CONDITIONS,  status:VALID,  product: AR - Receivables ,  description: Stores information conditions and match rules in match rule sets ,  implementation_dba_data: AR.HZ_MATCH_RULE_CONDITIONS , 

  • Table: AR_BPA_RULES_B 12.2.2

    owner:AR,  object_type:TABLE,  fnd_design_data:AR.AR_BPA_RULES_B,  object_name:AR_BPA_RULES_B,  status:VALID,  product: AR - Receivables ,  description: The AR_BPA_RULES_B table stores the template assignment rules defined in Bill Presentment Architecture. ,  implementation_dba_data: AR.AR_BPA_RULES_B , 

  • Table: AR_BPA_RULE_ATTRIBUTES_TL 12.2.2

    owner:AR,  object_type:TABLE,  fnd_design_data:AR.AR_BPA_RULE_ATTRIBUTES_TL,  object_name:AR_BPA_RULE_ATTRIBUTES_TL,  status:VALID,  product: AR - Receivables ,  description: The AR_BPA_RULE_ATTRIBUTES_TL table provides multilingual support (MLS) for assignment attributes of assignment rules defined in Bill Presentment Architecture. ,  implementation_dba_data: AR.AR_BPA_RULE_ATTRIBUTES_TL , 

  • Table: AR_BPA_RULE_ATTRIBUTES_B 12.1.1

    owner:AR,  object_type:TABLE,  fnd_design_data:AR.AR_BPA_RULE_ATTRIBUTES_B,  object_name:AR_BPA_RULE_ATTRIBUTES_B,  status:VALID,  product: AR - Receivables ,  description: The AR_BPA_RULE_ATTRIBUTES_B table stores all assignment attributes of assignment rules defined in Bill Presentment Architecture. ,  implementation_dba_data: AR.AR_BPA_RULE_ATTRIBUTES_B , 

  • Table: AR_BPA_RULE_ATTRIBUTES_TL 12.1.1

    owner:AR,  object_type:TABLE,  fnd_design_data:AR.AR_BPA_RULE_ATTRIBUTES_TL,  object_name:AR_BPA_RULE_ATTRIBUTES_TL,  status:VALID,  product: AR - Receivables ,  description: The AR_BPA_RULE_ATTRIBUTES_TL table provides multilingual support (MLS) for assignment attributes of assignment rules defined in Bill Presentment Architecture. ,  implementation_dba_data: AR.AR_BPA_RULE_ATTRIBUTES_TL , 

  • Lookup Type: CREDIT_METHOD_FOR_RULES 12.1.1

    product: AR - Receivables ,  meaning: Credit Method For Rules ,  description: Credit method specifying how account assignments are credited , 

  • Table: HZ_CREDIT_USAGE_RULES 12.1.1

    owner:AR,  object_type:TABLE,  fnd_design_data:AR.HZ_CREDIT_USAGE_RULES,  object_name:HZ_CREDIT_USAGE_RULES,  status:VALID,  product: AR - Receivables ,  description: Usage rules assigned to each credit limit ,  implementation_dba_data: AR.HZ_CREDIT_USAGE_RULES , 

  • Table: HZ_CREDIT_USAGE_RULES 12.2.2

    owner:AR,  object_type:TABLE,  fnd_design_data:AR.HZ_CREDIT_USAGE_RULES,  object_name:HZ_CREDIT_USAGE_RULES,  status:VALID,  product: AR - Receivables ,  description: Usage rules assigned to each credit limit ,  implementation_dba_data: AR.HZ_CREDIT_USAGE_RULES , 

  • Table: HZ_PARTY_USAGE_RULES 12.2.2

    owner:AR,  object_type:TABLE,  fnd_design_data:AR.HZ_PARTY_USAGE_RULES,  object_name:HZ_PARTY_USAGE_RULES,  status:VALID,  product: AR - Receivables ,  description: Stores party usage rules. ,  implementation_dba_data: AR.HZ_PARTY_USAGE_RULES , 

  • Lookup Type: CREDIT_METHOD_FOR_RULES 12.2.2

    product: AR - Receivables ,  meaning: Credit Method For Rules ,  description: Credit method specifying how account assignments are credited , 

  • Table: AR_BPA_RULES_B 12.1.1

    owner:AR,  object_type:TABLE,  fnd_design_data:AR.AR_BPA_RULES_B,  object_name:AR_BPA_RULES_B,  status:VALID,  product: AR - Receivables ,  description: The AR_BPA_RULES_B table stores the template assignment rules defined in Bill Presentment Architecture. ,  implementation_dba_data: AR.AR_BPA_RULES_B , 

  • Table: AR_CMGT_AUTO_RULE_DTLS 12.2.2

    owner:AR,  object_type:TABLE,  fnd_design_data:AR.AR_CMGT_AUTO_RULE_DTLS,  object_name:AR_CMGT_AUTO_RULE_DTLS,  status:VALID,  product: AR - Receivables ,  description: The AR_CMGT_AUTO_RULE_DTLS table stores rules about whether a credit review and credit decision may be processed without user intervention. ,  implementation_dba_data: AR.AR_CMGT_AUTO_RULE_DTLS , 

  • Lookup Type: RECEIPT_MATURITY_DATE_RULES 12.1.1

    product: AR - Receivables ,  meaning: Receipt Maturity Date Rules ,  description: Values for Payment Maturity Date rule in Define Payment Methods , 

  • Lookup Type: RECEIPT_MATURITY_DATE_RULES 12.2.2

    product: AR - Receivables ,  meaning: Receipt Maturity Date Rules ,  description: Values for Payment Maturity Date rule in Define Payment Methods , 

  • Table: AR_CMGT_AUTO_RULES 12.2.2

    owner:AR,  object_type:TABLE,  fnd_design_data:AR.AR_CMGT_AUTO_RULES,  object_name:AR_CMGT_AUTO_RULES,  status:VALID,  product: AR - Receivables ,  description: The AR_CMGT_AUTO_RULES table stores rules about whether a credit review and credit decision may be accomplished without user intervention. ,  implementation_dba_data: AR.AR_CMGT_AUTO_RULES , 

  • Lookup Type: ARXTWLIN_REGION_CONTROL 12.2.2

    product: AR - Receivables ,  meaning: Arxtwlin Region Control ,  description: Lines alternative region , 

  • Table: AR_CMGT_AUTO_RULES 12.1.1

    owner:AR,  object_type:TABLE,  fnd_design_data:AR.AR_CMGT_AUTO_RULES,  object_name:AR_CMGT_AUTO_RULES,  status:VALID,  product: AR - Receivables ,  description: The AR_CMGT_AUTO_RULES table stores rules about whether a credit review and credit decision may be accomplished without user intervention. ,  implementation_dba_data: AR.AR_CMGT_AUTO_RULES , 

  • Table: AR_CMGT_AUTO_RULE_DTLS 12.1.1

    owner:AR,  object_type:TABLE,  fnd_design_data:AR.AR_CMGT_AUTO_RULE_DTLS,  object_name:AR_CMGT_AUTO_RULE_DTLS,  status:VALID,  product: AR - Receivables ,  description: The AR_CMGT_AUTO_RULE_DTLS table stores rules about whether a credit review and credit decision may be processed without user intervention. ,  implementation_dba_data: AR.AR_CMGT_AUTO_RULE_DTLS , 

  • Table: AR_BPA_RULE_TEMPLATES 12.1.1

    owner:AR,  object_type:TABLE,  fnd_design_data:AR.AR_BPA_RULE_TEMPLATES,  object_name:AR_BPA_RULE_TEMPLATES,  status:VALID,  product: AR - Receivables ,  description: The AR_BPA_RULE_TEMPLATES table stores all assignment templates for assignment rules defined in Bill Presentment Architecture. ,  implementation_dba_data: AR.AR_BPA_RULE_TEMPLATES , 

  • Table: AR_BPA_RULE_TEMPLATES 12.2.2

    owner:AR,  object_type:TABLE,  fnd_design_data:AR.AR_BPA_RULE_TEMPLATES,  object_name:AR_BPA_RULE_TEMPLATES,  status:VALID,  product: AR - Receivables ,  description: The AR_BPA_RULE_TEMPLATES table stores all assignment templates for assignment rules defined in Bill Presentment Architecture. ,  implementation_dba_data: AR.AR_BPA_RULE_TEMPLATES , 

  • Table: AR_BPA_RULE_ATTRIBUTES_B 12.2.2

    owner:AR,  object_type:TABLE,  fnd_design_data:AR.AR_BPA_RULE_ATTRIBUTES_B,  object_name:AR_BPA_RULE_ATTRIBUTES_B,  status:VALID,  product: AR - Receivables ,  description: The AR_BPA_RULE_ATTRIBUTES_B table stores all assignment attributes of assignment rules defined in Bill Presentment Architecture. ,  implementation_dba_data: AR.AR_BPA_RULE_ATTRIBUTES_B ,