Autocreate - Error: Unexpected Error Occurred During Autocreate (Doc ID 2378008.1)

Last updated on JUNE 21, 2023

Applies to:

Symptoms

Using Purchasing, Version 12.2


Actual:
Autocreate is ending in an error.

Expected:
Error should not occur during the autocreate.

Error:
"Error: Unexpected error occurred during autocreate"

Replication Steps:
The issue can be reproduced at will with the following steps:
1. Purchasing - autocreate form.
2. Query the requisition and submit.
3. Error is encountered.


Below error message can be observed on the FND debug log:

____________________________________________________________________________

po.plsql.PO_HEADERS_DRAFT_PKG.delete_rows.BEGIN Start of subprogram.
po.plsql.PO_HEADERS_DRAFT_PKG..delete_rows.0.EXCEPTION ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE in Package po.plsql.PO_HEADERS_DRAFT_PKG. Procedure delete_rows.0;SQLERRM = ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE
po.plsql.PO_DRAFTS_PVT..remove_draft_changes.0.EXCEPTION User-Defined Exception in Package po.plsql.PO_DRAFTS_PVT. Procedure remove_draft_changes.0;SQLERRM = User-Defined Exception
po.plsql.PO_DRAFTS_PVT..complete_transfer.20.EXCEPTION User-Defined Exception in Package po.plsql.PO_DRAFTS_PVT. Procedure complete_transfer.20;SQLERRM = User-Defined Exception
po.plsql.PO_DRAFTS_PVT..transfer_draft_to_txn.70.EXCEPTION User-Defined Exception in Package po.plsql.PO_DRAFTS_PVT. Procedure transfer_draft_to_txn.70;SQLERRM = User-Defined Exception
po.plsql.PO_PDOI_POSTPROC_PVT..transfer_draft_to_txn.10.EXCEPTION User-Defined Exception in Package po.plsql.PO_PDOI_POSTPROC_PVT. Procedure transfer_draft_to_txn.10;SQLERRM = User-Defined Exception
po.plsql.PO_PDOI_POSTPROC_PVT..create_update_doc.60.EXCEPTION User-Defined Exception in Package po.plsql.PO_PDOI_POSTPROC_PVT. Procedure create_update_doc.60;SQLERRM = User-Defined Exception
po.plsql.PO_PDOI_POSTPROC_PVT.process.80 rollback to savepoint po_pdoi_doc_postproc_sp
po.plsql.PO_PDOI_POSTPROC_PVT..process.80.EXCEPTION User-Defined Exception in Package po.plsql.PO_PDOI_POSTPROC_PVT. Procedure process.80;SQLERRM = User-Defined Exception
po.plsql.PO_PDOI_PVT.set_draft_errors.BEGIN Start of subprogram.
po.plsql.PO_PDOI_PVT.set_draft_errors.END End of subprogram.
po.plsql.PO_PDOI_PVT..start_process.120.EXCEPTION User-Defined Exception in Package po.plsql.PO_PDOI_PVT. Procedure start_process.120;SQLERRM = User-Defined Exception
po.plsql.PO_PDOI_PVT.wrap_up.BEGIN Start of subprogram.

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.