Attempting to Cancel an Approved Blanket Agreement Completes Without Error - but Cancel is not Applied to the Blanket

(Doc ID 2318376.1)

Last updated on OCTOBER 17, 2017

Applies to:

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

Symptoms

Using Purchasing, Version 12.1.3


Actual:
Upon cancelling the blanket purchase agreement - nothing is happening. The cancel engages but the blanket agreement is not updated.

Expected:
The blanket agreement should cancel when the cancel action is taken.

Error:


Replication
The issue can be reproduced at will with the following steps:
1. Purchase Orders Summary
2. Tools/control - cancel
3. Action completes but the agreement is not updated or changed.


Other:
Patches applied - upgrade has taken place.

 

Trace File:

CLOSE #4584701000:c=1,e=1,dep=1,type=3,tim=119672783879722
CLOSE #4584376016:c=7,e=11,dep=1,type=0,tim=119672783879788
BINDS #4584453232:
Bind#0
oacdty=01 mxl=2000(1003) mxlc=00 mal=00 scl=00 pre=00
oacflg=03 fl2=1206001 frm=01 csi=31 siz=4000 off=0
kxsbbbfp=11144ec90 bln=2000 avl=1003 flg=05
value="----- PL/SQL Call Stack -----
object line object
handle number name
70001013a19d758 73 package body APPS.FND_LOG
70001013a19d758 216 package body APPS.FND_LOG
7000100cf3476f0 125 package body APPS.ICX_CAT_UTIL_PVT
70001"...
Bind#1
oacdty=01 mxl=2000(150) mxlc=00 mal=00 scl=00 pre=00
oacflg=03 fl2=1206001 frm=01 csi=31 siz=0 off=2000
kxsbbbfp=11144f460 bln=2000 avl=150 flg=01
value="ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'SYNCRN'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
"
Bind#2
oacdty=01 mxl=2000(256) mxlc=00 mal=00 scl=00 pre=00
oacflg=03 fl2=1206001 frm=01 csi=31 siz=2024 off=0
kxsbbbfp=111419398 bln=2000 avl=60 flg=05
value="icx.plsql.ICX_CAT_POPULATE_PODOCS_PVT.populateOnlineBlankets"
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=2000
kxsbbbfp=111419b68 bln=22 avl=02 flg=01
value=6
Bind#4
oacdty=01 mxl=2000(168) mxlc=00 mal=00 scl=00 pre=00
oacflg=03 fl2=1206001 frm=01 csi=31 siz=2312 off=0
kxsbbbfp=111418a50 bln=2000 avl=168 flg=05
value=" --> l_err_loc:400 ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'SYNCRN'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored"
Bind#5
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=03 fl2=1206001 frm=00 csi=00 siz=0 off=2000
kxsbbbfp=111419220 bln=22 avl=03 flg=01
value=-1
Bind#6

 

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