How to Add Third Party Web Page Link to Oracle Application Web Page

Oracle e-Business Suite may require to integrate with third party/custom tool/software to augments the investment in Oracle e-Business Suite and to meet the business requirements.There are large number of third party tool/software available in the market that can be integrate with e-business Suite (for example Org-Plus).


Here we will discuss about how can we provide a hyper-link to oracle application web page through which we can navigate to third party web-page/or any custom created jsp page.

Basic Requirement
We need to provide a hyper-link to "My Employee Information" page so that we can directly access the third party web page via the hyper-link.
The third party sample URL is :-
https://cust-devenv.Client.local/OPE/Access.aspx?user=<Username> 

cid=<EmployeeNumber>&rid=<RoleName>&status=valid 

Here <Username>,<EmployeeNumber> => needs to be taken from the person who has logged in the system

             <RoleName> => Role Name will be based on the responsibility

                                 through which Third Party page will be accessed. 

                                For Manager Self  Service  Role Name is "XX_Manager".

To read the full document go to Shareapps4u

Problem With XML Parsing

XML stands for Extensible Markup Language.XML was designed to carry data not to display data.XML was designed to transport and store data, with focus on what data is.

An XML Parser is a parser that is designed to read XML and create a way for programs to use XML. There are different types, and each has its advantages.

The different types of parsers are:- a) SAX b) DOM c) PULL

To read the full document go to Shareapps4u

How To Customise Vacancy Search in iRecruitment- Adding Subsidiary Logo

Oracle iRecruitment enables us to set up a flexfield to capture additional vacancy (and candidate) information that can then be used by managers searching for a job/vacancy (or candidate and by candidates searching for a job).

Basic Requirement
The Basic requirement is explained below

The end user(recruiter/manager) should able to search a job based on the subsidiary company. Business will provide us the different subsidiary logo that should be available in the page and when clicks on that logo , the subsidiary field(available under vacancy search)  must be populated with the value. When recruiter/Manager clicks on go it should show only the vacancy for that subsidiary.

The requirement is explained below with a prototype.

To read the full document go to Shareapps4u

How to Change User Password

Users log in to Oracle Applications using a client web browser. From the Oracle Applications Login page, users access the E-Business Suite Home Page(AppsLocalLogin.jsp) which provides a single point of access to HTML-based applications, forms-based applications, and Business Intelligence applications.

Here we will discuss how can we change the user password with the help of oracle provided API.

Basic Requirement
Our basic requirement is to change the user password programatically and also force the user to change the password(which was changed through API) onfirst login.

To read the full document go to Shareapps4u 

How To Send Notification To Multiple Users

sOracle Workflow roles are stored in the database, in the Oracle Workflow directory service.The performer can be an item type attribute that dynamically returns a role.To send a single notification(FYI/Actionable) to multiple users we have to use Role attribute as performer of that notification.The attribute value must be the internal name of a role. 

Here we will discuss how can we send a single notification to multiple users.

Basic Requirement

Our old requirement looks like "when a person applies for a leave it should go his/her supervisor for approval.Approver must be able to provide his/her approval/rejection comments. The comments must be entered by the approver while rejecting the leave requisition.If he/she rejects the leave requisition without entering comments, then it should raise an application error.If he/she approves the requisition it should be optional.Approver must also be able to select theOrganization Leave Type from a list of values . If the leave gets rejected, don’t store any information in database.The approver should able to view/edit the person "Special Information Types" before approving the leave request.Before approving the sick leave request the approver must able to see the submitted medical document."

Now we will twist our original requirement- Instead of going to Supervisor for approval, all the leave request must go to the following identified people

• ROLE1_APPR (User name of the person)
• ROLE2_APPR (User name of the person)
• ROLE3_APPR (User name of the person)

To read the full document go to Shareapps4u 

How To Attach Document With Notification

Oracle Workflow also provide us a provision to attach document and help us to share information with the different stakeholders of business process (whereever is required) .

In a workflow process, we can attach documents generated by a PL/SQL procedure, which we call PL/SQL, PL/SQL CLOB, or PL/SQL BLOB documents.

Here we will discuss about the ways to attach PL/SQL BLOB and PL/SQL CLOB with the notification.

Basic Requirement

Our old requirement looks like "when a person applies for a leave it should go his/her supervisor for approval.Approver must be able to provide his/her approval/rejection comments. The comments must be entered by the approver while rejecting the leave requisition.If he/she rejects the leave requisition without entering comments, then it should raise an application error.If he/she approves the requisition it should be optional.Approver must also be able to select theOrganization Leave Type from a list of values . If the leave gets rejected, don’t store any information in database.The approver should able to view/edit the person "Special Information Types" before approving the leave request."

In addition to the above requirement:- When a Person applies for leave* he/she also submits the medical document. Approver should able to see the submitted medical document submitted by person.

* ==> Here we are considering only sick leave.

To read the full document go to Shareapps4u 

How to Restrict Agency from entering Duplicate Candidate

Agency personnel can Search for vacancies assigned to that agency, and view vacancy details such as the maximum number of applicants that can submit for a vacancy and current number of applicants.They can also create user accounts for candidate and apply for job on behalf of candidate.

Basic Requirement

Our basic requirement is as mentioned below:-

Oracle application doesn't restrict agency from entering duplicate candidate.Now our organization is landing up paying multiple times  for a single candidate,since there are multiple entry for a single candidate is found. Now our basic requirement is to restrict the agency from entering duplicate candidate.

The duplicate candidate can be identified by email address.

If agency personnel try to enter candidate with already existing email address then application should throw an error.

To read the full document go to Shareapps4u