OUASA 2.4.0.4 - C1-FTGL Extract Failed Load After SP4 Upgrade

(Doc ID 1583356.1)

Last updated on JUNE 12, 2014

Applies to:

Oracle Utilities Business Intelligence - Version 2.4.0.0.0 and later
Information in this document applies to any platform.

Goal

Here's the changes made to CCB and BI environments:
1) CC&B Upgraded to 2.4
2) OUASA 2.4 upgraded to SP4

After above upgrade, the FT GL fact load failed into BI. After further investigation, it seems Flat file format and BI external table are not compatible each other.
Populate attached extract file into external table and check data for DATA_SOURCE_IND, ARREARS_DT, UDM6 fields.
 

Solution

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