Validation Error on FEM_BALANCES table using FIELD type Mapping Rule on R12 RUP3 (Doc ID 580349.1)

Last updated on JUNE 06, 2017

Applies to:

Oracle Enterprise Performance Foundation - Version: 12.0.3
Information in this document applies to any platform.
Specific to Mapping rules that were created pre R12 RUP 3 that were upgraded to R12 RUP 3 or beyond.
Specific to FIELD type Mapping Rules.

Symptoms

When attempting to run Validation on a FIELD type Mapping Rules, the following error occurs.

Error:

"Balances must be assigned one of the following table classifications: Customer Account Profitability Tables, Transaction Profitability Tables"

and in the Troubleshooting column, you see:

"Either 1) change the table name in the mapping rule or 2) re-register the table with the specified table classification."

Steps:

1. Upgraded 11i instance to R12 RUP 3 including the mapping rules.
2. Update and validate Formula or Field mapping rules and received the error.

Changes

Upgraded from Release 11i to R12 RUP3

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