My Oracle Support Banner

Creating the Blanket Agreement or Requisition Template gives Error - APP-PO_14142 : insert_line-015:ORA-01403 : No Data Found (Doc ID 2716323.1)

Last updated on JUNE 07, 2021

Applies to:

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

Symptoms

Using Purchasing, Version 12.2

Actual:
Upon entering a Blanket Agreement and choosing Save - error is encountered.

Expected:
Upon entering the Blanket Agreement - error is not expected.

Error:
Blanket:
APP-PO_14142 : insert_line-015:ORA-01403 : No Data Found
Cause: A SQL error has occurred in insert_line. The SQL error is ORA-1403 No Data Found

 

Requisition Template:
APP-PO-14142: INSERT_HEADER-020: ORA-01403
Cause: A SQL error has occurred in insert_line. The SQL error is ORA-1403 No Data Found

 

 

Replication Steps:
The issue can be reproduced at will with the following steps:
1. Core Purchasing Responsibility - Purchase Orders - Purchase Orders
2. Enter the Blanket Agreement type of Purchase Order
3. Attempt to save the Lines
4. Error is encountered

Other:

Trace file shows -
Bind#1 value="ORA-01403: no data found
Bind#2 value="po.plsql.po_message_s.insert_line.015.EXCEPTION"
Bind#3 value=4
Bind#4 value=";SQLERRM = ORA-01403: no data found"

Bind#1 value="ORA-01403: no data found
Bind#2 value="po.plsql.PO_ATTRIBUTE_VALUES_PVT.CREATE_DEFAULT_ATTRIBUTES.20.EXCEPTION"
Bind#3 value=4
Bind#4 value="Unhandled exception;SQLERRM = ORA-01403: no data found"

 



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.