How to Use XML Bursting to Send XML Report via Email

Oracle Bursting Mechanism enables us to deliver a single XML Publisher report/letter to multiple destinations simultaneously.One can create a single report/letter , then send it in any format (e.g., PDF or HTML) to multiple destinations(email ids).
There are two kind of bursting mechanism available within BI publisher

1) Control File Base:- Integrated with EBS
2) Delivery SQL based:- Part of Enterprise release.All delivery, template, output format, locale and other details define through delivery SQL Query. Enterprise Edition assume that this information is stored in data base. The process create the XML file out if this query and the delivery xml file works as control file.

 

Here we will discuss about the "Control File Base" mechanism.

 

To read the full document go to Shareapps4u

How to Create Global User Defined Table(UDT)

User Defined Table(UDT) is a table defined by the user in application to hold the data .Oracle HRMS user-defined tables are different from the database tables of the Oracle Relational Database Management System.While defining the table we need to define all the rows and the columns. With the help of Oracle Fast formula, we can validate the entry made in the table column. 

Basic Requirement

Our basic requirement is to create a global UDT that will hold the employee data and can be accessible from across the business group.

To read the full document go to Shareapps4u

How to Retrieve XML Publisher Report output

Oracle XML Publisher is a template-based publishing solution delivered with the Oracle E-Business Suite.One can Design and control how the report outputs will be presented in separate template files,known as template.At runtime, XML Publisher merges designed template files with the report data to create a variety of outputs to meet a variety of business needs.

To read the full document go to Shareapps4u

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