RCVRCERC: APP-PO-14142: Rcv_receipts_eh.event-000: Normal, Successful Completion (Doc ID 1991503.1)

Last updated on MARCH 31, 2015

Applies to:

Oracle Inventory Management - Version 12.0.0 to 12.2.4 [Release 12.0 to 12.2]
Information in this document applies to any platform.

Symptoms

When attempting to receive a PO the following error occurs:

ERROR
-----------------------
APP-PO-14142: rcv_receipts_eh.event-000: ORA-0000: normal, successful completion
Cause: A SQL error has occurred in rcv_receitps_eh.event. The SQL error is ORA-0000: normal, successful completion.

FORMS TRACE SHOWS THE FOLLOWING
---------------------------------------------
SELECT VENDOR_SITE_CODE , NVL(INACTIVE_DATE , SYSDATE  +  1  )  FROM PO_VENDOR_SITES_ALL   WHERE VENDOR_ID =  :b1  AND VENDOR_SITE_ID =  :b2  
END OF STMT
PARSE #140629010371184:c=2000,e=2496,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,plh=1735902381,tim=1425495956062244
BINDS #140629010371184:
Bind#0
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=03 fl2=1000000 frm=00 csi=00 siz=48 off=0
kxsbbbfp=7fe6be3539c8  bln=22  avl=03  flg=05
value=7009
Bind#1
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=03 fl2=1000000 frm=00 csi=00 siz=0 off=24
kxsbbbfp=7fe6be3539e0  bln=22  avl=04  flg=01
value=47619
EXEC #140629010371184:c=0,e=144,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,plh=1735902381,tim=1425495956062488
FETCH #140629010371184:c=0,e=22,p=0,cr=3,cu=0,mis=0,r=0,dep=0,og=1,plh=1735902381,tim=1425495956062550

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