OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » Difference between po_headers and po_headers

Home » Applications » Oracle Fusion Apps & E-Business Suite » Difference between po_headers and po_headers_all

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Difference between po_headers and po_headers_all [message #156679]

Fri, 27 January 2006 00:40

anil_apps
Messages: 34
Registered: November 2005
Location: India

Member

Hi,

What is Difference between po_headers and po_headers_all and how to identify views n tables in oracle apps schema and what is different types of tables like _dfv,_kfv, _v,...etc

thanks in advance
Anil

Report message to a moderator

Re: Difference between po_headers and po_headers_all [message #156691 is a reply to message #156679]

Fri, 27 January 2006 01:49

adragnes
Messages: 241
Registered: February 2005
Location: Oslo, Norway

Senior Member

This has been discussed previously in this thread. "_dfv" and "_kfv" are compiled views with descriptive and key flexfields as defined.

--
Aleksander Dragnes.

[Updated on: Fri, 27 January 2006 01:49]

Report message to a moderator

Re: Difference between po_headers and po_headers_all [message #156710 is a reply to message #156691]

Fri, 27 January 2006 04:21

anil_apps
Messages: 34
Registered: November 2005
Location: India

Member

Thanks a lot for u valuable information,
but i need some information
why we need po_headers and Po_headers_all in both tables we get org_id information, is multi org means org_id?
which is base table and which is view when iam trying to select data from Po_headrs 0 rows are selecting...
can u explain or else give some ref. site or link
in metalink how to search...

thanks in advance
Anil

Report message to a moderator

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

Report message to a moderator

Re: Difference between po_headers and po_headers_all [message #156726 is a reply to message #156720]

Fri, 27 January 2006 06:05

anil_apps
Messages: 34
Registered: November 2005
Location: India

Member

THANKS LOT Aleksander Dragnes
i got morethen enough information ....
thanks again.

Report message to a moderator

Previous Topic:	need advice
Next Topic:	Payment went to 2006 (GL_Date) instead of 2005 GL_Date

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 30 00:13:26 CDT 2025