2 Replies Latest reply on Jan 16, 2018 11:12 PM by user12056608

    How to update RECEIPT_NUM on RCV_SHIPMENT_HEADERS?

    user12056608

      Hello

       

       

       

      I'm trying to update the RECEIPT_NUM on RCV_SHIPMENT_HEADERS by using the open interface tables but the information on the table gets stuck in RUNNING process and the receipt_num never gets updated.

       

      I want to know if is possible to update this information with the open interface tables. I used to do it by an direct update to the RCV_SHIPMENT_HEADERS table but my dba team ask me to change this for security reasons.

       

      The code i use to insert on the table is the next:

       

          INSERT INTO

            APPS.rcv_headers_interface( header_interface_id,    GROUP_ID,           processing_status_code,

                                        receipt_source_code,    transaction_type,   last_update_date,

                                        last_updated_by,        last_update_login,  creation_date,

                                        created_by,             vendor_id,          expected_receipt_date,

                                        validation_flag,

                                        ASN_TYPE,         AUTO_TRANSACT_CODE,       EMPLOYEE_ID,

                                        VENDOR_SITE_ID,   SHIP_TO_ORGANIZATION_ID,  receipt_num,

                                        RECEIPT_HEADER_ID, SHIPMENT_NUM,  ORG_ID)

            VALUES  ( I_rec_rcv_trx_interface.header_interface_id,

                      rcv_interface_groups_s.CURRVAL,

                      'PENDING',

                      'VENDOR',

                       'UPDATE',

                      SYSDATE,

                      FND_GLOBAL.USER_ID,   FND_GLOBAL.USER_ID,   SYSDATE,

                      FND_GLOBAL.USER_ID,  

                      I_rec_rcv_trx_interface.vendor_id,  NULL,

                      'Y',

                      'ASN',

                      'RECEIVE',

                      V_EMPLOYEE_ID,

                      I_rec_rcv_trx_interface.vendor_site_id,

                      I_rec_rcv_trx_interface.to_organization_id,

                      x_receipt_num,

                      I_rec_rcv_trx_interface.shipment_header_id,

                      I_rec_rcv_trx_interface.shipment_num,

                      I_rec_rcv_trx_interface.org_id);

       

      Regards