My Oracle Support Banner

Isupport Return And Shipment Section Shows 3 Order Lines (Doc ID 1334619.1)

Last updated on DECEMBER 09, 2020

Applies to:

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

Symptoms

After submitting Charges to Order Management from a Service Request -- which yields a 1 to 1 (I return for 1 return and 1 order for 1 order) when reviewing this data in iSupport Resolutions Tab, Returns and Shipments the Order and Return are showing up in triplicate.

Steps to Reproduce

(R) iSupport Business User
Review Returns and Shipments

This is confirmed in query output of:

select csed.ESTIMATE_DETAIL_ID,
transtl.name,
csed.creation_date,
mtl.description,
csed.serial_number,
csed.quantity_required,
oh.order_number,
oh.header_id,
oel.meaning,
oh.order_category_code,
ol.line_number,
oh.sold_to_org_id
from cs_estimate_details csed,
mtl_system_items_tl mtl,
oe_order_headers_all oh,
oe_order_lines_all ol,
OE_LOOKUPS oel,
cs_transaction_types_tl transtl,
cs_txn_billing_types cstxbt,
CS_BILLING_TYPE_CATEGORIES csbtc
and mtl.organization_id = :[NOTE, REPLACE WITH VALUE NOTED]
and csed.inventory_item_id = mtl.inventory_item_id
and csed.transaction_type_id = transtl.transaction_type_id
and oh.header_id= csed.order_header_id
and oh.header_id = ol.header_id
and oel.LOOKUP_CODE= ol.flow_status_code
and oel.LOOKUP_TYPE= 'LINE_FLOW_STATUS'
and csed.txn_billing_type_id = cstxbt.txn_billing_type_id
and cstxbt.billing_type = csbtc.billing_type
and csbtc.billing_category = 'M'
and incident_id = :[NOTE, REPLACE WITH VALUE NOTED]
order by csed.creation_date desc ;

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
References


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