My Oracle Support Banner

Installation Of DM (GL Recon) Application Pack Failed (Doc ID 2625457.1)

Last updated on JANUARY 06, 2020

Applies to:

Oracle Financial Services Analytical Applications Reconciliation Framework - Version 8.0.0 and later
Information in this document applies to any platform.

Symptoms

While trying to install DM pack 8.0.5, installation is failing with below errors

 [ERROR] - Query:'
CALL FSI_CREATE_SEQUENCE('SEQ_DIM_KI_GRP','DIM_KI_GROUP','N_KI_GROUP_SKEY')
'
 Error:ORA-00942: table or view does not exist
ORA-06512: at "RPF_ATMC2_SCHEMA.FSI_CREATE_SEQUENCE", line 6

[ERROR] - Query:'
declare
v_count int;
v_count1 int;
begin

select count(*) into v_count from user_indexes where upper(index_name) = upper('DIM_DATES_CALENDAR_DATE');

select count(*) into v_count1 from user_tables where table_name = upper('DIM_DATES');

if (v_count = 0) then
if (v_count1 > 0) then

execute immediate 'CREATE INDEX DIM_DATES_CALENDAR_DATE ON DIM_DATES (D_CALENDAR_DATE)';

end if;
end if;

end ;
'
Error:ORA-01408: such column list already indexed
ORA-06512: at line 14

Filename =Pack_install.log
[WRAPPERINSTALLER] [ INFO] - Setup status : 2
[WRAPPERINSTALLER] [ERROR] - Error : APP Setup bin file failed.

Changes

 

 

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.