My Oracle Support Banner

Data is Not loading in "Holding_Recon_Output" Table While Doing 'Holding Recon' For 'Equity' Instrument Type (Doc ID 2605101.1)

Last updated on DECEMBER 18, 2020

Applies to:

Oracle FLEXCUBE Private Banking - Version to [Release 12]
Information in this document applies to any platform.




 On hitting 'Upload' button in 'Holding Recon' screen for 'Equity' instrument type, uploaded data is not getting loaded into the database table named "holding_recon_output".


1. Log-in into the application using Operations user
2. Go to Operations Tab
3. Navigate to Reconciliation section
4. Select 'Holding' options
5. Select 'Equity' Instrument Type from the drop-down menu
6. Click on 'Upload'


 The process of holding reconciliation aims at cross checking the holding balance according to the FCPB (Oracle FLEXCUBE Private Banking) system with the customer level holding data file sent by the External Source system.

 As the holding recon is getting stuck with status 'Z', data is not being loaded in "holding_recon_output" table. 


Hence, Operations user is unable to perform the reconciliation successfully. In case of any genuine mismatch in the holding balance between the External system and FCPB system, the customer of the bank will be displayed with incorrect holding data in the dashboard and the portfolio reports.


Typically post the reconciliation activity, for mismatch cases Operations user investigates the portfolio level transaction data posted in the FCPB system for all the impacted customers. Later the missing transactions are either posted from external system or the incorrect transactions posted are deleted from the customers portfolio. This activity is done to ensure that the final holding balance matches with the balance in the file provided by the External Source system.


 There are no changes in the environment or hardware level which triggered the issue. 


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.