How to write negative value comparison logic in Oracle AFC with a Certain negative Value Ex: -20000
Summary:
In Oracle AFC, there is a system limitation to use (-) for negative sign. I have a requirement to write condition to Extract High Value Credit Memos, which means i need to write a condition where credit memo is greater than say 20000 AUD. In oracle AFC, when i try to write a condition with negative value, its not allowing. i tried between and less than conditions.
Appreciate your inputs here.
Content (please ensure you mask any confidential information):
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):