Error "Reporting: ORA-00904: "ERP_ERROR": invalid identifier" Occurs During WFR Export
Last updated on APRIL 14, 2017
Applies to:Oracle WebCenter Forms Recognition - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
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'
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