Line #### Of Requisition ### Currently Locked By Another User When Attempting Autocreate a Purchase Order. (Doc ID 1998470.1)

Last updated on MARCH 02, 2023

Applies to:

Symptoms

When attempting to autocreate a purchase order from a requisition,  requisition lines become locked and the following error occurs.

ERROR
-------------------
Error appears after this :
APP-14142: AUTOCREATE_DOCUMENTS-008: ORA-0000: normal,
successful completion.

Cause: A SQL error has occurred in AUTOCREATE_DOCUMENTS. The SQL error is ORA-0000: normal, successful completion.

Action: Take note of both this error number and the actions you were trying to perform. Contact your system administrator for further assistance.

STEPS
-------------------
1. Login to the E-Business Suite and choose the Purchasing Module.
2. Autocreate - select many lines
3. Message is given that one line is not matching the PO Currency - proceed
4. Note is given -

 - Line xxxx of requisition xxx is currently locked by another user.
  It will not be autocreated at this time

5. Choose OK but have to kill the session.
6. Log back in and again try the autocreate
7. Note in step 4 is shown again - then followed with error seen in the error message section.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.