Announcement

Collapse
No announcement yet.

[SOLVED] datachecks before saving business object

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts

  • [SOLVED] datachecks before saving business object

    Scenario:

    A user is only allowed to enter an order release when the early delivery date is not within 2 (configurable) working days.

    I have tried a few things with Action Checks, but that doesn't seem to work.

    Has somebody have experience on this?

    Best regards,

    Bob Romijn
    Best Regards,

    Bob Romijn

  • #2
    Re: datachecks before saving business object

    The challenge here is with the working days. Its hard through a query to handle calendar days against a system date. I have done action checks around dates like the following
    TRUNC (o.early_pickup_date) - TRUNC (SYSDATE) <=2

    Hope this helps!
    Sam
    Samuel Levin
    MavenWire

    www.MavenWire.com

    Comment

    Working...
    X
    😀
    🥰
    🤢
    😎
    😡
    👍
    👎