ORA-00936 When Using T2T_STG_INVESTMENTS_CAS to Load FCT_COMMON_ACCOUNT_SUMMARY
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)
On OFSAAI 7.2.11, when attempting to load data into FCT_ACCOUNT_SUMMARY from T2T_STG_INVESTMENTS_CAS the following error occurs:
ORA-00936: missing expression
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms