Answer / vaidinindia@gmail.com

We can get the item or po number on basis of its Organization. So we can provide organization id in parameter. If you want to take default organization profile then you can use SELECT FND_PROFILE.VALUE('ORG_ID') FROM DUAL; in parameter value set definition. and what ever will be token value (P_ORG) you are going to define you need to same token while defining a parameter for report. Ex: (P_ORG)

Answer / dheeraj kain

Simply set organization context in belofore report trigger.
e.g mo_global.set_policy_context('S','FND_PROFILE.VALUE('ORG_ID'))
and then use po_headers view to fetch needed PO_NUMBER.

please any one provide the oracle erp technical interview questions on modules(PO,AP,AR,INV,GL,OM)wise to my mail id..narendra_609@yahoo.co.in

0 Answers   Satyam,

---

Can we run a package with out specification?If yes how?

4 Answers  

---

What is ment by Global Templates in Oracle.

1 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 are the functions you are used in utl_file at the time of transferring the data?

2 Answers   Oracle,

---

what could be the problem if invoice_id is same in ap_invoices_all and ap_invoices_interface. while the Ord_id , invoice_num, and other things is diffrent .

3 Answers   Infosys, Oracle,

---

what is Flex mode and Confine mode?

2 Answers   Rapidigm,

---

in which tables the transaction details stored? at least two.

5 Answers   Scan Steel,

---

what is the difference between varchar and varchar(2)?

4 Answers  

---

Give a brief overview on OrderManagement.

1 Answers   Zensar,

---

define steps of assigning items to an organization.

1 Answers   Scan Steel,

---

what is difference between procedure and function

5 Answers   E Logic,

---