This discussion is archived
2 Replies Latest reply: Nov 14, 2012 2:11 AM by 597001 RSS

APP-ONT 250268

user9204034 Newbie
Currently Being Moderated
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 Oracle ACE
    Currently Being Moderated
    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 Journeyer
    Currently Being Moderated
    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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points