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

Symptoms

On EFPA 8.0.0, when executing FN_MGMT_REP_MGMT_LEDGER batch, the batch fails with the following errors in FSI_MESSAGE_LOG:

ERROR

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
Declare
num number;
Begin
num := fn_mgmt_rep_mgmt_ledger_TRM('OFSPFTINFO_Fsi_d_management_TRansformation_20151305_1','20151305',1,12,1999,'USD','N','FSI_D_MANAGEMENT_LEDGER');
END;


2. Check for errors

select * from fsi_message_log where batch_run_id like '%d_management%';

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