ORA-01747 and ORA-00942 Errors Executing FN_MGMT_REP_MGMT_LEDGER
(Doc ID 2014733.1)
Last updated on JUNE 21, 2017
Applies to:Oracle Financial Services Enterprise Financial Performance Analytics - Version 8.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Enterprise Financial Performance Analytics (EFPA/PFTBI) previously known as Oracle Financial Services Profitability Analytics
On EFPA 8.0.0, when executing FN_MGMT_REP_MGMT_LEDGER batch, the batch fails with the following errors in FSI_MESSAGE_LOG:
Starting FCT_MGMT_REPORTING load
Fatal error occured :ORA-01747: invalid user.table.column, table.column, or column specification
Dropping Temporary table
ORA-00942: table or view does not exist
The issue can be reproduced at will with the following steps:
1. Run the function
set serveroutput on
num := fn_mgmt_rep_mgmt_ledger_TRM('OFSPFTINFO_Fsi_d_management_TRansformation_20151305_1','20151305',1,12,1999,'USD','N','FSI_D_MANAGEMENT_LEDGER');
2. Check for errors
select * from fsi_message_log where batch_run_id like '%d_management%';
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document