Order Attachments Long Text and Short Text Identification Issue.
(Doc ID 759309.1)
Last updated on FEBRUARY 12, 2019
Applies to:Oracle Shipping Execution - Version 220.127.116.11 to 11.5.10.CU2 [Release 11.5.10]
Information in this document applies to any platform.
Oracle Shipping Delivery Based - Version: 18.104.22.168
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.
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