Dynamic Driver Allocation on Transaction Table Fails with "ORA-00918: Column Ambiguously Defined" Error (Doc ID 2020668.1)

Last updated on JUNE 29, 2015

Applies to:

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

Symptoms

In Oracle Financial Services Profitability Management (PFT) 8.0, when you run a Dynamic Driver Allocation that uses a Transaction table in the source and target and the Ledger Stat table as the driver, the Allocation fails and the following error appears in the ofspa log in $FIC_DB_HOME/log/FusionApps:

Module Logging OFS errors: (203105) Oracle drv_oci error: OCI Function: [4] - oexec(),
    oexn() SQL Function: [189] - SQL function not found! Oracle
    Error: ORA- 00918: column ambiguously defined Driver Function:
    drv_oci::Execute() SQL Statement: MERGE INTO FSI_D_CASA_TXNS
    TARGET USING (SELECT SUM (IVW_SOURCE.IVW_TARGET_AMOUNT)
    TARGET_AMOUNT, GL_ACCOUNT_ID, IDENTITY_CODE, ID_NUMBER,
    ORG_UNIT_ID, PRODUCT_ID
.
.
.
etc.

The processing key of the Transaction table contains more than one dimension column.

As a result of the error, the Allocation fails to output any rows.

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