Undo of Deleted Allocation Model Fails With 'ORA-01722: invalid number' in PFT 8.1
(Doc ID 2809835.1)
Last updated on SEPTEMBER 28, 2021
Applies to:Oracle Financial Services Profitability Management - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Profitability Management (PFT)
You cannot use Undo to remove records associated with a deleted Allocation Model. You can find the deleted Model in Allocation History and execute the undo but no records are removed.
You find the following error in the web layer pftapp.log:
[07-06-21 18:22:54,651 GMT PM] [DEBUG] [WEB] allocModelIdSeq::::::null,
[07-06-21 18:22:54,651 GMT PM] [DEBUG] [WEB] allBatch::::::null,'<INFODOM>_284528_EXEC_20210228_2_Task1'
[07-06-21 18:22:54,651 GMT PM] [DEBUG] [WEB] UndoType:U:data:14617-284528-02/28/2021:allocId:'14617':allocModelId:284528:allocModelIdSeq:
[07-06-21 18:22:54,651 GMT PM] [DEBUG] [WEB] getAllocMdlSeqId() qry::select allocation_model_seq_num from fsi_data_identity where identity_code =? and allocation_model_sys_id =? and batch_name = ?
[07-06-21 18:22:54,651 GMT PM] [DEBUG] [WEB] Connection got successfully for pft infodom: <INFODOM>
[07-06-21 18:22:54,651 GMT PM] [DEBUG] [WEB] DBManager::wrapQuery() Param : ['14617', 284528, '<INFODOM>_284528_EXEC_20210228_2_Task1']
[07-06-21 18:22:54,655 GMT PM] [DEBUG] [WEB] Closing Connection Error : java.sql.SQLSyntaxErrorException: ORA-01722: invalid number
You expect to be able to remove rows associated with deleted Allocation Models listed in Allocation History.
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