My Oracle Support Banner

PFT 8.0.6.6 Patch Fails During Model Upload With Errors Like 'The Column <Column> of table LEDGER_STAT cannot be deleted' (Doc ID 2807299.1)

Last updated on MAY 07, 2023

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.6.6.0 to 8.0.6.6.0 [Release 8]
Oracle Financial Services Profitability Management - Version 8.0.6.6.0 to 8.0.6.6.0 [Release 8]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Profitability Management (PFT)

Symptoms

When attempting to install PFT 8.0.6.6 Patch 31562914, the installation fails at the model upload step:

[28-07-21 09:53:19,396 EDT AM] [INFO ] Model upload status message : [123] Error in Upload Operation

Errors like the following exist in the model upload log:

The Column COMPONENT_ID of table LEDGER_STAT cannot be deleted as the table has data for this column.

The Column SEGMENT_ID of table LEDGER_STAT cannot be deleted as the table has data for this column.

or

This column BRANCH_ORG_ID has been deleted from the table LEDGER_STAT in the new database model
Error while querying the database for the number of records in the Column BRANCH_ORG_ID which are not null.

Modelupload status..Altering the Model Failed.ERWINUPLOAD ERROR..Modelupload Failed

These errors cause the model upload to fail.

The model upload process should not be deleting the columns listed in the errors.

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
Cause
Solution
 If PFT 8.0.6.1 is installed, do the following:
 If PFT 8.0.6.1 is not installed, do the following:
References


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