How can we use msc_calendar_exceptions table data in Groovy Script
Summary:
We need to implement logic to validate the Scheduled Ship Date. When a user selects a shipping date and saves the order line, the Groovy extension should ensure that the selected date does not fall on any exception date.
The exception dates are maintained in the MSC_CALENDAR_EXCEPTIONS table.
Kindly advise on how this table can be accessed within a Groovy-based OM Extension, or recommend an appropriate approach to incorporate this validation logic.
Navigation for below page: Order Management —> Global Order Promising —> Review Planning Calendars(Task)
Kindly help on how we can access the above table using groovy script.
0