My Oracle Support Banner

TBML - Batch Execution Failed Because Of Invalid Schema Name (Doc ID 2734158.1)

Last updated on DECEMBER 07, 2020

Applies to:

Oracle Financial Services Behavior Detection Platform - Version 8.0 and later
Information in this document applies to any platform.

Goal

Customer is reported that, they have installed fresh TBAML 807 on OFSBD and ECM 807. Installation was successful and no errors were found in logs.

After this they have executed the TBAML scenario jobs, and after the alerts were created. After they executed the TBAML ECM batch the batch failed on the 2nd step.

In the logs we noticed that temp table creation failed. it is trying to use table from OFSAATBMLUBL table instead on OFSAAFCCMUBL which is the correct schema table.

2020/11/09 11:17:01:::sourceName::OFSAATBMLUBLdataMovementCode::TBAML_EVENT_LOOKUP::runskey::9412::filters::"$RUNSKEY"="9412"[]"$MISDATE"="to_date(^20151030^,^yyyyMMdd^)"
java.sql.SQLException: ORA-20104: Create Temp Table failed
ORA-06512: at "OFSAAFCCMUBL.PKG_FCC_DM", line 250
ORA-06512: at line 1


 

Solution

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
Goal
Solution


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