Answer / askvenki

-all is multiorgtable which contains all orgnization
information
po_hedear is the view which contains information abt
particular organization of user is login
-- little tricy to understand how it works
how view get particular organization data
select * from po_headers where org_id=:client_info
client_info holds the org_id which user logged
if any dout askvenki@gmail.com i will respond

explain o2c cycle? what are the table reflected for this process?

1 Answers   BirlaSoft,

---

where we will put the control file ,where we will run sql star loader what is the cmd?

1 Answers   Cap Gemini, KPMG,

---

difference b/w procedures&functions

2 Answers   Oracle, TCS,

---

Which one Module is Biggest Module in oracle apps?

3 Answers   Questam,

---

1. when we r doing interface/conversion which things u will take care to improve the perfrmonce?(except bulk collect) 2. In conversion,u r loading the data using sql*loader,I dnt want to use sql*loader,& i have millions of records,Id der any way to load the data withing fraction of time considering best performance. 3. When u r doing conversion,taht using sql*loader u r loading data into staging table,u r writing control file bt I dnt want to use sql*loader,when u r creating con prog that time can we pass all values from flat file using paramere,valuset?how? 4. In flat file u got 50 records,out of 50 ,30 records are proceesed & inserted into base table,after taht clien understood that 1 item having wrong name e.g insted of ABC he given DCE, so can we delete?hw?(client permission is der) i have lot of wrong item name randomly spreaded,can we delete it?hw? 5.after doing validation hw u will follow approach to error out records?if i want to send all the error out records to client daily,whats ur approach? 6. In outbound interface is der any way to load the data(large data-millions of records) except UTL_FILE package? 7. what is parsing? 8. In technical doc.s which section will mention?except code? 9. Do u have any idea about code depository tool? 10.whats is performance tunning,DB link? 11, How u will do RMA?

2 Answers   Cap Gemini,

---

What are triggers?

3 Answers  

---

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

1 Answers   PWC,

---

How can u find custom top? where its located? How to find custom top in front end?

1 Answers  

---

what is the difference between procedure and function

4 Answers  

---

How will u register concurrent request ?

1 Answers   Convergys,

---

can we execute one concurrent program through another concurrent program?

1 Answers   KPIT,

---

In support project one ticket alloted which steps follows manualy tell me ?

0 Answers   BEL, Questam,

---