ORA-00936 When Using T2T_STG_INVESTMENTS_CAS to Load FCT_COMMON_ACCOUNT_SUMMARY (Doc ID 1530138.1)

Last updated on OCTOBER 04, 2016

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.2.11 and later
Oracle Financial Services Profitability Analytics - Version 5.6 and later
Oracle Financial Services Asset Liability Management Analytics - Version 5.6 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI) - Version 7.x
Oracle Financial Services Analytical Applications (OFSAA)
ALMBI
ALM BI
PFTBI
PFT BI

Symptoms

On OFSAAI 7.2.11, when attempting to load data into FCT_ACCOUNT_SUMMARY from T2T_STG_INVESTMENTS_CAS the following error occurs:

ERROR
ORA-00936: missing expression

STEPS
The issue can be reproduced at will with the following steps:

1. Installed ALMBI 5.6
2. Create a batch with the following defintion:
Load Mode: Table to Table
Source Name: STAGING_BE
File Name: T2T_STG_INVESTMENTS_CAS
Data File Name: NULL
Default Value: [DRCY ]='GBP'

3. Ran the batch and received the above error.

This issue is also reproduced when Default Value is NULL.

Cause

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