If you are new to Oracle APEX, well you are opening up a new world. Otherwise you know what APEX can do for you. With the latest version of 4.2 released at least I have lot of dreams with it.
I began developing in the age where Client-server applications were dominant. Oracle Forms provided features where it is easy to develop an application within days. With the advent of Web applications Oracle provided various frameworks including ADF, APEX among others. I do not know Java, so I left behind from ADF. APEX seems to be perfect fit for me because it is pure PL/SQL that I have to know. (Though Java script/jQuery skills will be hugely beneficial).
To add to this list for a year or so I have been developing website for our client with pure PL/SQL Web Toolkit. With this skill with me it was easy to delve deeper into APEX. With APEX 4.2 I have got more than what I have dreamed of, Mobile Applications.
I am sharing with all my readers an application which I have designed and developed using APEX 4.1 and now upgraded to APEX 4.2.
The application is called LeaveLite and its features are follows:
This application supports three modules and following functions
1. Administration
a. Employees List
b. Holidays List
c. Add Leave Balance
2. Manager Services
a. Approve/Reject Leave
b. My Team
c. Employee-wise Leave Taken
3. Employee Services
a. Apply for Leave
b. Cancel Leave
c. Leaves Report
d. Holidays List
Installation Instructions
To Install this software you must install Oracle APEX. Once that is installed make sure you upgrade your APEX version to 4.2. An alternate for you to try this is to use APEX cloud for trial purposes. Register/Log on to http://apex.oracle.com and use Application Import feature.
After APEX is upgraded to 4.2 you may now install this application using Application Import feature within APEX.
The install script comes with all tables script and necessary objects. Once installed browse the table LEAVE_MEMBER and make sure there are some members added to this table (administrator user) and then login using this user id and password.
I began developing in the age where Client-server applications were dominant. Oracle Forms provided features where it is easy to develop an application within days. With the advent of Web applications Oracle provided various frameworks including ADF, APEX among others. I do not know Java, so I left behind from ADF. APEX seems to be perfect fit for me because it is pure PL/SQL that I have to know. (Though Java script/jQuery skills will be hugely beneficial).
To add to this list for a year or so I have been developing website for our client with pure PL/SQL Web Toolkit. With this skill with me it was easy to delve deeper into APEX. With APEX 4.2 I have got more than what I have dreamed of, Mobile Applications.
I am sharing with all my readers an application which I have designed and developed using APEX 4.1 and now upgraded to APEX 4.2.
The application is called LeaveLite and its features are follows:
This application supports three modules and following functions
1. Administration
a. Employees List
b. Holidays List
c. Add Leave Balance
2. Manager Services
a. Approve/Reject Leave
b. My Team
c. Employee-wise Leave Taken
3. Employee Services
a. Apply for Leave
b. Cancel Leave
c. Leaves Report
d. Holidays List
- Download Readme
- Download Source cum Apex Installer (v1.1)
- Download Source cum APEX Installer (v1.0) (older version)
Installation Instructions
To Install this software you must install Oracle APEX. Once that is installed make sure you upgrade your APEX version to 4.2. An alternate for you to try this is to use APEX cloud for trial purposes. Register/Log on to http://apex.oracle.com and use Application Import feature.
After APEX is upgraded to 4.2 you may now install this application using Application Import feature within APEX.
The install script comes with all tables script and necessary objects. Once installed browse the table LEAVE_MEMBER and make sure there are some members added to this table (administrator user) and then login using this user id and password.
Can I use this on 4.1 version, if not can I get it 4.1 version
ReplyDeleteHi Anantha,
ReplyDeleteI have installed the application.
Can you please explain briefy how is it running and the steps?
Like the requirement in detail? Also how do i add user?
This comment has been removed by the author.
ReplyDeleteHey Anantha,
ReplyDeleteone more question, there is a leave_Dates table used but when i installed your project could not find any leave dates table. Please share script?
Hi Vineet. Am not maintaining this anymore. Couldnt find the code. Sorry about it. You will be able to create the table by looking at the report columns though, I guess.
DeleteThis comment has been removed by the author.
DeleteI have not used any system so far. However if you have expertise in oracle apex you can build one easily.
DeleteThis comment has been removed by the author.
ReplyDeleteThis comment has been removed by the author.
ReplyDeleteThis comment has been removed by the author.
Delete