How to create a XMLTYPE data type in Oracle

XMLTYPE in Oracle

XMLTYPE is a data type in oracle. Oracle has made this data type for storing the XML message, this data type is made up of CLOB which can store XML data.

Let us check how to use XMLTYPE.

1)   Creating table column using XMLTYPE

CREATE TABLE XMLTEST2

(ID NUMBER,

XMLDATA XMLTYPE,

NAME VARCHAR2(50)

);

How to Find Last Query in Forms and OAF |Oracle E-Business Suite

Find Last Query executed in form and OAF Page.

Let us check in Forms

The data presented in forms and Oaf page is through database query only, so if you want to find the database query which was executed to get the data then you need to follow the below steps.  

è Open the form and query the record.

è Then go to HELPà DiagnosticsàExamine.

Enable Diagnostics, Personalization and Profile Options in OAF and FORMS

Enable Diagnostics and Personalization.

How to enable Diagnostics and Personalization link in Form and OAF page.

First let us check for OAF pages.

As a normal user the “Personalization”, “About this Page” and “Diagnostics” links are disabled and these can be managed with the below profile options.

Script to reset User password in Oracle Applications

Script to reset user password in oracle applications

We can use the in build API to reset the user password from backend.

API: fnd_user_pkg.changepassword this API accepts two parameters one is USER NAME and other is New Password.

Below is the anonymous block to reset password.

SET SERVEROUTPUT ON;

How to create Lookups in Oracle E-Business Suite

Lookup in Oracle Apps

What is lookup in oracle apps?

Lookup is nothing but a set of codes and their meaning.

E.g. in HCM or HRMS we have users, a user can be active or Inactive.

For this purpose oracle has provided the standard lookup called “ACTIVE_INACTIVE”.

How to Create and Use Messages in Oracle Apps |Oracle E-Business Suite

Messages in Oracle Apps:

Oracle application uses a message dictionary to display the messages in Forms, Reports, PLSQL code, OAF, and ADF. 

Oracle has given a mechanism to define your own messages, it provides you the flexibility to define and store your messages in a message dictionary and you can display them as error/warning/notes.

How to Enable Trace and Read Trace Files in Oracle Apps |Oracle E-Business Suite

How to enable trace for concurrent program?

Trace is used to identify long running or time consuming query/queries due to which performance of concurrent program is decreasing.

By identifying the time taking queries we can tune those queries to increase the performance of concurrent program.