How to write the no data found in XML Publiser Report in apps?
Answers were Sorted based on User's Feedback
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"
| Is This Answer Correct ? | 10 Yes | 4 No |
Answer / mahesh govindu
if count(*)=o then
it will displays the no dtata found
| Is This Answer Correct ? | 7 Yes | 7 No |
in interface and conversion if 10 records are error out we can't load the records?if >10 we have to insert,if we not insert we need to gernerate error how u can achieve?
Oracle E-Business suite?
in which tables the transaction details stored? at least two.
A program must be written which accepts date parameter. The date parameter will accept data in the format DD/MM/YYYY. This data has to be validated and post validation, the following details have to be displayed for this date parameter 1. Input date must be defaulted to sysdate, It can be overridden by any other date. 2. Financial year should be displayed for this date parameter. Eg: If the input date is 30/11/2010, the financial year must be displayed as 1. From Date : 01-Aprr-2010 To Date: 31-Mar-2011 3. Calendar year and Calendar month must also be displayed. 4. The next payment cycle (say for EB), must be displayed based on this date parameter. 5. The previous payment must also be displayed based on this date.
Can functions be overloaded ?
Which oracle applications pl/sql standard apis you are familiar, have you used most of them?
What is cursor?
what are stock locators and how to define them? name the tables where the stock locator information is stored. at least two.
What are different execution methods of executabls?
can we execute one concurrent program through another concurrent program?
What are profile options?
what is difference between po_headers_all and po_headers