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.
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 R12 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.
Oracle Application R12 Benchmark
The EBS R12 Standard Benchmark supports four types of configurations: Small, Medium, Large and Extra-Large. The volume of data loaded into Oracle Applications schema is one of two sizes for Release 12.0.4 and only one size for Release 12.1.2. The batch workload and the maximum number of users allowed for benchmark run depend upon the type of configuration selected.
Category | Order to Cash | Payroll | Number of Users |
---|---|---|---|
Small | 10,000 lines/Hr | 5,000 Employees/Hr | 1 – 1000 |
Medium | 50,000 lines/Hr | 10,000 Employees/Hr | 1100 – 3000 |
Large | 100,000 lines/Hr | 50,000 Employees/Hr | 3100 – 10000 |
Extra-Large | 250,000 lines/Hr | 250,000 Employees/H | 10100 -20000 |
XX-Large | 750,000 lines/Hr | NA | NA |
Prior to Release 12.1.2, there were 'Medium' and 'Extra-Large' kits available to cover the Small/Medium and Large/Extra-Large workloads. With Release 12.1.2, there is a single 'Extra-Large' kit available to cover all workloads. Thus the data setup is the same for all sizes; with only the number of users, or the number of lines or employees processed varying with the model size.
Application | Business Objects | Row Counts / Extra-Large |
---|---|---|
TCA | Organizations | 1,100,000 |
Contacts | 4,900,000 | |
Contact Points | 3,700,000 | |
Account | 1,100,000 | |
Account Sites | 1,090,000 | |
Account Site Uses | 2,180,000 | |
Contracts | Contracts | 222,000 |
IB | Instances | 1,300,000 |
IB Items | Items | 5 |
Items | Reservable | 1,100,000 |
Managers | 800 | |
Employees | 250,000 | |
Payroll Users | 250,000 | |
Self Service Employees | 40,000 | |
Users | 20,000 | |
Credit Card Entries | 4,000,000 | |
Supplier | 10,000 | |
Asset Categories | 900 | |
GL Code Combinations | 93,000 |
The modules used by the E-Business R12 benchmark are:
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.
Name of Transaction | Trans/HR/User | Base User Count |
---|---|---|
OM_Insert_Order | 20 | 4 |
OM_order_Pick_Release | 40 | 2 |
OM_ship_Confirm | 40 | 2 |
AR_INSERT_MANUAL_INVOICE | 40 | 2 |
OM Order Summary Report | 4 | 2 |
SS_Create_Query_Requisition | 20 | 2 |
Create_Approve_Purchase_Order | 20 | 2 |
View_Purchase_Order | 20 | 2 |
Create_Payables_Invoice | 20 | 2 |
View_Payables_Invoice | 20 | 2 |
PO_Printed_Report | 4 | 2 |
Create_SR | 15 | 16 |
Update_SR | 15 | 16 |
Close_SR | 15 | 8 |
SS_Create_Query_Cash_Expenses | 10 | 4 |
SS_Create_Query_Credit_Expenses | 10 | 4 |
SS_Create_Timecard | 10 | 6 |
SS_View_Employee_Payslip | 10 | 6 |
AR_View_Customer_Transactions | 8 | 2 |
AR_Customer_Summary | 8 | 2 |
FA_Create_Asset | 8 | 2 |
GL_Journal_Entry | 8 | 2 |
INV_View_Item_Attributes | 8 | 2 |
INV_Insert_Miscll_Transactions | 8 | 2 |
AR_Aging_Report | 4 | 2 |
INV_Min_Max_Report | 4 | 2 |
389 | 100 |
Also new to R12, partners can execute individual flows from the complete atomic group. This offers more combinations of running users and may address business case situations that are of interest to particular partners.
Table 4: The R12 OLTP Flows
OLTP Flow | Transaction | Transactions | Percentage | Users (X-L) | |
---|---|---|---|---|---|
Order Management Flow | 6 | 14% | 2,800 | ||
Insert Order | 28.56% | 800 | Forms | ||
Pick Release | 14.28% | 400 | Forms | ||
OM Ship Order | 14.28% | 400 | Forms | ||
Insert Manual Invoice |
14.28% | 400 | Forms | ||
AR Customer Summary | 14.28% | 400 | Web | ||
OM Order Summary Report | 14.28% | 400 | Forms | ||
Procurement-to-Pay Flow | 6 | 12% | 2,400 | ||
SS Create Query Req. | 16.6% | 400 | Web | ||
Create Approve PO | 16.6% | 400 | Web | ||
View Purchase Order | 16.6% | 400 | Web | ||
Create Payables Invoice | 16.6% | 400 | Forms | ||
View Payables Invoice | 16.6% | 400 | Forms | ||
Printed PO Report | 16.6% | 400 | Forms | ||
Customer Service Flow
|
3 | 40% | 8,000 | ||
Create Service Request | 40% | 3,200 | Forms | ||
Update Service Request | 40% | 3,200 | Forms | ||
Close Service Request | 20% | 1,600 | Web | ||
HR Self-Service Flow | 4 | 20% | 4,000 | ||
Create Query Cash Expense | 20% | 800 | Web | ||
Create Query Credit Expense | 20% | 800 | Web | ||
View Payslip | 30% | 1,200 | Web | ||
Create Timecard | 30% | 1,200 | Web | ||
Financials Flow | 7 | 14% | 2,800 | ||
AR View Cust. Transaction | 14.28% | 400 | Web | ||
FA Create & Query Asset | 14.28% | 400 | Forms | ||
GL Journal Entry | 14.28% | 400 | Forms | ||
INV View Item Attributes | 14.28% | 400 | Forms | ||
INV Insert Misc. Transactions | 14.28% | 400 | Forms | ||
AR Aging Report | 14.28% | 400 | Forms | ||
Min/Max Inventory Report | 14.28% | 400 | Forms | ||
Totals: | 26 | 100% | 20,000 |
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
With changes to the R12.1.2 kit, the following batch processes are now capable of being multi-threaded for better performance.
1. Auto Invoice
2. Revenue Recognition
When running the R12.1.3 kit at the X-L user count, it may improve performance to slightly adjust the specific transaction user counts and pacing from the first transaction to the last transaction along the business flow to insure that certain queues have ample entries.
Table 5: The R12 OLTP Dependency by Flows
Business Flow | Order Management | iProcurement | Customer Service |
---|---|---|---|
1. Start | OM_Insert_Order | Create_Query_Requisition | Create_Service_Request |
2. | OM_Pick_Release | Create_Approve_PO | |
3. | OM_Ship_Confirm | View_PO | Update_Service_Request |
4. | Insert_Manual_Invoice | Create_Payables_Invoice | |
5. End | OM_Order_Summary | View_Payables_Invoice | Close_Service_Request |