My Oracle Support Banner

Could Not Create Link Between EBS Dataset & SQL Query Data Model (Doc ID 2762628.1)

Last updated on MARCH 30, 2021

Applies to:

BI Publisher (formerly XML Publisher) - Version 12.1.3 and later
Information in this document applies to any platform.

Goal

User want to run a report that requires to merge the data from EBS and RPD (Subject Area) in the BIP Model. Used two different datasets for EBS and RPD. When link is set on Project Number from EBS to RPD, getting a error, "SQL or ORA exceptions caused due to the invalid SQL, database package state of some database exception".

 

Solution

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
Goal
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.