Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Contract Approval rule based on start date and end date via BPM — 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

Contract Approval rule based on start date and end date via BPM

Received Response
17
Views
1
Comments
edited Aug 6, 2021 1:56PM in Enterprise Contracts 1 comment

Summary

Approval rule not routing as per requirement

Content

Hi,

I am new to enterprise contract module. I have below requirement of configuration on approval rule based on contract start date and end date

  1. contract duration ( Start date , End date) is less than 1 year
  2. contract duration ( Start date , End date) is between 1 to 3 year
  3. contract duration ( Start date , End date) is greater than 3 year

 

I built 3 rules

Rule 1 :  ((ContractDetails.endDate.day - ContractDetails.startDate.day) / 365) less than 1

Rule 2 :  ((ContractDetails.endDate.day - ContractDetails.startDate.day) / 365) between 1 and 3

Rule 3 :  ((ContractDetails.endDate.day - ContractDetails.startDate.day) / 365) more than 1

 

Now when contract is created for duration of less then 1 year (Start Date: 5/1/21, End Date : 11/29/21 ) its routing as per Rule 1

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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