The ONT Transaction Types Listing report is a comprehensive configuration audit tool that provides a detailed list of all Order Management transaction types and their associated setup attributes. As an enhanced version of a standard Oracle report, its key advantage is the ability to display and compare these setups across all operating units in a single view. It is a foundational report for functional analysts and system administrators for documenting, auditing, and ensuring the consistency of the core objects that drive order processing.
Consistent and correct transaction type setup is vital for smooth order processing. However, auditing this configuration in a multi-organization environment is a significant challenge.
- Siloed Configuration Views: The standard Oracle application forms and reports typically only show the setup for the current operating unit. This makes it extremely difficult to perform a global audit or to compare setups between two different business units.
- Hidden Details: Key attributes that have a major financial or logistical impact—such as the assigned Price List, Invoicing Rule, and Credit Check rules—are not visible in a single summary view, requiring users to navigate to multiple different setup screens.
- Risk of Inconsistency: Without an easy way to compare, transaction types that should be identical can slowly drift apart between operating units, leading to process inconsistencies and user confusion.
- Manual Documentation Effort: Documenting the full setup for dozens of transaction types across a global implementation is a massive manual task, prone to errors and quickly becoming outdated.
This report provides a multi-organizational, detailed listing of transaction type setups, offering a powerful tool for configuration management.
- Global, Cross-Organization Auditing: The report's primary function is to display transaction type setups for all or multiple operating units at once, making it simple to identify and rectify any inconsistencies.
- Consolidated Attribute View: It brings together all critical attributes for a transaction type—from pricing and invoicing rules to credit checks and freight terms—into a single, easy-to-read line, providing a complete picture of the configuration.
- Enforces Standardization: It is the perfect tool for ensuring that corporate standards for order processing are being followed consistently across all business units.
- Automated and Accurate Documentation: The report serves as a live, accurate snapshot of the transaction type configuration, which can be exported and used for project documentation, audit requests, or end-user training.
The report queries the central Order Management setup tables and joins them with various related definition tables to provide a user-friendly output.
- Primary Tables Involved:
oe_transaction_types_all(the main table storing the attribute settings for each transaction type per operating unit).oe_transaction_types_tl(for the name and description of the types).oe_price_lists_v(to get the name of the assigned price list).oe_credit_check_rules(to show the credit check rule setup).ra_rules(to get the name of the accounting and invoicing rules).
- Logical Relationships: The report's logic centers on the
oe_transaction_types_alltable. For each transaction type, it performs lookups to other setup tables to translate the internal IDs for entities like Price List or Invoicing Rule into their human-readable names, making the report far more intuitive than a raw data dump.
The parameters allow for both high-level and specific views of the configuration:
- Operating Unit: Allows the user to run the report for a single OU or, if left blank, for all OUs they have access to.
- Transaction Type Code: Filters the output for a specific transaction type to see its setup across different organizations.
- Order Category Code: Allows filtering for specific classes of transaction types, such as all 'Sales Order' types or all 'Return' types.
The report is designed for rapid execution.
- Optimized for Setup Data: The report queries configuration tables that have a low volume of data, resulting in near-instantaneous execution.
- Direct SQL vs. XML: As an enhancement of a standard BI Publisher report, this Blitz Report version offers superior performance by querying the database directly and delivering the output to Excel, avoiding the overhead of the XML/XSLT processing used by its predecessor.
1. When should I use this report versus the 'Transaction Types and Line WF Processes' report? Use this 'Transaction Types Listing' report when you need to audit and compare the attributes of transaction types, such as price lists, credit rules, and invoice sources, especially across multiple operating units. Use the 'Transaction Types and Line WF Processes' report when you need to understand the process flow, that is, the specific workflow engine and process steps that are assigned to an order or line type.
2. What does 'Order Category' signify? The Order Category is a high-level classification for a transaction type. The main categories are 'SALES' for sales orders, 'RETURN' for return material authorizations (RMAs), and 'MIXED' for orders that can contain both sales and return lines. This allows for easy filtering and grouping.
3. How can I see if a transaction type is restricted to a specific operating unit?
The oe_transaction_types_all table contains the org_id column. This report will show a row for every operating unit (org_id) a transaction type is defined for. If a type is defined with a specific org_id, it is restricted to that OU. If it is defined without an org_id, it is typically available globally.