T2F Execution Fails With 'ORA-00936: missing expression' When Runtime Parameters Used in OFSAA 8.1
(Doc ID 2807307.1)
Last updated on MARCH 17, 2023
Applies to:
Oracle Financial Services Funds Transfer Pricing - Version 8.1.0.0.0 and laterOracle Financial Services Analytical Applications Infrastructure - Version 8.1.0.0.0 and later
Oracle Financial Services Profitability Management - Version 8.1.0.0.0 and later
Oracle Financial Services Asset Liability Management - Version 8.1.0.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Symptoms
When running a Data Mapping T2F (table to file) definition, the process fails as a result of the runtime parameter. The filter contains the following runtime parameter:
FSI_D_LOAN_CONTRACTS.DATA_SLICE_ID=[NUMPARTI]
The Batch Task Parameters contain the following value: [NUMPARTI]=1
The following error appears in the T2F batch log in /<ftpshare>/logs/<MIS Date>/<Infodom>/EXTRACT DATA/:
[22-04-21 10:32:47,707 GMT AM] [ERROR] [BACKEND] [NA] [NA] Exception Occured while executing query
java.lang.reflect.InvocationTargetException: null
.
.
.
Caused by: java.sql.SQLSyntaxErrorException: ORA-00936: missing expression
This runtime parameter works for a T2T so you expect it to work for a T2F also.
Cause
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
Symptoms |
Cause |
Solution |
References |