Siebel Developers: UX, Web Tools, Scripting, Integration (MOSC)

MOSC Banner

EBC Error on navigation: Error retrieving next record

edited Oct 30, 2019 12:14PM in Siebel Developers: UX, Web Tools, Scripting, Integration (MOSC) 4 commentsAnswered

Hello,

We are on IP15.18  and on Oracle 11g 32 bit. We are experiencing an error when trying to navigate to EBC views in Siebel Application.

Error:

(oracon.cpp (3902)) SBL-DBC-00104: Error retrieving next record from the database.

ORA-24347: Warning of a NULL column in an aggregate function

Things we have done:

* We got TNS entries and login credentials from the concerned database view (Oracle 12c - 64bit).

* Connected to the Database using the TNS entries and Exported the DDL

* Used the DDL (Schema Source) to create EBC in Siebel Tools wizard.

* EX tables got created successfully.

Questions:

a) Why does the created EX tables have Physical Type = 'Varchar' and Length =  255 by default, though the External schema have Number/Date data type in their Database View?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

SBL Configuration-EAI Tags

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center