Answer / eldho

We can do it in 2 ways.
In rdf, we can define a summary column (say
CF_COUNT)which counts the number of rows of a group, and in
the rtf layout create a text form field and put the help
text as <?if:CF_COUNT=0?>No Data Found<?end if?>
Other way, no need of summary column, in the rtf layout
create a text form field and put the help text as
<?if:
count(./LIST_G_SO_NUMBER/G_SO_NUMBER/LIST_G_SO_NUMBER1/G_SO_NUMBER1)=0?>No
Data Found<?end if?>

where
./LIST_G_SO_NUMBER/G_SO_NUMBER/LIST_G_SO_NUMBER1/G_SO_NUMBER1
is the expected path to the group, from the root of the xml,
that we define. This expression will count the number of
occurances of the group "G_SO_NUMBER1"

Answer / mahesh govindu

if count(*)=o then
it will displays the no dtata found

please any one provide the oracle erp technical interview questions on modules(PO,AP,AR,INV,GL,OM)wise to my mail id..narendra_609@yahoo.co.in

0 Answers   Satyam,

---

How many types of projects are there in project module?

6 Answers   Fujitsu, Tech Mahindra,

---

Explain the multi-organization structure.

1 Answers   Accenture,

---

any one can expalin report registration steps?

6 Answers   Infosys,

---

where we find the status of order information.

2 Answers  

---

what is the difference between procedure and function

4 Answers  

---

Difference between Bind and Lexical parameters?

3 Answers  

---

HOW U DISPLAY THE FLEXFIELD DATA IN APPS?

2 Answers  

---

Hi Anil, When we importing the journals in GL module we need to insert the one row into GL_INTERFACE_CONTROL for each group_id.Now my question is what is the use of inserting the data into GL_INTERFACE_CONTROL table and if I not inserted into GL_INTERFACE_CONTROL what will happen

2 Answers   TCS,

---

How to create user and how u attach with responsibility.

2 Answers   Accenture,

---

Is that Possible To create package Overloading , If Yes Give any Examples

1 Answers   PWC,

---

what are the different types of triggers in reports

2 Answers   Oracle,

---