Data Model Upload Fails with There is a space in the Table name Errors

(Doc ID 2394631.1)

Last updated on MAY 03, 2018

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.5 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Profitability Management (PFT)
Oracle Financial Services Funds Transfer Pricing (FTP)
Oracle Financial Services Asset Liability Management (ALM)
Erwin Data Model Upload

Symptoms

On OFSAAI 8.0.5, the Datamodel upload is failing and custom dimension tables are not added to model. Ran a model upload to add dimension and staging tables to support seven custom dimensions. The model upload log shows the following errors:

ERROR
There is a space in the Table name .....Stg_business unit_B_Intf

The issue can be reproduced at will with the following steps:
1. Create custom dimension tables in the Erwin file
2. Run model upload

Changes

 

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