1 Reply Latest reply on Dec 14, 2013 6:38 PM by PranitSaha

    rec_transactions_interface table troubleshooting

    kp2000

      Hello

       

      we are having errored records processing_status_code = 'ERROR' or transaction_status_code = 'ERROR' from the previous months.

       

      1--when we run this process next month, will we need to remove all previous months records from  rcv_transactions_interface table ?

       

      Or its fine to leave them as it is.

       

      please advise

       

      2--

      In general, how can we troubleshoot once a record got transaction status code as ERROR. Can we just update the transaction_status_code to NULL and rerun the concurrent program?

       

      Thanks

      kp

        • 1. Re: rec_transactions_interface table troubleshooting
          PranitSaha

          kp2000 wrote:

           

          Hello

           

          we are having errored records processing_status_code = 'ERROR' or transaction_status_code = 'ERROR' from the previous months.

           

          1--when we run this process next month, will we need to remove all previous months records from  rcv_transactions_interface table ?

           

          Or its fine to leave them as it is.

           

          please advise

           

          2--

          In general, how can we troubleshoot once a record got transaction status code as ERROR. Can we just update the transaction_status_code to NULL and rerun the concurrent program?

           

          Thanks

          kp

          1. It's ok leave the ERROR records in the table but recommended to remove them periodically.

          2. I believe both the transaction_status_code and processing_status_code need to be updated to PENDING.