4 Replies Latest reply on Mar 24, 2015 9:49 AM by Sanjay Desai EBS

    RCV_TRANSACTIONS TABLE

    1337792

      Hi Oracle Team Members,

       

      I want to know on what scenarios RCV_TRANSACTIONS is inserted and updated.

       

      When we receive PO items a line will be inserted. and when we return item to supplier then also a line will be inserted into rcv_transactions table.

      Is there any scenarios where previously inserted lines will get update in rcv transactions table.

      In our project a line in rcv_transaction table is created in in year 2011 (creation_date 02-NOV-2011) but last updated date is showing recent date (last_UPDATE_DATE 11-SEP-2014).

      transaction which created in year 2011 is as part of receiving. I am not sure  why last update date is showing as recent date.

      There is no custom  triggers and custom code that update rcv_transaction tables in out project.

       

      Need some information on what scenarios RCV_TRANSACTIONS is inserted and updated.

       

       

       

      Thanks & Regards

      Gopal