How to fix Journal Approval Rule based on total running debit for large amounts using CAST to double — 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
Get Started with Redwood: Oracle Cloud SCM and Purchasing

How to fix Journal Approval Rule based on total running debit for large amounts using CAST to double

Summary:

We have three journal approval rules.

  1. For identified journal sources in "USD", if amount is same or more than 5000 - Approval Group
  2. For identified journal sources in "USD", if amount is less than 5000- Auto Approve
  3. For journals in "STAT"- Auto Approve

When we are creating a journal of 4 billion, it is getting auto approved instead of going to approval group.

As per Note: Journal Approval Rule Is Not Followed When Amount Is Greater Than 2.1 Billion (Doc ID 2237077.1)

, need help in relation to which additional condition of doublevalue/longvalue is to be added in which rules above.


Code Snippet (add any code snippets that support your topic, if applicable):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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