My Oracle Support Banner

Undo of Deleted Allocation Model Fails With 'ORA-01722: invalid number' in PFT 8.1 (Doc ID 2809835.1)

Last updated on MAY 07, 2023

Applies to:

Oracle Financial Services Profitability Management - Version 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

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