Cancel Internal Sales Order - Unable to Save The Changes As The Corresponding Internal Requisition Cannot be Updated (Doc ID 2184704.1)

Last updated on JUNE 06, 2017

Applies to:

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

Symptoms

On : 12.1.3 version, Requisitions

Actual:
Attempting to cancel an internal sales order ends in error.

 
Expected:
Expect that the error should not occur and the internal sales order and backing requisition should be updated/cancelled.

Error:
Unable to save the changes as the corresponding Internal Requisition cannot be updated

 

 

From the trace -

PARSING IN CURSOR #4888821768 len=39 dep=1 uid=84 oct=45 lid=84 tim=3368343380883 hv=2928719929 ad='0' sqlid='4rd8432r91f1t'
ROLLBACK TO UPDATE_REQCANCEL_FROM_SO_SP
END OF STMT
PARSE #4888821768:c=70,e=139,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=0,plh=0,tim=3368343380883
EXEC #4888821768:c=38,e=84,p=0,cr=0,cu=2,mis=0,r=0,dep=1,og=0,plh=0,tim=3368343381036
CLOSE #4888821768:c=0,e=1,dep=1,type=3,tim=3368343381091
BINDS #4865960000:
Bind#0
oacdty=01 mxl=32(00) mxlc=00 mal=00 scl=00 pre=00
oacflg=03 fl2=1206001 frm=01 csi=31 siz=2088 off=0
kxsbbbfp=12365d5b0 bln=32 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=0 off=32
kxsbbbfp=12365d5d0 bln=32 avl=00 flg=01
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=64
kxsbbbfp=12365d5f0 bln=2000 avl=59 flg=01
value="po.plsql.PO_RCO_VALIDATION_GRP.update_reqcancel_from_so.060"

=====================
PARSING IN CURSOR #4888833648 len=45 dep=1 uid=84 oct=45 lid=84 tim=3368343824157 hv=3395239480 ad='0' sqlid='c76k9bz55ygjs'
ROLLBACK TO SAVEPOINT PROCESS_CANCEL_QUANTITY
END OF STMT
PARSE #4888833648:c=97,e=160,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=0,plh=0,tim=3368343824157
EXEC #4888833648:c=820,e=1641,p=0,cr=0,cu=185,mis=0,r=0,dep=1

 

 

From the FND_LOG_MESSAGES.xls file uploaded:
..
ont.plsql Cancelling Requisition Line
po.plsql.PO_RCO_VALIDATION_GRP.update_reqcancel_from_so.BEGIN Start of subprogram.
po.plsql.PO_RCO_VALIDATION_GRP.update_reqcancel_from_so.000 p_api_version = 4
po.plsql.PO_RCO_VALIDATION_GRP.update_reqcancel_from_so.050 Calling Private Procedure update_ReqCancel_from_SO table count =1
po.plsql.PO_RCO_VALIDATION_GRP.update_reqcancel_from_so.060 p_req_line_id = 3504891
po.plsql.PO_RCO_VALIDATION_GRP.update_reqcancel_from_so.060 p_req_can_all = FALSE
po.plsql.PO_RCO_VALIDATION_GRP.update_reqcancel_from_so.060 p_req_line_id = 3504891
..
po.plsql.PO_RCO_VALIDATION_GRP.update_reqcancel_from_so.060 After Private Procedure update_ReqCancel_from_SO
ont.plsql After PO_RCO_Validation_GRP.Update_ReqCancel_from_SO E

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