NullPointerException encountered when using Excel based data model with multiple Excel data sets in BI Publisher
Last updated on MARCH 08, 2017
Applies to:Oracle Fusion Application Toolkit - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
When creating a data model based on more than one Excel data set (either separate Excel files or separate worksheets within a single file), joining the two data sets results in no data being returned and an error being generated :
1. Create a new Data Model in BI Publisher
2. Create a new dataset using excel
3. Excel files have two tables defined (Main, Child)
4. Create 2 Data sets for the 2 tables in excel.
5. Run output XML
6. No results and an exception is generated.
Two types of errors were being reported :
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms