Hierarchy Flattening Batch Fails with ORA-01722 After Applying OFSAAI 7.3.3 (Doc ID 1634880.1)

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 7.3.3.0.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)

Symptoms

After applying <Patch: 17379934> OFS Analytical Applications Infrastructure Interim Release 7.3.3.0.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.

ERROR

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

Changes

 Install OFSAAI 7.3.3 patch.

Cause

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