ORA-00936: missing expression Errors Generating Hybrid Curve Rates in Database 12C (Doc ID 3058152.1)

Last updated on NOVEMBER 14, 2024

Applies to:

Symptoms

On FTP 8.0.7.8.0, the Hybrid Curve generation is getting triggered from the front end but no data is being populated in the FSI_IRC_RATE_HIST.

From the FSI_MESSAGE_LOG errors:

ERROR

ORA-00936: missing expression

This is database version 12c. The issue appears to be tables with characters > 38 digits:

  PROCEDURE OBJECTS_DROP IS
BEGIN
NULL;
SQL_STATEMENT := 'drop table FSI_IRC_HYB_MOV_BASE_IRC_SPREAD_DETAILS';
  EXECUTE IMMEDIATE SQL_STATEMENT;
  SQL_STATEMENT := 'drop table FSI_IRC_HYB_MOV_BASE_IRC_RATE_INTERPOLATED';
  EXECUTE IMMEDIATE SQL_STATEMENT;
SQL_STATEMENT := 'drop table FSI_IRC_HYB_MOV_EFF_DATES';
  EXECUTE IMMEDIATE SQL_STATEMENT;
SQL_STATEMENT := 'drop table FSI_IRC_HYB_MOVING_AVERAGE_START_DATE';
  EXECUTE IMMEDIATE SQL_STATEMENT;
  SQL_STATEMENT := 'drop table FSI_IRC_HYB_MOVING_AVERAGE_SELECTED';
  EXECUTE IMMEDIATE SQL_STATEMENT;
EXCEPTION WHEN OTHERS THEN
DBMS_OUTPUT.PUT_LINE('ERROR IN objects_drop' || SQLERRM || ' ' || SQLCODE);
NULL;

The issue can be reproduced at will with the following steps:
1. Funds Transfer Pricing -> Common Object Maintenance -> Rate Management -> Interest Rates
2. Select Hybrid Curve
3. Generate rates accordingly

Changes

 Upgrade to 8.0.7.8.

Cause

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