Line #### Of Requisition ### Currently Locked By Another User When Attempting Autocreate a Purchase Order.

(Doc ID 1998470.1)

Last updated on SEPTEMBER 19, 2017

Applies to:

Oracle Purchasing - Version 12.2.3 and later
Information in this document applies to any platform.

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms