When you run he report you have to get only that particular organization po numbers or item number how can do it?
Answers were Sorted based on User's Feedback
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)
| Is This Answer Correct ? | 1 Yes | 0 No |
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.
| Is This Answer Correct ? | 2 Yes | 1 No |
While running the concurrent program we will get the status, we have to change the status. How it will be done.
what is the difference between request group and request security in oracle apps?
P_CONC_REQUEST_ID mandatory in oracle reports to run in oracle applications or not ( I am not talking about running in report builder or D2k ) or not ?
9 Answers CSC, IBM, KPIT, Oracle,
explain registration steps of a concurrent program.
cursor 1 and cursor 2 are there did you open both the cursors at a time or not?
what r the objects u have to do in u experiance
what are version control tools used in oracle apps?
how to set org context?
in one report using two layout models.if yes how to do
What is multoorg and what is it's level or structure
what is the defference between credit memo and debit memo
which parameters passed in report in oracle developer how to pass