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:


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

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