ARFG_INVOICE_ADJUSTMENTS View is Returning 2 Lines for a Specific Adjustment
Last updated on JANUARY 25, 2017
Applies to:Oracle Financials Intelligence - Version 12.1.2 and later
Information in this document applies to any platform.
After the application of patch 14499301 when you query a transaction in the view - ARFG_INVOICE_ADJUSTMENTS it is returning 2 identical lines for a invoice that has 2 lines, 3 identical lines for a invoice that has 3 lines, and so on.
When you use the view in a report, it doubles, triples etc the values.
If you have an invoice with 2 lines and they total $75, the view has two identical lines for the transaction and the total is $150 in any report that is run against the view.
If you have an invoice with 3 lines and they total $100, the view has three identical lines for the transaction and the total is $200 in any report that is run against the view.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms