25.9 Opkey Oracle EBS Keywords

While automating OracleEBS application with OpKey SaaS, you must keep in mind that this application works as a normal web_application in beginning (until the OracleEBS_form opens). Once OracleEBS_form is launched, OracleEBS keywords of OpKey are being used. Thus, you have to follow the beginning steps of OracleEBS which behave as web_application until you are redirected to the OracleEBS form. You can refer OracleEBS tutorial video at:

OracleEBS Tutorial Video:

Action

Oracle_SelectRadioButton

This keyword is used to select a radio button in the Oracle EBS application form. It Β takes the Radio Button object as Object Input argument. It doesn’t take any Data Input Arguments.

Input Arguments

Object Input Arguments

Required?

Description

Object

Yes

This keyword takes the Radio Button object as object input argument.

Data Input Arguments

Required?

Description

Data

No

This keyword doesn’t take any Data Input Arguments.

Output

True

If the keyword passes successfully

False

If the keyword fails

Example

SelectRadioButton.jpg

In the above screenshot, if you want to select the Icon View radio button then you can use the β€œOracle_SelectRadioButton” keyword as follows:

Oracle_SelectRadioButton

Object

<  Choose a radio button object from the OR  >

Common Error conditions

Scenarios

Error Message

Debug Information

When object is not given.

Argument Data Missing (-13200)

Data not provided for argument: ‘Object’. Expected Static Value was empty.

When Oracle_SelectRadioButton keyword is used without launching the the OracleEBS application form.

Step Timed Out (-12200)

Step [#11] timed out. System waited for 90sec.

Oracle_Click

This keyword clicks on the specified object. It takes OR object as input argument. It does not take any Data Input arguments.

Input Arguments

Object Input

Arguments

Required?

Description

Object

Yes

This keyword takes one object as object

Input argument.

Data Input Arguments

Required?

Description

Data

No

This keyword doesn’t take any data Input argument.

Output

True

If the keyword passes successfully

False

If the keyword fails

Example

In the above screenshot, if you want to click on β€œServer” object of a page of the Oracle application then this is how you will use β€œOracle_Click” keyword.

Oracle_Click

Object

<  Choose an Object from the OR  > Here, Server

Common Error conditions

Scenarios

Error Message

Debug Information

If object is not given

Object: No object

Argument Data Missing (-13200)

Data not provided for argument: ‘Object’. Expected Static Value was empty.

When Oracle_Click keyword is used without launching the Oracle EBS application form.

Step Timed Out (-12200)

Step [#11] timed out. System waited for 90sec.

Oracle_GetCellChild

This keyword get the names of the children cell of a table. It takes a table Object as Object Input Arguments. It also takes Column Name and Row Number as Data Input Arguments

Input Arguments

Object Input Arguments

Required?

Description

 Object

 Yes

This Keyword takes one table object as Object input argument.

Data Input Arguments

Required?

Description

Column

Yes

Specify the column name of the table.

Row

Yes

Specify the row number of the table.

Note: Row Number starts from 1

Output

Retrieves the name of the children cell

If the keyword passes successfully

False

If the keyword fails

Example

2.jpg

Suppose you want to retrieve the children of the highlighted cell of the table Β that exists on a page of an oracle application then, you will use the keyword β€œOracle_GetCellChild” as follows:

Oracle_GetCellChild

Object

<  Choose a table Object from the OR  >

Column

Customer Taxpayer ID

Row

1

Common Error conditions

Scenarios

Error Message

Debug Information

When blank Object and Data input argument is provided .

Argument Data Missing (-13200)

DESCRIPTION:

A step could not be executed because one or more of the arguments have not been provided a value. Of all the arguments a keyword accepts, some arguments might be compulsory. As opposed to the non-compulsory ones, the compulsory argument must be provided some data. The data may be provided through one of many sources like statically entering, output of a previous step, a global variable etc; but it must not be left blank.

Data not provided for argument: ‘Object’. Expected Static Value was empty.

When blank object and valid Data Input Argument is provided.

Object : None

Column: Invoice Num

Row : 1

Argument Data Missing (-13200)

DESCRIPTION:

A step could not be executed because one or more of the arguments have not been provided a value. Of all the arguments a keyword accepts, some arguments might be compulsory. As opposed to the non-compulsory ones, the compulsory argument must be provided some data. The data may be provided through one of many sources like statically entering, output of a previous step, a global variable etc; but it must not be left blank.

Data not provided for argument: ‘Object’. Expected Static Value was empty.

Oracle_PressToolBarButton

This keyword is used to press Toolbar Button in the Oracle EBS application form. It takes tooltip of the toolbar item as Data Input Arguments.

Input Arguments

Object Input Arguments

Required?

Description

Object

Yes

This keyword takes the toolbar object as object input argument.

Data Input Arguments

Required?

Description

Value

Yes

This keyword takes tooltip of the toolbar item as Data Input Arguments.

Output

True

If the keyword passes successfully

False

If the keyword fails

Example

Oracle_PressToolBarButton2.jpg

In the above screenshot, if you want to press β€œSave” toolbar button item then you can use the β€œOracle_PressToolbarButton” keyword as follows:

Oracle_PressToolbarButton

Object

<   Choose toolbar button Object from the OR  >

Value

<  Provide the tooltip of the toolbar item as Data Input Argument   > Here, Save

Common Error conditions

Scenarios

Error Message

Debug Information

When object is not given

Argument Data Missing (-13200)

Data not provided for argument: ‘Object’. Expected Static Value was empty.

When tooltip of the toolbar item is not correct.

Step Timed Out (-12200)

Step [#11] timed out. System waited for 90sec.

Oracle_ClickButton

This keyword is used to click on the given button available in the Oracle EBS application form. This keyword takes button object as Object Input argument. This keyword doesn’t take any as Data Input Arguments.

Input Arguments

Object Input Arguments

Required?

Description

Object

Yes

This keyword takes the button object as object input argument.

Data Input Arguments

Required?

Description

Data

No

This keyword doesn’t take any as Data Input Arguments.

Output

True

If the keyword passes successfully

False

If the keyword fails

Example

06-ClickButton.jpg

In the above screenshot, if you want to click on the button β€œOK” then then you can use the β€œOracle_ClickButton” keyword as follows:

Oracle_ClickButton

Object

<  Choose Button Object from the OR  >

Common Error conditions

Scenarios

Error Message

Debug Information

When object is not given

Argument Data Missing (-13200)

Data not provided for argument: ‘Object’. Expected Static Value was empty.

When Oracle_ClickButtonn keyword is used without launching the the OracleEBS application form.

Step Timed Out (-12200)

Step [#11] timed out. System waited for 90sec.

Oracle_SelectItemFromList

This keyword is used to select an item from the list in the Oracle EBS application form. It takes the Item list object as Object Input argument. It also takes Item value of the list item as Data Input Arguments.

Input Arguments

Object Input Arguments

Required?

Description

Object

Yes

This keyword takes the Item list object assobject input argument.

Data Input Arguments

Required?

Description

Value

Yes

Specify the Item value of the item as Data Input Arguments.  

Output

True

If the keyword passes successfully

False

If the keyword fails

Example

SelectItemFromList.jpg

In the above screenshot, if you want to select the the Asset Management list item then then you can use the β€œOracle_SelectItemFromList” keyword as follows:

Oracle_SelectItemFromList

Object

<  Choose a list object from the OR  >

Value

<  Provide the Item value of the list item  > Here, Asset Management

Common Error conditions

Scenarios

Error Message

Debug Information

When object is not given.

Argument Data Missing (-13200)

Data not provided for argument: ‘Object’. Expected Static Value was empty.

When the given value of the list item is not correct.

Step Timed Out (-12200)

Step [#11] timed out. System waited for 90sec.

Oracle_ClickImage

This keyword is used to click on the specified image object in the Oracle EBS application form. It takes image object as Object Input argument. It doesn’t take any Data Input Arguments.

Input Arguments

Object Input Arguments

Required?

Description

Object

Yes

This keyword takes image object as Object Input argument.

Data Input Arguments

Required?

Description

Data

No

This keyword doesn’t take any Data Input Arguments.

Output

True

If the keyword passes successfully

False

If the keyword fails

Example

ClickImage.jpg

In the above screenshot, if you want to click on the Highlighted image then you can use the β€œOracle_ClickImage” keyword as follows:

Oracle_ClickImage

Object

<  Choose image object from the OR  > Here, Oracle

Common Error conditions

Scenarios

Error Message

Debug Information

When object is not given.

Argument Data Missing (-13200)

Data not provided for argument: ‘Object’. Expected Static Value was empty.

When Oracle_ClickImage keyword is used without launching the the Oracle EBS application form.

Step Timed Out (-12200)

Step [#11] timed out. System waited for 90sec.

Oracle_ClickCell

This keyword clicks on a specified table cell in the Oracle EBS application form. It Β takes table object as Object Input argument. It takes Column Name and Β Row Number as Data Input Arguments.

Input Arguments

Object Input Arguments

Required?

Description

Object

Yes

This keyword takes table object as Object Input argument.

Data Input Arguments

Required?

Description

Column

Yes

Specify the column name of the table.

Row

Yes

Specify the row number of the table.

Note: Row Number starts from 1

Output

True

If the keyword passes successfully

False

If the keyword fails

Example

ClickCell.jpg

In the above screenshot, if you want to click on the first row under Invoice Num column in OracleEBS form then you can use the β€œOracle_ClickCell” keyword as follows:

Oracle_ClickCell

Object

<  Choose Radio table object from the OR  >

Column

Invoice Num

Row

1

Note: If you have created a Test Script (using Oracle_ClickCell) by recording actions performed on the Oracle EBS application then the OR created by recording, contains Column_Name and Row number as properties. In this scenario, it’s not mandatory to provide Column-Name & Row-Number as data input argument as if data input argument is empty then it picks data from the mapped OR. You can click on any cell of the table by providing the valid data from data input argument. In fact, during execution process it first picks the data from data input argument, if it’s empty then it picks data from the mapped OR.

Common Error conditions

Scenarios

Error Message

Debug Information

When object is not given.

Argument Data Missing (-13200)

Data not provided for argument: ‘Object’. Expected Static Value was empty.

If the provided data input arguments are not correct

Object Not Found (-11100)

 

Oracle_OpenDialogInTable

This keyword is used to open the dialog in table in the Oracle EBS application form. It takes table object as Object Input argument. It also Β takes Column and Β Row as Data Input Arguments.

Input Arguments

Object Input Arguments

Required?

Description

Object

Yes

This keyword takes table object as Object Input argument.

Data Input Arguments

Required?

Description

Column

Yes

Specify the column name of the table.

Row

Yes

Specify the row number of the table.

Note: Row Number starts from 1

Output

True

If the keyword passes successfully

False

If the keyword fails

Example

OpenDialogInTable.jpg

In the above screenshot, if you want to open the dialog in table of Oracle EBS form then then you can use the β€œOracle_OpenDialogInTable” keyword as follows:

Oracle_OpenDialogInTable

Object

<  Choose a table Object from the OR  >

Column

Invoice Num

Row

1

Common Error conditions

Scenarios

Error Message

Debug Information

When object is not given.

Argument Data Missing (-13200)

Data not provided for argument: ‘Object’. Expected Static Value was empty.

If the provided data input argument are not correct

Object Not Found (-11100)

          NA

Oracle_ClickMenuCheckBox

This keyword is used to click on a menu Checkbox in the Oracle EBS application form. It Β takes the menu Checkbox object as Object Input argument. It doesn’t take any as Data Input Arguments.

Input Arguments

Object Input Arguments

Required?

Description

Object

Yes

This keyword takes the menu Checkbox object as Object Input argument.

Data Input Arguments

Required?

Description

Data

No

This keyword doesn’t take any Data Input Arguments.

Output

True

If the keyword passes successfully

False

If the keyword fails

Example

if you want to click on the Menu checkbox then you can use the β€œOracle_ClickMenuCheckBox” keyword as follows:

Oracle_ClickMenuCheckBox

Object

<  Choose click menu checkbox Object from the OR  >

Common Error conditions

Scenarios

Error Message

Debug Information

When object is not given

Argument Data Missing (-13200)

Data not provided for argument: ‘Object’. Expected Static Value was empty.

When Oracle_ClickMenuCheckBox keyword is used without launching the the OracleEBS application form.

Step Timed Out (-12200)

Step [#11] timed out. System waited for 90sec.

Oracle_SetFocusToCell

This keyword set focus to a specified table cell. It takes a table Object as Object Input Arguments. It also takes Column Name and Row Number as Data Input Arguments.

Input Arguments

Object Input Arguments

Required?

Description

 Object

 Yes

This Keyword takes one table object as Object input argument.

Data Input Arguments

Required?

Description

Column

Yes

Specify the column name of the table.

Row

Yes

Specify the row number of the table.

Note: Row Number starts from 1

Output

True

If the keyword passes successfully

False

If the keyword fails

Example

2.jpg

Suppose you want to set focus on the highlighted cell of the table Β that exists on a page of an oracle application then, you will use the keyword β€œOracle_SetFocusToCell” as follows:

Oracle_SetFocusToCell

Object

<  Choose a table Object from the OR  >

Column

Customer Taxpayer ID

Row

1

Common Error conditions

Scenarios

Error Message

Debug Information

 When blank Object and Data input argument is provided .

Argument Data Missing (-13200)

DESCRIPTION:

A step could not be executed because one or more of the arguments have not been provided a value. Of all the arguments a keyword accepts, some arguments might be compulsory. As opposed to the non-compulsory ones, the compulsory argument must be provided some data. The data may be provided through one of many sources like statically entering, output of a previous step, a global variable etc; but it must not be left blank.

Data not provided for argument: ‘Object’. Expected Static Value was empty.

When blank object and valid Data Input Argument is provided.

Object : None

Column: Invoice Num

Row : 1

Argument Data Missing (-13200)

DESCRIPTION:

A step could not be executed because one or more of the arguments have not been provided a value. Of all the arguments a keyword accepts, some arguments might be compulsory. As opposed to the non-compulsory ones, the compulsory argument must be provided some data. The data may be provided through one of many sources like statically entering, output of a previous step, a global variable etc; but it must not be left blank.

Data not provided for argument: ‘Object’. Expected Static Value was empty.

Oracle_OpenDialog

This keyword is used to open the given dialog box. This keyword takes dialog box object as Object Input argument. It doesn’t take any Data Input Arguments.

Input Arguments

Object Input Arguments

Required?

Description

Object

Yes

This keyword takes the dialog box object as object input argument.

Data Input Arguments

Required?

Description

Data

No

This keyword doesn’t take any Data Input Arguments.

Output

True

If the keyword passes successfully

False

If the keyword fails

Example

3 Oracle_OpenDialog.jpg

In the above screenshot, if you want to open the Application dialog box field then you can use the β€œOracle_OpenDialog” keyword as follows:

Oracle_OpenDialog

Object

<  Choose dialog box Object from the OR  >

Common Error conditions

Scenarios

Error Message

Debug Information

When object is not given

 

Argument Data Missing (-13200)

Data not provided for argument: ‘Object’. Expected Static Value was empty.

When Oracle_OpenDialog keyword is used without launching the the OracleEBS application form.

Step Timed Out (-12200)

Step [#11] timed out. System waited for 90sec.

Oracle_VerifyCellValue

This keyword is used to verify the value of a specified table cell in the Oracle EBS application form. It takes table object as Object Input argument. It also takes value, column and row as Data Input Arguments.

Input Arguments

Object Input Arguments

Required?

Description

Object

Yes

This keyword takes table object as Object Input argument.

Data Input Arguments

Required?

Description

Column

Yes

Specify the column name of the table.

Row

Yes

Specify the row number of the table.

Note: Row Number starts from 1

Value

Yes

Specify the value that has to be verified.

Output

True

If the keyword passes successfully

False

If the keyword fails

Example

VerifyCellValue.jpg

In the above screenshot, if you want to verify the value of first cell entered in Invoice Num column in OracleEBS form then you can use the β€œOracle_VerifyCellValue” keyword as follows:

Oracle_VerifyCellValue

Object

<  Choose a table Object from the OR  >

Column

Invoice Num

Row

1

Value

5

Common Error conditions

Scenarios

Error Message

Debug Information

When object is not given.

Argument Data Missing (-13200)

Data not provided for argument: ‘Object’. Expected StaticValue was empty.

If the provided data input argument are not correct

Object Not Found (-11100)

 

Oracle_ClickTextField

This keyword is used to click on the given text field. This keyword takes text field object as Object Input argument. It does not take any Data Input Arguments.

Input Arguments

Object Input Arguments

Required?

Description

Object

Yes

This keyword takes an text field object as object input argument.

Data Input Arguments

Required?

Description

Data

No

This keyword doesn’t take any data input argument.

Output

True

If the keyword passes successfully

False

If the keyword fails

Example

1 Oracle_ClickTextField.jpg

In the above screenshot, if you want to click on the Name text field then you can use the β€œOracle_ClickTextField” keyword as follows:

Oracle_ClickTextField

Object

<  Choose an text field Object from the OR  > Here, Name

Common Error conditions

Scenarios

Error Message

Debug Information

When object is not given

 

Argument Data Missing (-13200)

Data not provided for argument: ‘Object’. Expected Static Value was empty.

When Oracle_ClickTextField keyword is used without launching the the OracleEBS application form.

Step Timed Out (-12200)

Step [#11] timed out. System waited for 90sec.

Oracle_WaitForOracleObject

This keyword waits for specified Object on page for a given time. This keyword used in such a condition when Page have Object that takes more time to appear on the page.

This keyword waits for specified time and if in given time Object is visible on page then it passes the Execution if Object is not visible in given time then it fails the Execution.

Input Arguments

Object Input Arguments

Required?

Description

Object

Yes

This keyword takes an object as object input argument.

Data Input Arguments

Required?

Description

Flag

Yes

Specify whether the keyword appears after any web keyword or not. It will work for both True/False conditions after launching the oracle forms.

At the time of transition from web to oracle if Flag is false then it will not wait for the oracle object.

Time Out

Yes

Specify the Time in seconds for which

the Execution will wait for the object to appear.

Output

True

If the keyword passes successfully

False

If the keyword fails

Example

In the above screenshot, if you want wait for the β€œServer” object of a page of the Oracle application then this is how you will use β€œ Oracle_WaitForOracleObjectβ€œ keyword.

Oracle_WaitForOracleObject

Object

<  Choose an Object from the OR  > Here, Server

Flag

False

Time Out

5

Common Error conditions

Scenarios

Error Message

Debug Information

When  blank Object input arguments but valid -data input arguments are provided

Object :

value : 18

Property : Height

Argument Data Missing (-13200)

DESCRIPTION:

A step could not be executed because one or more of the arguments have not been provided a value. Of all the arguments a keyword accepts, some arguments might be compulsory. As opposed to the non-compulsory ones, the compulsory argument must be provided some data. The data may be provided through one of many sources like statically entering, output of a previous step, a global variable etc; but it must not be left blank.

Data not provided for argument: ‘Object’. Expected Static Value was empty.

If object is not given

Object: No object

Argument Data Missing (-13200)

Data not provided for argument: ‘Object’. Expected StaticValue was empty.

Oracle_SelectFromLov

Oracle_IsCellEditable

Oracle_EnterCellValue

Oracle_ClickMenu

Oracle_TypeTextInTextArea

Oracle_VerifyCellProperty

Oracle_ClickMenuRadioButton

Oracle_DeSelectCheckBox

Oracle_GetCellType

Oracle_ClickMenuItem

Oracle_ClickOnText

Oracle_ClickTextArea

Oracle_SelectTab

Oracle_TypeTextOnEditBox

Oracle_GetCellValue

Oracle_SelectCheckBox

Oracle_SelectDropDownItem

Oracle_WaitForProperty

Oracle_GetCellProperty

Oracle_GetCheckBoxStatus

Oracle_GetFullTableText

Oracle_GetLabelText

Oracle_GetRadioButtonStatus

Oracle_GetTableColumnCount

Oracle_GetTableColumnName

Oracle_GetTableRowCount

Oracle_GetTableRowNumber

Oracle_VerifyLabelText

Function

Oracle_Output

Oracle_GetChildObjects

Oracle_FindInLOV

Oracle_ToString

Oracle_VerifyValue

Oracle_VerifyProperty

Oracle_VerifyCheckBoxStatus

Oracle_VerifyRadioButtonStatus

Oracle_VerifyTextInTextField

Oracle_VerifyTextInTextArea

Oracle_GetTextFromTextField

Oracle_GetTextFromTextArea

Oracle_GetProperty

Oracle_GetItemInList

Oracle_GetSelectedItemInList

‍

‍

Contact us