My Oracle Support Banner

RCVTXERT - Receiving Transactions Form Shows Error APP-PO-14142: DISTRIBUTION_DETAIL-10: ORA-01403: no data found (Doc ID 2425860.1)

Last updated on FEBRUARY 08, 2019

Applies to:

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


Problem Statement
When attempting to query in Find Receiving Transactions form,
the following error occurs.


APP-PO-14142: DISTRIBUTION_DETAIL-10: ORA-01403: no data found

Cause: A SQL error has occurred in DISTRIBUTION_DETAIL. The SQL error is ORA-01403: no data found.

Action: Take note of both this error number and the actions you were trying to perform. Contact your system administrator for further assistance.

Click OK, then


Steps to Reproduce

  1. Navigate to Receiving > Receiving Transactions

  2. Find Receiving Transactions window,
    Operating Unit is selected
    Perform the query by PO number

  3. The query finishes successfully.

  4. Find Receiving Transactions window, click Clear button
    Operating Unit is NOT selected this time
    Perform another query by Supplier or Receipt number

  5. Error shows



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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.