|
|
|
|
|
|
| Re: Difference between po_headers and po_headers_all [message #156720 is a reply to message #156710] |
Fri, 27 January 2006 05:30   |
adragnes
Messages: 241
Registered: February 2005
Location: Oslo, Norway
|
Senior Member |
|
|
The view PO_HEADERS only returns the rows in the table PO_HEADERS_ALL for the current organisation. When you log on directly into the database no current organisation has been set. This is why you do not get any rows when you query the view. For details on how the current organisation has been set please refer to Chapter 4 Technical Overview in the Multiple Organizations in Oracle Applications manual which can be downloaded from OTN.
If you want to use the PO_HEADERS view outside Oracle E-Business Suite forms, framework applications or concurrent programs you will need to initialise your applications session first. This is done using the FND_GLOBAL.APPS_INITIALIZE API.
Details on the API can be found in Chapter 30 FNDSQF Routine APIs in the Oracle Applications Developer's Guide .
Interestingly enough it seems that we will be seeing changes in the multi-org architecture in the future. According to a recent webcast by Steve Miranda on the Fusion Development Process it wil probably be replaced with a concept from PeopleSoft called SET_ID. As I understand it this will make it possible to create hierarchies of organisations and give responsibilities access to information for just a sub-tree of the total hierarchy. The changes will certainly be in place in Fusion Applications and perhaps also in E-Business Suite 12.
--
Aleksander Dragnes
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
