Oracle Forum - The Knowledge Center for Oracle Professionals - Looking Beyond the Possibilities
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