Highlighted
New Member.
702 views

LoadRunner 12.53 - Oracle Ebus Issue

Hi Guys,

I am looking to record a number of scripts for the Oracle Ebusiness Suite using HP LR 12.53. I have started off by simply recording the log in and out, using both Web HTTP/HTML protocol and Oracle WEB protocol seperately. However the code returned doesnt appear to pick up any information to correlate, and when I replay the script fails (looking at screenshots) but there is nothing in the script to correlate.

Can anyone suggested any settings I may need to change to get HP LR to pick up the required level of detail?

Many thanks,
Dave

0 Likes
8 Replies
Highlighted
Frequent Contributor.
Frequent Contributor.

Re: LoadRunner 12.53 - Oracle Ebus Issue

Hello,

Have your tried the Oracle related rules at: Rocording Option->Correlations->Rules ? and enable rule scan for correlations?

Regards,

Bingle

0 Likes
Highlighted
New Member.

Re: LoadRunner 12.53 - Oracle Ebus Issue

Bingle,

Thanks for your response, yes I have tried the correlation rules. The problem is once logged on, it is then picking up the correlation, and the auot correlation and rules are working then. However its at the landing page for logging on that there is a sid provided, but LR isnt picking this up so I am unable to correlate it and place it in the script.

Basically LR isnt picking any correlation values up pre login.

Cheers,
Dave

0 Likes
Highlighted
Micro Focus Frequent Contributor
Micro Focus Frequent Contributor

Re: LoadRunner 12.53 - Oracle Ebus Issue

Can you attache your script?

It will help us to help you...

0 Likes
Highlighted
New Member.

Re: LoadRunner 12.53 - Oracle Ebus Issue

Hi Dikla,

Please find below a sanitised version of the script, its a simple log in and log out script. The issue we have is that we can not replay the script without it failing but also its not capturing anything to correlate to allow us to replay. Once logged on the Oracle Web protocol starts picking up dynamic data but not during the log on..

Action()
{

web_set_sockets_option("SSL_VERSION", "2&3");


web_url("AppsLocalLogin.jsp",
"URL=https://{AppURL}/OA_HTML/AppsLocalLogin.jsp",
"TargetFrame=",
"Resource=0",
"RecContentType=text/html",
"Referer=",
"Snapshot=t1.inf",
"Mode=HTML",
LAST);

web_submit_data("AppsLocalLogin.jsp_2",
"Action=https://{AppURL}/OA_HTML/AppsLocalLogin.jsp?",
"Method=POST",
"TargetFrame=",
"RecContentType=text/html",
"Referer=https://{AppURL}/OA_HTML/AppsLocalLogin.jsp",
"Snapshot=t2.inf",
"Mode=HTML",
ITEMDATA,
EXTRARES,
"Url=media/spinner.gif", ENDITEM,
LAST);

lr_think_time(17);

lr_start_transaction("Login");

web_submit_data("AppsLocalLogin.jsp_3",
"Action=https://{AppURL}/OA_HTML/AppsLocalLogin.jsp?",
"Method=POST",
"TargetFrame=",
"RecContentType=text/html",
"Referer=https://{AppURL}/OA_HTML/AppsLocalLogin.jsp",
"Snapshot=t3.inf",
"Mode=HTML",
"EncodeAtSign=YES",
ITEMDATA,
"Name=username", "Value={Username}", ENDITEM,
"Name=password", "Value={Password}", ENDITEM,
"Name=_lAccessibility", "Value=N", ENDITEM,
"Name=langCode", "Value=US", ENDITEM,
LAST);

web_url("OA.jsp",
"URL=https://{AppURL}/OA_HTML/OA.jsp?OAFunc=OANEWHOMEPAGE",
"TargetFrame=",
"Resource=0",
"RecContentType=text/html",
"Referer=https://{AppURL}/OA_HTML/AppsLocalLogin.jsp",
"Snapshot=t4.inf",
"Mode=HTML",
LAST);

web_url("detachTable.js",
"URL=https://{AppURL}/OA_HTML/cabo/oajsLibs/detachTable.js",
"TargetFrame=",
"Resource=0",
"RecContentType=text/plain",
"Referer=https://{AppURL}/OA_HTML/OA.jsp?OAFunc=OANEWHOMEPAGE",
"Snapshot=t5.inf",
"Mode=HTML",
LAST);

web_custom_request("RF.jsp",
"URL=https://{AppURL}/OA_HTML/RF.jsp?function_id=MAINMENUREST&security_group_id=0",
"Method=POST",
"TargetFrame=",
"Resource=0",
"RecContentType=application/xml",
"Referer=https://{AppURL}/OA_HTML/OA.jsp?OAFunc=OANEWHOMEPAGE",
"Snapshot=t6.inf",
"Mode=HTML",
"EncType=application/xml",
"Body=<params><param>RESPLIST</param><param>HOMEPAGE</param></params>",
EXTRARES,
"Url=../OA_MEDIA/folder_xxx.png", "Referer=https://{AppURL}/OA_HTML/OA.jsp?OAFunc=OANEWHOMEPAGE", ENDITEM,
LAST);

web_url("disclosecollapsed_16_xxx.png",
"URL=https://{AppURL}/OA_HTML/cabo/images/skyros/disclosecollapsed_16_xxx.png",
"TargetFrame=",
"Resource=0",
"RecContentType=text/plain",
"Referer=https://{AppURL}/OA_HTML/OA.jsp?OAFunc=OANEWHOMEPAGE",
"Snapshot=t7.inf",
"Mode=HTML",
LAST);

lr_end_transaction("Login",LR_AUTO);

 

 

Thanks,

Dave

0 Likes
Highlighted
Frequent Contributor.
Frequent Contributor.

Re: LoadRunner 12.53 - Oracle Ebus Issue

HI Dave,

 

I know its old post, but I am facing the simillar issue, did you find the solution for this? can you please share the resolution if possible. Any help would be Much appreciated.

 

Thanks,

Varma

0 Likes
Highlighted
Acclaimed Contributor.
Acclaimed Contributor.

Re: LoadRunner 12.53 - Oracle Ebus Issue

Hi @Varma9999,

Can you please specify which version of LoadRunner do you use and which version or Oracle EBus you record?
Can you share the recorded script including recording and replay log with extended log turned on?

Regards,
Shlomi

 

0 Likes
Highlighted
Frequent Contributor.
Frequent Contributor.

Re: LoadRunner 12.53 - Oracle Ebus Issue

Hi Shlomi,

Thank you for your quick reply. Here are the details:

Loadrunner Version 12.50

Oracle 12.2.7

Here is the recorded code:

web_add_cookie("oracle.uix=0^^GMT+2:00^p; DOMAIN=<Servername>");

	web_url("AppsLocalLogin.jsp", 
		"URL=http://<Servername>/OA_HTML/AppsLocalLogin.jsp", 
		"Resource=0", 
		"RecContentType=text/html", 
		"Referer=", 
		"Snapshot=t1.inf", 
		"Mode=HTML", 
		LAST);

	web_submit_data("AppsLocalLogin.jsp_2", 
		"Action=http://<Servername>/OA_HTML/AppsLocalLogin.jsp?", 
		"Method=POST", 
		"RecContentType=text/html", 
		"Referer=http://<Servername>/OA_HTML/AppsLocalLogin.jsp", 
		"Snapshot=t2.inf", 
		"Mode=HTML", 
		ITEMDATA, 
		EXTRARES, 
		"Url=media/spinner.gif", ENDITEM, 
		LAST);

	lr_think_time(13);


	
	lr_start_transaction("login");

	web_custom_request("AppsLocalLogin.jsp_3", 
		"URL=http://<Servername>/OA_HTML/AppsLocalLogin.jsp?", 
		"Method=POST", 
		"Resource=0", 
		"RecContentType=text/html",
		"Referer=http://<Servername>/OA_HTML/AppsLocalLogin.jsp", 
		"Snapshot=t3.inf", 
		"Mode=HTML", 
		"Body=username=TestUser&password=Test123&_lAccessibility=N&displayLangCode=US", 
		LAST);


	web_url("OA.jsp", 
		"URL=http://<Servername>/OA_HTML/OA.jsp?OAFunc=OANEWHOMEPAGE", 
		"Resource=0", 
		"RecContentType=text/html", 
		"Referer=http://<Servername>/OA_HTML/AppsLocalLogin.jsp", 
		"Snapshot=t4.inf", 
		"Mode=HTML", 
		EXTRARES, 
		"Url=cabo/images/skyros/navBarUnderTopTabsBg.gif", "Referer=http://<Servername>/OA_HTML/OA.jsp?OAFunc=OANEWHOMEPAGE", ENDITEM, 
		LAST);

	web_add_header("Content-Type", "application/xml");

	web_custom_request("RF.jsp", 
		"URL=http://<Servername>/OA_HTML/RF.jsp?function_id=MAINMENUREST&security_group_id=0", 
		"Method=POST", 
		"Resource=0", 
		"RecContentType=application/xml", 
		"Referer=http://<Servername>/OA_HTML/OA.jsp?OAFunc=OANEWHOMEPAGE", 
		"Snapshot=t5.inf", 
		"Mode=HTML", 
		"EncType=application/xml", 
		"Body=<params><param>RESPLIST</param><param>HOMEPAGE</param></params>", 
		EXTRARES, 
		"Url=../OA_MEDIA/folder_ena.png", "Referer=http://<Servername>/OA_HTML/OA.jsp?OAFunc=OANEWHOMEPAGE", ENDITEM, 
		"Url=cabo/images/skyros/disclosecollapsed_16_ena.png", "Referer=http://<Servername>/OA_HTML/OA.jsp?OAFunc=OANEWHOMEPAGE", ENDITEM, 
		LAST);

	lr_end_transaction("login",LR_AUTO);

 Response of Login step: web_custom_request("AppsLocalLogin.jsp_3",

The Recorded response is:

HTTP/1.1 200 OK
Date: Thu, 20 Sep 2018 15:52:05 GMT
Server:
Content-Length: 211
X-ORACLE-DMS-ECID: 005T^y1CYMu9h^uMwaicMG000R7i0001_B
Set-Cookie: <Servername>=m2Z2hozxXSd7FbhEcDG7R0Gbbs; domain=.mmm.corp; path=/; HttpOnly
X-UA-Compatible: IE=10
X-Frame-Options: SAMEORIGIN
Keep-Alive: timeout=15
Connection: Keep-Alive
Content-Type: text/html; charset=UTF-8
Content-Language: en

{username:'TestUser',
  userid:'1180',
     url:'http\x3a\x2f\x2f<Servername>\x2e<MMM>\x2ecorp\x3a80\x2fOA\x5fHTML\x2fOA\x2ejsp\x3fOAFunc\x3dOANEWHOMEPAGE',
    xsid:'m2Z2hozxXSd7FbhEcDG7R0Gbbs',
  status: 'success', }

 

Reply Response: This is not producting the same above response. I am getting a huge html response.

Please see the attached Record and reply logs.

I will wait for your advise. Thank you So much for your attention and time.

Varma.

 

0 Likes
Highlighted
Frequent Contributor.
Frequent Contributor.

Re: LoadRunner 12.53 - Oracle Ebus Issue

Hello Shlomi, 

did you get the chance to look at my code and server responses. I am still try to figure out the issue. Any help would be greatly appreciated. Thanks.

--Varma

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.