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
Custom Attribute scripting for Auto-Reconciliation Rule for Threshold — 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

Custom Attribute scripting for Auto-Reconciliation Rule for Threshold

Question
31
Views
0
Comments
edited Jun 17, 2019 1:44PM in Account Reconciliation

Summary

Rule to auto-submit/approve reconciliation based on Risk Profile (High/Medium/Low) and % Tolerance (0.25,0.50,0.75) respectively

Content

 

We are looking into creating a business rule for their ARCS application which auto-closes and auto-submits reconciliations under a certain % threshold for unexplained variances based on the Risk Rating of the profiles.
If the Risk Rating is 

High -> Tolerance Level is 0.25%
Medium -> Tolerance Level is 0.50%
Low -> Tolerance Level is 0.75%.

We looked at the 'Auto Reconciliation' Method: Balance match (% tolerance), the restriction with this is that Match Threshold % should be a whole number between 1 and 100.

<Image 1>

To overcome this, we're trying to create a customer attribute that can calculate the value of the unexplained difference from the profile. We have used the following script (in Custom Attribute Scripting):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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