My Oracle Support Banner

Attempting to Receive Against Some POs Fails With APP-PO-14142: rcv_receipts_th.insert_transaction-001 (Doc ID 1941528.1)

Last updated on JUNE 28, 2017

Applies to:

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

Symptoms

Attempting to receive some POs results in error:

APP-PO-14142: rcv_receipts_th.insert_transaction-001:
ORA-0000: normal, successful completion

Cause: A SQL error has occurred in
rcv_receipts_th.insert_transaction. The SQL error is
ORA-0000: normal, successful completion

Trace file shows the following exception:

=====================
PARSING IN CURSOR #140693121674872 len=90 dep=0 uid=194 oct=3 lid=194 tim=1414512109748958 hv=1795299636 ad='45cc7cc88' sqlid='9sqz3bdph469n'
SELECT MUOM.UOM_CODE FROM MTL_UNITS_OF_MEASURE MUOM   WHERE MUOM.UNIT_OF_MEASURE =  :b1   
END OF STMT
PARSE #140693121674872:c=0,e=204,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=1,plh=0,tim=1414512109748955
...
BINDS #140693121674872:
 Bind#0
  oacdty=01 mxl=32(25) mxlc=00 mal=00 scl=00 pre=00
  oacflg=03 fl2=1000010 frm=01 csi=31 siz=32 off=0
  kxsbbbfp=7ff5ab8a2a28  bln=32  avl=03  flg=05
  value="£££"
EXEC
...
RPC CALL:PROCEDURE APPS.PO_MESSAGE_S.SQL_ERROR(ROUTINE IN VARCHAR2, LOCATION IN VARCHAR2, ERROR_CODE IN NUMBER);
RPC BINDS:
 bind 0: dty=1 bfp=7ff5ac3cb3f0 flg=08 avl=34 mxl=34 val="rcv_receipts_th.insert_transaction"
 bind 1: dty=1 bfp=7ff5ac3cb448 flg=08 avl=03 mxl=03 val="001"
 bind 2: dty=6 bfp=7ff5ac3cb470 flg=00 avl=04 mxl=22 val=-6502
...
====================


The issue occurs for all POs that have PO_LINE_LOCATIONS_ALL.UNIT_MEAS_LOOKUP_CODE = "£££"

Steps:
PO Responsibility > Receiving > Receipt

Changes

 Issue did not occur before upgrade from 11i to 12.1.3

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.