2 Replies Latest reply: Nov 14, 2012 4:11 AM by 597001 RSS

    APP-ONT 250268

    user9204034
      Hi,

      Can anyone help me find solution to this error APP-ONT 250268 'Record is currently being worked on by another user'
      in Move Order

      thanks
        • 1. Re: APP-ONT 250268
          Helios-GunesEROL
          Hi;

          Similar error mention at:
          Interface Trip Stop LOCK Record is currently being worked on by another user [ID 777969.1]
          Interface Trip Stop Completed With Warning 'Record Is Currently Being Worked On By Another User' [ID 955966.1]
          Line Error in Fulfill: Record Is Currently Being Worked On By Another User [ID 1310961.1]

          Please review them

          Regard
          Helios
          • 2. Re: APP-ONT 250268
            597001
            Check the line status and QUANTITY, QUANTITY_DELIVERED, QUANTITY_DETAILED columns. The all three quantity columns should have same value for a move order to close.
            Also check in the MTL_MATERIAL_TRANSACTIONS_TEMP table for stuck records
            select header_id,line_id,line_number,line_status, b.meaning, inventory_item_id,quantity, QUANTITY_DELIVERED,QUANTITY_DETAILED
            from mtl_txn_request_lines a, mfg_lookups b
            where a.line_status = b.lookup_code
            and b.lookup_type = 'MTL_TXN_REQUEST_STATUS'
            and a.header_id = :p_header_id
            Cheers,
            ND
            Use the "helpful" or "correct" buttons to award points to replies / Mark the thread as answered, if your question is answered.