"ORA-00918: column ambiguously defined" Error in Customized UI Screens.

(Doc ID 2364961.1)

Last updated on FEBRUARY 23, 2018

Applies to:

Identity Manager - Version 11.1.2.3.161018 and later
Information in this document applies to any platform.

Symptoms

This can happen in the Self Service console>> Manage>> Organizations.
- other screens as well.

When clicking an Org, it defaults to Membership tab and the failure occurs.

If use backdoor method of opening Top org>>Children tab>>and then the org and stay away from Membership tab, then users can get to Admin Roles.

ERROR

[wls_oim1] [WARNING] [ADF_FACES-60051] [oracle.adfinternal.view.faces.renderkit.rich.table.BaseColumnRenderer] [tid: [ACTIVE].ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] ... [APP: oracle.iam.console.identity.self-service.ear#V2.0] [DSID: 0000M6Bic8T81zl6wvuXMG1QSkyW00028L] Invalid width: -46 specified on column: pt1:_d_reg:region1:1:pc2:t1:resId1c3.

[wls_oim1] [ERROR] [] [oracle.iam.identity.orgmgmt.impl] [tid: [ACTIVE].ExecuteThread: '21' for queue: 'weblogic.kernel.Default (self-tuning)']... [APP: oim#11.1.2.0.0] [DSID: 0000M6Bic8T81zl6wvuXMG1QSkyW00028L] getOrganizationMembers:Exception isjava.lang.RuntimeException: java.sql.SQLSyntaxErrorException: ORA-00918: column ambiguously defined[[

]]
[wls_oim1] [ERROR] [] [oracle.iam] [tid: [ACTIVE].ExecuteThread: '21' for queue: 'weblogic.kernel.Default (self-tuning)'] ...[APP: oracle.iam.console.identity.self-service.ear#V2.0] [DSID: 0000M6Bic8T81zl6wvuXMG1QSkyW00028L] getOrganizationMembersRelations: oracle.iam.identity.exception.OrganizationManagerException: java.lang.RuntimeException: java.lang.RuntimeException: java.sql.SQLSyntaxErrorException: ORA-00918: column ambiguously defined[[

]]
[wls_oim1] [WARNING] [] [oracle.adf.controller.faces.lifecycle.Utils] [tid: [ACTIVE].ExecuteThread: '21' for queue: 'weblogic.kernel.Default (self-tuning)'] ...[APP: oracle.iam.console.identity.self-service.ear#V2.0] [DSID: 0000M6Bic8T81zl6wvuXMG1QSkyW00028L] ADF: Adding the following JSF error message: java.lang.RuntimeException: java.sql.SQLSyntaxErrorException: ORA-00918: column ambiguously defined[[
oracle.iam.ui.platform.exception.OIMRuntimeException: java.lang.RuntimeException: java.sql.SQLSyntaxErrorException: ORA-00918: column ambiguously defined

at oracle.iam.ui.platform.exception.OIMErrorHandler.reportServiceException(OIMErrorHandler.java:178)
at oracle.iam.ui.platform.exception.OIMErrorHandler.reportException(OIMErrorHandler.java:66)
at oracle.adf.model.binding.DCDataControl.reportException(DCDataControl.java:413)
at oracle.adf.model.binding.DCBindingContainer.reportException(DCBindingContainer.java:425)

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot click on organizations to add Admin Roles or any other tab activity.

Changes

Using Customized form. Might be new or imported.

Cause

	Sign In with your My Oracle Support account
	Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms