How to write negative value comparison logic in Oracle AFC with a Certain negative Value Ex: -20000 — 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

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):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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