My Oracle Support Banner

The Buyer Work Center is not Allowing the Deletion of Incomplete Purchase Order Lines - Cannot Delete Purchase Order Lines in Buyer Work Center (Doc ID 2820510.1)

Last updated on MARCH 08, 2022

Applies to:

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

Symptoms

Using Purchasing, Version 12.2

Actual:
Accessing the buyer work center - Orders Page - buyers are not able delete lines from the Incomplete purchase orders.
Choosing Delete has no impact on the purchase order - the line remains.

Expected:
The buyers should be able to delete the lines from the Incomplete Purchase Orders.

Error:

Replication Steps:
The issue can be reproduced at will with the following steps:
1. Access the purchasing responsibility
2. Choose the Buyer Work Center - and then choose the Orders tab
3. Choose to update a purchase order
4. Choose the Lines region and then attempt to delete lines from the Incomplete Purchase Order - choose GO
5. A popup does appear - stating the line or lines would be deleted, however the delete does not occur
The line or lines remain

 

Other:
Using the core purchase order form - deleting the line is possible, it does work.

 

Debug:

Here are details noted in the trace file - 

BINDS #4855021464:

Bind#0
oacdty=01 mxl=16386(599) mxlc=00 mal=00 scl=00 pre=00
oacflg=03 fl2=1206001 frm=01 csi=31 siz=16392 off=0
kxsbbbfp=1232b7830 bln=16386 avl=599 flg=05
value="----- PL/SQL Call Stack -----
object line object
handle number name
70001035e6b46c8 73 package body APPS.FND_LOG.STR_UNCHKED_INT_WITH_CONTEXT
70001035e6b46c8 216 package body APPS.FND_LOG.STRING
70001035c085c28 492 pack"...
Bind#1
oacdty=01 mxl=32(25) mxlc=00 mal=00 scl=00 pre=00
oacflg=03 fl2=1206001 frm=01 csi=31 siz=2056 off=0
kxsbbbfp=1232e1870 bln=32 avl=25 flg=05
value="ORA-01403: no data found
"
Bind#2
oacdty=01 mxl=2000(256) mxlc=00 mal=00 scl=00 pre=00
oacflg=03 fl2=1206001 frm=01 csi=31 siz=0 off=32
kxsbbbfp=1232e1890 bln=2000 avl=63 flg=01
value="po.plsql.PO_TAX_INTERFACE_PVT.CALCULATE_TAX_WRAPPER.0.EXCEPTION"
Bind#3

 

BINDS #4855021464:

Bind#0
oacdty=01 mxl=16386(00) mxlc=00 mal=00 scl=00 pre=00
oacflg=03 fl2=1206001 frm=01 csi=31 siz=16392 off=0
kxsbbbfp=1232e00b0 bln=16386 avl=00 flg=05
Bind#1
oacdty=01 mxl=32(00) mxlc=00 mal=00 scl=00 pre=00
oacflg=03 fl2=1206001 frm=01 csi=31 siz=2056 off=0
kxsbbbfp=1232df868 bln=32 avl=00 flg=05
Bind#2
oacdty=01 mxl=2000(256) mxlc=00 mal=00 scl=00 pre=00
oacflg=03 fl2=1206001 frm=01 csi=31 siz=0 off=32
kxsbbbfp=1232df888 bln=2000 avl=48 flg=01
value="po.plsql.PO_TAX_INTERFACE_PVT.APPEND_ERROR.BEGIN"
Bind#3
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=03 fl2=1206001 frm=00 csi=00 siz=0 off=2032
kxsbbbfp=1232e0058 bln=22 avl=02 flg=01
value=2
Bind#4
oacdty=01 mxl=2000(99) mxlc=00 mal=00 scl=00 pre=00
oacflg=03 fl2=1206001 frm=01 csi=31 siz=2408 off=0
kxsbbbfp=1232de6f0 bln=2000 avl=99 flg=05
value="p_message_text = po.plsql.PO_TAX_INTERFACE_PVT.CALCULATE_TAX_WRAPPER.#0:100ORA-01403: no data found"

Changes

 The following file was upgraded during a patching cycle - POXVCPOB.pls 120.50.12020000.27 - and the problem occurs on this version.

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
Changes
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.