Transaction Detail Report ( ARXTDR) Shows Item Description Instead Of Discount Information For Discount Lines (Doc ID 1154693.1)

Last updated on JULY 11, 2013

Applies to:

Oracle Receivables - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms

When a Pricing modifier applied for OM Line AR Invoice creates with two lines one for Inventory Item and second for Discount line.

Discounts are interfaced as different records in interface table.

The description for discount lines comes from oe_price_adjustments.adjustment_name and inventory_item_id is inserted for discount lines.

When the invoice is created, the details are listed correctly

Invoice Details

LNo. Item # Inv Line Descr Quantity Unit Price Extended Amount
---- ----------------- ---------------------------------------- --------
1 XBN R211 NL LPW01.6006 5 89.99 449.95
2 XBN R211 PHONE GIFTPACK.A.XBN.R211.BLACK.1.NL-5 10.01 50.05

Issue: The 'Transaction Detail Report' is showing the item description instead of the discount information

Transaction Detail Report

LNo. Item # Inv Line Descr Quantity Unit Price Extended Amount
---- ----------------- ---------------------------------------- --------
1 XBN R211 PHONE GIFTPACK.A.XBN.R211.BLACK.1.NL-5 89.99 449.95
2 XBN R211 PHONE GIFTPACK.A.XBN.R211.BLACK.1.NL-5 10.01 50.05

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