1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

ora-02287 sequence number not allowed here

Discussion in 'Oracle Apps Technical' started by jagadekara, Oct 31, 2014.

  1. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hi All,

    I am getting following error in form personalization.

    ora-02287 sequence number not allowed here.

    Any idea?

    I wrote code as =select test_sql.nextval from dual
     
  2. DTSIGuy

    DTSIGuy Forum Advisor

    Messages:
    402
    Likes Received:
    58
    Trophy Points:
    410
    Location:
    Texas
  3. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Thanks CJ,

    It's coming fine. I used like below.

    =test_sql.nextval