Don't allow cancellation of sales order line if the schedule ship date falls within - Printable Version +- Oracle Forum - The Knowledge Center for Oracle Professionals - Looking Beyond the Possibilities (http://www.oraerp.com) +-- Forum: Oracle Applications (http://www.oraerp.com/forum-39.html) +--- Forum: Oracle E-Business Suite (EBS) (http://www.oraerp.com/forum-1.html) +---- Forum: Purchasing, Inventory & Order Management (http://www.oraerp.com/forum-3.html) +---- Thread: Don't allow cancellation of sales order line if the schedule ship date falls within (/thread-70977.html)

Don't allow cancellation of sales order line if the schedule ship date falls within - visgyan - 06-25-2013 Requesting you all to help me with your valuable ideas: My requirement is not to allow cancellation of sales order line if the schedule ship date falls within 3 weeks.. I tried to acheive this through processing constraint but while creating validationTemplate at order line entity for column schedule ship date I have four options for validation operation (equal to,not equal to,null and not null). So there is no way to place a condition for < or > 21 days. Appriciate your response. Thanks and Regards, Abhigyan Visen 09748206680 RE: Don't allow cancellation of sales order line if the schedule ship date falls within - shirfan - 02-11-2014 Hi Abhigyan Define a custom PL/SQL Procedure and call it in the Validation template by using the template type as API instead of TBL. After that define the Processing Constraint by using the above template. Thanks & Regards, Irfan