My Oracle Support Banner

ISTBS_BIC_DIR_PLUS_temp Is Stating Upload_status P (success) Even Though Upload Failed. (Doc ID 2650231.1)

Last updated on MARCH 20, 2020

Applies to:

Oracle Banking Payments - Version 14.3.0.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 14.3.0.0.0 version, Implementation Support

ACTUAL BEHAVIOR
---------------
ISTBS_BIC_DIR_PLUS_temp is stating upload_status P (success) even though upload failed internally for a record that didn’t make it to main table ISTBS_BIC_DIR_PLUS.

The record is recieved with modification flag "M", but the record is not inserted into the master table "ISTBS_BIC_DIR_PLUS" due to internal failure/error.But the Upload Status is updated to "P" in the temporary table "ISTB_BIC_DIR_PLUS_temp".

In case if the record is not considered into the master table then the Upload Status in Temp Table should not be "P". We should have different status for such records:


EXPECTED BEHAVIOR
-----------------------
System should mark status as U

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Upload BIC Directory Upload File PMDFLEVP
2. Query and check in ISTBS_BIC_DIR_PLUS_Temp
3. check upload_status column.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot identify failed records

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
Cause
Solution


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