OBPM | Inward / Outward Cheque Clearing Return Accounting Entries Getting Rejected (Doc ID 3074804.1)

Last updated on MARCH 10, 2025

Applies to:

Symptoms

On : 14.5.0.0.0 version, Production Support

Inward / Outward Cheque Clearing Return Accounting Entries Getting Rejected

Bank user initiating Inward/Outward cheque clearing return from PGDINRTN/PGDOURTN in OBPM,then accounting entries for return transactions are getting rejected.
When we checked OBPM is sending Original transaction reference number and not the return transaction reference number in tag in "Acc-Mis" block in the FCUBSIFService request to Core. so its getting failed in unique constraint error in mitb_class_mapping insert.

Note: This Return is raised by CHKPOINT toll after rejection of cheque. so the toll initiated the return to collect the funds from customer which was credited as part of clearing transaction.

ERROR
-----------------------
Failed to save the record ( ORA-00001: unique constraint (PK01_MITB_CLASS_MAPPING) violated)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1)Took a successful outbound clearing transaction as input & returned that using PGDOURTN.
2)After authorization of return outbound clearing transaction the handoff status went to Rejected status.
3)After checking the queue response it was showing as 'Failed to save'. After analyzing the debugs it was failed to create the MIS of the transaction.
Here the system sent to create the MIS for outbound clearing transaction , but this was already created as part of outbound clearing. Due to this unique constraint error occurred.

System should send the return transaction reference instead of outbound clearing transaction reference number.
 

Cause

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