'APP-PO-14160' Error When Trying to Finally Close a Blanket Purchase Agreement Release is_complex_work_po10.EXCEPTION ORA-01403: no data found (Doc ID 1949096.1)

Last updated on JUNE 02, 2015

Applies to:

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

Symptoms

When attempting to Finally Close a Blanket Purchase Agreement (BPA) Release the following error occurs:

Error

APP-PO-14160: Document action not completed successfully

In FND Log next error can be seen:

po.plsql.PO_COMPLEX_WORK_PVT.is_complex_work_po10.EXCEPTION 4 100ORA-01403: no data found;SQLERRM = ORA-01403: no data found
po.plsql.PO_COMPLEX_WORK_PVT.is_complex_work_po END 2 End of subprogram.
po.plsql.PO_DOCUMENT_CHECKS_PVT.check_final_close100.EXCEPTION 4 100: ORA-01403: no data found;SQLERRM = ORA-01403: no data found




Steps to reproduce

1. Create a new Release from an existing or new BPA.
2. Query the release in PUrchase Orders SUmmary > Go to Tools > Control > chose Finally Closed
3. Error occurs

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