My Oracle Support Banner

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 12.4.0.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 12.4.0.0.0 version, Production Support-SET

ACTUAL BEHAVIOR
---------------
SI contract with Sweep In Product type are not processed on the execution date

EXPECTED BEHAVIOR
-----------------------
 SI contract with with Sweep In Product type needs to be processed on the execution date

STEPS
-----------------------
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.

 

Changes

 !. 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'
 

Cause

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
Symptoms
Changes
Cause
Solution
References


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