My Oracle Support Banner

OFSAA Batch Run Unexpectedly Fails with ORA-00604 error (Doc ID 2835018.1)

Last updated on JANUARY 25, 2022

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.3.2 and later
Information in this document applies to any platform.


On OFSAAI 7.3.2

Issue description:

Batch execution fails as one of the OFSAA Rule Execution Tasks in LLFP Batch Run fails due to below error 


Error: ORA-00604: error occurred at recursive SQL level 1

ORA-00904: : invalid identifier

Steps to reproduce:

Try to execute OFSAA batch which includes Run executable task from Operations >> Batch Execution screen.

 Business impact:

Unable to execute batch successfully 


Hardware was upgraded from EXA to PCA.


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

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