To all:

I'm hoping someone will have a brainstorm for me. In order to successfully test a process were are writing - that uses CUSTORDER/COLINE as part of the process - we need to get 100,000 orders loaded to OE10.

Obviously, having the user enter them isn't an option. We can't refresh test from production for 2 reasons - it would affect too many other projects going on right now and we don't have that many orders in production.

The fall season is when business gets heavy for the systems that this process is being written for - so right now there isn't much out there. One of the stipulations of this project, though, was it must be able to handle pulling back data from 100,000 multi-line orders within a specified period of time.

Has anybody come up with a way to generate orders in OE10?

Unix
Apps 8.0.3 MSP8
Env 8.0.3 ESP6
Oracle

Thanks in advance,
Laura

We've had many discussions about load testing software here, but I recently heard of a player that you might want to add to your toolbox. The geniuses at Apache have released the open source 'JMeter'

From the website:

Apache JMeter is a 100% pure Java desktop application designed to load test functional behavior and measure performance. It was originally designed for testing Web Applications but has since expanded to other test functions.

What can I do with it?

Apache JMeter may be used to test performance both on static and dynamic resources (files, Servlets, Perl scripts, Java Objects, Data Bases and Queries, FTP Servers and more). It can be used to simulate a heavy load on a server, network or object to test its strength or to analyze overall performance under different load types. You can use it to make a graphical analysis of performance or to test your server/script/object behavior under heavy concurrent load.

What does it do?

Apache JMeter features include:

o Can load and performance test HTTP and FTP servers as well as arbitrary database queries (via JDBC)
o Complete portability and 100% Java purity .
o Full Swing and lightweight component support (precompiled JAR uses packages javax.swing.* ).
o Full multithreading framework allows concurrent sampling by many threads and simultaneous sampling of different functions by seperate thread groups.
o Careful GUI design allows faster operation and more precise timings.
o Caching and offline analysis/replaying of test results.
o Highly Extensible:
# Pluggable Samplers allow unlimited testing capabilities.
# Several load statistics may be choosen with pluggable timers .
# Data analysis and visualization plugins allow great extendibility as well as personalization.
# Functions can be used to provide dynamic input to a test or provide data manipulation.
# Scriptable Samplers (BeanShell is fully supported; and there is a sampler which supports BSF-compatible languages)


It could probably be setup to generate your 100,000 orders

Worth checking out! http://jakarta.apache.org/jmeter/

Second thought...

It MIGHT be possible to create a script to randomly select from ITEMMAST and generate csv files that look like orders, then use AddIns to load them. Haven't tried it - just a suggestion to help you think.

g'luck!

Thanks for your input.

Unfortunately, anything that costs $$$ is not even an option ....

I will check this out though.

- LP

Ah - no cost! That's even better. I'm passing this along.

Thanks again!

"Free and Open Source Software = Sometimes you get what you don't pay for..." - My favorite signature line...

Hi -

I passed along to the group here and there are some that are pretty excited about digging into this.

Thanks again!
- Laura