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).

Explain oracle apps architecture.

0 Answers  

---

testing tools?

0 Answers   BirlaSoft, Convergys,

---

how to print multi lay outs,muti currency,muti language in xml publisher

2 Answers   Deloitte, Oracle,

---

what is difference between po_headers_all and po_headers

5 Answers   Deloitte, Wipro,

---

where the accounting related data is stored ? all type of accounting related data costing etc...

3 Answers  

---

I am insert in data to a table X .Which one is better while writing commit statement After each row inset or after all row insert to table.

3 Answers   IBM,

---

In SQL Loader i have 100 Records to be loaded into my table. How do i load the first 30 Records and skip the last 10 Records within a single .ctl file ? So my total no.of records to be loaded would be 60. Could anybody help me in this ?

2 Answers  

---

what is difference between d2k report and oracle apps report

10 Answers   Seven Hills, Wipro,

---

How to create a link between One dependent value set to another Dependent value set

5 Answers   Indorama, ManSoft System, Syntel, TE Data,

---

what is Flex mode and Confine mode?

2 Answers   Rapidigm,

---

In 11i we didn't have AP_Invoice_Lines Table, but in R12 this table is available, what is reason, advantage?

1 Answers   Accenture,

---

What is MO operating units. Why it need to to set this and where .

2 Answers   IBM,

---