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 |