My Oracle Support Banner

EDPMS - Acknowledgement status not updated properly for shipping bills (Doc ID 2673971.1)

Last updated on MAY 26, 2020

Applies to:

Oracle FLEXCUBE Universal Banking - Version and later
Information in this document applies to any platform.


Acknowledgement status received from EDPMS system are not updated properly for the shipping bills.

When attempting to upload the acknowledgement files of various categories such as PRN, ROD, WSN,etc. , the below mentioned error occurs:

 "Failed to select ORA-01422: exact fetch returns more than requested number of rows"

The issue can be reproduced at will with the following steps:

1) Create a Bill contract and link the shipping bill number.
2) Reverse the particular contract.
3) Then Create an another contract and link the same shipping bill number.
4) Generate ROD/PRN hand-off and Upload the Acknowledgement file.
5) Verify whether the system has updated the acknowledgement status for the contract that is linked to the shipping bill number and not against the contract which has been reversed.

The issue has the following business impact:
Due to this issue, Acknowledgement status of the respective shipping bills are not updated properly and only partial records get updated with correct status.

Because of this, Users were not able to track the exact status of the shipping bills which are linked with more than one contract (i.e Active/Liquidated/Reversed Contracts)



EDPMS - Export Data Processing and Monitoring System


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

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