ORA-00936: Missing Expression Error Running T2T Load Using Seeded OFSAA Database Extract (Doc ID 1477008.1)

Last updated on APRIL 21, 2017

Applies to:

Oracle Financial Services Asset Liability Management Analytics - Version 5.2 and later
Oracle Financial Services Analytical Applications Infrastructure - Version 7.2 and later
Oracle Financial Services Enterprise Financial Performance Analytics - Version 5.2 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

In Oracle Financial Services Analytical Applications (OFSAA) Infrastructure, when running a Table to Table (T2T) load using one of the Database Extracts provided with a Financial Services Application, the T2T task fails and an error message like the following exists in the T2T log located at $FIC_DB_HOME/log/t2t:

2012-07-16 | 14:04:06 | t2tserver | DEBUG |  |  | ClsUTableToTableLoad::Load, Query for fetching the number of rows when Load mode is Direct or Batch : select case  when count(1) = 1 then sum(inline_view.rec_count) else count(1) end from ( SELECT COUNT(1) rec_count  FROM FSI_D_ANNUITY_CONTRACTS INNER JOIN DIM_COMMON_COA ON DIM_COMMON_COA.N_COMMON_COA_ID = FSI_D_ANNUITY_CONTRACTS.COMMON_COA_ID INNER JOIN DIM_CURRENCY ON DIM_CURRENCY.V_ISO_CURRENCY_CD = FSI_D_ANNUITY_CONTRACTS.ISO_CURRENCY_CD INNER JOIN DIM_GL_ACCOUNT ON DIM_GL_ACCOUNT.N_GL_ACCOUNT_ID = FSI_D_ANNUITY_CONTRACTS.GL_ACCOUNT_ID INNER JOIN DIM_ORG_UNIT ON DIM_ORG_UNIT.N_ORG_UNIT_ID = FSI_D_ANNUITY_CONTRACTS.ORG_UNIT_ID INNER JOIN DIM_PRODUCT ON DIM_PRODUCT.N_PRODUCT_ID = FSI_D_ANNUITY_CONTRACTS.PRODUCT_ID LEFT OUTER JOIN FSI_EXCHANGE_RATE_HIST ON FSI_EXCHANGE_RATE_HIST.FROM_CURRENCY_CD = FSI_D_ANNUITY_CONTRACTS.ISO_CURRENCY_CD AND FSI_EXCHANGE_RATE_HIST.EFFECTIVE_DATE = FSI_D_ANNUITY_CONTRACTS.AS_OF_DATE AND FSI_EXCHANGE_RATE_HIST.TO_CURRENCY_CD = [DRCY] WHERE 1=1 AND FSI_D_ANNUITY_CONTRACTS.AS_OF_DATE=to_date('20120716','YYYYMMDD') AND DIM_COMMON_COA.F_LATEST_RECORD_INDICATOR='Y' AND DIM_GL_ACCOUNT.F_LATEST_RECORD_INDICATOR='Y' AND DIM_ORG_UNIT.F_LATEST_RECORD_INDICATOR='Y' AND DIM_PRODUCT.F_LATEST_RECORD_INDICATOR='Y' ) inline_view
2012-07-16 | 14:04:06 | t2tserver | SEVERE |  |  | ClsUDBConnect::executeCountQuery, Error, unable to execute count(*) query. ERROR Message: ORA-00936: missing expression

2012-07-16 | 14:04:06 | t2tserver | SEVERE |  |  | ClsUTableToTableLoad::directLoad, unable to fetch the count of rows for loading
2012-07-16 | 14:04:06 | t2tserver | SEVERE |  |  | ClsUTableToTableLoad::ExtractLoad, Error, unable to perform direct table to table load

The error prevents the T2T process from transferring data from the source table into the target table.

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