Overview
Things You Can't DoBML
- Use certain special characters in a script (for example,
0x1c), or the characters can corrupt the entire Commerce Process when the script is deployed
Configuration
- Link directly to a specific tab in a Configuration Flow
User and Group Administration
- Delete a user (instead, use Inactivate)
- Delete a group
One application boundary deals with reporting. Reporting will not convert quotes into a single currency. This means that if a Sales Representative or manager wants to do some reporting on Quote value roll-ups, they will need to duplicate that report for every currency being quoted.
Approval Workflow
- 256 characters for the approve/reject comment in Approval Workflow
- 4000 characters for the Submit Comment in Approval Workflow
Attributes
- 16 digits maximum length of a Currency attribute converted to scientific notation
(for example, 10,000,000 is 10e6 in scientific notation)
Any amount entered that has more than 16 digits is rounded to 16 digits.
-
90000000000000 (90 trillion) is the limit for Currency attributes
- 16 digits maximum length of a Float attribute
- 18 digits maximum for the
_system_transaction_counter attribute - 255 characters in a text field (Not text area)
- 4000 characters in an attribute description
- 200 configuration array rows
- 500 rows in a Transaction Array
To increase the default row size, open a ticket on My Oracle Support. - -2,147,483,648 to 2,147,483,647 = integer variable value range
-
60 Product Line attributes and 60 Model attributes for each Product Family is the maximum supported in Commerce
BML
-
20,000,000 characters is the maximum length of a string which can be converted into a JSON object with BML function
json() -
64kb maximum length of a BML script (limit on Java try block)
This is a limit on the length of the Java code that is generated by the BML script, not the length of the BML script itself (which is typically larger).
Bulk Upload and Data Migration
- 1,073,741,824 Bytes is the maximum zip file size for uploading a file to Oracle CPQ
Configuration Rules
- 1000 configuration attributes referenced in a rule
Data Columns
- 251 main document data columns
- 400 sub document data columns
- 100 characters maximum displayed in a data column on a report
Data Tables
- 150 Data tables with initial site setup
To increase the allowable number of Data Tables, open a ticket on My Oracle Support - 20 characters in a Data Table name
- 20 characters in a Data Table Column name
- 100 Data Table Columns (50 String, 25 Integer, 25 Float)
* Secure Data Table Columns count against the 50-column limit for String columns in a single table - 5 selected Data Tables for the Global Menu Advanced Filter
- 255 characters in a Data Table cell
- 16 digits maximum length of a Float Data Table column (16 9's is too big, 15 9’s and an 8 is fine)
6 decimal places for a Data Table float column - 999,999,999 maximum value of an Integer Data Table column
Descriptions
- 255 characters in a Commerce action description
- 4000 characters in a function description
- 4000 characters in a Model/Product Line description used on the home page
Document Engine
- 30 conditional columns per table (Document Engine in v11.1)
- 170 character limit for page names in Document Engine
Import/Export
- 65,000 parts exported per CSV
Integrations
- 200 line items sent to Salesforce in one batch (Salesforce limitation)
Pricebooks:
- 30 Price Books
- 5 custom Price Book fields
- 1 numeric Price Book custom fields
Part Custom Fields
- 600 part custom fields
- 350 Text/Menu fields that can be String, Single Select Menu, or Multi-Select Menu data types
- 200 Number fields that can be Float or Integer data types
- 50 Date & Time data type fields
- 300 characters for the standard part number field. However, if a part number exceeds 255 characters it will appear truncated in Commerce, because the text field limit in Commerce is 255 characters.
- 60 part custom fields can be selected and displayed on Search, Search Results, BOM and Detail Pages
Transactions
- 99,998 maximum Line Items on a Transaction
- 99,999 maximum Transaction Document numbers
- 80 characters displayed in a column on the Transaction Manager
- 90 lines is the maximum amount of lines that can be copied at the same time using the Commerce Copy Line Items action.
Users
- 30 characters for username field
Views
- 10 saved views per user
- 10 views that an Application Administrator can share
- 50 saved views created by Application Administrator
- 50 saved views created or shared for users without Application Administrator permissions
- 100 saved views for an Application Administrator (50 created by Application Administrator and 50 shared views by other users)
Web Services
- 300 results returned from Web Services Data Table API
