Error While Viewing Attachment In Invoice Workbench

(Doc ID 2413834.1)

Last updated on JUNE 30, 2018

Applies to:

Oracle Payables - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

When attempting to open a invoice attachment, the form errors with,
the following error occurs.

ERROR
-----------------------
FRM-40735: WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA-01403.



Changes

Check if the data is available in the below Tables.

1. select * from  FND_HELP_DOCUMENTS where file_name
  in (select file_name from fnd_attached_docs_form_vl
  WHERE entity_name = 'AP_INVOICES' AND pk1_value = '&P_INVOICE_ID')

2. SELECT * FROM fnd_attached_docs_form_vl
   WHERE entity_name = 'AP_INVOICES' AND pk1_value = '&P_INVOICE_ID';

3. select * FROM FND_LOBS WHERE FILE_NAME = -- File name from Query 1;

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