10 Replies Latest reply: Jan 28, 2014 12:54 AM by shd-hfz-syd RSS

ORA-01867: the interval is invalid

TaxCalculation Newbie
Currently Being Moderated

Hi Team,

 

We had a requirement for creating a custom Web ADI.

We have two databases database1 APPS and Database2 Custom Schema. We create our table on Database2 Custom schema and Synonym in Database1 using the DB Link. Packages are created on Database1.

 

I was developing the same and when I tried to load the data it gives me this error:  ORA-01867: the interval is invalid.

 

The funny part is it loads sometimes successfully and it fails sometimes with the above message. There is no code change

 

Procedure In package:

 

PROCEDURE XX_INSU_PAID

(

        P_ORG_CODE         VARCHAR2,

        P_INSU_NAME         VARCHAR2,

        P_ADDRESS           VARCHAR2 ,

        P_FISCAL_NUM        VARCHAR2 ,

        P_FILE_NUM          VARCHAR2 ,

        P_FISCAL_YEAR       NUMBER,

        P_INSU_CATEGORY     VARCHAR2,

        P_PAID_AMOUNT       NUMBER

 

 

);

 

Table Structure:

 

XX_INSUR_PAID

(

  ORG_ID             NUMBER,

  INSU_NAME          VARCHAR2(3000 BYTE),

  FISCAL_YEAR        NUMBER,

  FISCAL_NUM         VARCHAR2(2000 BYTE),

  FILE_NUM           VARCHAR2(2000 BYTE),

  ADDRESS            VARCHAR2(2000 BYTE),

  INSU_CATEGORY      VARCHAR2(1000 BYTE),

  PAID_AMOUNT        NUMBER,

  CREATED_BY         NUMBER(15),

  CREATION_DATE      DATE,

  LAST_UPDATED_BY    NUMBER(15),

  LAST_UPDATE_DATE   DATE,

  LAST_UPDATE_LOGIN  NUMBER(15)

)

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points