Order Attachments Long Text and Short Text Identification Issue. (Doc ID 759309.1)

Last updated on APRIL 26, 2016

Applies to:

Oracle Shipping Execution - Version 11.5.10.2 to 11.5.10.CU2 [Release 11.5.10]
Information in this document applies to any platform.
Oracle Shipping Delivery Based - Version: 11.5.10.2
WSHRDPIK.rdf


Symptoms

Checked for relevance on 26-Apr-2016

Find that when using a long text attachment, the long text information resulted in the query is different from the long
text information in the order attachment for the same MEDIA_ID even though the MEDIA_ID for a Customer's query
matches with the MEDIA_ID which appears on the form when performing Help->Diagnostics->Examine.

EXPECTED BEHAVIOR
Expect that the long text note in the query matches with the one on the form based on the MEDIA_ID.

-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:

1. Create an Order.
2. In the attachments, create two short and one long text.

From the standard pick slip report, the following query is is returning some other long text which is
not related/linked to the sales order.

select st.short_text order_short_text,
description order_attach_desc,
pk1_value order_attach_pk,
datatype_name order_attach_dtype
from
fnd_attachment_functions fndattfn,
fnd_doc_category_usages fndcatusg,
fnd_documents_vl fnddoc,
fnd_attached_documents fndattdoc,
fnd_documents_short_text st
where fndattfn.attachment_function_id=fndcatusg.attachment_function_id and
fndcatusg.category_id=fnddoc.category_id and
fnddoc.document_id=fndattdoc.document_id and
fndattfn.function_name=:P_FUNCTION_NAME and
fndattdoc.entity_name=:P_ENTITY_HEADERS and
fnddoc.media_id=st.media_id

-- Business Impact:
The issue has the following business impact:
Due to this issue, users cannot verify whether correct long text is being used on the attachment.

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