Ads 468x60px

Pages

Subscribe:

Labels

Informatica (18) Integration Service (10) Siebel Business Intelligence (6) ETL (5) Informatica PowerCenter (4) Informatica PowerCenter 8x (4) Oracle (4) Metadata (3) DTM (2) Data Transformation Manager (2) Hexaware Technologies (2) OUD (2) Oracle Unified Directory (2) PowerCenter (2) XML (2) business (2) ASCII (1) Administration Console (1) Application Services (1) Automated Migration (1) BFSI (1) Binary (1) Bulk Load (1) Business Intelligence (1) Business Intelligence Challenge (1) Business Intelligence Company (1) Business Intelligence Consulting (1) Business Objects (1) ByTree (1) CDC (1) CNBC News (1) CNBCTV18’s Shreya Roy (1) COBOL (1) Change Data Capture (1) Collaborative (1) Collaborative Data Management (1) Computing Expression Evaluator (1) Convert Rows To Columns In Inforamtica (1) Data (1) Data Governance (1) Data Management (1) Data Mart (1) Data Type (1) Data Virtualization Services (1) Database (1) Datawarehouse (1) ETL Developers (1) Expression Evaluator (1) Expression Evaluator Debugging (1) Extract (1) FTP (1) File List (1) Flash or Java Applets (1) Flat Files (1) Function (1) HP Diagnostics-Identify (1) HP Diagnostics-Identify bottlenecks (1) HTTP Headers (1) Hexaware Technologies Limited (1) IT Metrics (1) IT companies (1) IT company (1) Index (1) Indirect Source (1) Informatica 8.6 (1) Informatica 8.x (1) Informatica Data Integration Service (1) Informatica Debugger (1) Informatica Debugging Transformation (1) Informatica Development (1) Informatica File Transfer (1) Informatica Power Center (1) Informatica Powercenter 8x Key Concepts (1) Informatica Process Control Audit (1) Informatica Repository Restoration (1) Informatica Server Re-Installation (1) Informatica Server Recovery System (1) Informatica Upgrade Challenge (1) Informatica Workflow (1) Informatica Workflow Process Control (1) Integration Services (1) Integration and Repository services (1) Invalid Objects (1) JavaScript Functions (1) Joiner Transformation (1) LDAP (1) LDAP Directory (1) LDAP Replication (1) Load Balancer (1) LoadRunner 11.5 (1) Looping (1) Manual Correlation (1) Mappings (1) NTLM Resource (1) NTLM authentication (1) Native Driver (1) New Column (1) ODBC (1) ODBC Driver (1) OID (1) OUD Configuration (1) OUD Directory Server (1) OUD Replication (1) Oracle Applications (1) Oracle Client (1) Oracle Hints In SQL (1) Oracle Internet Director (1) Oracle Optimizer (1) Oracle R12 (1) Oracle Solutions (1) Oracle loadrunner (1) OracleErrorActionFile (1) PeopleSoft Jobs (1) PeopleSoft Jobs In Hexaware (1) Peoplesoft Tester In Chennai (1) Peoplesoft Tester Jobs In Chennai (1) Performance (1) Performance Testing (1) PowerCenter 8.5 (1) PowerCenter Server (1) PowerCenter Server Support (1) Powercenter 8.5.1 (1) Pushdown Optimization (1) Re-Import (1) Relational (1) Remote Filename (1) Repository Services (1) Reverse Of A Normalizer In Informatica (1) Rows Read (1) SFTP (1) SJSDS (1) SMP (1) SQL Statement (1) SSH2 (1) SUBSTR Function (1) Session Failed (1) Source Data (1) Source Definition (1) Source Row (1) Store Procedure (1) SuppressNilContentMethod (1) Symmetric Multi-Processing (1) Target Definition (1) Target Row (1) Task Developer (1) Text Flags (1) Transfer Protocol (1) Transformation (1) Transformation Logics (1) Transpose Records (1) UDF (1) User Defined Functions (1) WriteNullXMLFile (1) XML File (1) XML Optimization (1) XML Target (1) XML Tuning (1) XMLSendChildFirst (1) XMLWarnDupRows (1) Zero byte XML file (1) accelerate application (1) employee performance (1) mid-cap it (1) web_reg_save_param (1)

Labels

Blogroll

About

Blogger templates

Blogger news

Tuesday 20 November 2012

Oracle R12 Applications Using LoadRunner


The Challenge
We recently load tested our first Oracle R12 release (All modules for nationwide and international wide of Oracle ERP R12). The company was upgrading to R12 from 11.5.8 largely for performance reasons.
We knew we’d be “cutting new ground” with LoadRunner on R12. This became evident with our first testrecord-and-playback, which failed even after finding and fixing all the missing correlations. We raised a ticket with HP (SR# #4622615067), and with their initial help, step by step we overcame all the nuances of coaxing vugen to record successfully, and then creatively working around its inability to recognize the full set of identifiers for a new java ITEMTREE object.
This Practical Solution describes the challenges we encountered and how we overcame them. See the
Technical Issues and Solutions section for the gory details.
Before You Start
As with 11i, remember that you must expose “Oracle Developer Names*” on the instance before
recording. There’s an HP technote on this, but here are the steps:
  • Launch Oracle application
  • Login with Administrator privileges
  • Select the role “System Administrator”. If you don’t have this role, you don’t have the rights to do this
  • Select the option “Profile: System”
  • Search for the following profile option: “ICX: Forms Launcher” (Search for a specific user to change only the settings for one user);
  • Append this string to the end URL: “?play=&record=names”;
  • Save and close.
* Failure to do this will result in generic field names that make scripting much more difficult and harder to
maintain.
Lessons Learned
  • HP Support can help
  • Oracle Metalink documents provide good info on R12 architecture and configuration
  • If VUGen stumbles on a new object, try the QTP Object Spy
  • R12 can be installed in two distinct communication modes; make sure it’s in the more efficient “Socket    mode” before you beginning scripting
  • Porting scripts is a pretty common requirement – save crucial time at “show time” by parameterizing the instance-specific values up-front
Technical Issues and Solutions
Issue1: Playback failure on nca_object_action statements
Following the nca_connect statement there are two statements of this form:
nca_java_action (“SR_DUP_GRID_DUP_GRID_0″,)
On playback, the script invariably fails at the first of these.
Practical Solution:
In each script directory, open the default.cfg file and in the [NCA_GENERAL] section add this line:
NCATimerWaitMode=0
Playback will now successfully process nca_object_action statements.
Issue2: Java Runtime version and memory setting
Oracle R12 now loads the JInitiator file (runtime program for executing the Oracle java applet) from the
Java JRE, instead of downloading it during the Oracle initialization process or installing it on your PC separately. Also, Forms 10g needs more desktop memory than Forms 6 to perform reasonably.
Practical Solution:
Upgrade the Java JRE to version 1.0.0_05 or later. Moreover, allocate at least 512 MB of memory, using the Java Control Panel, and add the parameter:
–mx512m –Dcache.size=500000000.
Issue3: The correlation of ncx_ticket is different from 11i
In 11i, the correlation rule to correlate the key Oracle Forms session id, ncx_ticket, yields a web_reg_save_param statement with these left and right boundaries:
web_reg_save_param (“ICX_Ticket”, “LB=icx_ticket=”, “RB=’”, LAST);
In R12, a new suffix appears on the LB and a there is a new RB:
web_reg_save_param (“ICX_Ticket”, “LB=icx_ticket&gv15=”, “RB=&“,LAST);
Practical Solution:
In the Recording Settings, modify the OracleApps ‘icx’ correlation rule with the above LB and RB
to enable vugen to properly correlate icx_ticket automatically.

Issue4: Failure to recognize certain new java objects on record
QTP has issues recording an R12 object called an ITEMTREE which was a list of expandable items that
look like this:
+40907824 ITEM1
+40907839 ITEM2
The following statements resulted after selecting an item during recording, but these would not play back:
nca_tree_select_item (“ITEMTREE_ITEMTREE_0″, “40907824 ITEM1 “);
nca_tree_activate_item(“ITEMTREE_ITEMTREE_0″, “40907824 ITEM1 “);
If you encounter this object, or any other new object that vugen has trouble with, this tip may get you
around the recording limitation.
Practical Solution:
We used QuickTest Pro’s ObjectSpy to examine the ITEMTREE object and found that each menu
item had a reference number that is selectable and plays back correctly. We then modified the
VUgen code with the correct reference numbers:
nca_tree_select_item(“ITEMTREE_ITEMTREE_0″, “409“);
nca_tree_activate_item(“ITEMTREE_ITEMTREE_0″, “409“);
This reference number is listed in the detail log files if you look carefully but they were not obvious
during recording, but we recommend using ObjectSpy if you encounter any other objects that
VUgen doesn’t handle correctly. 
Issue5: Porting scripts between environments
A common situation is that you must develop scripts in one environment but conduct testing in another.
This requires that your scripts be portable across environments.
Practical Solution:
There are several values that need to be parameterized in order to make your scripts portable.
Parameterize and test these as early as possible to avoid frantic porting at test execution time!
The values to parameterize are:
1. Base URL or app server ip
2. Web server port number which you initially connect to for login authentication
3. Forms server port number, which the nca_connect sues to connect to the Forms server
4. Configuration (“config” value in nca_connect)
5. Module (second ‘path’ value in nca_connect)
Examples of where these are used:
/*initial Oracle launch*/
web_browser (“UnysisERPR12.com:8050“,
DESCRIPTION,
ACTION,
“Navigate=http ://{ app_srv} :{ port_web}/”,
LAST);
/*Forms server connect*/
nca_connect_server (“{app_srv}“, “{port_forms}“,
“module=/ebstop/{module}/apps/apps_st/appl/fnd/12.0.0/forms/US/FNDSCSGN fndnam=APPS
record=names config=’{config}‘ icx_ticket=’.{ICX_Ticket}..’
resp=’AR/CAN_CUSTOMER_MASTER_ADMIN’ …”);

No comments:

Post a Comment