PFT 184.108.40.206 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 SEPTEMBER 17, 2021
Applies to:Oracle Financial Services Analytical Applications Infrastructure - Version 220.127.116.11.0 to 18.104.22.168.0 [Release 8]
Oracle Financial Services Profitability Management - Version 22.214.171.124.0 to 126.96.36.199.0 [Release 8]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Profitability Management (PFT)
When attempting to install PFT 188.8.131.52 Patch 31562914, the installation fails at the model upload step:
[28-07-21 09:53:19,396 EDT AM] [INFO ] Model upload status message :  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.
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.
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
|If PFT 184.108.40.206 is installed, do the following:|
|If PFT 220.127.116.11 is not installed, do the following:|