My Oracle Support Banner

Accessing View Based on EBC Fails when using LDAP/ADSI with Error ORA-00942 (Doc ID 3081501.1)

Last updated on APRIL 13, 2025

Applies to:

Siebel CRM - Version 23.6 and later
Information in this document applies to any platform.

Symptoms

An new EBC Datasource created to point to external database.

Profile Configuration was successfully created and mapped the details to the Application UI Component under named Datasource parameter.

After restart it was not working so reconfig compdef and commit reconfig compdef commands were executed once again.

DB authenticated URL started invoking the profile properly but for other LDAP/ADSI Authenticated URLS still the changes are not working as expected.

The error below is seen in increased Object Manager Log:
 

ERROR
-----------------------

SELECT
  T2.GUEST_ID_NBR,
  T2.SHIP_DEPARTURE_DATE,
  T2.GUEST_LAST_NAME,
  T2.GUEST_LINE_1_ADDR,
  T2.GUEST_ID_NBR,
  T2.GROUP_AGREEMENT_ID,
  T2.GUEST_FIRST_NAME,
  T2.GUEST_BIRTH_DATE,
  T2.SHIP_CODE,
  T2.GUEST_PHONE_NBR,
  T1.CONSUMER_ID,
  T2.BOOKING_AGREEMENT_ID,
  :1
  FROM
  EDW_CORE.DIM_GUEST_XREF T1,
  EDW_CORE.DIM_GUEST_PROFILE T2
  WHERE
  T2.GUEST_ID_NBR = T1.GUEST_ID_NBR (+) AND
  (T2.CURRENT_FLAG = 'Y') AND
  (T2.BOOKING_AGREEMENT_ID = :2)
ObjMgrLog Error 1 0000004667f6a7f7:0 2025-04-09 01:46:20 (oracon.cpp (5069)) SBL-DBC-00105: An error has occurred executing a Sql statement.
 
Please continue or ask your systems administrator to check your application configuration if the problem persists.
SQLParseAndExecute Execute 5 0000004667f6a7f7:0 2025-04-09 01:46:20 ORA-00942: table or view does not exist


The issue can be reproduced at will with the following steps:

1- Have the EBC Datasource changed to point to external database.
Profile Configuration was successfully created and mapped the details to the Application UI Component under named Datasource parameter.
2- Restart
3- Execute reconfig compdef and commit reconfig compdef commands again
4- Test using DB authenticated OM, works
5- Same Repository but OM using LDAP/ADSI Authentication Fails

Changes

 New EBC created against same external Database used by a working EBC but using a different schema.

Cause

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
Symptoms
Changes
Cause
Solution
References


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