Wednesday, October 15, 2014

Sales Order Booking, Picking and Shipping Made Easy – Using Oracle Forms Personalization

The purpose of this document is to to sophisticate the work of the end-user and to give him a pleasure of using Oracle Applications.
Training the End-Users is always a challenging task. They normally find a hard time to understand and remember the navigation. This is an idea regarding effective usage of User Interface messages to ease their work with Oracle Applications.
Solution Approach and Flow chart of the Process Flow
Using Forms Personalization in Oracle Applications.
  1. Have access to or have installed licensed version of Oracle Applications R12
  2. Having access to Forms personalization window.
The section lists the complete set of assumptions that need to be considered along with the other constituents of this solution.
  1. The is a instance of Oracle Applications version R12
  2. Single user is responsible for Entering/Booking/Picking and Shipping the order
  3. Sales Order consists of single line
  4. User only performing Entering,Booking,Picking and Shipping the order
The way it works after Forms Personalization
Screen: 1 (Header Information)
Screen: 2 (Line Information)
Screen: 3 (Zooming from Sales Order Form to Shipping Transaction Form)
User Interface Guidance Message
Screen: 4 (In this Shipping Transaction Form Source System and Sales Order Number will be automatically assigned)
Screen: 5 (User Interface Guidance Message
Screen: 6 (In Actions "Launch Pick Release" will be automatically assigned and the control will be at "Go" button)
Screen: 7 (User Interface Guidance Message)
Screen: 8 (After the completion of "Launch Pick Release" Concurrent coming back to SO form and Zoom t o Shipping Transaction Form)
Screen: 9 (The Control will automatically go to Delivery and Delivery Number will be automatically assigned)
Screen: 10 (User Interface Guidance Message)
Screen: 11 The Control will directly come to the Delivery Tab
Sales Order Form:
Condition: 1: When-New-Form-Instance
Action: 1
Creating Menu "Picking and Shipping Made Easy"
Action: 2
Declaring Global Variable for passing the Sales Order Number from SO form to Shipping Transaction Form
Condition: 2
When-Validate-Record (Line)
Action: 1
Assigning Value to Global Variable
Condition: 3
When-New-Block-Instance (Order)
Action: 1
Condition: 4
Zooming from SO form to Shipping Transaction Form
Action: 1
Launching Shipping Transaction Form
Shipping Transaction Form:
Condition: 1
Checking whether we have the passed the Global Variable from Sales Order form to Shipping Transaction Form correctly or not. Also we are checking "Order Number" field is blank or not.
Action: 1
Assigning the Source System = "Order Management"
Action: 2
Assigning the Global Variable to the Order Number field.
Action: 3
Committing the form
Condition: 2
Checking the Line Status. If it is "Ready to Release" then we should perform "Launch Pick Release"
Action: 1
Assigning the values for Actions from LOV.It should be "Launch Pick Release"
Action: 2
Placing the Control at the "GO" button
Action: 3
User Interface Message
Condition: 3
Action: 1
Checking for the existence of "Message" window.
(FYI: Forms Personalization will be executed first before the core code does)
Condition: 4
Checking the Line Status. If it is "Staged/Pick Confirmed" then we should do "Ship Confirm"
Action: 1
Automating the control to Delivery Tab
Action: 2
Automating the Control to the Delivery Tab
Action: 3
Assigning the Delivery Number to the Delivery Number field. (We got this Number from the Lines Tab)
Action: 4
Committing the form
Condition: 5
Checking whether the Delivery Status is "Open" or not.
Action: 1
User Interface Message after Shipping is done.
Action: 2
Assigning Null Value to Global Variable
Solution Salient Features
The following are the salient features
  1. User Friendly
  2. No invasive customization of any standard Oracle components.
  3. Simple approach with the tangible end deliverables clearly identified for each stage.
Concluding Notes
  1. The contents of this document the first cut of a solution approach and design for a prototype.
  2. The Same Methedology can be used for the Sales Order with Multiple Lines with some enhancements
  3. The Same Idea of using Guidance UI messages can be implemented to all the complex navigation in Oracle Applications

No comments:

Post a Comment

Best Blogger TipsGet Flower Effect