questions
Posted: Tue Oct 24, 2006 4:15 am
1) Can we use commits in Database triggers and cursors? Is there any way to use commit in triggers?
2) Use of between pages trigger ? what can we achieve through between pages trigger ?
3) Can we write the user exits in other triggers other than before report triggers whether it will show errors or not ?
4) How do u test the reports ( testing ) ?
5) Join between AP and PO ?
6) Join between PO and Inventory ?
7) If u don?t know the Org Id,..how will u set the Org id ? Is there an environment to set the OrgId other than Backend ?
If we don?t define the P_conc_request_id , can I run the report, whether it will give eroor,if so, which error ?
9) Have u ever used the database triggers in Oracle Aplications ?
10) Whats the diference between Report and Pl/sql Parameters ?
11) [:$Flex$] if first parameter value is null, I want all values in 2nd parameter . how ?
12) What is the process_lead_time ?
13) How do u handle the errors in Interface process ?
14) Have u used API?s in interfaces ?
15) How will u run the concurrent program after 100 rows are inserted into base tables ?
16) How can u do performance tuning using TOAD ?
17) Whats the difference between pre ? formatted report and normal report ?
18) Different types of report ?
19) What happens if u specify srw.init userexit in before parameter form trigger ?will it give an error ? if so,..what error ?
20) Is value compulsory for value set field while defining parameters for a report ?
21) How to exclude certain menu entries for specific user ?
22) Explain the advantages of Folders ?
23) What is an alternative region ?
24) What is current record indicator ?
25) What is report security group?
26) When a query is parsed ?
27) How to access values from flexfields ? different tyes ?
28) Explain about top N Analysis ?
29) How to delete the executable ?
30) Does order of procedures matter in package ?
<font face="Arial"></font id="Arial"><font size="6"></font id="size6"><font color="black"></font id="black">
am in need of these answers,..if anyone can do me the needy it would be of great favour for me,....have a nice time,..Aneel.
2) Use of between pages trigger ? what can we achieve through between pages trigger ?
3) Can we write the user exits in other triggers other than before report triggers whether it will show errors or not ?
4) How do u test the reports ( testing ) ?
5) Join between AP and PO ?
6) Join between PO and Inventory ?
7) If u don?t know the Org Id,..how will u set the Org id ? Is there an environment to set the OrgId other than Backend ?
If we don?t define the P_conc_request_id , can I run the report, whether it will give eroor,if so, which error ?
9) Have u ever used the database triggers in Oracle Aplications ?
10) Whats the diference between Report and Pl/sql Parameters ?
11) [:$Flex$] if first parameter value is null, I want all values in 2nd parameter . how ?
12) What is the process_lead_time ?
13) How do u handle the errors in Interface process ?
14) Have u used API?s in interfaces ?
15) How will u run the concurrent program after 100 rows are inserted into base tables ?
16) How can u do performance tuning using TOAD ?
17) Whats the difference between pre ? formatted report and normal report ?
18) Different types of report ?
19) What happens if u specify srw.init userexit in before parameter form trigger ?will it give an error ? if so,..what error ?
20) Is value compulsory for value set field while defining parameters for a report ?
21) How to exclude certain menu entries for specific user ?
22) Explain the advantages of Folders ?
23) What is an alternative region ?
24) What is current record indicator ?
25) What is report security group?
26) When a query is parsed ?
27) How to access values from flexfields ? different tyes ?
28) Explain about top N Analysis ?
29) How to delete the executable ?
30) Does order of procedures matter in package ?
<font face="Arial"></font id="Arial"><font size="6"></font id="size6"><font color="black"></font id="black">
am in need of these answers,..if anyone can do me the needy it would be of great favour for me,....have a nice time,..Aneel.