OBIA 11g: BIACM - No Model To Configure Source Connections In Oracle Data Integrator (Doc ID 2648123.1)

Last updated on JULY 17, 2021

Applies to:

Symptoms

OBIA version: 11.1.1.10.2

EBS version: 12.1.3

ODI version: 11.1.1.9.0

In the reported OBIA version, it was not possible to register/configure or view the Connection details for Source System in BIACM.
Initially it was possible to set the source connection details but after some changes were made in the details of target system it was not possible to view source system connection details. The change in target system was just from IP to hostname.

Further more, it was not possible to add a new Source system for Product Line Version EBS 12.1.3 as it was showing message that there is no model in ODI to configure for this Product Line Version,  although it was possible to add source system for other Product Line Version & even lower versions of EBS (like -EBS 12.1.2). 

The below errors were seen in biacm.log file -
==
[2xxx-xx-xxTxx:20:56.762+03:00] [bi_server1] [ERROR] [] [oracle.apps.bi.configmngr.view.ui.bean.systemsetups.ManageConnectionsBean] [tid: xx] [userId: xxxxxx] [ecid: xxxxxxxxxxxx:-xxxxxxxxxxxxxxx:-xxxx-xxxxxxxx,0] [APP: xxxxxx.xxxxx] Failed to save source due to : JBO-25013: Too many objects match the primary key oracle.jbo.Key[0 ].

[2xxx-xx-xxTxx:45:47.816+03:00] [bi_server1] [ERROR] [] [oracle.apps.bi.configmngr.view.ui.bean.systemsetups.ManageConnectionsBean] [tid: xx] [userId: xxxxxx] [ecid: xxxxxxxxxxxx:-xxxxxxxx:xxxxxxxxxx:-xxxx-xxxxxxxx,0] [APP: xxxxxx.xxxxx] Failed to save source due to : null
==

Changes

 No changes were done in initial source connection details, but for target system, server IP was replaced with hostname.

Cause

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