Oracle Forum - The Knowledge Center for Oracle Professionals - Looking Beyond the Possibilities

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

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