Join the OracleApps88 Telegram group @OracleApps88to get more information on Oracle EBS R12/Oracle Fusion applications.

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.

Saturday, December 10, 2016

Oracle Process Manufacturing Test Details

Script: CrtItems - Create Items: Create items with various attributes to be used in a production batch.
Login: process_ops/welcome
Responsibility: Inventory Super user Process Operations
Choose Organization as PR1 if organization access window opens.

Task: Oracle Inventory Item Set up
Actions:
1.         Navigate: Item/Master Item/Master Item
2.         Enter
Item: TSKFG
Description: Test Item

Main Tab:
Item status: Active
User Item Type: FIN
Primary UOM: LB
Tracking: Primary
Pricing: Primary

Inventory tab:
Inventory Item = YES
Stackable: YES
Reservable: YES
Transact able: YES
Lot Control: Full Control
Starting Prefix: LOT
Starting Number: 1
Lot Status Enabled: YES
Default Lot Status: GOOD

Bill of Material tab:
BOM allowed: no

Costing tab:
Costing enabled: YES
Inventory asset value: YES

Purchasing tab:
Purchased: YES
Purchasable: YES
Default Buyer: Copeland, Ms. Sandra
List price: 10

Receiving tab:
Receipt Routing: Direct

General Planning tab:
Make or Buy: Make

Work in Process tab:
Build in WIP = YES
Type = Push

Process Manufacturing tab:
Process Quality Enabled: YES
Process Costing Enabled= YES
Recipe Enabled: YES
Process Execution Enabled: YES
3.         Click the Save icon.
4.         Select Tools/Organization Assignment.
5.         Assign to Org PR1.
6.         Click Save.
7.         Select File/Close Form.
8.         Navigate: Item/Master Item/Master Item
9.         Enter:
Item: TSKRAW
Description: Test Item

Main tab:
item status: Active
User Item Type: RAW
Primary UOM: LB
Tracking: Primary
Pricing: Primary

Inventory tab:
Inventory Item = YES
Stackable: YES
Reservable: YES
Transact able: YES
Lot Control: Full Control
Starting Prefix: LOT
Starting Number: 1
Lot Status Enabled: YES
Default Lot Status: GOOD

Bill of Material tab:
BOM allowed: no

Costing tab:
Costing enabled: YES
Inventory asset value: YES

Purchasing tab:
Purchased: YES
Purchasable: YES
Default Buyer: Copeland, Ms. Sandra
List price: 10

Receiving tab:
Receipt Routing: Direct

General Planning tab:
Make or Buy: Buy

Work in Process tab:
Build in WIP: YES
Type: Push

Process Manufacturing tab:
Process Quality Enabled: YES
Process Costing Enabled= YES
Recipe Enabled: YES
Process Execution Enabled: YES
10.       Click the Save icon.
11.       Select Tools/Organization Assignment.
12.       Assign to Org PR1
13.       Click Save.
14.       Select File/Close Form

Verifications:
1.         Items form opens.
2.         Data entered.
3.         Forms close.

Script: CrtLotsConPross - Create Lots for Lot Controlled Process Items
Responsibility: Inventory Super user Process Operations
Task: Create Lot for Lot controlled Raw material item.
Actions:
1.         Navigate: On hand, Availability/Lots/Edit Item Lots
2.         Enter:
Item: TSKRAW
Parent Lot: Click generate parent lot button.
Lot: Press Tab to show the generate lot and click on generate lot button.
Originating Date: Today’s date Accept all other defaults
3.         Click the Save icon.
4.         Select File/Close Form

Verifications:
1.         Edit Item Lot form opens. If Find Lots/Jobs Form opens up, select Inventory Lot and click New.
Note down the Parent Lot and Lot number.
2.         FRM-40400: Transaction complete 1 record applied and saved when click the Save icon.
3.         Edit Item Lot form is closed when Select File/Close Form.

Script: CrtOnHndforItms - Create On hand Quantities for Items
Responsibility: Inventory Super User (Process Operations)
Task: Create a miscellaneous receipt transaction to increase on hand qty for Raw Material.
Actions:
1.         Navigate: Transactions/Miscellaneous Transactions
2.         Select Org PR1.
3.         Enter:
Date: Today’s date
Type: Miscellaneous receipt
4.         Click Transaction lines.
5.         Enter:
Item: TSKRAW
Sub inventory: PR0
Lot: XXXX (Lot Generated Earlier)
Quantity: 100
Account: 100-1100-1225-1010-0000
6.         Select File/Save.
7.         Select File/Close Form

Verifications:
1.         Miscellaneous Transactions form opens when Navigate: Transactions/Miscellaneous Transactions/select Org PR1.
2.         Miscellaneous Receipt form opens when click Transaction lines.
3.         An on-hand quantity has just been created and saved when select File/Save.
Notice that the On-Hand Quantity field is now populated.
4. Close Miscellaneous Receipt form closes when select File/Close Form.

Script: CrtaFormula - Create a formula which is approved for general use
Responsibility: Formulator
Choose Organization as PR1 if Organization selection window opens.
Tasks: Create a formula for the finished goods.
Actions:
1.         Navigate: Formulas
Form: Formula Details
2.         Enter:
Formula: TSK-Formula
Version: 1
Description: Tsk Formula
3.         Select Products tab.
4.         Enter:
Product: TSKFG
Quantity: 50
Scale Type: Proportional
Yield Type: Automatic
Cost Allocation: 1
5.         Select Ingredients tab.
6.         Enter:
Product: TSKRAW
Quantity: 50
Scale Type: Proportional
Yield Type: Automatic
Cost Allocation: 1
7.         Select File/Save
8.         Select Actions/Change Status
9.         Change current status from ‘NEW’ to ‘Approved for General Use’
10.       Click OK.
11.       Select File/Close form.

Verifications:
1.         Header fields are populated.
2.         Products Fields are populated with data as expected
3.         Ingredients Fields are populated with data as expected
4.         The formula record is saved when Select File/Save.
5.         Status of formula is now ‘Approved for General Use’ when Change current status and click OK.
6.         Form closes and user is returned back to the Navigator when select File/Close form.

Script: CrtaRecpt - Create a Recipe with a routing and validity rule which is Approved for General Use.
Responsibility: Formulator
Choose Organization as PR1 if Organization selection window opens.
Tasks: Create a recipe and validity rule using the formula created previously.
Actions:
1. Navigatge: Recipes
Form: Recipe Details
2.         Enter:
Recipe: TSK-Recipe
Version: 1
Product: TSKFG
Formula: TSK-Formula
Version: 1
Routing: 100-PACK
Version: 100
3.         Select File/Save
4.         Select Actions/Change Status
5.         Change Status from ‘NEW’ to ‘Approved for General Use’
6.         Click Validity Rule.
Form: Recipe (WR-Recipe,1): Validity Rule Details
7.         Enter: Organization: PR1 Recipe Use: Production Product: TSKFG Preference: 1 Standard Quantity: 50
8.         Select File/Save.
9.         Select Actions/Change Status
10.       Change current status from ‘NEW’ to ‘Approved for General Use’
11.       Select File/Close form.
12.       Select File/Close Form.

Validations:
1.         Header fields are populated.
2.         Record is saved
3.         Status is changed on the Recipe header.
4.         Fields are populated with data as expected.
5.         Validity Rule is saved.
6.         Status of validity rule is now ‘Approved for General Use’
7.         Recipe Details form is closed when select File/Close Form.

Script: CrtProdcBatch - Create a Production Batch using earlier created recipe.
Responsibility: Production Supervisor
Choose Organization as PR1 if Organization selection window opens.
Tasks: Create a pending batch by earlier created recipe.
Actions:
1. Navigate: Create Document
Form: Create Batch/Firm Planned Order (PR1)
Recipe: TSK-Recipe
Version: 1
2.         Click OK.
3.         Select File/Close Form.

Validations:
1.         A pending batch is created and focus is on the Batches form when click OK. Note Batch number.
2.         User is returned back to the Navigator when select File/Close Form.

Script: ComandClseBtch - Release, Complete and Close earlier created Batch
Responsibility: Production Supervisor
Choose PR1 if Organization selection window opens.

Tasks: Release, Complete and Close the earlier created batch
Actions:
1.         Navigate: Batch Details
2.         Enter:
Document: Earlier Created Batch
3.         Click Find.
4.         Select Action/Release.
5.         Click OK.
If Material Exception form opens, click Proceed. Batch Status should have changed to ‘WIP’
6.         Click Transact Material on the Ingredient tab.
7.         Enter:
Transact: Checked
Transaction Type: WIP Issue
Sub inventory: PR0
Lot: Earlier created Lot
Quantity: 50
8.         Click Transact.
9.         Select Action/Complete
10.       Click OK.
11.       Enter:
Transact: Checked
Transaction type: WIP Completion
Sub inventory: PR0
Quantity: 50
12.       Click Lot/Serial.
Lot Number: Click Generate Lot to generate Lot.
Quantity: 50
Note the Lot number: _________________
13.       Click Done.
14.       Click Proceed.
15.       Select Action/Close.
16.       Close Batch window pop up.
17.       Click OK.
18.       Select File/Close Form.

Validations:
1.         Batch Details Form opens.
2.         Batch is retrieved and displays on the Batches form when click Find.
3.         Release Batch Form opens when select Action/Release.
4.         Batch Status should have changed to ‘WIP’
5.         Batch Detail Form/Ingredient tab opens when click OK.
6.         Material Transactions form opens when click Transact Material.
7.         Batch Details form opens when click Transact.
8.         Complete Batch form opens when select Action/Complete.
9.         Material Exception Window opens when click OK.
10.       Lot Entry (PR1) form opens when click Lot/Serial.
11.       Material Exception form opens when click Done.
12.       Batch Details form opens when click Proceed.
13.       Status of the batch becomes ‘Completed’.
14.       Close Batch window pop up when Select Action/Close.
15.       Batch Status Changed to ‘Closed’ when click OK.
16.       Batch Detail form closed when select File/Close Form.

Script: VewOnHandQanty - View On Hand Quantity
Responsibility: Inventory Super user Process Operations
Choose PR1 if Organization selection window opens.

Tasks: Verify the increase in On Hand Quantity for finished product.
Actions:
1.         Navigate: On hand, Availability/On-hand Quantity
2.         Enter:
Item: TSKFG
Lot : Earlier created lot (for WIP Completion transaction in section ComandClseBtch)
3.         Click Find.
4.         Click Availability.
5.         Verify that Total Quantity field is showing as 50.
6.         Select File/Close Form.
7.         Select File/Exit Oracle Application.

Validations:
1.         Query Material form opens when Navigate: On hand, Availability/On-hand Quantity.
2.         Upon OK, a Pending batch is created and focus is on the Batches form. Note Batch number.
3.         Material Workbench form opens when click Find.
4.         Availability form opens when click Availability.
5.         Total Quantity field is showing as 50.
6.         Availability form closes when select File/Close Form

7.         application closes when select File/Exit Oracle Application.

No comments:

Post a Comment

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.
Best Blogger TipsGet Flower Effect