1. Home
  2. OpKey Help
  3. 12. Oracle Test Accelerator
  4. 12.24 Procure to Pay – Part 4

12.24 Procure to Pay – Part 4

Journal Posting with Changed Currency

This Business Process allows user to post the Journal with changed currencyl. It is composed of the  following Business Components.

[* It is mandatory to use Log in to Oracle Application and Navigate to Responsibility before proceeding below].

Check Balance Using Entered Currency In Account Inquiry of Journal with Approval

This component allows the users to check Balance of Journal. It does not take any Object Input Arguments. It takes thirteen Data Input Arguments.

 

Data Input Arguments


Data Input

Arguments

Required?

Type

Description

Accounting Period Form

Yes

String

Enter the start Date of Accounting Period.

Currency Type in Account Inquiry

Yes

String

Enter the Currency Type in Account Inquiry.

Currency Entered

Yes

String

Enter the type of Currency.

Company Low

Yes

String

Enter the Lowest statistics seen by Company.

Company High

Yes

String

Enter the Highest statistics seen by Company.

Department Low

Yes

String

Enter the lowest statistics seen by any Department.

Department High

Yes

String

Enter the highest statistics seen by any Department.

Account Low

Yes

String

Enter the lowest statistics seen by an Account.

Account High

Yes

String

Enter the highest statistics seen by an Account.

Future Low

Yes

String

Enter the lowest statistics seen by Future 1.

Future High

Yes

String

Enter the highest statistics seen by Future 1.

Second Future Low

Yes

String

Enter the lowest statistics seen by Future 2.

Second Future High

Yes

String

Enter the highest statistics seen by Future 2.

 

Output

True

If the Component passes successfully

False

If the Component fails

 

Oracle EBS Implementation

 

Data Input Arguments [Example]


Accounting Period Form

JAN-18

Currency Type in Account Inquiry

Entered

Currency Entered

USD

Company Low

01

Company High

02

Department Low

001

Department High

003

Account Low

1110

Account High

9999

Future Low

000

Future High

000

Second Future Low

000

Second Future High

000

 

Change Currency while Journal Posting

This component allows the user to post the Journal with Approved status. It does not take any Object Input Argument. It takes thirteen Data Input Arguments.

 

Data Input Arguments


Data Input

Arguments

Required?

Type

Description

Journal Category

Yes

String

Enter the Name of Journal Category.

Company

Yes

String

Enter the name of Company.

Credit Account

Yes

String

Enter the Credit Account.

Debit Account

Yes

String

Enter the Debit Account.

Credit Department

Yes

String

Enter the name of Credit Department.

Debit Department

Yes

String

Enter the name of Debit Department.

Currency Type

Yes

String

Enter the type of Currency.

Currency Name

Yes

String

Enter the name of Currency.

Cash Category

Yes

String

Enter the Cash Category.

Credit Amount

Yes

String

Enter the Credit Amount.

Debit Amount

Yes

String

Enter the Debit Amount.

Line

Yes

String

Enter the Line of Item.

New Form Period

Yes

String

Enter the New Form Period.


Output

True

If the Component passes successfully

False

If the Component fails

 

Oracle EBS Implementation

 

Data Input Arguments [Example]


Journal Category

%expenditure%

Company

01

Credit Account

2210

Debit Account

1110

Credit Department

001

Debit Department

001

Currency Type

Corporate

Currency Name

USD

Cash Category

Rent

Credit Amount

2000

Debit Amount

2000

Line

1

New Form Period

JAN-18

Close All Forms 

This component allows the user to close all Forms. It does not take any Object and Data Input Arguments.

Output

True

If the Component passes successfully

False

If the Component fails

 

Oracle EBS Implementation

 
 

Check Process Status

This  component allows the user to check the Status of the Current Process. It does not take any Object Input Argument. It takes two Data Input Arguments.

 

 

Data Input Arguments

 

Data Input

Arguments

Required?

Type

Description

Status To Verify

Yes

String

Enter the Status to be verified.

Process ID

Yes

String

Enter the Process ID.

 

Output

True

If the Component passes successfully

False

If the Component fails

 

Oracle EBS Implementation

Data Input Arguments [Example]

Status To Verify

Approval

Process ID

Request ID

Close All Forms

This component allows the user to close all Forms. It does not take any Object and Data Input Arguments.

 

Output

True

If the Component passes successfully

False

If the Component fails

 

Oracle EBS Implementation

 

Navigate To General Ledger Super User Inquiry Account

This  component allows the user to navigate on the desired function. It does not take any Object and Data Input Argument.

 

Output

True

If the Component passes successfully

False

If the Component fails

 

Oracle EBS Implementation

 
 

Check Balance Using Entered Currency In Account Inquiry of Journal with Approval

This component allows the users to check Balance of Journal. It does not take any Object Input Arguments. It takes thirteen Data Input Arguments.

 

Data Input Arguments


Data Input

Arguments

Required?

Type

Description

Accounting Period Form

Yes

String

Enter the start Date of Accounting Period.

Currency Type in Account Inquiry

Yes

String

Enter the Currency Type in Account Inquiry.

Currency Entered

Yes

String

Enter the type of Currency.

Company Low

Yes

String

Enter the Lowest statistics seen by Company.

Company High

Yes

String

Enter the Highest statistics seen by Company.

Department Low

Yes

String

Enter the lowest statistics seen by any Department.

Department High

Yes

String

Enter the highest statistics seen by any Department.

Account Low

Yes

String

Enter the lowest statistics seen by an Account.

Account High

Yes

String

Enter the highest statistics seen by an Account.

Future Low

Yes

String

Enter the lowest statistics seen by Future 1.

Future High

Yes

String

Enter the highest statistics seen by Future 1.

Second Future Low

Yes

String

Enter the lowest statistics seen by Future 2.

Second Future High

Yes

String

Enter the highest statistics seen by Future 2.


 

Output

True

If the Component passes successfully

False

If the Component fails

 

Oracle EBS Implementation




Accounting Period Form

JAN-18

Currency Type in Account Inquiry

Entered

Currency Entered

USD

Company Low

01

Company High

02

Department Low

001

Department High

003

Account Low

1110

Account High

9999

Future Low

000

Future High

000

Second Future Low

000

Second Future High

000

 

Close All Browsers

This  component allows the user to close all Oracle Forms and Browsers.It does not take any Object and Data  Input Argument.

 

Output

True

If the Component passes successfully

False

If the Component fails

 
 

Oracle EBS Implementation

 

 

Reverse Journal 

This Business Process allows user to reverse any Journal. It is composed of the  following Business Components.

[* It is mandatory to use Log in to Oracle Application and Navigate to Responsibility before proceeding below].

Post Journal with Approval

This component allows the user to post the Journal with Approved status. It does not take any Object Input Argument. It takes eleven Data Input Arguments.

 

Data Input Arguments


Data Input

Arguments

Required?

Type

Description

Category

Yes

String

Enter the Name of Category.

   Cash Category

Yes

String

Enter the Cash Category.

Journal Period

Yes

String

Enter the period for the Journal.

Company LOV

Yes

String

Enter the List of Values for Company.

Department

 LOV

Yes

String

Enter the List of Values for Department.

Department

Yes

String

Enter the Department name.

Account

Yes

String

Enter the Amount.

Credit Amount

Yes

String

Enter the Credit Amount.

Debit Amount

Yes

String

Enter the Debit Amount.

Line

Yes

String

Enter the Line of Item.

Account LOV

Yes

String

Enter the List of Values for Account.

 

Output

True

If the Component passes successfully

False

If the Component fails

 

Oracle EBS Implementation

 

Data Input Arguments [Example]


Category

%expenditure%

   Cash Category

Rent

Journal Period

JAN-18

Company LOV

01

Department LOV

001

Department

001

Account

2210

Credit Amount

2000

Debit Amount

2000

Line

1

Account LOV

1110

 

Close All Forms

This component allows the user to close all Forms. It does not take any Object and Data Input Arguments.

 

Output

True

If the Component passes successfully

False

If the Component fails

 

Oracle EBS Implementation

 

Check Process Status

This  component allows the user to check the Status of the Current Process. It does not take any Object Input Argument. It takes two Data Input Arguments.

 

Data Input Arguments

 

Data Input

Arguments

Required?

Type

Description

Status To Verify

Yes

String

Enter the Status to be verified.

Process ID

Yes

String

Enter the Process ID.

 

Output

True

If the Component passes successfully

False

If the Component fails

 

Oracle EBS Implementation

 

Data Input Arguments [Example]


Status To Verify

Approval

Process ID

Request ID

Close All Forms

This component allows the user to close all Forms. It does not take any Object and Data Input Arguments.

 

Output

True

If the Component passes successfully

False

If the Component fails

 

Oracle EBS Implementation

Find Journal And Verify Batch Status

This component allows the user to search the Journal and also to verify the batch status for the Journal being searched. It does not take any Object Input Argument. It takes eleven Data Input Arguments.

 

Data Input Arguments

 

Data Input

Arguments

Required?

Type

Description

Journal Number

Yes

String

Enter the Journal Number.

Category

Yes

String

Enter the Name of Category.

   Currency

Yes

String

Enter the Currency.

Funds Status

Yes

String

Enter the Status of Funds.

Batch Control Total

Yes

String

Enter the Batch Control Total.

Journal Control Total

Yes

String

Enter the Journal Control Total.

Batch Number

Yes

String

Enter the Batch Number.

Period

Yes

String

Enter the Period.

Posting Status

Yes

String

Enter the Posting Status.

Ledger

Yes

String

Enter the Ledger.

Source

Yes

String

Enter the Source.

 

Output

True

If the Component passes successfully

False

If the Component fails

 

Oracle EBS Implementation

 
Data Input Arguments [Example]

Journal Number

Journal Number

Category

 

   Currency

 

Funds Status

 

Batch Control Total

 

Journal Control Total

 

Batch Number

 

Period

JAN-18

Posting Status

Posted

Ledger

NEW ERP LED

Source

 

Reverse Journal

This component allows the user to reverse the Journal. It does not take any Object Input Arguments.  It takes four Data Input Arguments.

 

 

Data Input Arguments

 

Data Input

Arguments

Required?

Type

Description

Journal Number

Yes

String

Enter the Journal Number.

Ledger

Yes

String

Enter the name of the Ledger.

Reverse Period

Yes

String

Enter the Period of Reversal.

Status to Verify

Yes

String

Enter the Status to Verify.

 

Output

True

If the Component passes successfully

False

If the Component fails

 

Oracle EBS Implementation

 
Data Input Arguments [Example]


Journal Number

Journal Number

Ledger

NEW ERP LED

Reverse Period

JAN-18

Status to Verify

Reverse Journals

Close All Browsers

This component allows the user to close all browsers. It does not take any Object and Data Input Arguments.

 

Output

True

If the Component passes successfully

False

If the Component fails

 

Oracle EBS Implementation

 

 

Create Invoice And Stop Payment

This Business Process allows user to create Invoice and Stop Payment. It is composed of the  following Business Components.

[* It is mandatory to use Log in to Oracle Application and Navigate to Responsibility before proceeding below].

Create Invoice

This  component allows the user to create Invoice. It does not take any Object Input Argument.  It takes ten Data Input Arguments.

 

Data Input Arguments


Data Input

Arguments

Required?

Type

Description

Trading Partner

Yes

String

Enter the  name of Trading Partner.

Department

Yes

String

Enter the name of Department.

Company LOV

Yes

String

Enter the List of Values for Company.

Account Code

Yes

String

Enter the  Account Code.

Distribution

Combination

Yes

String

Enter the combination for Distribution of Item.

Invoice Date

Yes

String

Enter the Date of Invoice.

Operating Unit

Yes

String

Enter the Operating Unit.

Invoice Amount

Yes

String

Enter the Amount on invoice.

Distributed Amount

Yes

String

Enter the Distributed Amount.

Requester

Yes

String

Enter the name of the Requester.

 

Output

True

If the Component passes successfully

False

If the Component fails

 

Oracle EBS Implementation

 

Data Input Arguments [Example]


Trading Partner

NEW ERP

Department

003

Company LOV

01

Account Code

1110

Distribution Combination

 

Invoice Date

2-APR-2018

Operating Unit

erp op1

Invoice Amount

100000

Distributed Amount

30000

Requester

Finance

 

Stop Payment

This component allows the user to stop the Payment for the created Invoice. It does not take any Object Input Arguments.  It takes three Data Input Arguments.

 

Data Input Arguments

 

Data Input

Arguments

Required?

Type

Description

Payment Process Profile

Yes

String

Enter the Payment Process Profile.

Payment Date

Yes

String

Enter the Payment Date.

Bank Account

Yes

String

Enter the name of the Bank Account.

 

Output

True

If the Component passes successfully

False

If the Component fails

 

Oracle EBS Implementation

 
Data Input Arguments [Example]

Payment Process Profile

AS_Pay_check

Payment Date

28-FEB-2018

Bank Account

erp bank account

Close All Browsers

This component allows the user to close all Oracle Forms and their browsers. It does not take any Object and Data Input Arguments.

 

Output

True

If the Component passes successfully

False

If the Component fails

 

Oracle EBS Implementation

 

 

Create Recurring Skelton Journal

This Business Process allows user to create recurring Skelton Journal. It is composed of the  following Business Components.

[* It is mandatory to use Log in to Oracle Application and Navigate to Responsibility before proceeding below].

Create Recurring Journal

This component allows the user to create the recurring Journal. It does not take any Object Input Arguments.  It takes seven Data Input Arguments.

 

Data Input Arguments


Data Input

Arguments

Required?

Type

Description

Recurring Batch

Yes

String

Enter the Recurring Batch.

Period

Yes

String

Enter the Period.

Posting Status

Yes

String

Enter the Status about Posting.

Ledger

Yes

String

Enter the name of the Ledger.

Source

Yes

String

Enter the Source.

Status to Verify

Yes

String

Enter the Status to Verify.

Process ID

Yes

String

Enter the Process ID.

 

 

Output

True

If the Component passes successfully

False

If the Component fails

 

Oracle EBS Implementation

 

Data Input Arguments [Example]


Recurring Batch

Rec_sk

Period

MAR-18

Posting Status

Unposted

Ledger

NEW ERP LED

Source

Recurring

Status to Verify

Recurring Journal Entry

Process ID

 

 

Close All Browsers

This component allows the user to close all Oracle Forms and their browsers. It does not take any Object and Data Input Arguments.

 

Output

True

If the Component passes successfully

False

If the Component fails

 

Oracle EBS Implementation

 

 

Create Recurring Standard Journal

This Business Process allows user to create recurring standard Journal. It is composed of the  following Business Components.

[* It is mandatory to use Log in to Oracle Application and Navigate to Responsibility before proceeding below].

Create Recurring Journal

This component allows the user to create the recurring Journal. It does not take any Object Input Arguments.  It takes seven Data Input Arguments.

 

Data Input Arguments


Data Input

Arguments

Required?

Type

Description

Recurring Batch

Yes

String

Enter the Recurring Batch.

Period

Yes

String

Enter the Period.

Posting Status

Yes

String

Enter the Status about Posting.

Ledger

Yes

String

Enter the name of the Ledger.

Source

Yes

String

Enter the Source.

Status to Verify

Yes

String

Enter the Status to Verify.

Process ID

Yes

String

Enter the Process ID.

 

 

Output

True

If the Component passes successfully

False

If the Component fails

 

Oracle EBS Implementation

 

Data Input Arguments [Example]


Recurring Batch

Rec_sk

Period

MAR-18

Posting Status

Unposted

Ledger

NEW ERP LED

Source

Recurring

Status to Verify

Recurring Journal Entry

Process ID

 

 

Post Recurring Journal

This component allows the user to Post the recurring Journal. It does not take any Object Input Arguments.  It takes six Data Input Arguments.

 

Data Input Arguments

 

Data Input

Arguments

Required?

Type

Description

Status to Verify

Yes

String

Enter the Status to Verify.

Batch Number

Yes

String

Enter the Batch Number.

Ledger

Yes

String

Enter the name of the Ledger.

Source

Yes

String

Enter the Source.

Posting Status

Yes

String

Enter the Status about Posting.

Period

Yes

String

Enter the Period.

 

 

Output

True

If the Component passes successfully

False

If the Component fails

 

Oracle EBS Implementation

 
Data Input Arguments [Example]

Status to Verify

Recurring Journal Entry

Batch Number

Batch Number

Ledger

NEW ERP LED

Source

Recurring

Posting Status

Posted

Period

MAR-18

Close All Browsers

This component allows the user to close all Oracle Forms and their browsers. It does not take any Object and Data Input Arguments.

 

Output

True

If the Component passes successfully

False

If the Component fails

 

Oracle EBS Implementation

 

 

Run Revaluation

This Business Process allows user to run revaluation. It is composed of the  following Business Components.

[* It is mandatory to use Log in to Oracle Application and Navigate to Responsibility before proceeding below].

 

Setup Currency Rate

This component allows the user to setup the Currency Rate. It does not take any Object Input Arguments.  It takes five Data Input Arguments.

Data Input Arguments

 

Data Input

Arguments

Required?

Type

Description

Currency From

Yes

String

Enter the Account from which Currency has to be updated.

Currency To

Yes

String

Enter the Currency name for converting.

Conversion Date

Yes

String

Enter the Date of Conversion.

Conversion Type

Yes

String

Enter the type of Conversion.

Conversion Rate

Yes

String

Enter the Rate of Conversion.

 

Output

True

If the Component passes successfully

False

If the Component fails

 

Oracle EBS Implementation

 

Data Input Arguments [Example]


Currency From

ERP

Currency To

EURO

Conversion Date

26-MAR-2018

Conversion Type

Corporate

Conversion Rate

12

 

Close All Forms

This component allows the user to close all Forms. It does not take any Object and Data Input Arguments.

 

Output

True

If the Component passes successfully

False

If the Component fails

 

Oracle EBS Implementation

 

Change Currency While Journal Posting

This component allows the user to post the Journal with Approved status. It does not take any Object Input Argument. It takes thirteen Data Input Arguments.

Data Input Arguments

 

Data Input

Arguments

Required?

Type

Description

Journal Category

Yes

String

Enter the Name of Journal Category.

Company

Yes

String

Enter the name of Company.

Credit Account

Yes

String

Enter the Credit Account.

Debit Account

Yes

String

Enter the Debit Account.

Credit Department

Yes

String

Enter the name of Credit Department.

Debit Department

Yes

String

Enter the name of Debit Department.

Currency Type

Yes

String

Enter the type of Currency.

Currency Name

Yes

String

Enter the name of Currency.

Cash Category

Yes

String

Enter the Cash Category.

Credit Amount

Yes

String

Enter the Credit Amount.

Debit Amount

Yes

String

Enter the Debit Amount.

Line

Yes

String

Enter the Line of Item.

New Form Period

Yes

String

Enter the New Form Period.

 

Output

True

If the Component passes successfully

False

If the Component fails

 

Oracle EBS Implementation

Data Input Arguments [Example]


Journal Category

%expenditure%

Company

01

Credit Account

2210

Debit Account

1110

Credit Department

001

Debit Department

001

Currency Type

Corporate

Currency Name

USD

Cash Category

Rent

Credit Amount

2000

Debit Amount

2000

Line

1

New Form Period

JAN-18



 

Close All Forms

This component allows the user to close All Forms. It does not take any Object and Data Input Arguments.

 

Output

True

If the Component passes successfully

False

If the Component fails

 

Oracle EBS Implementation

 
 

Check Process Status

This  component allows the user to check the Status of the Current Process. It does not take any Object Input Argument. It takes two Data Input Arguments.

 

Data Input Arguments


Data Input

Arguments

Required?

Type

Description

Status To Verify

Yes

String

Enter the Status to be verified.

Process ID

Yes

String

Enter the Process ID.


 

Output

True

If the Component passes successfully

False

If the Component fails

 

Oracle EBS Implementation

 

Data Input Arguments [Example]


Status To Verify

Approval

Process ID

Request ID

 

Close All Forms

This component allows the user to close all Forms. It does not take any Object and Data Input Arguments.

 

Output

True

If the Component passes successfully

False

If the Component fails

 

Oracle EBS Implementation

 

Update Currency Rate

This component allows the user to update the Currency Rate. It does not take any Object Input Arguments.  It takes six Data Input Arguments.

 

Data Input Arguments

 

Data Input

Arguments

Required?

Type

Description

Currency From

Yes

String

Enter the Account from which Currency has to be updated.

Currency To

Yes

String

Enter the Currency name for converting.

From Date

Yes

String

Enter the Starting Date of Conversion.

To Date

Yes

String

Enter the Ending Date of Conversion.

Conversion Type

Yes

String

Enter the type of Conversion.

Updated Conversion Rate

Yes

String

Enter the Updated Rate of Conversion.



 

Output

True

If the Component passes successfully

False

If the Component fails

 

Oracle EBS Implementation

Data Input Arguments [Example]


Currency From

ERP

Currency To

EURO

From Date

1-JAN-2018

To Date

1-JAN-2018

Conversion Type

Corporate

Updated Conversion Rate

14

Navigate to General Ledger Super User Set up Currency Rate Daily

This component allows the user to navigate on the desired Function. It does not take any Object and Data Input Arguments.

 

Output

True

If the Component passes successfully

False

If the Component fails

 

Oracle EBS Implementation

 

Close All Forms

This component allows the user to close all Forms. It does not take any Object and Data Input Arguments.