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:Business Intelligence Applications Consumer - Version 220.127.116.11.2 and later
Information in this document applies to any platform.
OBIA version: 18.104.22.168.2
EBS version: 12.1.3
ODI version: 22.214.171.124.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
No changes were done in initial source connection details, but for target system, server IP was replaced with hostname.
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