My Oracle Support Banner

'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 04, 2021

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


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