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



When you run he report you have to get only that particular organization po numbers or item number h..

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

When you run he report you have to get only that particular organization po numbers or item number h..

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

Post New Answer

More Oracle Apps Technical Interview Questions

What is multi org?

6 Answers   Accenture, CTS,


how can develope the po variance and po summary report? with tables mandatory columns and query please?

0 Answers  


How to create user and how u attach with responsibility.

2 Answers   Accenture,


What is SRW Package? (Sql Report Writer)

1 Answers  


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,






Tell me some errors names and number what u got while developing the reports?

1 Answers  


why r u transer the data base tables to flat file and what is use

2 Answers  


what is pick selection list generation report.

3 Answers  


Which one Module is Biggest Module in oracle apps?

3 Answers   Questam,


how will you refer a report column (data column,formula,summery,placeholderr)?

1 Answers  


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

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


How You Will display the key flexifields in your report

3 Answers   TCS,


Categories
  • Oracle Apps Technical Interview Questions Oracle Apps Technical (547)
  • Oracle Apps Financial Interview Questions Oracle Apps Financial (793)
  • Oracle Apps Manufacturing Interview Questions Oracle Apps Manufacturing (53)
  • Oracle Apps HRMS Interview Questions Oracle Apps HRMS (169)
  • Oracle Apps CRM Interview Questions Oracle Apps CRM (9)
  • Oracle Apps SCM Interview Questions Oracle Apps SCM (141)
  • Oracle Install Base Interview Questions Oracle Install Base (62)
  • Oracle Service Contracts Interview Questions Oracle Service Contracts (101)
  • Oracle Apps AllOther Interview Questions Oracle Apps AllOther (114)