My Oracle Support Banner

Organization-Enabled LOV: Column specified by Owner Organization Specifier must be accessible to the BC (using a join if necessary) (Doc ID 1477938.1)

Last updated on MAY 13, 2022

Applies to:

Siebel Sales - Version SIA[20433] and later
Information in this document applies to any platform.


A custom BC was created based on S_OPTY_XM. One of the fields in this BC uses an Organization-enabled picklist.

To enable Organization LOV's, the originating business component needs to supply an Organization Id. For this purpose, the table property "Owner Organization Specifier" can be used to specify a column on the BC's table, or a column joined in from another table, that supplies the Organization ID. In the customer's scenario, this property was set to:


[PAR_ROW_ID] is a foreign key column pointing to S_OPTY, so this Owner Organization Specifier value would advise the system to pick the Organization ID from S_OPTY.BU_ID.

However, this setup did not work. For new records, the Organization ID was successfully retrieved from the current user's position; however, for existing records, where the Organization ID should get picked from S_OPTY.BU_ID, the system was unable to retrieve the Organization Id.

As a result, the picklist query filtered for "BU_ID IS NULL" which was not the desired behavior.


The session log file revealed an error message related to the Owner Organization Specifier:

EventContext EvtCtxApplet 4 000000024ffd1628:0 2012-07-11 11:52:28 <custom MVG applet> (GetQuickPickInfo)
ObjMgrBusCompLog Warning 2 000000024ffd1628:0 2012-07-11 11:52:28 Field "OrgSpecializedLOV.Internal_OwnerOrgSpecifierBU_ID" is not activated in BusComp "<custom MVG BusComp name>".

which indicated an issue with resolving the reference in Owner Organization Specifier.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.