Home » Applications » Oracle Fusion Apps & E-Business Suite » OM Shipping Exception Error (Oracle Application 11.5.9)
OM Shipping Exception Error [message #331986] Mon, 07 July 2008 02:41 Go to next message
Messages: 35
Registered: October 2007
Hi All,

How to remove exception in Shipping Transaction Form (Under Delivery Tab, Exception is checked with red color).

I got this exception when I was trying to release the order which was on hold. After releasing the hold again I released the order and this time release was successful and delivery was generated but that exception still there Under Delivery Tab. Now, I want to remove this exception and do ship-confirm and also I want to know how to delete The exceptions which are there in exception form.

Appreciate your help.

Thx N Regs,


icon14.gif  Re: OM Shipping Exception Error [message #358483 is a reply to message #331986] Tue, 11 November 2008 09:39 Go to previous message
Messages: 18
Registered: October 2007
Location: Renukoot
Junior Member

To remove exceptions in the order use this procedure this may help.

CREATE OR REPLACE PROCEDURE exceptions_close_update_all(p_organization_id number)
CURSOR exceptions_cl
IS select we.exception_id,we.delivery_detail_id,wdd.organization_id
from wsh_exceptions we, wsh_delivery_details wdd, org_organization_definitions ood
where we.delivery_detail_id = wdd.delivery_detail_id
and wdd.organization_id = ood.organization_id
and ood.organization_id = p_organization_id
and wdd.released_status = 'Y' and wdd.subinventory = ood.organization_code
and we.status = 'OPEN';
FOR i IN exceptions_cl LOOP
update wsh_exceptions
set status = 'CLOSED'
where exception_id = i.exception_id;
end Loop;


Dhrubajyoti Nath
Previous Topic: Excise Invoice number Skipping at regular interval
Next Topic: Reg: API
Goto Forum:

Current Time: Wed Jul 26 18:08:53 CDT 2017

Total time taken to generate the page: 0.12511 seconds