I am using Oracle Cash Management Adapter to Insert the Bank Files in to Oracle Applications Database. Everything works fine but I have a requirement that I need to insert only one Header for all the day to day transactions.
To do that I have written an JDBC Delete adapter service which deletes the header if the header already exists in the headers table based on the header record I get from the flat file. If the header already exists I will delete it otherwise I have to insert a new header and the detail lines for that header. I am doing the delete beacuse the Oracle Applications Adapters dosen’t allow the detail records insert without the header records.
When I call the JDBC delete header service with the Bank Account Num as 123456789 and Statement Date as JAN-2006 , the IS hangs.
Is there any way that I can check the header records and if it exists delete and insert the same header record with new detail lines without causing the IS hangovers?
Thank you in advance,