ORA-00932 on Allocation with Expression Using Date Function and Numeric Field (Doc ID 1930042.1)

Last updated on DECEMBER 17, 2015

Applies to:

Oracle Financial Services Profitability Management - Version 6.1.0.3 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

On Oracle Financial Services Profitability Management (PFT) 6.1.0.3, when attempting to run an Allocation with Expression that using Date Field the following error occurs.

ERROR
ORA- 00932: inconsistent datatypes: expected DATE got NUMBER
ORA- 06550: line 1, column 537: PLS- 00103: Encountered the symbol "YYYY" when expecting one of the following: * & = - + ; <
/ > at in is mod remainder not rem <>
or !=
or ~= >=
and
or like like2 like4 likec between || multiset member submultiset

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

1. Create and expression through Financial Services Application > Master Maintenance > Expressions that has a return type of numeric and
    references a field with a data type of date (use the functions YEAR or MONTH on any date field).

    For example:  YEAR(account_open) - Year(account_closed)

2. Create an allocation that references the expression as the source.

3. The allocation fails and the error log shows the SQL with NVL(data field, 0) causing the error.

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