This discussion is archived
5 Replies Latest reply: Jan 4, 2013 1:48 PM by 939840 RSS

AutoInvoice Error:Fatal error returned from FND_SEQNUM during document numb

939840 Newbie
Currently Being Moderated
Autoinvoice Import Program which gets spawned from Autoinvoice Master Program after successful completion of AR SUNB Autoinvoice Program(Report Set) errors:-

Message logged in Log file: Fatal error returned from FND_SEQNUM during document number assignment.

Note: Document Sequence configuration successfully validated but sequence number not generated when transactions created manually via Transaction workbench.

Appreciate all help in advance.
  • 1. Re: AutoInvoice Error:Fatal error returned from FND_SEQNUM during document numb
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    Please post the details of the application release, database version and OS.
    Autoinvoice Import Program which gets spawned from Autoinvoice Master Program after successful completion of AR SUNB Autoinvoice Program(Report Set) errors:-

    Message logged in Log file: Fatal error returned from FND_SEQNUM during document number assignment.

    Note: Document Sequence configuration successfully validated but sequence number not generated when transactions created manually via Transaction workbench.

    Appreciate all help in advance.
    Can you please the contents of the concurrent request log file here?

    Please see (Bug 6502908 : DATAFIX) AUTOINVOICE FAILS; CUSTOMER REQUESTS DATAFIX IN AR_DOC_SEQUENCE_AUDIT;).

    Thanks,
    Hussein
  • 2. Re: AutoInvoice Error:Fatal error returned from FND_SEQNUM during document numb
    939840 Newbie
    Currently Being Moderated
    Release = 11.5.10.2
    Version = Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
    Log File
    raaudn()+ Current system time is 17-DEC-2012 18:29:15
    Fatal error returned from FND_SEQNUM during document number assignment. Review log messages for details on failed transaction(s)

    Error calling raaudn()
    Error calling raapic()
    raarrt2()+ Current system time is 17-DEC-2012 18:29:15
    Commit after cleanup - Current system time is 17-DEC-2012 18:29:16
    raarrt2()- Current system time is 17-DEC-2012 18:29:16
    raacit()+ Current system time is 17-DEC-2012 18:29:16
    raadcr()+ Current system time is 17-DEC-2012 18:29:16
    raadcr()- Current system time is 17-DEC-2012 18:29:16
    raacit()- Current system time is 17-DEC-2012 18:29:16
    raafds()+ Current system time is 17-DEC-2012 18:29:16
    raafeb()+ Current system time is 17-DEC-2012 18:29:16
    raafeb()- Current system time is 17-DEC-2012 18:29:16
    raafds()- Current system time is 17-DEC-2012 18:29:16
    ---------------------------------------------------------------------------
    Start of log messages from FND_FILE
    ---------------------------------------------------------------------------
    18:29:15 :raaudn: Call to FND_SEQNUM.GET_SEQ_VAL failed.

    Thanks for the response.
    NM

    Edited by: 936837 on Dec 20, 2012 4:08 PM
  • 3. Re: AutoInvoice Error:Fatal error returned from FND_SEQNUM during document numb
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    Was this working before? If yes, any changes been done recently?

    Do you have any invalid objects in the database?

    Can you find any errors in the database?

    Have you tried to generate the executable file (if exists) via adadmin and see if this helps?

    If none of the above helps, please log a SR.

    Thanks,
    Hussein
  • 4. Re: AutoInvoice Error:Fatal error returned from FND_SEQNUM during document numb
    SriniVelumuri Explorer
    Currently Being Moderated
    Check sequence FND_DOC_SEQ_111_S exits & Valid
    Refer note 563519.1 for additional details.

    Regards,
    Srini
  • 5. Re: AutoInvoice Error:Fatal error returned from FND_SEQNUM during document numb
    939840 Newbie
    Currently Being Moderated
    This error was caused due to Environment clone issue as it did work in an another refresh environment.
    Thanks for all quick response!!!

Legend

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