Issue/Symptom/Question

We received the below error when trying to process an interface file.

An error has been detected in a SQL Statement.

IFP003 - 1455 ORA - 01455: converting column overflows integer datatype

days between

Applies To

PENTA for Windows

Interfaces > Processing > Initiate Batch Interface Request

Resolution/Fix/Answer

The interface file has a wrong date placed within the file. If you experience this error please submit a Service Desk ticket and reference this article.  Please provide the following information in your Service Desk ticket:

• Interface Request ID
• User ID
• Interface Type: