N04 Messages Going Into Error Status
(Doc ID 3053601.1)
Last updated on OCTOBER 23, 2024
Applies to:
Oracle Banking Payments - Version 14.6.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
On : 14.6.0.0.0 version, Implementation Support
ACTUAL BEHAVIOR
---------------
N04 messages are going into Error status. As checked in 'OBPM.PMTB_NEFT_DLY_MSG_IN' table, the Process_status is 'E' for few batches.
EXPECTED BEHAVIOR
-----------------------
N04 messages should not be going into Error status
BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot process the N04 batch completely
SUPPORT ANALYSIS:
------------------------------
Row lock contention was observed on PMTB_NETWORK_DATES table where it is updating latest BATCH_TIME and AMOUNT in PMTB_NETWORK_DATES during N04. This update was present before patch set as well.
Suspect is that previous N04 batch has taken more than 30 minutes causing contention with N04 of next batch.
On initial analysis, we have found that select on PMZB_N02_N04_MATCH table was taking time.
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 |
| References |