Long Text Attachment Printing on Work Order but not visible on Asset Activity
I have a client seeing a lot of incorrect information on the printed work order. The text is appearing in the "Long Text Attachment" section of the print out. But there is no attachment associated to the activity. The client can add a new long text attachment to the activity and it will append to the end of the section.
Where else would these attachments be? Is this corruption in the FND tables referenced in the package? (cursor definition below)
Thanks in advance!
cursor oplongattachment_cursor(p_wip_id number,p_org_id number) is
select XMLFOREST(
fdlt.media_id as "OPALONGMEDIAID",