APP-PO-14142: ORA-01403 : No Data Found, When Updating BPA Loaded Through PDOI

(Doc ID 1437055.1)

Last updated on JUNE 01, 2016

Applies to:

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


On : 12.1.3 version, Purchasing Processes

When creating BPA from Import Price Catalogs Process, user tries to update data at BPA Line level and the following error occurs in forms:

APP-PO-14142: update_line-010 : ORA-01403 : no data found
Cause : A SQL error has occurred in update_line. The SQL error is ORA-01403: no data found
Action: Take note of both this error number and the actions you were trying to perform. Contact you system administrator

BWC error
## Detail 0 ##
java.lang.Exception: Assertion failure: The value cannot be null.
at oracle.apps.po.common.Assert.assertTrue(
at oracle.apps.po.common.Assert.assertNotNull(
at oracle.apps.po.common.Assert.assertNotNull(
at oracle.apps.po.document.server.PoItemAttributesRenderCmd.prepareSpelAttributes(

The issue can be reproduced at will with the following steps:
1. Create an BPA from Import Price Catalogs Process
2.Update data at BPA Line level using Form or PBWC
3.It errors out as per the above error

The issue has the following business impact:
Due to this issue, users cannot update the BPA line level.


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