questions

[aneelkuumar]

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.

[anuprpandit]

1>Commit cannot be used in triggers. Autonomous transaction can be used. Cusros can be included with procedures having commits.
2>coluring,formatting of individual items,fields can be done by page triggers
3>after report->srw.user_exit(FND EXIT); , yes u can use,but mainly func is achieved in before report trigger as it executes before query fires and report executes
4>report builder pass diff parameters and test or in apps do the same thing in the application page
5>tough one through ap_invoices_all and po_distributions by use of distribution_id and then link back to po_headers from po_distributions_all
6>inventory_item_id in po_headers and mtl_system_items_b
7>fnd_client_info.set_org_context('org_id); ->this will set the org_id
select * from org_organization_definitions shold give you the org_id
8>for using srw.user_exit yu have to define it. run the report in application rather than report builder and the error should go away. this is normal func.
13>if standard conc opne interfaces are there then you have standard error tables and apis if used have the return parameters eg x_msg_data to give you error