1. Home
  2. OpKey Help
  3. 12. Oracle Test Accelerator
  4. 12.28 Pick To Order

12.28 Pick To Order

Pick To Order

The order picking or order preparation operation is one of a logistic warehouse’s processes. It consists in taking and collecting articles in a specified quantity before shipment to satisfy customers’ orders. It is a basic warehousing process and has an important influence on supply chain’s productivity.

All the mentioned  Business Processes in the Oracle EBS Application uses the following Business Components in Sequence.

Login to Oracle Application

This component allows user to Log into the Oracle EBS Application. It does not take any Object Input Argument.It takes two Data Input Arguments.

Data Input Arguments

Data Input Arguments

Required?

Type

Description

User Name

Yes

String

Enter the User Name to log in to the Oracle EBS application.

Password

Yes

String

Enter the Password to log in to the Oracle EBS application.

Output

True

If the Component passes successfully

False

If the Component fails

Oracle EBS Implementation

This Component Enters the User Name and Password on the browser and Log in to the Oracle EBS application.

Data Input Arguments [Example

User Name

ERP

Password

Welcome 1

Navigate to Responsibility

Navigate to Responsibility component allows user to navigate to their respective responsibility .It does not take any Object Input Argument.It takes three Data Input Arguments.

**A responsibility is a level of authority in Oracle Applications that lets users access only those Oracle Applications functions and data appropriate to their roles in an organization.

Data Input Arguments

Data Input Arguments

Required?

Type

Description

Parent Responsibility

Yes

String

Enter the Parent Responsibility.

Sub Parent Responsibility

Yes

String

Enter the Sub Parent Responsibility.

Child Responsibility

Yes

String

Enter the Child Responsibility.

Output

True

If the Component passes successfully

False

If the Component fails

Oracle EBS Implementation

This Component navigates the user from Parent Responsibility to Sub Parent Responsibility and then Child Responsibility.

Data Input Arguments [Example]

Parent Responsibility

Crestech purchase Super User

Sub Parent Responsibility

Requisitions

Child Responsibility

Requisitions

 

Now, let’s have a look at all the Business Processes one by one.

Pick To Stock Processes

This Business Process allows user to enable the Pick To Stock process flow in Oracle EBS Application. 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 Sales Order

This component allows the user to create Sales Order. It does not take any Object Input Arguments.  It takes fifty seven Data Input Arguments.

Data Input Arguments

Data Input

Arguments

Required?

Type

Description

Order Type

Yes

String

Enter the type of Order.

Item

Yes

String

Enter the name of Item.

Sales Order Customer

Yes

String

Enter the customer of Sales Order.

Customer Number

Yes

String

Enter the Customer Number.

Customer PO

Yes

String

Enter the Customer PO.

Customer Contact

Yes

String

Enter the Contact details of Customer.

Ship to Location

Yes

String

Enter the Location to be shipped to.

Ship Address 1

Yes

String

Enter the Shipping Address 1.

Ship Address 2

Yes

String

Enter the Shipping Address 2.

Bill to Location

Yes

String

Enter the Bill to Location.

Bill to Address 1

Yes

String

Enter the Bill to Address 1.

Bill to Address 2

Yes

String

Enter the Bill to Address 2.

Date Ordered

Yes

String

Enter the Date of Ordering.

Price List

Yes

String

Enter the Price List.

Salesperson

Yes

String

Enter the name of the Salesperson.

Currency

Yes

String

Enter the name of the Currency.

Payment Terms

Yes

String

Enter the Terms of Payment.

Warehouse

Yes

String

Enter the name of the Warehouse.

Line Set

Yes

String

Enter the Line Set.

FOB

Yes

String

Enter the FOB.

Shipping Instruction

   

Yes

String

Enter the Instructions of Shipping.

Tax Handling

 

Yes

String

Enter the details on Tax Handling.

Sales Channel

Yes

String

Enter the name of Sales Channel.

Shipping Method

Yes

String

Enter the name of Shipping Method.

Freight terms

Yes

String

Enter the terms of Freight.

Shipping Priority

Yes

String

Enter the Shipping Priority.

Packing Instruction

Yes

String

Enter the Instructions of Packing.

Payment type

Yes

String

Enter the type of Payment.

Quantity

Yes

String

Enter the Quantity of Item.

UOM

Yes

String

Enter the UOM.

Unit Selling Price

Yes

String

Enter the Selling Price per Unit

Schedule Ship Date

Yes

String

Enter the Scheduled Date of Shipping.

Reason

Yes

String

Enter the Reason.

Comment

Yes

String

Enter the Comment.

Tax Classification Code

Yes

String

Enter the Code of Tax Classification.

Title

Yes

String

Enter the Title.

Order Status

Yes

String

Enter the Status of Order.

Output

True

If the Component passes successfully

False

If the Component fails

Oracle EBS Implementation

Data Input Arguments[Example]

 

Order Type

1

Item

erp om header

Sales Order Customer

Battery Charger

Customer Number

NEW ERP SOLUTIONS

Customer PO

Yes

Customer Contact

Ship to Location

Ship Address 1

Ship Address 2

Bill to Location

Bill to Address 1

Bill to Address 2

Date Ordered

Price List

Salesperson

Currency

Payment Terms

Warehouse

Line Set

FOB

Shipping Instruction

   

Tax Handling

 

Sales Channel

Shipping Method

Freight terms

Shipping Priority

Packing Instruction

Payment type

Quantity

UOM

Unit Selling Price

Schedule Ship Date

Reason

Comment

Tax Classification Code

Title

Order Status

Launch Pick Release

This component allows the user to pick the released Item. It does not take any Object Input Arguments.  It takes fifty seven Data Input Arguments.

Data Input Arguments

 

Data Input

Arguments

Required?

Type

Description

Actions

Yes

String

Enter the Actions.

Saved Query Name

Yes

String

Enter the Name of Saved Query.

Saved Query Description

Yes

String

Enter the Description of Saved Query.

Source System

Yes

String

Enter the Source System.

Consignee

Yes

String

Enter the Consignee.

Ship From

Yes

String

Enter the Location to be shipped from.

From Schedule Date

Yes

String

Enter the Scheduled Date from which Shipping will be made.

From Order Number

Yes

String

Enter the Order Number from which Shipping will be made.

Assigned Lines

Yes

String

Enter the names of Assigned Lines.

Item

Yes

String

Enter the name of Item.

Shipment Priority

Yes

String

Enter the Priority of Shipment.

From Pick Up Date

Yes

String

Enter the Pick Up Date from which Shipping will be made.

From Tracking Number

Yes

String

Enter the Tracking Number from which Shipping will be made.

To Tracking Number

Yes

String

Enter the Tracking Number to which Shipping will be made.

Ship Method

Yes

String

Enter the Shipping Method.

Ship To

Yes

String

Enter the Location to be shipped to.

Freight terms

Yes

String

Enter the terms of Freight.

Output

True

If the Component passes successfully

False

If the Component fails

Oracle EBS Implementation

Data Input Arguments[Example]

 

Actions

1

Saved Query Name

erp om header

Saved Query Description

Battery Charger

Source System

NEW ERP SOLUTIONS

Consignee

Yes

Ship From

From Schedule Date

From Order Number

Assigned Lines

Item

Shipment Priority

From Pick Up Date

From Tracking Number

To Tracking Number

Ship Method

Ship To

Freight terms

Ship Confirm

This component allows the user to confirm the Shipment of the Order. 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

Submit New Request For Auto Invoice

This component allows the user to submit new Request for Auto Invoice. It does not take any Object Input Arguments.  It takes fifty seven Data Input Arguments. 

Data Input Arguments

 

Data Input

Arguments

Required?

Type

Description

Request Name

Yes

String

Enter the Request Name.

Number of Instances

Yes

String

Enter the Number of Instances.

Organisation

Yes

String

Enter the name of Organisation.

Invoice Source

Yes

String

Enter the Source of Invoice.

Default Date

Yes

String

Enter the Default Date.

Transaction Type

Yes

String

Enter the Type of Transaction.

Low Bill To Customer Number

Yes

String

Enter the value of Low Bill to Customer Number.

High Bill To Customer Number

Yes

String

Enter the value of High Bill to Number.

Low Bill To Customer Name

Yes

String

Enter the value of Low Bill to Customer Name.

High Bill To Customer Name

Yes

String

Enter the value of High Bill to Name.

Low GL Date

Yes

String

Enter the value of Low GL Date.

High GL Date

Yes

String

Enter the value of High GL Date.

Low Ship Date

Yes

String

Enter the value of Low Ship Date.

High Ship Date

Yes

String

Enter the value of High Ship Date.

Low Transaction Number

Yes

String

Enter the value of Low Transaction Number.

High Transaction Number

Yes

String

Enter the value of High Transaction Number.

Low Sales Order Number

Yes

String

Enter the value of Low Sales Order Transaction Number.

High Sales Order Number

Yes

String

Enter the value of High Sales Order Number.

Low Invoice Date

Yes

String

Enter the value of Low Invoice Date.

High Invoice Date

Yes

String

Enter the value of High Invoice Date.

Low Ship To Customer Number

Yes

String

Enter the value of Low Ship to Customer Number.

High Ship To Customer Number

Yes

String

Enter the value of High Ship to Customer Number.

Low Ship To Customer Name

Yes

String

Enter the value of Low Ship to Customer Name.

High Ship To Customer Name

Yes

String

Enter the value of High Ship to Customer Name.

Base Due Date on TRX Date

Yes

String

Enter the value of Base Due Date on TRX Date.

Due Date Adjustment Days

Yes

String

Enter the value of Due Date Adjustment Days

Process Status

Yes

String

Enter the Status of Process.

Transaction Source

Yes

String

Enter the Transaction Source.

Transaction Number

Yes

String

Enter the Transaction Number.

Transaction Reference

Yes

String

Enter the Transaction Reference.

Transaction Legal Identity

Yes

String

Enter the Transaction Legal Identity.

Transaction Date

Yes

String

Enter the Transaction Date.

Transaction GL Date

Yes

String

Enter the Transaction GL Date.

Transaction Currency

Yes

String

Enter the Transaction Currency.

Transaction Document Number

Yes

String

Enter the Transaction Document Number.

Output

True

If the Component passes successfully

False

If the Component fails

Oracle EBS Implementation

Data Input Arguments[Example]

 

Request Name

Autoinvoice Master Program

Number of Instances

Organisation

erp op1

Invoice Source

ERP OM Source

Default Date

04-APR-2018

Transaction Type

Low Bill To Customer Number

High Bill To Customer Number

Low Bill To Customer Name

High Bill To Customer Name

Low GL Date

High GL Date

Low Ship Date

High Ship Date

Low Transaction Number

High Transaction Number

Low Sales Order Number

High Sales Order Number

Low Invoice Date

High Invoice Date

Low Ship To Customer Number

High Ship To Customer Number

Low Ship To Customer Name

High Ship To Customer Name

Base Due Date on TRX Date

Due Date Adjustment Days

Process Status

Autoinvoice Master Program

Transaction Source

Transaction Number

Transaction Reference

Transaction Legal Identity

Transaction Date

Transaction GL Date

Transaction Currency

Transaction Document Number

Close All Browsers

This component allows the user to close all Forms and 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 PTO Item

This Business Process allows user to create PTO Items in Oracle EBS Application. 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 Item

This component allows the user to create Item. It does not take any Object Input Arguments.  It takes three Data Input Arguments.

Data Input Arguments

Data Input

Arguments

Required?

Type

Description

Organization

Yes

String

Enter the name of the Organization.

Item Name

Yes

String

Enter the name of Item.

Template

Yes

String

Enter the Name of Template.

Output

True

If the Component passes successfully

False

If the Component fails

Oracle EBS Implementation

Data Input Arguments[Example]

 

Organization

%E99%

Item Name

%XEROX%PRINTER%1%

Template

%Assembly%

Close All Browsers

This component allows the user to close all Forms and 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 On Hand

This Business Process allows user to check on hand availability of items in Oracle EBS Application. 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 On Hand

This component allows the users to check on Hand availability of Items. It does not take any Object Input Arguments. It takes eight Data Input Arguments.

Data Input Arguments

 

Data Input Arguments

Required?

Type

Description

Organisation

Yes

String

Enter the name of Organisation.

Type

Yes

String

Enter the type of Item.

Item

Yes

String

Enter the name of Item.

Sub Inventory

Yes

String

Enter the Subinventory of Item.

Quantity

Yes

String

Enter the Quantity of Item.

Company

Yes

String

Enter the name of Company.

Department

Yes

String

Enter the name of Department.

Account

Yes

String

Enter the name of Account.

Future

Yes

String

Enter the name of Future.

Future2

Yes

String

Enter the name of Future2.

Output

True

If the Component passes successfully

False

If the Component fails

Oracle EBS Implementation

Data Input Arguments[Example]

 

Organisation

%E99%

Type

%Miscellaneous%receipt%

Item

YAMAHA FZ ENGINE

Sub Inventory

%ERP%SUB%IN%

Quantity

1000

Company

01

Department

001

Account

1410

Future

000

Future2

000

Close All Browsers

This component allows the user to close all Forms and 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 BOM

This Business Process allows user to create Bill of Material for the Selected Item. 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 BOM

This component allows the users to create Bill of Material for the Selected Item. It does not take any Object Input Arguments. It takes four Data Input Arguments.

Data Input Arguments

Data Input Arguments

Required?

Type

Description

Organisation

Yes

String

Enter the name of Organisation.

Item

Yes

String

Enter the name of Item.

Sub Item One

Yes

String

Enter the name of Sub Item One.

Sub Item Two

Yes

String

Enter the name of Sub Item Two.

Output

True

If the Component passes successfully

False

If the Component fails

Oracle EBS Implementation

Data Input Arguments[Example]

 

Organisation

E99

Item

%YAMAHA%FZ%BIKE002%

Sub Item One

%FIXED%CALIPER%DISC%BRAKE1%

Sub Item Two

%FLOATING%CALIPER%DISC%BRAKE1%

Close All Browsers

This component allows the user to close all Forms and 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

 

Was this article helpful to you? Yes No