Approval Workflow Enhancements
- Approve/Reject Comment Limit: Extended to 256 characters for adding comments in the Approval Workflow, facilitating clearer communication.
- Submit Comment Capacity: Increased capacity for the Submit Comment field in Approval Workflow, accommodating up to 4000 characters for detailed submission notes.
Attribute Specifications
- Currency and Float Attributes: Maximum length capped at 16 digits before conversion to scientific notation (e.g., $10,000,000 becomes 10e6), ensuring precision in financial calculations.
- System Transaction Counter: The _system_transaction_counter attribute supports up to 18 digits, offering extensive tracking capabilities.
- Text Field Limitations: Text fields are restricted to 255 characters, while attribute descriptions can contain up to 4000 characters, supporting detailed explanations.
- Configuration Array Rows: A maximum of 200 configuration array rows are available, with the option to extend this limit via My Oracle Support.
- Transaction Array Rows: Support for up to 500 rows in a Transaction Array, with extension possibilities through My Oracle Support.
- Integer Variable Range: From -2,147,483,648 to 2,147,483,647, covering a wide range of numerical data inputs.
BML Scripting Insights
- BML Script Length: The maximum length of a BML (BigMachines Language) script is 64kb, a limitation determined by the Java try block length rather than the BML script itself.
Configuration Rules and Data Columns
- Configuration Attributes: Up to 1000 configuration attributes can be referenced in a rule, allowing for complex product configurations.
- Document Data Columns: The main document supports 251 data columns, with sub-documents allowing for 400 data columns, accommodating extensive data management.
Data Tables and Columns
- Initial Data Tables: 150 Data tables are available with initial site setup, with expansion options available through My Oracle Support.
- Data Table Naming: Both Data Table names and Data Table Column names are limited to 20 characters, supporting concise identifiers.
- Data Table Columns: A total of 100 Data Table Columns are supported, divided among 50 String, 25 Integer, and 25 Float columns. Secure Data Table Columns are included in the 50-column limit for String columns.
- Global Menu Advanced Filter: Selection is limited to 5 Data Tables, streamlining the filtering process.
- Data Table Cell Capacity: Each cell in a Data Table can contain up to 255 characters, while Float Data Table columns are limited to 16 digits and 6 decimal places.
- Integer Data Table Columns: The maximum value for an Integer Data Table column is 999,999,999, ensuring a broad range of integer values.
Conclusion
Understanding the boundaries and magic numbers within Oracle CPQ is crucial for optimizing the configuration and customization of the CPQ system. These limitations guide the design and development of CPQ solutions, ensuring that they are both effective and efficient. As Oracle CPQ continues to evolve, staying informed about these limitations will help administrators and developers create more robust and scalable CPQ solutions.