My Oracle Support Banner

Duplicate Lines On PDF Quote Due To Duplicate Instance Relationships In Install Base (Doc ID 2034875.1)

Last updated on MAY 10, 2018

Applies to:

Oracle Installed Base - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Support Codes, Production environment:

ACTUAL BEHAVIOR
---------------
Oracle pricing does not tally with the quote generated. Table cs_customer_products_all is returning duplicate lines which is causing the duplicate lines and the price issue.

EXPECTED BEHAVIOR
-----------------------
Expect cs_customer_products_all table to return only one line.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Oracle price is USD 28,816.47. The quote generated price is USD 31,498.53.
Line item # 2.1 had been duplicated and printed TWICE on the pdf.
MNT-ARX-SM-5000 - $2,682.07.
When checked in details users found below:
For Line 2.1 related Item ARX-SM-5000, cs_customer_products_all table returning duplicate lines which causing the duplicate lines and price issue. Related Item Instance 4082784.
select * from cs_customer_products_all
where CUSTOMER_PRODUCT_ID = 4082784

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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.