Answer Posted / hema

Exception is an error caused which leads to abnormal
termination of the program...
To handle these exceptions oracle provides 2 types of
exceptions.
1. oracle server exceptions
2. user-defined exceptions.

oracle server exceptions are the exceptions pre-defined by
the oracle server.
for example,
zero_divide with some error code. like -01400
array_out_of_bounds etc...

for all thse exceptions sqlcode is given(assigned by the
oracle sever)

there are pragma exceptions for which oracle has not given
the names.to assign the exception name with some oracle
defined code ...we go for pragma exceptions.

user-defined exceptions are those defined by the user.
for which the names as wel as code is given by the user.
there is some specified code range to assign to user-
defined exceptions.

Which oracle apps version you are very confident in?

1203

---

In oracle application how do you debug or trace errors?

1098

---

What are file in oracle.

2223

---

How is choreography different from orchestration?

1124

---

List the various types of value set.

1076

---

pls send me out bound code of supplers,site,bankiformation code pls as soon as

2253

---

Can you explain the difference between architecture followed in 10g & 11g?

1058

---

What are the Standard Reports and Forms in HRMS?

2300

---

how can i print random rows in plsql table

2483

---

What are do's and dont's of Interface?

2418

---

Do you know what is applysys in oracle application database schema, what is apps?

1174

---

Tell me how to debug the report?

1119

---

List of all the modules under Manufacturing, Finance and Distribution in oracle applications?

2206

---

what are the balancing segments in AR?

2089

---

Can u give the Documentation of Custom.pll in oracle apps

3465

---