Error "Reporting: ORA-00904: "ERP_ERROR": invalid identifier" Occurs During WFR Export (Doc ID 1931682.1)

Last updated on APRIL 14, 2017

Applies to:

Oracle WebCenter Forms Recognition - Version 11.1.1.8.0 and later
Information in this document applies to any platform.

Symptoms

When configuring the Forms Recognition 1007CA project for reporting, the below error occurs:

Reporting: ORA-00904: "ERP_ERROR": invalid identifier

UPDATE OFRDOCUMENT SET BATCHNAME = '00000040', DATEEXPORTRTS = sysdate, PIDEXPORTRTS = '5836', PCNAMEEXPORT = 'USATL01MT243', FLAGEXPORTED = 'Y', CLASSNAMEV = 'Invoices', SOURCE_ID = '10702', SOURCE_NAME = 'ALLENS', ORG_ID = '88', ERP_DOC_KEY = '', ERP_ERROR = '', DOCUMENT_LINK = '475CC5F1A18F493D896A932B1EA54668', CURRENT_STATUS = 800, TABLE_ROWS_OUT = 1, LP_STATUS = 0, LP_TOTAL = 0, LP_PAIRED = 0 WHERE DOCUMENTNUMBER = '475CC5F1A18F493D896A932B1EA54668'

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