2 Replies Latest reply on Nov 3, 2009 2:54 PM by user627525

    Auto invoice import program(RAXTRX) ERROR

    user627525
      Hi,

      i have a problem with Auto invoice import program(RAXTRX). i have submitted through my custom package.
      some times its is working fine. some times it is not working.
      Auto invoice import program has completed with error. Records are existing in RA_INTERFACE_LINES_ALL TABLE. COLUMN NAME RECORD_STATUS AND REQUEST_ID IS NOT UPDATED.

      please find the log message below and provide some solution to solve this issue. thanks in advance.


      Error calling raaild()
      Error calling raapic()
      raarrt2()+ Current system time is 03-NOV-2009 17:34:06
      issued rollback in raarrt2 Current system time is 03-NOV-2009 17:34:06
      0 row(s) deleted from AR_CREDIT_MEMO_AMOUNTS - Current system time is 03-NOV-2009 17:34:06
      0 row(s) deleted from RA_CUSTOMER_TRX_LINES - Current system time is 03-NOV-2009 17:34:06
      0 row(s) deleted from RA_CUST_TRX_LINE_GL_DIST - Current system time is 03-NOV-2009 17:34:06
      0 row(s) deleted from RA_CUST_TRX_LINE_SALESREPS - Current system time is 03-NOV-2009 17:34:06
      0 row(s) deleted from RA_CUSTOMER_TRX - Current system time is 03-NOV-2009 17:34:06
      Cleanup: 172 row(s) updated in RA_INTERFACE_LINES - Current system time is 03-NOV-2009 17:34:06
      Commit after cleanup - Current system time is 03-NOV-2009 17:34:06
      raarrt2()- Current system time is 03-NOV-2009 17:34:06
      raacit()+ Current system time is 03-NOV-2009 17:34:06
      0 row(s) updated Current system time is 03-NOV-2009 17:34:06
      0 row(s) deleted Current system time is 03-NOV-2009 17:34:06
      0 row(s) deleted Current system time is 03-NOV-2009 17:34:06
      0 row(s) deleted Current system time is 03-NOV-2009 17:34:06
      raadcr()+ Current system time is 03-NOV-2009 17:34:06
      raadcr()- Current system time is 03-NOV-2009 17:34:06
      raacit()- Current system time is 03-NOV-2009 17:34:06
      raafds()+ Current system time is 03-NOV-2009 17:34:06
      raafeb()+ Current system time is 03-NOV-2009 17:34:06
      raafeb()- Current system time is 03-NOV-2009 17:34:06
      arcdcu()+ Current system time is 03-NOV-2009 17:34:06
      arcdcu()- Current system time is 03-NOV-2009 17:34:06
      raafds()- Current system time is 03-NOV-2009 17:34:06
      ---------------------------------------------------------------------------
      Start of log messages from FND_FILE
      ---------------------------------------------------------------------------
      ---------------------------------------------------------------------------
      End of log messages from FND_FILE
      ---------------------------------------------------------------------------


      ---------------------------------------------------------------------------
      Executing request completion options...


      Finished executing request completion options.
      Error calling raapic()

      ---------------------------------------------------------------------------
      Concurrent request completed
      Current system time is 03-NOV-2009 17:34:06

      ---------------------------------------------------------------------------