SI Not Executing Even Though Account Has Sufficient Funds.
(Doc ID 2687772.1)
Last updated on APRIL 26, 2021
Applies to:Oracle FLEXCUBE Universal Banking - Version 184.108.40.206.0 and later
Information in this document applies to any platform.
On : 220.127.116.11.0 version, Production Support-SET
SI contract with Sweep In Product type are not processed on the execution date
SI contract with with Sweep In Product type needs to be processed on the execution date
The issue can be reproduced at will with the following steps:
1. Create a SI contract with Sweep In product type and execution stage as BOD
2. Run a complete EOD
3. Verify if the SI contract is processed in BOD stage.
!. There were few records for which data was present in sitb_instruction but not in sitb_contract_master and hence SI batch was failing and there was no error updated during EOD.
Instead batch was executed successfully and contracts were not processed in EOD
2. On going through the sipks_batch.sql unit, it can be confirmed that there is no code to process Sweep in Instructions during EOD.
3. Advice format was not maintained for collection product.and following sql identified the issue.
SELECT * FROM mstms_msg_format where MSG_TYPE = 'COLLECTION_ADV'
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