Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
Defaulting Promise Date to First Scheduled Ship Date — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Defaulting Promise Date to First Scheduled Ship Date

Received Response
11
Views
3
Comments
edited Aug 4, 2021 5:23PM in Order Management 3 comments

Content

We have a requirement to default the Promise Date to the First Scheduled Ship Date.  The first problem is that we can't do this based on a Post Transformation Rule linking Promise Date to Scheduled Ship Date because if the Scheduled Ship date is updated, then Promise Date updates as well. 

We're thinking that we need to default an EFF with the value of the Scheduled Ship Date IF the EFF is NULL, otherwise, no update.  Then we'd  have a second Post Transformation Rule to default the EFF contents to the Promise Date.  

The Second Problem is that Oracle's note (Doc ID 2305643.1)    defaulting the Promise Date is incomplete when it comes to defining the Post Transformation Rule to accomplish this and doesn't explain the details in arriving at the Value to set in Promise Date.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!