Sunday, April 19, 2009

RDBMS Variable

When Multi_org is enabled , a global variable exists in the oracle DataBase called CLIENT_INFO
it is 64 Bytes long variable. The first 10 bytes are used to store the operating unit ID or ORG_ID for the multiple organization Support.

The CLIENT_INFO contextis derived from aprofile option the user sets for each responsibility.

How it works

PO_HEADERS_ALL  in Apps Schema , This is a synonym to PO_HEADERS_ALL table

PO_HEADERS this is Multi-Org view based on CLIENT_INFO where CLIENT_INFO= ORG_ID

No comments: