ORA-00904: "SOURCE"."ORG_UNIT_ID" Invalid Identifier on Static Table Driver Allocation (Doc ID 1963638.1)

Last updated on JANUARY 22, 2015

Applies to:

Oracle Financial Services Profitability Management - Version 6.1.0.3 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications

Symptoms

On : 6.1.0.3 version

When attempting to run a test Allocation ID using Static Table Driver the following error occurs in ofspa debug log.


Error:

INSERT INTO FSI_MESSAGE_LOG (PROCESS_ID, SEQUENCES,
    MSG_TIMESTAMP, MESSAGE_CD, MSG_SEVERITY_CD, BATCH_RUN_ID,
    CONTEXT_SPECIFIC_TEXT) VALUES( 206131.000000, 8, TO_DATE(''12/
    19/ 2014 01:11:06'', ''MM/ DD/ YYYY HH24:MI:SS''), 20006, 40,
    ''PFTUAT_Task1_206131_EXEC_20140927_1'',
    ''Oracle Error: ORA- 00904: "SOURCE"."ORG_UNIT_ID": invalid identifier'') ')

Changes

 Migrated allocation from 4.5 to 6.0.

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