| Re: Automatic Refresh Cache Before Processing Inbound XML Message
Hi,
The first error does look like a cache issue. However the second looks like you have a record in the DB that you would need to delete for the pure insert 'I' to succeed.
Have you verified that the contact_gid PHL/SHAREDAIR_EXPORT is in fact not in the database at the time of the error? You may have that contact tied to multiple orders so deleteing it may not be reasonable.
Can you not use a transaction code of 'D' to delete the order rather than using PL/SQL outside of the application? This method should avoid any cache related issues.
--Alan |