Questions on 8.1.x Upgrade for OFS_PFT_INS Allocation Manager For Enterprise Profitability (Doc ID 2951871.1)

Last updated on JUNE 05, 2023

Applies to:

Goal

Question 1: Currently on OFS_PFT_INS 8.1.1.0.0 version and planning to upgrade 8.1.2.X.X.  Currently referencing the OIAM Installation Guide for 8.1.2:

It is documented to run the following script in the atomic schema as part of the upgrade steps.  Is this required?

DECLARE
tbl_check NUMBER;
BEGIN
Select count(*) into tbl_check from user_tables where table_name='FSI_IRCS';
IF( tbl_check=1) THEN
for i in (SELECT CONSTRAINT_NAME, TABLE_NAME FROM USER_CONSTRAINTS WHERE R_CONSTRAINT_NAME = (SELECT CONSTRAINT_NAME FROM USER_CONSTRAINTS WHERE TABLE_NAME='FSI_IRCS' AND CONSTRAINT_TYPE='P'))
LOOP
execute immediate 'ALTER TABLE '||i.table_name||' DISABLE CONSTRAINT '||i.constraint_name||'';
end loop;
execute immediate 'ALTER TABLE FSI_CURRENCIES DROP CONSTRAINT FK_FSI_CURRENCIES_2';
END IF;
EXCEPTION
WHEN OTHERS THEN
dbms_output.put_line(sqlerrm);
END;
/

Question 2: Currently there is a custom data model in use for current 8.1.1 version.  Is it possible to proceed with released (seeded / Out of the box (OOTB)) data model during installation and upload the Custom data model post application upgrade ?

If upgrading with below option in Silent.prop ONLY with released datamodel

UPLOAD_MODEL=1
MODEL_TYPE=0
 
Question 3: How to merge seeded upgrade data model with Custom one?
 
Question 4: Which option should be used to upload the data model?
 
Question 5: If planning to merge the seeded upgrade data model with custom one and then want to upload with upgrade patch (81200), is it required to update Silent.prop with custom data model location and then run installer?
 
Question 6: Current version is 8.1.1.0.0 and upgrading to 8.1.2.0.0. For the Silent.props files for below parameters:

ETL_APPSRC_TYPE

# 0 = If you want to create a new ETL app/src pair
# 1 = If you want to use an existing pair

As this is upgrade, should value 1 be selected?
 
Question 7: For the #ETL Staging source description & #ETL Processing source description
ETL_SRC_1_DESC & ETL_SRC_2_DESC

How to find current values that were used during 8.1.1.0.0 installation?

Question 8: Post upgrade, is there any issue with upgrade if patch application log ends with warnings:

[17-05-23 08:58:28,241 EST AM] [INFO ] ******************************************************************************
[17-05-23 08:58:28,241 EST AM] [INFO ] * APP INSTALLATION COMPLETED IN 00 HOURS 07 MINUTES 08 SECONDS.
[17-05-23 08:58:28,241 EST AM] [INFO ] *
[17-05-23 08:58:28,241 EST AM] [INFO ] * INSTALLATION SUMMARY
[17-05-23 08:58:28,241 EST AM] [INFO ] * --------------------
[17-05-23 08:58:28,241 EST AM] [INFO ] * FATAL ERRORS : 0
[17-05-23 08:58:28,241 EST AM] [INFO ] * ERRORS : 0
[17-05-23 08:58:28,241 EST AM] [INFO ] * WARNINGS : 6
[17-05-23 08:58:28,241 EST AM] [INFO ] *
[17-05-23 08:58:28,241 EST AM] [INFO ] ******************************************************************************

Solution

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