Enterprise_id is not meant to used for query purposes. It's meant for internal use.
We might help based on your exact query/report requirements.
Hope this helps
Thanks & Regards
It would come in handy when we are building reports that refer base tables and we wish to put in data security.
Or are you saying that this is automatically added onto queries in Fusion+BIP combination even if we are using base tables?
I think you can access the ENTERPRISE_ID with:
- SYS_CONTEXT('FND_VPD_CTX', 'ENTERPRISE_ID')
Assuming that the ApplCore session has been initialized or alternatively:
Note that since this is related to VPD implementation you cannot simply query across enterprises, rather restrictions are applied on the table level. Also do note that since its internal code it is subject to change without notice.
Fusion Applications Developer Relations
Many thanks Jani.
This was exactly what I was looking for.