0027494: Error on installation ORA-00910: specified length too long for its datatype

Description

Error on module installation on Oracle ORA-00910: specified length too long for its datatype

Steps To Reproduce

When installing module, Oracle ORA-00910: specified length too long for its datatype when trying to create OBARCNT_ENQUIRY since column EMAIL_LOG NVARCHAR2(4000) is bigger than the 2000 allowed by Oracle.

CREATE TABLE OBARCNT_ENQUIRY
      (
       OBARCNT_ENQUIRY_ID VARCHAR2(32) NOT NULL,
       AD_CLIENT_ID VARCHAR2(32) NOT NULL,
       AD_ORG_ID VARCHAR2(32) NOT NULL,
       ISACTIVE CHAR(1) DEFAULT 'Y' NOT NULL,
       CREATED DATE DEFAULT SYSDATE NOT NULL,
       CREATEDBY VARCHAR2(32) NOT NULL,
       UPDATED DATE DEFAULT SYSDATE NOT NULL,
       UPDATEDBY VARCHAR2(32) NOT NULL,
       C_DOCTYPE_ID VARCHAR2(32) NOT NULL,
       DOCUMENTNO NVARCHAR2(30) NOT NULL,
       OBARCNT_ENQUIRY_CATEGORY_ID VARCHAR2(32) NOT NULL,
       C_BPARTNER_ID VARCHAR2(32) NOT NULL,
       DOCSTATUS VARCHAR2(60) NOT NULL,
       STARTDATE DATE NOT NULL,
       ENDDATE DATE NOT NULL,
       CAPACITY NUMBER(10,0) NOT NULL,
       AD_LANGUAGE VARCHAR2(6),
       DESCRIPTION NVARCHAR2(2000),
       BILLED_BPARTNER_ID VARCHAR2(32),
       EMAIL_LOG NVARCHAR2(4000),
       PROCESSING CHAR(1) DEFAULT 'N' NOT NULL,
       ACTION CHAR(1) DEFAULT 'N' NOT NULL,
       ADD_RESOURCE_PICK CHAR(1) DEFAULT 'N' NOT NULL,
       NIGHTS NUMBER(10,0),
       BOOKINGLINK VARCHAR2(2000),
       CHILDREN_UNDER NUMBER,
       CHILDREN_ABOVE NUMBER
      )

Proposed Solution

Change EMAIL_LOG NVARCHAR2(4000) by EMAIL_LOG NVARCHAR2(2000)

Issue History
Date Modified	Username	Field	Change
2014-08-28 17:48	rafaroda	New Issue
2014-08-28 17:48	rafaroda	Assigned To	=> jonalegriaesarte
2014-08-28 17:48	rafaroda	Relationship added	blocks 0027493

Notes
There are no notes attached to this issue.