WFR Reporting Database is not Populated Due to Error "ORA-01400: cannot insert NULL into ("WFRUSER"."OFRDOCUMENT"."DOCUMENTNUMBER")" (Doc ID 2246410.1)

Last updated on MARCH 28, 2017

Applies to:

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

Symptoms

The WFR Reporting Database is not populated due to error:

[Error] |30| 12:47:53.229 | 1312 | 3299520k/5088632k | 4903768k/11870676k | 266256k/269688k | 574 | 137/75 | Reporting: ORA-01400: cannot insert NULL into ("WFRUSER"."OFRDOCUMENT"."DOCUMENTNUMBER")
[Info] |30| 12:47:53.229 | 1312 | 3299520k/5088632k | 4903768k/11870676k | 266256k/269688k | 574 | 137/75 | INSERT INTO OFRDOCUMENT (DOCUMENTNUMBER, VERSION, PROJECTNAME, CLIENTNAME, DateImportStartRTS) VALUES ( '', '1', 'AP PACKAGED PROJECT', '', sysdate)

Changes

Implemented Reporting in .INI file and created the Reporting Database Tables

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