Order Attachments Long Text and Short Text Identification Issue.
Last updated on OCTOBER 25, 2017
Applies to:Oracle Shipping Execution - Version 18.104.22.168 to 11.5.10.CU2 [Release 11.5.10]
Information in this document applies to any platform.
Oracle Shipping Delivery Based - Version: 22.214.171.124
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.
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,
where fndattfn.attachment_function_id=fndcatusg.attachment_function_id and
-- 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.
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