|
| The Oracle Applications Standard Benchmark is focused on ERP applications and represents a mixed workload intended to model the most common transactions operating on the most widely used enterprise application modules. Definitions of transactions that compose the benchmark load were obtained through collaboration with functional consultants and are representative of typical customer workloads, with batch transactions representing 25% of the total workload.
To ensure that the benchmarks workload characteristics remain constant across a variety of user counts the concept of atomic user group has been defined. The atomic user group is the smallest number of users that can be added at any given time while still ensuring that the workload remains unchanged, specifically in terms of the percentages of each type of user in the mix. The atomic user group consists of the sum of all the base user counts specified in the table. To run more users you simply add an integer number of atomic groups, and thereby the characteristics of the workload remain constant.
For the eBS 11.5.10 benchmark, performance comparison(s) between benchmark kits of different sizes such as small, medium and large is not encouraged. By the same token, for benchmark kit of the same size, results comparison(s) between Single Instance versus RAC is also discouraged.
11.5.10 eBS Kit Workload
The EBS 11.5.10 Standard Benchmark supports three types of configurations : Small, Medium and Large. The volume of data loaded into Oracle Applications schema and the max number of users allowed for benchmark run depend upon the type of configuration selected.
| |
Req. Throughput |
Req. Throughput |
|
| Category |
Order to Cash |
Payroll |
Number of Users |
Maximum Number for Workers for each batch program |
| Small |
10,000 lines/Hr |
5,000 Employees/Hr |
1 – 1000 |
4 |
| Medium |
50,000 lines/Hr |
10,000 Employees/Hr |
1001 – 3000 | 8 |
| Large |
100,000 lines/Hr |
100,000 lines/Hr |
> 3000 | 24 |
The data should be loaded as per the data size specified here.
| Application | Business Objects | Data Size |
| Low
| Medium
| High
|
| TCA
| Organizations
| 100,000 | 500,000 | 1,000,000 |
| Contacts
| 200,000 | 1,000,000 | 2,000,000
|
| Contact Points
| 200,000 | 1,000,000 | 2,000,000
|
| Account
| 100,000 | 500,000 | 1,000,000 |
| Account Sites
| 100,000 | 500,000 | 1,000,000 |
| Account Site Uses
| 200,000 | 1,000,000 | 2,000,000 |
| Contracts | Contracts
| 20,000 | 100,000 | 200,000
|
| IB | Instances
| 100,000
| 500,000 | 1,000,000
|
| IB Items
| Items
| 5
| 5 | 5
|
| Items
| Reservable
| 100,000
| 500,000 | 1,000,000
|
| Managers | |
200
| 400 | 800
|
| Employees | |
5,000 | 10,000 | 100,000 |
| Payroll Users | |
5,000 | 50,000 | 100,000 |
| Self Service Employees | |
5,000 | 10,000 | 20,000 |
| Users | |
5,000 | 10,000 | 20,000 |
| Credit Card Entries | |
250,000 | 500,000 | 1,000,000 |
| Supplier | |
1,000
| 5,000 | 10,000 |
| Asset Categories | |
100
| 100 | 100 |
| GL Code Combinations | |
1000 | 1000 | 1000 |
| Resources | |
3601 | 9021 | 19033 |
| Resource Groups | |
400 | 820 | 1464 |
| Resource Hierarchy Level | |
4 | 4 | 4 |
| Sales Leads | |
100,000 | 500,000 | 1,000,000 |
| Campaigns | |
1 | 1 | 1 |
| Sales Territory | |
3201 | 8201 | 17569 |
Batch Benchmark
The batch component of the Oracle Applications Standard Benchmark focuses on executing the core concurrent programs in the eBusiness Suite such as the High Volume Order Import program, which is part of the order to cash business flow. The batch benchmark is extremely useful in providing sizing and capacity planning information for the core Oracle Applications batch flows and concurrent programs.
High Volume Order Processing (HVOP)
The Release 11i Order Management HVOP benchmark focuses exclusively on meeting the high order volumes originating from the new electronic channels, such as consumer and business web sites, B2B exchanges, and EDI. The benchmark is designed to represent a core component of the order to cash business flow demonstrating the overall order processing throughput. Oracle Workflow, a high performance process control engine that guides sales order headers and lines through a series of consecutive steps from order creation through Shipping, controls order processing. The HVOP program processes orders by reading the rows from the Order Management Interface tables and converting the interface records into permanent Oracle Applications? order headers and their respective order lines. The orders are then booked and advanced to the shipping state
Oracle Application 11.5.10 Benchmark
The modules used by the E-Business 11.5.10 benchmark are:
- Oracle Financials: Accounts Payable, Accounts Receivable, Fixed Assets, General Ledger
- Human Resource Management System
- Sales and Marketing
- Customer Support: Service
- Supply Chain Management (SCM): Logistics, Order Management, Purchasing, Shipping
- Self-Service Applications: Employee Self-Service, iExpenses, iProcurement, Oracle Time & Labor
A list of the transactions and their suggested completion rate is specified below in Table 2.
For a description of each transaction, please click on the transaction name in the left column.
Table 2: The 11.5.10 Atomic Group
Batch Benchmark
There are two batch processes included in the E-Business 11.5.10 benchmark, the HRMS-Payroll process and the Order to Cash batch process.
The HRMS-Payroll process involves the complete payroll process flow i.e. Payroll process, pre-payments, NACHA, archive, check writing, costing and transfer to GL and GL Autopost.
The Order to Cash process involves the entire flow from Order to Cash i.e. High Volume Order Processing (HVOP), Pick Release, Process Deliveries, Ship Confirm, Interface Trip Stop (ITS), Autoinvoice, Revenue Recognition, Transfer to GL and GL Autopost.
For a description of each of these processes, please click on the process name below:
HRMS-Payroll
Order to Cash
The batch benchmark is extremely useful in providing sizing and capacity planning information for the core Oracle Applications batch.
|
Oracle Application R12 Benchmark
The EBS R12 Standard Benchmark supports four types of configurations : Ultra-Small, Small, Medium and Large. The volume of data loaded into Oracle Applications schema and the max number of users allowed for benchmark run depend upon the type of configuration selected.
| |
Req. Throughput |
Req. Throughput |
|
| Category |
Order to Cash |
Payroll |
Number of Users |
Maximum Number for Workers for each batch program |
| Ultra-Small |
5,000 lines/Hr |
2,500 Employees/Hr |
0 – 200 |
4 |
| Small |
10,000 lines/Hr |
5,000 Employees/Hr |
1 – 1000 |
8 |
| Medium |
50,000 lines/Hr |
10,000 Employees/Hr |
1001 – 3000 | 12 |
| Large |
100,000 lines/Hr |
50,000 lines/Hr |
3100 – 10000 | 24 |
The data should be loaded as per the data size specified here.
| Application |
Business Objects |
Data Size |
| Ultra-Small |
Small |
Medium |
High |
| TCA |
Organizations |
100,000 |
100,000 |
500,000 |
1,000,000 |
| |
Contacts |
200,000 |
200,000 |
1,000,000 |
2,000,000 |
| |
Contact Points |
200,000 |
200,000 |
1,000,000 |
2,000,000 |
| |
Account |
100,000 |
100,000 |
500,000 |
1,000,000 |
| |
Account Sites |
100,000 |
100,000 |
500,000 |
1,000,000 |
| |
Account Site Uses |
200,000 |
200,000 |
1,000,000 |
2,000,000 |
| Contracts |
Contracts |
20,000 |
20,000 |
100,000 |
200,000 |
| IB |
Instances |
100,000 |
100,000 |
500,000 |
1,000,000 |
| IB Items |
Items |
5 |
5 |
5 |
5 |
| Items |
Reservable |
100,000 |
100,000 |
500,000 |
1,000,000 |
| Managers |
|
200 |
200 |
400 |
800 |
| Employees |
|
5,000 |
5,000 |
10,000 |
100,000 |
| Payroll Users |
|
5,000 |
5,000 |
50,000 |
100,000 |
| Self Service Employees |
|
5,000 |
5,000 |
10,000 |
20,000 |
| Users |
|
5,000 |
5,000 |
10,000 |
20,000 |
| Credit Card Entries |
|
250,000 |
250,000 |
500,000 |
1,000,000 |
| Supplier |
|
1,000 |
1,000 |
5,000 |
10,000 |
| Asset Categories |
|
100 |
100 |
100 |
100 |
| GL Code Combinations |
|
1000 |
1000 |
1000 |
1000 |
| Resources |
|
3601 |
3601 |
9021 |
19033 |
| Resource Groups |
|
400 |
400 |
820 |
1464 |
| Resource Hierarchy Level |
|
4 |
4 |
4 |
4 |
| Sales Leads |
|
100,000 |
100,000 |
500,000 |
1,000,000 |
| Campaigns |
|
1 |
1 |
1 |
1 |
| Sales Territory |
|
3201 |
3201 |
8201 |
17569 |
The modules used by the E-Business R12 benchmark are:
- Oracle Financials: Accounts Payable, Accounts Receivable, Fixed Assets, General Ledger
- Human Resource Management System
- Sales and Marketing
- Customer Support: Service
- Supply Chain Management (SCM): Logistics, Order Management, Purchasing, Shipping
- Self-Service Applications: Employee Self-Service, iExpenses, iProcurement, Oracle Time & Labor
A list of the transactions and their suggested completion rate is specified below in Table 3.
For a description of each transaction, please click on the transaction name in the left column.
Table 3: The R12 Atomic Group
R12 Functional Updates from 11.5.10
There are several changes and modifications in the R12 E-Business Benchmark Kit that reflect changes from Release 11i
Four online transactions have changed from Forms based (11i) to Web based (R12). They are:
1. AR View Customer Transactions
2. AR Customer Summary (ARCS)
3. PO Create Approve Purchase Order (SS)
4. PO View Purchase Order (SS)
Due to changes in R12 application the following batch processes are now capable of being multi-threaded for better performance. In addition, the SUBMITO2C.SQL script has been modified to incorporate this change.
1. Pick release
2. Pick confirm date
3. Create Accounting
| |
