ARFG_INVOICE_ADJUSTMENTS View is Returning 2 Lines for a Specific Adjustment (Doc ID 1938356.1)

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.

Symptoms

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.

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

Cause

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