Unexpected Error Occurred During Auto Create

(Doc ID 2343241.1)

Last updated on DECEMBER 29, 2017

Applies to:

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

Symptoms

Using Purchasing, Version 12.1.3


Actual:
Attempting the autocreate and it is failing.

Expected:
During the autocreate process - the exception is occurring and it is failing.

Error:
Unexpected error occurred during Auto Create


Replication Steps:
The issue can be reproduced at will with the following steps:
1. Demand workbench - attempt the autocreate.
2. Find that it is failing.



Other:

In FND Log we can see:
po.plsql.PO_PDOI_POSTPROC_PVT.copy_req_attachments.30 1 Copy Attachments from
Requisition Header to PO Line
po.plsql.PO_PDOI_POSTPROC_PVT..copy_req_attachments.30.EXCEPTION 4
"ORA-01001: invalid cursor
ORA-06512: at ""APPS.FND_ATTACHED_DOCUMENTS2_PKG"", line 900
ORA-01400: cannot insert NULL into
(""APPLSYS"".""FND_LOBS"".""FILE_CONTENT_TYPE"") in Package
po.plsql.PO_PDOI_POSTPROC_PVT. Procedure copy_req_attachments.30;SQLERRM =
ORA-01001: invalid cursor
ORA-06512: at ""APPS.FND_ATTACHED_DOCUMENTS2_PKG"", line 900

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