Express Receipt Results in Error APP-PO-14142 and Error Insert_express_rows-000 (Doc ID 2035012.1)

Last updated on AUGUST 17, 2016

Applies to:

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

Symptoms

On 12.2.4 version using Express Receipts option the following error occurs (standard receiving is ok)

 
ERROR
APP-PO-14142: insert_express_rows-000: ORA-0000: normal, successful completion

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

click ok

then

APP-PO-14142: rcv_header_th.event-000: ORA-0000: normal, successful completion

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


STEPS
The issue can be reproduced at will with the following steps:
1. Create PO with multiple lines and approve it
2. Express Receipt when saving throws error



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