Answer / mylapuram

you can create two more dummy parameters(like
p2_dummy,p3_dummmy ) and set display property to no.

now set the default value for p2_dummy as "decode
(p1,'a','Y',null) in the same way for p3_dummmy.

now in the valueset for p2 use where $FLEX$.p2_dummy ='Y'
and similarly for p3.

contact me if u have any doubt in this(on my mail).

35—how to create ldt lct files? 36—how to tranfor on file from one instance to another instance?

2 Answers   Accenture,

---

LOCKS?

1 Answers  

---

tell me the scenarios of between pages in reports

1 Answers   TCS, Wipro,

---

What is the Exception. Types of exception, Difference between those. And example

2 Answers   IBM,

---

What is the difference between base table and multi-org table?

3 Answers   Infosys,

---

What are the Import Programs We need to run after creating Interface table for all modules

1 Answers   Accenture,

---

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 the types of interfacing?

3 Answers   TCS,

---

Which oracle apps version you are very confident in?

0 Answers  

---

In unix Schell sript what is very 1st line to be wriiten .

2 Answers   IBM,

---

Can we create tables in apps schema?

0 Answers  

---

How can you achieve loose coupling in soa framework?

0 Answers  

---