PLS-00103: Encountered the symbol "." when expecting one of the following Errors Running FSI_LEDGER_STAT_TRM (Doc ID 1932266.1)

Last updated on JULY 16, 2024

Applies to:

Symptoms

On Oracle Financial Services Asset Liability Management Analytics (ALMBI) 6.1, when attempting to run FSI_LEDGER_STAT_TRM, the batch fails and no record shows up in the FSI_Message_log. The following error is found in the RunProc_INFODOM04_T2T_FCT_LEDGER_STAT_20131231_1_Task1.log:

ERROR
Log Message here 1: Tue 09 Sep 2014 11:13:05 AM EDT||INFO||Parameters : fsi_ledger_stat_trm,'INFODOM04_T2T_FCT_LEDGER_STAT_20131231_1','20131231',1,12,2013,'','','Y','USD'.
Log Message here 1: Tue 09 Sep 2014 11:13:05 AM EDT||INFO||Statement to execute : BEGIN :D := fsi_ledger_stat_trm('INFODOM04_T2T_FCT_LEDGER_STAT_20131231_1','20131231',1,12,2013,'','','Y','USD'.); END;
Error Msg :-> ORA-06550: line 1, column 112:
PLS-00103: Encountered the symbol "." 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 symbol "." was ignored.

Unable to populate FCT_LEDGER_STAT from LEDGER_STAT.

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

1. Create a batch to run FSI_LEDGER_STAT_TRM
2. Use the parameters: 1,12,2013,'','','Y','USD'.
3. Run the batch

Cause

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