My Oracle Support Banner

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

Last updated on FEBRUARY 21, 2019

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

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
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
 Still Have Questions?
References


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