My Oracle Support Banner

WFR Negative AmountDiscount Value is not Correctly Validated in 1007G AP Project (Doc ID 2154151.1)

Last updated on SEPTEMBER 28, 2022

Applies to:

Oracle WebCenter Forms Recognition - Version 11.1.1.9.0 and later
Information in this document applies to any platform.

Symptoms

If a discount amount is printed on the invoice as a negative value, it does not validate against the AmountTotal correctly in the 1007G AP Project.  The algorithm for validating the Amount total on the invoice is documented in the AP guide as:

Invoice Total = Subtotal + Total Tax + Freight + Miscellaneous Charge – Discount – Withholding Tax – ISR Retention

If the Discount value is denoted as a negative value, it is still subtracted in the algorithm as a negative value (and therefore added to the amount).  In this case, the discount is printed on the invoice as "-1.81":

Total = 33.99

Subtotal = 32.99
Tax = 2.81
Discount = -1.81

If processed in the 1007CA project, the Total comes through as valid (green) since the Discount is extracted as "1.81":

33.99 = 32.99 + 2.81 - 1.81
33.99 = 33.99 (VALID)

However in 1007G the project total comes through as invalid since the Discount is extracted as "-1.81":

33.99 = 32.99 + 2.81 - (-1.81)
33.99 = 37.61 (INVALID)

 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.