Hierarchy Flattening Batch Fails with ORA-01722 After Applying OFSAAI 7.3.3
Last updated on OCTOBER 04, 2016
Applies to:Oracle Financial Services Asset Liability Management Analytics - Version 6.1 and later
Oracle Financial Services Analytical Applications Infrastructure - Version 22.214.171.124.0 and later
Oracle Financial Services Enterprise Financial Performance Analytics - Version 6.1 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
After applying <Patch: 17379934> OFS Analytical Applications Infrastructure Interim Release 126.96.36.199.0, running the hierarchy flattening batch results in failure with the error ORA-01722 (in fsi_message_log table). The rev_batchHierFlatten function and the underlying rev_hier_transformaton_biapps.batchHierarchyLoad seems to have been updated with OFSAAI 7.3.3.
ORA-01722: invalid number
Steps to reproduce
The issue can be reproduced at will with the following steps:
1. Apply OFSAAI 7.3.3.
2. Attempt to run Hierarchy Flattening batch
Install OFSAAI 7.3.3 patch.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms