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.

Symptoms

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:

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 

Changes

Hardware was upgraded from EXA to PCA.

Cause

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
Symptoms
Changes
Cause
Solution


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