'ORA-01747: invalid user.table.column' Error on Undo of a Custom Management Ledger Allocation
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)
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:  - oexec(),
oexn() SQL Function:  - SQL function not found! Oracle Error:
ORA- 01747: invalid user.table.column, table.column,
or column specification Driver Function: drv_oci::Execute() SQL
SET [Current_Amount] = 0
WHERE as_of_date = '06/ 30/ 2017'
and identity_code_chg = 3
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.
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