My Oracle Support Banner

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

Last updated on JANUARY 22, 2021

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 see error -
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

Changes

 

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.