My Oracle Support Banner

R12: APXINWKB Wrong Discount Amount Calculated On Invoice Using Folders With Invoice Amount Before Currency Code (Doc ID 1503647.1)

Last updated on OCTOBER 18, 2020

Applies to:

Oracle Payables - Version 12.0.1 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.
Wrong Discount Amount Calculated On Invoice Using Folders With Invoice Amount Before Currency Code
Or
If Invoice Created Using Copy Invoice Above Invoice Amount Changed

Symptoms

Users may experience some of these symptoms:

Steps to reproduce:

1. Create only the invoice header with the any custom folder that has got the amount field before the currency code.
Save the record and query the record in sql. 

SQL> SELECT invoice_amount,amount_applicable_to_discount FROM AP_INVOICES_ALL
WHERE invoice_num = 'Put your invoice number here'

The amount_applicable_to_discount will be more than the invoice_amount.

2. Open up the same custom folder and place the invoice amount field after invoice currency code.
Save the record and query the record in sql.

SQL> SELECT invoice_amount,amount_applicable_to_discount FROM AP_INVOICES_ALL
WHERE invoice_num = 'Put your invoice number here'

The amount_applicable_to_discount will be equal to the invoice_amount.

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
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.