My Oracle Support Banner

T2F Execution Fails With 'ORA-00936: missing expression' When Runtime Parameters Used in OFSAA 8.1 (Doc ID 2807307.1)

Last updated on SEPTEMBER 16, 2021

Applies to:

Oracle Financial Services Funds Transfer Pricing - Version 8.1.0.0.0 and later
Oracle 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.