Unexpected Error Occurred During Auto Create (Doc ID 2343241.1)

Last updated on JUNE 07, 2021

Applies to:

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

Changes

Cause

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