310 likes | 485 Views
What is ERP?. ERP attempts to integrate all departments and functions across a company onto a single computer system that can serve all those different departments' particular needs. That is a tall order, building a single software program that serves the needs of people in finance as well a
E N D
1. Final ProjectPeopleSoft Application Development Advisor: Prof. Khaled Elleithy
Submitted By: Madhan Maram
Student ID: 514512
2. What is ERP? ERP attempts to integrate all departments and functions across a company onto a single computer system that can serve all those different departments' particular needs.
That is a tall order, building a single software program that serves the needs of people in finance as well as it does the people in human resources and in the warehouse. Each of those departments typically has its own computer system optimized for the particular ways that the department does its work. But ERP combines them all 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.
3. Architecture Diagram
4. PeopleTools - Some areas of focus
PeopleSoft Internet Architecture
Application Designer
Application Engine
Component/component Interface
File/File Layout
PeopleCode
Security Manger
Integration Broker
Portals
Reporting
Data Archiving
5. Application Development PeopleSoft Applications are made up of a navigational structure, menus, components and pages. Using these elements new data or change, delete and modify the existing data in the application. PeopleSoft web browsing and working with database.
6. Application Designer: Every PeopleSoft Internet Architecture (PIA) application contains a collection of related objects that work together for a specific purpose.
Developing and customizing PeopleSoft applications is a step-by-step process where you define and build the objects, establish relationships among objects, implement security, run your
PeopleSoft application within an Internet Browser, and test every aspect thoroughly.
You use one interactive tool, Application Designer, for the majority of these activities. Application Designer is an integrated development environment that enables you to work with the numerous objects of a business application in a single work area.
The following section introduces you to Application Designer's development environment.
7. Application Engine: Called App Engine is mostly used for batch processing, for example we have to schedule a student’s registration list for the whole semester on a particular date, and we can schedule and automates the process.
Application Engine is the People Tool that you use to develop batch or online programs that are effective alternatives to COBOL or SQR programs (for non-report processing). Using Application Engine, you can create programs that perform high-volume, background processing against your data.
Application Engine is comprised of two distinct components: the "front-end" where you define your batch program and the"back-end," which entails running and monitoring our program .
8. Web Interface Navigation
Left-hand navigation .
Updated structure
Security Enhancements
Create Row Level Security for Various Profiles
Improved Home Pages
9. Peoplecode: Plays the major role in the application, considering the administration at UB. Not all users get the same access towards the application. This security is contained in the application sample.
The PeopleSoft Internet Architecture falls into the category of PeopleSoft online security, also known as runtime security. Only authorized users can connect to the web and application servers, and only authorized application servers can connect to a given database.
10. Security: Plays the major role in the application, considering the administration at UB. Not all users get the same access towards the application. This security is contained in the application sample.
The PeopleSoft Internet Architecture falls into the category of PeopleSoft online security, also known as runtime security. Only authorized users can connect to the web and application servers, and only authorized application servers can connect to a given database.
11. Web Interface Navigation
Left-hand navigation .
Updated structure
Security Enhancements
Create Row Level Security for Various Profiles
Improved Home Pages
12. A few technical aspects in developing How the tables are created.
How the pages are created, various tools used.
How the relations are developed.
How components are developed.
How permissions and roles are created for access to only specific personnel in a business.
How reports are generated.
How search Engines can be developed.
How batch processes are scheduled.
Security Administration.
13. Creation of Records Open Application DesignerFile New > Select type > Record
The Records are thus created very much similar to any Online Objects.
The fields, Application Engine Programs, and every other online objects skeletal build initiates through Application Designer.
The ability to create robust and powerful internet applications of PeopleSoft functions like web pages.
Support as many existing page controls and concepts as possible.
Ability for the application to operate in a menu system independently.
15. Few of the Records created for the Application Course Tables
Session tables
Instructor tables
Location tables
Route tables
Review tables
Suggestions tables
Enrollment tables
Tasks Tables
Task Review tables
16. Adding Controls to Pages Add controls to your page definition by the following:
dragging and dropping a field definition (or record field in your project workspace) into a page
using the Page Definition Toolbar
using the Insert menu.
17. Developing RelationshipsRelationships are built using levels LEVELS
Level 0 Course RecordsLevel 1 Session RecordLevel 2 Instructor Record
The Records have a parent child relation, PeopleSoft holds this relation having at least one additional primary key together with all in the child record.
This is explained with Multiple Sessions for a single course available for the semester. The level 2 record contains all the primary keys in Level 1 Record and an extra primary key.
18. Creating Components For all the WebPages, there will be a corresponding component create.
The hierarchy – All the online pages are built in application designer and are attached to a Component.
The Components are Attached to Menu.
The Menus are classifies as USE and SET UP
The Set up menu – Mostly are Configuration tables. A one time bulk data entry
The USE tables are Transaction Tables, These are Informative and Helps to Query out the Information from the Database.
The Components are Added to the MenuFile New – Menu – Insert Component
19. List of Pages Created Address Page
Bus and Bus Routes Pages
Course and Sub Pages
Curriculum and Tasks page
Enrollment Pages
Equipment Pages
Expenses Pages
Location Pages
Review and Search pages
Session and Student Pages
Suggestion and Suggestion Review Pages
Task Effort Pages
20. List of Batch Programs Application Engine Programs
To Load PeopleSoft tables from External Files
These files are scheduled through Process Scheduler
This loads Bulk data in to Application tables replicating the enterprise batch processing.
The programs to write the bulk data in to a Flat File.
The Programs using component Interface to load information, which helps to validate the information prior to loading.
24. File Layout A File Layout is a definition (or mapping) of a file to be processed. It identifies where in a file data fields are located. Once a File Layout has been created, you can write PeopleCode programs that use the file object, which in turn use the File Layout, to either read data from or write data to a file.
Types of File layouts.
Fixed Positional Each field has a starting position and a length which is their descriptive location.
Sequence Positional (CSV) Fields are separated and the order of appearance is their descriptive location.
Tagged (XML) Each field has predefined tags (or identifiers) surrounding it.
In the Application that I have developed File Layout is used with application engine program for importing data in to the system and to send data out of the system. Replicating the arching job process at the corporate level.
25. Sample Input File ADCC DATA COMMUNICATIONS 06/11/2003 11/13/2003 5M 9 15OA
AC1 CHECK 09/09/2003 10/09/2003 45D 9 5OA
C1 F4 0D 0 0 AL1 0 0
C1 G6 0D 0 0 AL1 0 0
C1 S2 10/06/200310/12/2003 4D 3 7NAL1 2 3
AIB INTEGRATION BROKER 10/16/200310/18/2003 2D 0 0 A
AD CC1 FINAL PROJECT 10/08/200210/17/2002 0D 2 6IA
AL1 TWO TIER 10/16/200310/30/2003 4D 4 7II
26. Sample Output File E(0N&l0O&l8D&l88F(s16.66H&a9L&k2G
REPORT GENERATION
DCC DATA COMMUNICATIONS 11-JUN-2003 13-NOV-2003
C1 CHECK 09-SEP-2003 24-FEB-2004
IB INTEGRATION BROKER 16-OCT-2003 18-OCT-2003
DCC1 FINAL PROJECT 08-OCT-2002 17-OCT-2002
L1 TWO TIER 16-OCT-2003 30-OCT-2003
The Special Characters at the top of the report defines the printer configuration.
27. Main Menu AND Base Table Menu
28. All the base records are loaded Instructor
Location
Student
Equipment
Bus, etc.,
29. Sample Online Pages
30. Interface Thanks for the interest you showed in presentation, also special thanks to Professor Khaled elleithy and all CS department for the support throughout my course curriculum
31. Thanks