When you run he report you have to get only that particular organization po numbers or item number how can do it?
- 2 Answers
- 3520 Views
- IBM, I also Faced
- E-Mail Answers
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 |
what is the database size you used?
what is inbound and outbound interface?
in order to run utl_file package we need to give any specific path? if yes what is that?where u will run utl_package?
Can you explain the difference between architecture followed in 10g & 11g?
what are stock locators and how to define them? name the tables where the stock locator information is stored. at least two.
What is Place holder Columns?
Steps for DFF registration
What repots or concurrent program run to transfer data from Inventory to GL.
What is function?
INBOUND INTERFACE: Suppose I have 100 Records of employees in flat file.When moving the records from flat file to STAGING table using >CTl file, I want to restrict the records whose salary is less than 500.what are the validations(or conditions) you write to achieve this.
how many layout sections are tehre in layout editor?
While importing data into interface tables,if u got number of records are error(like more than 1000 records are error),how to imform user?
Oracle Apps Technical 
