'ORA-01747: invalid user.table.column' Error on Undo of a Custom Management Ledger Allocation

(Doc ID 2301130.1)

Last updated on OCTOBER 03, 2017

Applies to:

Oracle Financial Services Profitability Management - Version 8.0.4 to 8.0.4 [Release 8]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

In Oracle Financial Services Profitability Management (PFT) 8.0.4, in Allocation History, when you try to run Undo for an Allocation that populates a custom Management Ledger table, the Undo fails and the following ORA-01747 error exists in the ofspa.xxxxxx.log in $FIC_DB_HOME/log/FusionApps:

Module Logging OFS errors: (203105) Oracle drv_oci error: OCI Function: [4] - oexec(),
       oexn() SQL Function: [0] - SQL function not found! Oracle Error:
       ORA- 01747: invalid user.table.column, table.column,
or     column specification Driver Function: drv_oci::Execute() SQL
       Statement:
UPDATE MGMT_LEDGER_CUSTOM
SET    [Current_Amount] = 0
WHERE  as_of_date = '06/ 30/ 2017'
and    identity_code_chg = 3
and    MGMT_LEDGER_CUSTOM.FINANCIAL_ELEM_ID<=0
 

The table MGMT_LEDGER_CUSTOM does not contain a column called '[Current_Amount]' as this is a macro.

This error prevents you from removing the results of an Allocation against a custom Management Ledger table.

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