internship report covert
TRANSCRIPT
INTERNSHIP REPORT
INTERNSHIP REPORT
SUBMITTED TO: Mr. Quasim Imran
SUBMITTED BY:
NAME: MOHAMMAD IBRAHIM
PROGRAM: COMPUTER SCIENCE (3RD YEAR).
INTERNSHIP DURATION: 23ST JUNE 2015 TO 24 JULY 2015.
REPORT SUBMISSION: 24 JULYTH JUNE 2015.
UNIVERSITY: UNIVERSITY OF KARACHI
DEPARTMENT OF INTERNSHIP:
INFRASTRUCTURE, NETWORKING and DATABASE. Organization Development through Self Development Page 1
INTERNSHIP REPORT
DEDICATION
I would like to dedicate this report to my parents.
Without their patience, understanding, support and most of all
their love and prayers, the completion of this work would not
have been possible.
Organization Development through Self Development Page 2
INTERNSHIP REPORT
Table of Contents Acknowledgment .................................................................................................................................... 3 Introduction............................................................................................................................................. 4 Objectives Of internships ..................................................................................................................... 4 Pupose Of Internships In IT ............................................................................................................... 4
AtlusCulture………………………………………………………………………… …5
About Chairman ..................................................................................................................................... 6 Overview Of Atlas Group .................................................................................................................... 7 History OF Atlas Battery ................................................................................................................... 20
Hierarchy Of Post In Atlas Battery (IT depart.) ............................................................................. 9
SYSTEMS OSI Model.............................................................................................................................................10 Router ..................................................................................................................................................... 35 Switches .................................................................................................................................................. 36
Routing ...................................................................................................................................................14 What is Data centre .............................................................................................................................15 Atlas Battery Datacentre .....................................................................................................................15 Standards For Intallation Of a PC ....................................................................................................16 How to create a System image ..........................................................................................................17 SOP .........................................................................................................................................................18 Initiating a SOP ....................................................................................................................................18
INFORMATION SYSTEMS
What Is ERP .........................................................................................................................................19 Scope OF ERP .....................................................................................................................................21 Precure To Pay Cycle ........................................................................................................................ 22 How to Create a Purchase Order In EBS ..................................................................................... 24
Report Building In ORACLE (Scenario Based) ......................................................................... 28 Achievements During Internship. (task) ........................................................................................38
Internship Experience Summary .................................................................................................... 39 Recommendation ................................................................................................................................. 40
Comments OR reviews ...................................................................................................................... 40
References ............................................................................................................................................. 41
Organization Development through Self Development Page 3
INTERNSHIP REPORT
ACKNOWLEDGMENT
Internship is the integral and basic requirement of all the engineering programs. Because it is
the practical implementation of the theoretical knowledge which we have taught in our engineering
subjects to gain further knowledge and experience about professional activities. It equips us with the
necessary knowledge, skills and values of engineering field which are basic requirement of the
engineering professional and which also helps new graduates to perform professionally as they get first
step in their practical professional life.
The internship opportunity I had with Atlas Battery limited was a great chance for learning and
professional development. Therefore, I consider myself as a very lucky individual as I was provided with
an opportunity to be a part of it. I am also grateful for having a chance to meet so many wonderful people
and professionals who led me though this internship period.
Bearing in mind previous I am using this opportunity to express my deepest gratitude and special
thanks to the GM of Atlas Battery (Information Technology) Mr. Quasim Imran who in spite of being
extraordinarily busy with his duties, took time out to hear, guide and keep me on the correct path and
allowing me to carry out my project at their esteemed organization and extending during the training.
I express my deepest thanks to Mr. Asher, Manager in Information Systems and Mr. Imtaiz
Askari (Manager Systems) for taking part in useful decision & giving necessary advices and
guidance and arranged all facilities to make life easier. I choose this moment to acknowledge his/her
contribution gratefully.
It is my radiant sentiment to place on record my best regards, deepest sense of gratitude to Mr.
Asim (Assistant Manager), Mr. Ishtiaq (assistant Manager) Mr Ali Shahab, Mr. Sheikh Muhammad
Rafay (Network and Support Engineer) and Mr. Talha (Network and Support Engineer) for their
careful and precious guidance which were extremely valuable for my study and professional both
theoretically and practically.
I have perceived this opportunity as a big milestone in my career development. I will strive to use
gained skills and knowledge in the best possible way, and I will continue to work on their improvement, in
order to attain desired career objectives. Hope to continue cooperation with all of you in the future
sincerely,
MUHAMMAD IBRAHIM
Organization Development through Self Development Page 4
INTERNSHIP REPORT
INTRODUCTION:
An internship is a trained and supervised experience in a professional setting in which the student
is learning and gaining essential experience and expertise. Internship is meant for introducing candidates
either full-time or part-time to a real world experience related to their career goals and interests. It may,
but does not have to be related connected to one's academic major or minor. Internships can be done
during the academic semester and or summer depending upon the spaced out curriculum. There are
several varieties of internship: some are paid some are not and some offer credit towards graduation.
Internship is an excellent way to build those all important connections that are invaluable in developing
and maintaining a strong professional network for the future. Internships provide real world experience to
those looking to explore or gain the relevant knowledge and skill required to enter into a particular career
field.
OBJECTIVES OF INTERNSHIP
The main objective of the internship course is to facilitate reflection on experiences obtained in the
internship and to enhance understanding of academic material by application in the internship setting.
Internships will provide students the opportunity to test their interest in a particular career before
permanent commitment is made. Apart from it is more important because: I. Internship will help the trainees to develop skills and techniques directly applicable to their careers.
2. Internship will provide students the opportunity to develop attitudes conducive to effective interpersonal relationship.
3. Internship will provide students with an in-depth knowledge of the formal functional activities of a participating organization.
4. Internship programs will enhance advancement possibilities of graduates.
5. Internship students will develop employment records or reference that will enhance employment opportunities.
PURPOSE OF INTERNSHIP IN INFORMATION TECHNOLOGY:
1- The main purpose for doing internship in IT because I decided to set my career goals in IT. 2- To get the experience that how an organization manages its work loads. 3- To get the knowledge about the hierarchy in the organization.
Organization Development through Self Development Page 5
INTERNSHIP REPORT
ATLUS CULTURE:
The Atlas Culture (We look beyond horizons) built on
heritage and accomplishments, the ATLAS CULTURE promote:
Good Corporate Governance.
Respect, Recognition and Reward.
Value of time.
Recruitment and career advancement based on values,
experience, skills, merit and integrity.
Education and training of staff and family members.
Self reliance.
Leading by example.
Humility and striving for excellence.
Living within ones means, saving for the future
and donating for good cause.
To be happy and healthy Organization Development through Self Development Page 6
INTERNSHIP REPORT
ABOUT CHAIRMAN:
Mr. Yousuf H.Sherazi
Mr. Shirazi is a Law graduate (LLB) with BA (Hons) and JD (Diploma in Journalism) from
Punjab University and AMP Harvard. He served in the financial services of the Central Superior
Services of Pakistan for eight years. He is the author of five books including "Aid or Trade"
adjudged by the Writers Guild as the best book of the year and continues to be a columnist,
particularly on economy. Mr. Shirazi is the Chairman of Atlas Group, which, among others, has
joint ventures with Honda, GS Yuasa and MAN to name a few. He has been the President of
Karachi Chamber of Commerce and Industry for two terms. He has been the founder member of
Karachi Stock Exchange, Lahore Stock Exchange and International Chamber of Commerce and
Industry. He has been on the Board of Harvard Business School Alumni Association and is the
Founder President of Harvard Club of Pakistan and Harvard Business School Club of Pakistan. He
has been a visiting faculty member at National Defense University, Navy War College and
National School of Public Policy. He has been on the Board of Governors of LUMS, GIK and FC
College. Previously, he also served, among others, on the Board of Fauji Foundation Institute of
Management and Computer Sciences (FFIMCS) and Institute of Space Technology - Space &
Upper Atmosphere Research Commission (SUPARCO). Organization Development through Self Development Page 7
INTERNSHIP REPORT
OVERVIEW OF ATLAS GROUP OF COMPANIES:
COMPANIES YEARS
Sherazi investment 1962
Atlas Honda 1963
Atlas Battery 1966
Sherazi Trading 1973
Atlas Insurance 1980
Atlas Engineering 1981
Atlas Honda car 1992
Honda Atlas Power Product 1997
Atlas Assets Management 2002
Atlas Power 2007
Atlas World Wide 2007
Atlas Venture 2008
Atlas Autos 2011
Atlas Hitee 2012
Atlas Metals 2012
Table 1.1 Organization Development through Self Development Page 8
INTERNSHIP REPORT
HISTORY:
Atlas Battery Limited (ABL) was incorporated in 1966 through a Technical Collaboration with
Japan Storage Battery Company Limited (JSB), Japan and later entered a Joint Venture Agreement in 1987.
JSB and Yuasa Corporation, Japan merged in 2004. The merged entity GS Yuasa Corporation is a leading
global battery manufacturer. ABL manufactures a complete range of lead acid batteries for cars,
motorcycles, trucks, tractors, heavy vehicles, construction and road-building equipments, as well as host
of stationary batteries. In recent years, the shortage of electricity has spurred the demand of UPS systems.
ABL has developed batteries for UPS systems, which are customers’ first choice due to their quality,
reliability and durability. The Company has always been at the vanguard of development. The AGS brand
has earned a reputation as a quality product with latest Japanese technology, high level of performance
and reliability.
Specialties Type Automobile Batteries, Motorcycle Batteries, Battery Tonic Public Company
Industry Website Automotive http://www.atlasbattery.com.pk/
Headquarters Company Size D-181, Central Avenue, S.I.T.E., Karachi, 1001-5000 employees Sindh Pakistan
Founded
1966 Organization Development through Self Development Page 9
INTERNSHIP REPORT
HIERARCHY OF POST IN AN ORGANIZATION:
Table 1.2
Organization Development through Self Development Page 10
INTERNSHIP REPORT
Objective
How OSI model is implemented on Data Centre. In which departments of Atlas Battery CISCO switches are placed. Overview about router and switches and Networking process of Atlas Battery by Mr. Asim.
2. OSI MODEL LAYERS SEVEN LAYERS OF OSI MODEL:
Open Systems Interconnection Basic Reference Model (OSI Reference Model or OSI
Model) is an abstract description for layered communications and computer network protocol
design. It was developed as part of the Open Systems Interconnection (OSI) initiative. In its
most basic form, it divides network architecture into seven layers which, from top to bottom,
are the Application, Presentation, Session, Transport, Network, Data-Link, and Physical Layers.
It is therefore often referred to as the OSI Seven Layer Model.
Organization Development through Self Development Page 11
INTERNSHIP REPORT
LAYER 1 (PHYSICAL LAYER):
The physical layer has the following major functions:
It defines the electrical and physical specifications of the data connection. It defines the
relationship between a device and a physical transmission medium (e.g., a copper or fiber
optical cable). This includes the layout of pins, voltages, line impedance, cable
specifications, signal timing, hubs, repeaters, network adapters, host bus adapters (HBA
used in storage area networks) and more.
It defines the protocol to establish and terminate a connection between two directly connected nodes over a communications medium.
It may define the protocol for flow control.
It defines transmission mode i.e. simplex, half duplex, full duplex.
LAYER 2 (DATA LINK LAYER):
The data link layer provides node-to-node data transfer -- a reliable link between two directly connected nodes, by detecting and possibly correcting errors that may occur in the physical layer.
LAYER 3 (NETWORK LAYER):
The network layer provides the functional and procedural means of transferring variable length
data sequences (called datagram) from one node to another connected to the same network. It
translates logical network address into physical machine address. A network is a medium to which many
nodes can be connected, on which every node has an address and which permits nodes connected to it
to transfer messages to other nodes connected to it by merely providing the content of a message and
the address of the destination node and letting the network find the way to deliver ("route") the message
to the destination node. In addition to message routing, the network may (or may not) implement
message delivery by splitting the message into several fragments, delivering each fragment by a
separate route and reassembling the fragments, report delivery errors, etc.
LAYER 4 (TRANSFORT LAYER):
A transport layer provides end-to-end or host-to-host communication services for applications
within a layered architecture of network components and protocols. [1]
The transport layer provides Organization Development through Self Development Page 12
INTERNSHIP REPORT services such as oriented data support, reliability, flow control, and multiplexing. Transport layer
implementations are contained in both the model which is the foundation of the Internet, and the
Open Systems Interconnection(OSI) model of general networking, however, the definitions of details of
the transport layer are different in these models. In the Open Systems Interconnection model the
transport layer is most often referred to as Layer 4 or L4.
LAYER 5 (SESSION LAYER):
The session layer controls the dialogues (connections) between computers. It
establishes, manages and terminates the connections between the local and remote
application. It provides for full-duplex, half-duplex, or simplex operation, and establishes
check pointing, adjournment, termination, and restart procedures. The OSI model made this
layer responsible for graceful close of sessions, which is a property of the Transmission
Control Protocol, and also for session check pointing and recovery, which is not usually used in
the Internet Protocol Suite. The session layer is commonly implemented explicitly in application
environments that use remote procedure calls.
LAYER 6 (PRESENTATION LAYER):
The presentation layer establishes context between application-layer entities, in which the
application-layer entities may use different syntax and semantics if the presentation service
provides a big mapping between them. If a mapping is available, presentation service data units
are encapsulated into session protocol data units, and passed down the protocol stack.
LAYER 7 (APPLICATION LAYER):
The application layer is the OSI layer closest to the end user, which means both the OSI
application layer and the user interact directly with the software application. This layer interacts
with software applications that implement a communicating component. Such application
programs fall outside the scope of the OSI model. Application-layer functions typically include
identifying communication partners, determining resource availability, and synchronizing
communication. When identifying communication partners, the application layer determines the
identity and availability of communication partners for an application with data to transmit. When
determining resource availability, the application layer must decide whether sufficient network or
the requested communication exists. In synchronizing communication, all communication Organization Development through Self Development Page 13
INTERNSHIP REPORT
between applications requires cooperation that is managed by the application layer. Some examples of application-layer implementations include:
Web Browsers File transfer programs
Mail programs such as Outlook, Opera
3. ROUTERS AND SWITCHES ROUTER:
A router is a networking device that forwards data packets between computer networks. A
router is connected to two or more data lines from different networks (as opposed to a network
switch, which connects data lines from one single network). When a data packet comes in on one
of the lines, the router reads the address information in the packet to determine its ultimate
destination. Then, using information in its routing table or routing policy, it directs the packet to
the next network on its journey. This creates an overlay internetwork. Routers perform the "traffic
directing" functions on the Internet. A data packet is typically forwarded from one router to another
through the networks that constitute the internetwork until it reaches its destination node. Organization Development through Self Development Page 14
INTERNSHIP REPORT
SWITCH:
A network switch (also called switching hub, bridging hub, officially MAC bridge [1]
) is a
computer networking device that connects devices together on a computer network, by using packet
switching to receive, process and forward data to the destination device. Unlike less advanced
network hubs, a network switch forwards data only to one or multiple devices that need to receive it,
rather than broadcasting the same data out of each of its ports. [2]
A network switch is a multiport network bridge that uses hardware addresses to process and
forward data at the data link layer (layer 2) of the OSI model. Switches can also process data at the
network layer (layer 3) by additionally incorporating routing functionality that most commonly uses
IP addresses to perform packet forwarding; such switches are commonly known as layer-3 switches
or multilayer switches.
ROUTING:
Routing is the process of selecting best paths in a network. In the past, the term routing
was also used to mean forwarding network traffic among networks. However this latter function
is much better described as simply forwarding. Routing is performed for many kinds of
networks, including the telephone network (circuit switching), electronic data networks (such
as the Internet), and transportation networks. This article is concerned primarily with routing in
electronic data networks using packet switching technology. Organization Development through Self Development Page 15
INTERNSHIP REPORT
In packet switching networks, routing directs packet forwarding (the transit of logically
addressed network packets from their source toward their ultimate destination) through
intermediate nodes. Intermediate nodes are typically network hardware devices such as routers,
bridges, gateways, firewalls, or switches. General-purpose computers can also forward packets
and perform routing, though they are not specialized hardware and may suffer from limited
performance. The routing process usually directs forwarding on the basis of routing tables
which maintain a record of the routes to various network destinations. Thus, constructing
routing tables, which are held in the router's memory, is very important for efficient routing.
Most routing algorithms use only one network path at a time. Multipath routing techniques
enable the use of multiple alternative paths.
Organization Development through Self Development Page
INTERNSHIP REPORT
WHAT IS DATA CENTRE?
A data center is a centralized repository, either physical or virtual, for the storage, management,
and dissemination of data and information organized around a particular body of knowledge or
pertaining to a particular business.
PURPOSE OF DATACENTRE:
As more and more companies shift from individual servers to networked systems, they are
realizing that the original benefit of running their own server room is being outweighed by the advantages
of a datacenters. Many companies do not realize that you can save money and have greater resilience in
a data center.
ATLAS BATTERY DATA CENTRE:
Atlas Battery (Karachi) provides all the IT facilities and solutions to all over Pakistan (Atlas Battery).
This datacenter consist of:
2server racks.
1 communication rack. 1 CCTV and PABX rack. 1 UPS rack.
All the powers provided to the user’s system through UPS (Universal Power Supply).
WHAT ARE STP CABLES?
Often abbreviated STP, a type of copper telephone wiring in which each of the two copper wires
that are twisted together are coated with an insulating coating that functions as a ground for the wires.
The extra covering in shielded twisted pair wiring protects the transmission line from electromagnetic
interference leaking into or out of the cable. STP cabling often is used in Ethernet networks, especially
fast data rate Ethernets.
All the installation and implementation of networks in Atlas Battery is based on STP
(shielded Twisted Pair) cables. Organization Development through Self Development Page 17
INTERNSHIP REPORT
STANDARDS FOR THE INSTALLATION OF SYSTEM:
To maintain a new system in organization we must follow the standards set by that
department. In atlas Battery IT department sets some standards about the installation of a PC in
any area. The System must contain.
Windows 7 Internet Explorer
Team viewer IBM lotus note
Microsoft Office Window backup image
VNC Organization Development through Self Development Page 18
INTERNSHIP REPORT
WHAT IS SYSTEM IMAGE (BACKUP):
Applies to Windows 7
A system image is an exact copy of a drive. By default, a system image includes the drives
required for Windows to run. It also includes Windows and your system settings, programs, and
files. You can use a system image to restore the contents of your computer if your hard disk or
computer ever stops working. When you restore your computer from a system image, it's a
complete restoration—you can't choose individual items to restore, and all of your current
programs, system settings, and files are replaced with the contents of the system image.
You can create a system image, which contains a copy of Windows and copies of your
programs, system settings, and files. The system image is then stored in a separate location
from the original programs, settings, and files. You can use this image to restore the contents of
your computer if your hard disk or entire computer ever stops working.
If you're using Windows Backup to back up your files, you can have a system image
created each time your files are backed up. The files can be saved on a USB flash drive, CDs,
DVDs, or a hard drive. The system image must be saved on a hard drive. By default, the system
image only includes the drives required for Windows to run. Organization Development through Self Development Page 19
INTERNSHIP REPORT
Standard Operating Procedures
An SOP is a procedure specific to your operation that describes the activities necessary
to complete tasks in accordance with industry regulations, provincial laws or even just your own standards for running your business. Any document that is a “how to” falls into the category of procedures
Initiating a SOP
As implied above, the initiative and further procedure for the preparation, implementation and
management of the documents is a procedure in itself which should be described. These SOPs should at least mention:
who can or should make which type of SOP; to whom proposals for a SOP should be submitted, and who adjudges the draft; the procedure of approval; who decides on the date of implementation, and who should be informed; How revisions can be made or how a SOP can be withdrawn.
Preparation of SOPs
The make-up of the documents should meet a minimum number of requirements:
Each page should have a heading and/or footing mentioning:
Date of approval and/or version number; A unique title (abbreviated if desired); The number of the SOP (preferably with category); Page number and total number of pages of the SOP.
The heading (or only the logo) of originals should preferably be printed in another colour than
black. Organization Development through Self Development Page 20
INTERNSHIP REPORT
INFORMATION SYSTEMS
INSTRUCTOR: Mr. Ali Shahab
OBJECTIVES
How ERP (Enterprise Resource Planning) Works In An Organization. Scope of ERP and ORACLE in future. Which ERP Is Implemented On Atlas Battery?
What Is Procuring To Pay Cycle? What are the steps of purchasing an inventory using P2P cycle?
Atlas Battery Limited is based on the ERP of ORACLE database management system. During
the session of first database lecture Mr. Ali Shahab Told that this ERP is implemented by ORACLE.
Atlas Battery overall consist of 2 data centers situated at Admin Block and SIL (Sherazi Investment
Limited). He further describe that there is lot of scope of ERP in Pakistan or especially in Middle East.
The person must show his interest and efforts in his learning process than he/she get the
better opportunity in the future. We further discuss the career opportunities related to databases and
management fields.
Throughout it was the well experienced and knowledgeable day. Below is the
detailed description of the materials that are discussed on 13-july-2015.
Given that ERP is a $25 billion industry,
TOP 10 ERP vendors by total, 2007 revenues:
VENDORS REVENUE
SAP $10.5 billion
Oracle $4.6 billion
Lawson $747 million
Organization Development through Self Development Page 21
INTERNSHIP REPORT
Microsoft $855 million
Sage Group $1.4 billion
VIEWS OF Paul Hamerman (Forrester analyst) ON World’s Top 3 ERP Giants:
“Microsoft's market share is a modest 4 to 5 percent, “but I do see them growing pretty rapidly.”
In contrast, SAP’s strategy is “more around developing those capabilities rather than acquiring them.”
Oracle’s future growth strategy, I think, is going to be dependent on acquiring vendors that have particular strength in an industry,"
Posted November 15, 2007
By
James Maguire REFERENCE:
http://www.datamation.com/erp/article.php/3643966/The-Future-of-
ERP.htm http://www.erpschools.com/articles/procure-to-pay-cycle
http://www.erpschools.com/apps-process-flows/procure-to-pay-oracle-r12
Organization Development through Self Development Page 22
INTERNSHIP REPORT
ENTERPRISE RESOURCE PLANNING:
WHAT IS ERP?
Enterprise Resource Planning (ERP) is a planning philosophy enabled with software that attempts to integrate all the business processes of different departments and functions across a company onto a single computer system that can serve particular needs of the different departments.
Typically, before ERP implementation, each department has its own computer system
optimized for the requirement that a department needs. Each department will maintain separate databases and design applications as per their functionalities. These will result in local optima and overall very poor results across all the departments or within the company.
SCOPE OF ERP:
ERP combines all the business requirements of the company together into a single, integrated software program that runs off a single database so that the various departments can more easily share information and communicate with each other. Conceptually ERP replaces the old standalone computer system in finance, HR, manufacturing, etc., with a single software program that facilitates various functional modules.
Thus everybody from the finance, manufacturing, purchasing etc will get their own
advantages of software, along with the added feature of availability of information across other departments to improve decision quality. For example, someone in finance can use ERP to see if any sale order has been shipped from the warehouse so that he can now confidently plan for working capital management for the next period.
With the advent of Web-based ERP solution working environment started witnessing a
tremendous change. Web-based simplified back-office process automation for mid-sized and growing business. It provided real-time information about finance, order management, purchase, inventory, employee management, e-commerce and much more. With web-based ERP solution, you can accelerate business cycles, improve productivity and reliability, and provide higher levels of service to customers, suppliers and partners. Organization Development through Self Development Page 23
INTERNSHIP REPORT
PROCURE TO PAY CYCLE:
It can be divided into three categories 1-Purchasing 2- Inventory 3-payment
Procure to pay process which is also known as P2P cycle is followed by any organization in any
ERP system if they would like purchase any products (it could raw materials, office supplies,
infrastructure etc). Of course when there is a purchase there should be a payment. This entire
process of purchasing a product and making payment for that product to supplier is called procure to
pay process.
Create Requisition
Create Purchase Order
Create Inventory Receipt
Enter AP Invoice
Make Payment
Transfer to GL Organization Development through Self Development Page 24
INTERNSHIP REPORT
Create Requisition:
Requisition is nothing but a formal request to buy something (like Inventory material, office supplies etc) needed for the enterprise. Only an employee can create one. There are two types of requisitions:
Internal Requisition
Purchase requisition
Create Purchase Order:
A Standard PO is created for one–time purchase of various items
Create Receipt:
Create a receipt to receive the items in the Purchase Order.
Create Invoice in Payables:
Once the goods are received, it’s time to pay the vendor for the goods purchased and
hence the invoices are created.
Making a Payment:
Go to the Invoice window and query the invoice you want to pay. You would see Amount
paid as 0.00 before you make a payment.
Transfer to General Ledger:
A general ledger is a complete record of financial transactions over the life of a
company. The ledger holds account information that is needed to prepare financial statements, and includes accounts for assets, liabilities, owners' equity, revenues and expenses.
Organization Development through Self Development Page 25
INTERNSHIP REPORT
HOW TO CREATE PURCHASE ORDERS IN ORACLE APPS:
A Purchase order is a commercial document and first official order issued by the buyer to the
supplier, indicating types, quantities, and agreed prices for products or services the supplier will provide
to the buyer. Basically, there are four types of Purchase Orders,
Standard Used for One-time purchases for goods and Purchase services. Here you know the item, price, payment Order terms an delivery schedule Planned Created when you have long-term agreement with Purchase the supplier. You must specify the details of goods Order and services, payment terms and the tentative
delivery schedule Blanket Created when the details of items and services, Purchase payment terms are known but not specific about Agreement the delivery schedule Contract Created when the terms and conditions of a Purchase purchase are known but specific goods and Agreement services are not.
Navigation: Purchasing>> Auto Create
Organization Development through Self Development Page 26
INTERNSHIP REPORT
Auto Create Document
Select your Requisition Line by ticking the check box next to the Requisition Line Action: Create Document Type: Standard PO Grouping: Default
Click Automatic button and click create button in the New Document form. By clicking Automatic button, a standard PO is created based on the details provided in the Purchasing
requisition
.
Auto Create to PO Organization Development through Self Development Page 27
INTERNSHIP REPORT
Status represents the status of the document. Incomplete is the default status for all purchase
orders until they are submitted for the first time for approval. Click Shipments button.
Shipment number, Org, Ship-to, UOM, Quantity and Need-by-date are shown by default.
These fields can be edited as needed. You can split the lines and can change the ship-to
Organization, quantity of items to be shipped and delivery date.
[You can request the supplier to supply some of the quantities to be supplied by the need-by date
you provided and rest of the quantities (to the same ship-to address or a different address) to a different
need-by-date]
Distributions Organization Development through Self Development Page 28
INTERNSHIP REPORT
Click on More tab. The Requisition number from which this Purchase Order has been
created is shown by default.
Distributions
Click Terms to enter terms, conditions, and control information for purchase orders.
Approve Document
Click OK and check the status in the Purchase Order Organization Development through Self Development Page 29
INTERNSHIP REPORT
CREATE REPORTS IN ORACLE:
INSTRUCTOR: Mr. Ishtiaq
ORACLE database can be divided into two portions.
ORACLE
Functional technical
Apps DBA Apps Developer
DUTIES OF ORACLE APPS DEVELOPER:
Some duties of apps developer mentioned by MR. ishtiaq are as follow.
Forms customization
Reports Building
Data loading
Data integration
Interfaces
TASK:
On last day we work on a report building of purchase Order. Having Type STANDARD
and PO# 18141. We post it on TEST SERVER.
HELP> DIAGNOSE> EXAMINE
It shows all the field contain by the database (ORACLE).
PO# can be saved in segment1 cloumn (in ORACLE).
Organization Development through Self Development Page 30
INTERNSHIP REPORT
To generate a query we can commonly use 3 types of Query generating software.
PL/SQL developer.
SQL navigator
TOAD
SCENARIO:
Mr. Ishtiaq gives me the scenario to build a report and publish it into the server
having columns as follow.
ATLAS BATTERY LTD
PO Delivery Report
PO# Status PO date Vendor Item Description Quantity Rate Price
QUERRY USED TO GENERATE THE REPORT:
Select pha.segment1 from po_heades_all pha,
po_lines_all pla WHERE pha.segment= ‘18141’
AND pha.po_header_id=pla.po_header_id AND
pha.type_lookup_code+’standar’
FILE EXTENTION
To save the file it should be followed by the extention of .rdf or .rep
REGISTRATION OF REPORT:
Report registration can be done by System administrator OR apps developer. For this
process we use FILEZILLA. Organization Development through Self Development Page 31
INTERNSHIP REPORT
NAVIGATION:
As we create a report of PO, therefore its file can be publish in PO
folder. Prodapps > prod >apps >apps_st >app >PO >12i >reports >us
REPORT RUN:
View > Request > submit > OK.
Organization Development through Self Development Page 32
INTERNSHIP REPORT
CREATE REPORTS IN ORACLE:
In Oracle Reports, you have two options for building a paper report. The first one is to use
the wizards and editors in Reports Builder. The second one is to define the data model and/or
layout for your paper report in XML. Here we will discuss the steps to build a paper report using the Report Wizard.
Step 1: Invoking Reports Builder and the Report Wizard
When you invoke Reports Builder, the Welcome dialog box gives you the option of using the
Wizard to build a new report. The Report Wizard provides an easy step-by-step interface to create
a new report. The Report Wizard opens with a Welcome page. To suppress this page, clear the “Display at startup”
check box. You can reinstate this page in the same way as the Welcome dialog box in Reports
Builder; select the Wizard tab in the Preferences dialog box and then select Report Wizard Welcome
Page.
Each page of the Report Wizard asks you for information to help you create your initial
report. Step through the wizard pages, selecting next and back, until you are satisfied with the initial
information that you have entered. On the last page, select Finish.
Welcome to Reports Builder Organization Development through Self Development Page 33
INTERNSHIP REPORT
Report Wizard
Step 2: Choosing the Layout Type
Here you have to specify the type of layout you want the Wizard to generate. The available
options are: Web and Paper Layout
Web Layout only
Paper Layout only
Report Layout Type Organization Development through Self Development Page 34
INTERNSHIP REPORT
Step 3: Choosing a Report Style
This page of the Report Wizard shows the various styles of reports. Select Tabular and
then click next.
Report Style
Step 4: Selecting the Data Source Type
Next, you have to define the data source type for your report. Through the implementation of
the Pluggable Data Source (PDS) feature in Oracle Reports, the data for your report can come
from any source you choose. Reports Builder provides interface definitions that act as a translator
between Reports Builder and a PDS by redefining Reports Builder’s requests in terms your data
source uses.
Data Source Type Organization Development through Self Development Page 35
INTERNSHIP REPORT
Step 5: Building a Query using Query Builder
Building your query with the Query Builder GUI saves you time and increase the ease of
use for developers not familiar with building SQL statements or with the application tables. To build a query using Query Builder: 1. Select Query Builder from the Query page in the Report Wizard. 2. Enter your username, password, and alias in the Connect dialog box that appears if you have
not already connected to the database. 3. Select the data tables to build the query. 4. Click Include. The tables appear in the selection area. 5. Click Close to close the Select Data Tables window. 6. In each table, double-click the column names that you want in the query, or use the check boxes.
To select all columns, double-click the Table title bar. 7. Click OK.
Query Builder copies the query syntax into the Report Wizard. You can modify the query by reentering Query Builder or by modifying the SQL query statement text.
Note: If you prefer to write your own SQL statement, enter the syntax directly in the SQL query
statement area of the Query page. Alternatively, you can import the contents of a file by
clicking Import SQL Query.
Query Builder
Organization Development through Self Development Page 36
INTERNSHIP REPORT
Step 6: Selecting Displayed Fields
In the Field page, select each field from the Available Fields list and click >. The selected fields
move to the Displayed Fields list. To display all fields, click >>. You can alter the sequence of displayed fields by dragging one field above or below another in the
list. The sequence of fields in this list determines how the fields appear in the report output. In a
tabular report, the fields appear in sequence from left to right across the page. Fields that remain in the Available Fields list are available for you to reference in your report definition as hidden fields or in PL/SQL trigger code. In the report output, the user sees only those fields that you transfer to the Displayed Fields list.
Displayed Fields
Step 7: Totals and Labels
In the next two pages of the Report Wizard, you can create totals based on any of the
displayed fields and modify the labels and width of the displayed fields.
Totals: Standard SQL aggregate functions are provided for creating totals in your report. Organization Development through Self Development Page 37
INTERNSHIP REPORT
Total Fields
If the initial label is wider than the field, Reports Builder allows enough space for the label, or
displays it on multiple lines.
If you increase the number of characters in the label text in the reentrant Wizard, the label can appear truncated in the report output.
Labels
Step 8: Selecting a Report Template
Report Templates enforce corporate standards as well as create professional-looking
paper reports easily.
Select a template from the list of predefined template names. In a template, the fonts, styles,
and colors are already selected for designated objects. A variety of templates are available with the
standard Reports installation. Organization Development through Self Development Page 38
INTERNSHIP REPORT
To select a predefined template:
1. Select the Predefined Template option button, if it is not already selected. 2. Select a template from the Template list. 3. Click Finish
Report Template
Step 9: Viewing the Paper Report Output
When you finish creating your report in the Report Wizard, the output appears in the
Paper Design view of the Report Editor.
Report Output
Organization Development through Self Development Page 39
INTERNSHIP REPORT
Step 10: Saving the Report Definition
Remember to save the report frequently by selecting Save in the toolbar, or by using the File > Save menu option. The recommended format for storing paper reports is with an .rdf extension. If you want to make a copy of the report definition in a different filename, use the menu option File > Save As. There is no toolbar button for the Save As option.
ACHIEVEMENTS:
Visit conference hall (installation of VNC, multimedia and network cables. Prepare 3 PCs according to the standards with complete installation. Check out all the inventories available at SIL and make inventory chart of it. Install a new Scanner in to Quality Department located at SIL. Resolve 2 complains of Store room 1 and 2. Understanding the process that how to purchase inventory from vendor
Resolve three complains and maintenance issue in Admin dept and
maintenance dept. Check out all the inventories available at SIL and make inventory chart of it. Visit to SIL, Store house, Assembly hall and maintenance departments. Standards to install the system. How to create backup image of a PC. Create PO on EBS. Create Reports on PO.
Organization Development through Self Development Page 40
INTERNSHIP REPORT
INTERNSHIP EXPERIENCE SUMMARY
The past month of my internship has been very instructive for me. Atlas Battery (Pvt)
Limited has offered me opportunities to learn and develop myself in networking area,
infrastructure and databases. I gained a lot of experience, especially in infrastructure
department. A lot of the tasks and activities that I have worked on during my internship
are familiar with what I’m studying at the moment .I worked in Networking area and
databases where I did different work This gave me the chance to explore and also to select
IT field as my job option to work in after my education.
Before my internship started my ideas did not match the experiences have gained during my
internship. There is a big difference in the University projects and the tasks and activities
during the actual work. In University we learn how to describe the work in projects, where in
work you learn how to implement them in reality. This internship was definitely an
introduction to the actual work field for me. I have learned to work in a Networking
organization and apply my knowledge into practice.
My mentor during my internship was Mr. Asim , Mr. Rafay and Mr. Talha who I have also
learned a lot from during my internship. As an Assitant Manager of Atlas Battery (IT), Mr.
Asim has lots knowledge in Networking field and infrastructure, Troubleshooting and
Network Design
He was very helpful and always willing to give me advice and feedback which I appreciate .I
have tried to learn as much as possible from him. I also get a good feedback from my
mentor Mr. Asher (assistant Manager MIS), Mr. Ishtiaque and Mr. Ali Shahab in the field of
database and ERP.
Organization Development through Self Development Page 41
INTERNSHIP REPORT
RECOMMENDATION:
Atlas Battery (Pvt) Limited is a great learning company for interns. Atlas Battery (Pvt)
Limited is a Big organization and helps interns improve and develops their skills. I would
recommend Atlas Battery (Pvt) limited to keep hiring interns with different educational
background, to help build and improve the company with the knowledge they gained
from their studies.