EeS: 'Attachment Failed to Download' Error When Attempting to Open Attachment on Self Service Invoice (Doc ID 2659830.1)

Last updated on JANUARY 23, 2023

Applies to:

Symptoms

When supplier users sign in into the Supplier Portal and enter self service invoices then add attachments,  the attachment can not be opened by the AP processor in the Employee Portal under quick invoice or the Invoice screen.  Users receive an error when selecting the link. 

When the attachment is added in the supplier portal by a supplier user the INSERT INTO PS_PV_ATTACHMENTS sets the SERVER_ID value to 3.

When the attachment is retrieved in the employee portal the PS_PV_ATT_SERVERS .SERVER_ID value is retrieved, the value is 1 and it compares it to the PS_PV_ATTACHMENTS.SERVER_ID value which is 3.  Because the values are different it gives the following error: “Attachment failed to download. Attachment utility data integrity error. Server id 3 has 0 instances in the database!...”
 

ERROR

Attachment failed to download. Attachment utility data integrity error. Server id 3 has 0 instances in the database!(18036,10005)

STEPS

1.  On Page Administer File Attachments , ensure the default server is set to 1 which is of type Database
     Navigation:Main Menu > Set Up Financials/Supply Chain > Common Definitions >File Attachments > Administer File Attachments

2.  Sign in as eSettlements Supplier User

3.  Switch from EMPLOYEE to SUPPLIER portal (In the browser address field, replace EMPLOYEE in the link with SUPPLIER and hit enter key)

4.  Add Fluid SSI and upload a file (PDF, TXT etc.)

5.  Save the Invoice.

6 . Try opening the attached document.   Error is received:

    'Attachment failed to download. (18036,10014) A Server was not found. Error7.(18036,10009)'

    Note that if  Server Id 3 is removed in the delivered code EM_SSIFL_WRK.ADD_PB.FieldFormula, error message is returned which is exactly similar to error received by customer:

    Attachment failed to download.  Attachment utility data integrity error.  Server id 3 has 0 instances in the database! (18036,10005) SCM_ARCH_ATTACH.Attachments.ServerManager.OnExecute  Name:GetServer  PCPC:1476  Statement:22
    Called from:SCM_ARCH_ATTACH.Attachments.Attachment.OnExecute  Name:GetServer  Statement:838
    Called from:SCM_ARCH_ATTACH.Attachments.Attachment.OnExecute  Name:Download  Statement:400
    Called from:SCM_ARCH_ATTACH.UI.AttachmentHandler.OnExecute  Name:OnlineDownload  Statement:285
    Called from:PV_ATTACH_WRK.SCM_DOWNLOAD.FieldChange  Statement:8

The issue is only with fluid.

Cause

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